tnsnames.ora & listener.ora

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;