客户端连接oracle的时候时而连得上时而连不上 而且报错不是ora-12545,是报的ora-12541没有监听
连指定节点能连得上没问题,
SQL> conn sys/oracle@cbl1 as sysdba
Connected.
SQL> conn sys/oracle@cbl2 as sysdba
Connected.
SQL> conn sys/oracle@cbl as sysdba
Connected.
SQL> conn sys/oracle@cbl as sysdba
ERROR:
ORA-12541: TNS:no listener
我怀疑是不是监听动态注册的有问题,谁能帮我看看
SQL> show parameter name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convertstring
db_namestring cbl
db_unique_name string cbl
global_names boolean FALSE
instance_name string cbl1
service_names string cbln, cbl
我的listener.ora文件
LISTENER_ORACLE1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle1_vip)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
监听的状态
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER_ORACLE1
Version TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date06-JUN- 14:35:20
Uptime0 days 0 hr. 15 min. 6 sec
Trace Leveloff
SecurityON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/product/10g/db_1/network/admin/listener.ora
Listener Log File /opt/oracle/product/10g/db_1/network/log/listener_oracle1.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.33)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
Service "cbl" has 2 instance(s).
Instance "cbl1", status READY, has 2 handler(s) for this service...
Instance "cbl2", status READY, has 1 handler(s) for this service...
Service "cblXDB" has 2 instance(s).
Instance "cbl1", status READY, has 1 handler(s) for this service...
Instance "cbl2", status READY, has 1 handler(s) for this service...
Service "cbl_XPT" has 2 instance(s).
Instance "cbl1", status READY, has 2 handler(s) for this service...
Instance "cbl2", status READY, has 1 handler(s) for this service...
Service "cbln" has 2 instance(s).
Instance "cbl1", status READY, has 2 handler(s) for this service...
Instance "cbl2", status READY, has 1 handler(s) for this service...
The command completed successfully