当lsnrctl启动启动侦听器时,将面临以下错误。
监听错误:(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) TNS-12542: TNS:已在使用的地址TNS-12560: TNS:协议适配器错误TNS-00512:已在使用的地址Linux错误: 98:已经使用的地址
listener.ora内容如下。(DESCRIPTION_LIST = (ADDRESS_LIST =(ADDRESS_LIST= (PROTOCOL = IPC)(KEY = NSMS)) (ADDRESS = (PROTOCOL = TCP)(HOST =10.99.33.22(Port= 1522)) ) SID_LIST_NSMS = (SID_DESC = (GLOBAL_DBNAME = NSMS) (ORACLE_HOME =/opt/oracle/product/11.2.0 (SID_NAME = NSMS) )
/opt/oracle/product/11.2.0/network/trace/client.trc sqlnet.ora NAMES.DIRECTORY_PATH= (TNSNAMES) AUTOMATIC_IPC = ON TRACE_LEVEL_CLIENT = OFF TRACE_FILE_CLIENT =TRACE_FILE_CLIENT= 10 TCP.VALIDNODE_CHECKING = YES TCP.INVITED_NODES = (LA) #TCP.EXCLUDED_NODES = (1.22.33.44) # DIAG_SIGHANDLER_ENABLED=NO
tnsname.ora内容NSMS = (ADDRESS_LIST =(ADDRESS_LIST=(协议=TCP)(主机=10.99.33.22)(端口=1522)(地址=(协议= IPC)(KEY = NSMS)) ) (CONNECT_DATA =(服务器=专用) (SERVICE_NAME = NSMS) )
发布于 2017-11-15 01:29:07
如果文件在OS级别上正确设置,请尝试检查listner.ora中使用的主机名。然后尝试使用默认端口1521。
https://stackoverflow.com/questions/47280619
复制相似问题