Listener start error

[Former Member]

Dear all,

I got this error when start the listener on HP UX OS with oracle dbase:

Error listening on: (ADDRESS=(PROTOCOL=IPC)(KEY=<SID>.WORLD))

TNS-12557: TNS:protocol adapter not loadable

TNS-12560: TNS:protocol adapter error

TNS-00527: Protocol Adapter not loadable

Anyone knows the issue? Thanks.

Regards.

[Former Member · Accepted solution]

Hi

Check the file listener.ora has the right path to your ORACLE_HOME and SID

Regards

Uday

[Former Member · Accepted solution]

Dear all,

I've tried all suggestion, none work. The oracle home and id in listener.ora already correct as well. It used to work okay, I don't get it why it suddenly failed to start up..

Regards

[Former Member · Accepted solution]

hi

Start Oracle listener trace and try to find which dll file cause error

Starting Oracle Listener Tracing

The classical way is to set the following listener.ora parameters and reload:

TRACE_LEVEL_LISTENER=16

TRACE_FILE_LISTENER=listener.trc (listener.trc is the default)

TRACE_DIRECTORY_LISTENER=$ORACLE_HOME/network/trace

What i was missing is that you can initiate tracing by issuing the following command

lsnrctl trace 16 (to turn the trace on)

lsnrctl trace off (to turn the trace off)

the trace information is generated in the default trace directory that can be found at $ORACLE_HOME/network/trace

Regards,

Nitin Salunkhe

[Former Member · Accepted solution]

Thanks a lot Nikin,

Problem solved. The trace file is really informative in directing to the issue cause...

Regards,

[Former Member · Accepted solution]

Hi,

What was the problem and how you solve.

Please update so that other members can get benifits from it

Regards,

Nitin Salunkhe

[Former Member · Accepted solution]

Hi Nikin,

The cause is ora<SID> failed to write .oracle file, you just need change permission to any directory access by ora<SID>.

Regards,

[Former Member]

Hi

Check this [Link|http://download-east.oracle.com/docs/cd/B10501_01/network.920/a96580/listener.htm] may help you

Regards

Uday

[Former Member]

Hi,

Which user id you are using to start listner?

login as ora<SID> and try.

Regards,

Nitin Salunkhe

[Former Member]

Hi Nitin,

I did the lsnrctl start using ora<SID>

Regards.

[Former Member]

Hi,

check for your DB host environment parameter set properly or not?

Regards,

Nitin Salunkhe

[Former Member]

Hi,

I already set env value as follow:

ORACLE_HOME=/oracle/<SID>/102_64

ORACLE_SID=<SID>

Any other value to be set? Thanks.

Regards,

[Former Member]

hi

set ORACLE_HOSTNAME Environment Variable also and try

Regards,

Nitin Salunkhe

[audunlea_hansen]

Hi!

Please check if the env parameter TNS_ADMIN.

Locate the files listener.ora and sqlnet.ora (Normaly found where TNS_ADMIN points).

Check the name of the listener in listener.ora e.g. "LISTENER ="

Try 'lsnrctl start LISTENER'

Regards

Audun