Listener.ora 配置文件 中global_dbname 可以隨便配置;
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ora11gbak)----可以自定義
(ORACLE_HOME = /u01/app/ora11/product/11.2.0/dbhome_1)
(SID_NAME = ora11g)
)
(SID_DESC =
(GLOBAL_DBNAME = lixorabak) ----可以自定義
(ORACLE_HOME = /oracle)
(SID_NAME = lixora)
)
)
LSNRCTL> status
Services Summary...
Service "PLSExtProc" has 1instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) forthis service...
Service "lixora" has 1instance(s).
Instance "lixora", status READY, has 1 handler(s) for thisservice... ----------動態注冊
Service "lixorabak" has 1 instance(s).
Instance "lixora", status UNKNOWN, has 1 handler(s) for this service...----------靜態注冊
Service "ora11g" has 1instance(s).
Instance "ora11g", status READY, has 1 handler(s) for thisservice... --------------動態注冊
Service "ora11gbak" has 1 instance(s).
Instance "ora11g", status UNKNOWN, has 1 handler(s) for this service... ----------靜態注冊
The command completed successfully
NAME TYPE VALUE
---------------------------------------------------------- ------------------------------
db_name string ora11g
db_unique_name string ora11g
global_names boolean FALSE
instance_name string ora11g
service_names string ora11g
客戶端連接測試:---可以正常連接
C:\Users\hlj>sqlplus system/[email protected]/ora11gbak
SQL*Plus: Release 10.2.0.1.0 - Productionon 星期五 6月 19 16:56:15 2015
Copyright (c) 1982, 2005, Oracle. All rights reserved.
連接到:
Oracle Database 11g Enterprise EditionRelease 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Miningand Real Application Testing options
SQL> select * from dual;
DU
--
X