SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = SECDTEST.SECDMN)
(SID_NAME = secdnewsid)
)
)
SECDTEST_SID =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = colin-c3fd9ec04)(PORT = 1521))
(CONNECT_DATA =
(SID = secdnewsid)
)
)
SECDTEST_SERV_NAME =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = colin-c3fd9ec04)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = newserv_name.SECDMN)
)
)
D:/Documents and Settings/donggl>set oracle_sid=secdnewsid
D:/Documents and Settings/donggl>SQLPLUS / AS SYSDBA
SQL> ALTER SYSTEM SET SERVICE_NAMES = 'newserv_name, NEW2SSSV';
SQL> show parameter name;