1. Open EMC (Enterprise Manager), 1-1:
The page "add database to tree" is displayed. (You can also click "Navigator"> "add database to tree ")
Host Name: the IP address of the machine where the database is located. Here is 192.168.2.101.
Port: The default value is 1521.
Sid: identifies a database in the system. Used to identify the database, which is filled in when the database is created. Here we are: Alas
Network Service name: It is composed of "Sid _ host name", so it is: alas_192.168.2.101
The above information will be updated to the/clientlient10g_home1/Network/admin/tnsnames. ora file, as shown below:
Alas_192.168.2.101 =
(Description =
(Address_list =
(Address = (Protocol = TCP) (host = 192.168.2.101) (Port = 1521 ))
)
(CONNECT_DATA =
(SID = ALAs)
(Server = dedicated)
)
)
2. Interface 1-2 after successful connection.
Alas_192.168.2.101-alas, Cam refers to the user name.