本文共 622 字，大约阅读时间需要 2 分钟。

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;

转载地址：http://cynsi.baihongyu.com/