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:

 

评分:0

我来说两句

显示全部

:loveliness: :handshake :victory: :funk: :time: :kiss: :call: :hug: :lol :'( :Q :L ;P :$ :P :o :@ :D :( :)

日历

« 2008-12-03  
 123456
78910111213
14151617181920
21222324252627
28293031   

数据统计

  • 访问量: 6793
  • 日志数: 928
  • 影音数: 2
  • 文件数: 2
  • 书签数: 3
  • 建立时间: 2008-02-17
  • 更新时间: 2008-12-02

RSS订阅

Open Toolbar