最近重启了一次服务器,数据库实例启动后,发现监听无法启动,改了多次listener.ora,始终报下面的错误
[oracle@localhost admin]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on
27-JUN-2015 07:02:52
Copyright (c) 1991, 2011, Oracle. All rights
reserved.
Starting /oracle/product/11.2.0/dbhome/bin/tnslsnr: please
wait...
TNSLSNR for Linux: Version 11.2.0.3.0 - Production
System parameter file is
/oracle/product/11.2.0/dbhome/network/admin/listener.ora
Log messages written to
/oracle/diag/tnslsnr/LM01/listener/alert/log.xml
Error listening on:
(ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))
No longer listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=LM01)(PORT=1521)))
TNS-12557: TNS:protocol adapter not loadable
TNS-12560:
TNS:protocol adapter error
TNS-00527:
Protocol Adapter not loadable
网上查了一下,与/var/tmp/目录下的隐藏目录.oracle及其权限有关。
查了一下,发现没有这个目录,靠
[root@localhost /]$cd
/var/tmp
[root@localhost tmp]$ls -lhra
drwxr-xr-x
19 oracle dba 4.0K Aug 11
18:16 oracle
drwxr-xr-x 19
root root 4.0K
Aug 11 18:16 ..
drwxr-xr-x 3
root root 4.0K
Jan 4 11:02 .
创建该目录名修改属主
[root@localhost /]$mkdir /var/tmp/.oracle
[root@localhost /]$chown -R
oracle:dba /var/tmp/.oracle
[root@localhost /]$cd
/var/tmp
[root@localhost tmp]$ls -lhra
drwxr-xr-x
19 oracle dba 4.0K Aug 11
18:16 oracle
drwxr-xr-x
19 oracle dba
4.0K JUN 26 16:22 .oracle
drwxr-xr-x 19
root root 4.0K
Aug 11 18:16 ..
drwxr-xr-x 3
root root 4.0K
Jan 4 11:02 .
然后启动监听
[root@localhost tmp]$su - oracle
[oracle@localhost ~]$lsnrctl start
oracle@LM01 ~]$ lsnrctl
start
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on
27-JUN-2015 07:02:52
Copyright (c) 1991, 2011, Oracle. All rights
reserved.
Starting /oracle/product/11.2.0/dbhome/bin/tnslsnr: please
wait...
TNSLSNR for Linux: Version 11.2.0.3.0 - Production
System parameter file is
/oracle/product/11.2.0/dbhome/network/admin/listener.ora
Log messages written to
/oracle/diag/tnslsnr/LM01/listener/alert/log.xml
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=LM01)(PORT=1521)))
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=LM01)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start
Date 27-JUN-2015 07:02:58
Uptime 0 days 0 hr. 0 min. 10 sec
Trace
Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/product/11.2.0/dbhome/network/admin/listener.ora
Listener Log
File /oracle/diag/tnslsnr/LM01/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=LM01)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully