In its broadest sense, learning can be defined as a process of
progressive change from ignorance to knowledge,
and from indifference to understanding....
关于listener 案例_4
上一篇 /
下一篇 2007-07-31 00:00:00
/ 个人分类:Error Handle
Starting 2nd Listener on UNIX Yields ORA-12545 OS error; "Permission Denied"
Problem Description
-------------------
You have created a second Oracle listener on a UNIX server and cannot start it.
Issuing the command lsnrctl start <listener_name> results in:
ORA-12545 "Connect failed because target host or object does not exist"
ORA-12560 "TNS:protocol adapter error"
ORA-00515
<OS error> Permission Denied
You have populated the listener.ora correctly with a valid value for HOST =
in the TCP address configuration.
Solution Description
--------------------
Check listener executable for correct ownership and privileges. In this case, the correct
owner of the listener was the user "oracle" and the permission should be -rwsr-xr-x.
At ORACLE_HOMEin check ls -l tnslsnr. Should yield:
-rwsr-xr-x oracle dba
Explanation
-----------
Although the errors are consistent with a bad address for the HOST parameter
of the TCP/IP address in the listener.ora, the real clue is in the "Permission
Denied" error by the operating system. It could be deduced that the ORA-12545 error
is attributed to the listener not having the privileges to obtain a socket for
the TCP/IP.
导入论坛
引用链接
收藏
分享给好友
推荐到圈子
管理
举报
TAG: