当前位置: 代码迷 >> Oracle开发 >> lsnrctl stop 监听起步和停止都报错,数据库能正常打开 oracle11g linux
  详细解决方案

lsnrctl stop 监听起步和停止都报错,数据库能正常打开 oracle11g linux

热度:290   发布时间:2016-04-24 07:25:15.0
lsnrctl stop 监听启动和停止都报错,数据库能正常打开 oracle11g linux
[oracle@dbPrimary admin]$ lsnrctl stop

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 13-JUL-2012 19:49:52

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dbPrimary)(PORT=1521)))
TNS-12535: TNS:operation timed out
 TNS-12560: TNS:protocol adapter error
  TNS-00505: Operation timed out
  Linux Error: 110: Connection timed out
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCO)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
  Linux Error: 2: No such file or directory




[oracle@dbPrimary admin]$ vi listener.ora 

# listener.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
  (SID_DESC =
  (SID_NAME = PLSExtProc)
  (ORACLE_HOME = /home/oracle/app/oracle/product/11.2.0/dbhome_1)
  (PROGRAM = extproc)
  )
)


LISTENER =
  (DESCRIPTION_LIST =
  (DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = dbPrimary)(PORT = 1521))
  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROCO))
  )
  )

SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF



[oracle@dbPrimary admin]$ vi tnsnas.ora 


dbPrimary =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbPrimary)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)


dbStandby =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbStandby)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)


[oracle@dbPrimary admin]$ vi sqlnet.ora 

# sqlnet.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)



[oracle@dbPrimary admin]$ vi /etc/hosts

# Do not remove the following line, or various programs
# that require network functionality will fail.
192.168.1.101 dbPrimary dbPrimary
127.0.0.1 dbPrimary localhost



这个问题怎么解决???各位帮帮忙...

------解决方案--------------------
HOST = dbPrimary 改为实际IP,看看能不能启动吧!好像是主机名识别的问题
------解决方案--------------------
netca重建一个试试看