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重建一个试试看