主庫使用連接串連接備庫失敗
SQL> conn sys/oracle@orcldg as sysdba
ERROR:
ORA-12528: TNS:listener: all appropriate instances are blocking new connections
備庫已經(jīng)建立了靜態(tài)監(jiān)聽
# listener.ora Network Configuration File:
/u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = orcldg)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
ADR_BASE_LISTENER = /u01/app/oracle
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcldg)
(ORACLE_HOME =
/u01/app/oracle/product/11.2.0/db_1)
(SID_NAME =?orcldg)
)
)
主庫tns文件
$ cat tnsnames.ora
orcldb =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = orcldb)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =?pacsdb1)
)
)
ORCLDG =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = orcldg)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =?pacsdb1)
)
)
發(fā)現(xiàn)主庫tns中的服務(wù)名跟備庫靜態(tài)監(jiān)聽的服務(wù)名不一致，導致主庫識別不到備庫，上面標記紅色的部分需要一樣的服務(wù)名，這樣就可以連接了