轉(zhuǎn)載鏈接

如何修改 service_name

oracle之修改服務(wù)名

如何修改 service_name原有環(huán)境：

sid： mynewdb
global_name：mynewdb
service_names： MYNEWDB
db_domain  ： 
db_name：mynewdb

需要修改如下：

global_name：mynewdb
service_names： test
db_domain  ： 
db_name：mynewdb

服務(wù)器端：

alter system set service_names='test';

這里采用靜態(tài)注冊(cè)，同時(shí)還要修改下 listener.ora

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME =/u01/app/oracle/product/11.2.0/dbhome_1)
      (PROGRAM = extproc)
    )
        (SID_DESC=
        (GLOBAL_DBNAME = mynewdb)
        (ORALCE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
        (SID_NAME = mynewdb)
        )
        (SID_DESC=
        (GLOBAL_DBNAME = test)  -------這個(gè)是需要添加
        (ORALCE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
        (SID_NAME = mynewdb)    ------這個(gè)還是原來(lái)的實(shí)例名
        )
  )

cmd下執(zhí)行命令lsnrctl reload

查看監(jiān)聽(tīng)狀態(tài)lsnrctl status

LSNRCTL> 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.80.11.202)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for [Linux](https://www.2cto.com/os/linux/): Version 11.2.0.1.0 - Production
Start Date                21-NOV-2013 00:09:35
Uptime                    0 days 20 hr. 30 min. 55 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/oracle11g/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.80.11.202)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "mynewdb" has 1 instance(s).
  Instance "mynewdb", status UNKNOWN, has 1 handler(s) for this service...
Service "test" has 1 instance(s).
  Instance "mynewdb", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

可以看到新的 Service "test" 已經(jīng)可以使用了

客戶端配置：

net manager 配置 服務(wù)名為 test ，ip為數(shù)據(jù)庫(kù)服務(wù)器主機(jī)ip，相應(yīng)端口。

測(cè)試連接：

SQL>  conn sys/oracle@test as sysdba
已連接。
SQL>

當(dāng)然不使用靜態(tài)注冊(cè)，動(dòng)態(tài)注冊(cè)也可以