如下:
TNSNAME1=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.44.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DATABASE1)
)
)TNSNAME2=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.44.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DATABASE2)
)
)
TNSNAME1=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.44.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DATABASE1)
)
)TNSNAME2=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.44.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DATABASE2)
)
)
SQL> show parameters db_name;NAME TYPE VALUE
------------------------------------ ------- ------------------------------
db_name string ORCLalter user system identified by passwd;
他们的培训教材不错的。
有问题的话给我发email,[email protected]