Lesson 3 | View the Net Assistant |
Objective | Add a network node in Net Assistant. |
View the Net Assistant
The Net Assistant is a GUI tool that can help you configure your Oracle communications. It supports wizards and configuration windows for the Net listener,
Configuration Manager, Advanced Security, and Oracle database server nodes. It reads and modifies the tnsname.ora file, the sqlnet.ora file, and the listener.ora file,
which store configuration parameters for Oracle communications. The "tns" in tnsnames stands for Transparent Network Substrate, which is the technology built into Net that allows it to communicate with any standard network protocol (like TCP/IP).
Even though manually created configuration files can be read and modified by the Oracle8
i Net Assistant, many DBA's continue to manually support their configuration files as they have in the past.
Follow along in the simulation to add a new database node in the Net Assistant.
View Net 8 Assistant
As you probably realized, all this wizard does is make an entry in our tnsnames.ora file. Here is how it will appear after this session; note the new
ADDRESS_LIST
parameter.
# E:\ORACLE\ORA81\NETWORK\ADMIN\
TNSNAMES.ORA
Configuration
File:E:\Oracle\Ora81\NETWORK\ADMIN\
tnsnames.ora
# Generated by Oracle Net Assistant
TESTDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
CAROLSPC
(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl.carol.org)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
carolspc)
(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl.carol.org)
)
)
Add Net Service
Click the link below to practice adding another node yourself.
Add Net Service