Listener is pointing to wrong location

[Former Member]

Hi Experts,

I have installed 3 database in my one unix server. For one of the system the listener parameter file location is pointing to wrong path. It should point to /oracle/<SID>/11202/networ/admin/listener.ora but it is pointing to other system SID hence the error is like the user is not authorized to start the listener.

I checked the env of my system and which is fine. Please suggest where can i check the path for Listener parameter File.

Thanks and Regards

Gaurav

[Former Member]

After restarting all Listener processes it solved the problem.

[Former Member]

Hi,

Please check below notes.

Note 609332 - Composite note: ORA-12541/ORA-12224

Note 396873 - UNIX: Error due to socket authorizations

Regards,

Venkata S Pagolu

[Former Member]

Hi All,

The problem has been resolved after rerstarting all the listener process in the LPAR.

Thanks for all your help.

Gaurav

[Former Member]

Hi,

Could you pls post your where exactly the location is wrong?

Br,

Venky

[Former Member]

Hi Mate

Please check the following log :-

lsnrctl status LISTENER_ABC

LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production on 16-FEB-2012 03:46:06

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=ABC.WORLD))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

IBM/AIX RISC System/6000 Error: 2: No such file or directory

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=ABC))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

IBM/AIX RISC System/6000 Error: 2: No such file or directory

Connecting to (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=aytgfsredaa)(PORT=1521))

STATUS of the LISTENER

-

---

Alias LISTENER

Version TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production

Start Date 27-JAN-2012 14:58:35

Uptime 19 days 12 hr. 47 min. 32 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /oracle/XYZ/112_64/network/admin/listener.ora

In the above log I am trying to check the status of LISTENER_ABC and it should go to /oracle/ABC/112_64/network/admin/listener.ora but it is pointing to /oracle/XYZ/112_64/network/admin/listener.ora

Please suggest.

Thanks and Regards

Gaurav

[Former Member]

Hi,

Check following env variable for user executing listener start for LISTNER_ABC.

1. ORACLE_HOME (should be "/oracle/ABC/112_64")

2. ORACLE_HOME (should be "ABC")

3. TNS_ADMIN (should be "/oracle/ABC/112_64/network/admin")

Also check listener.ora, tnsnames.ora contents if it pointing to correct path.

Regards.

Rajesh Narkhede

[Former Member]

Hi Gaurav,

Execute the following command.

env | grep -i XYZ

Whereever you see XYZ you have to convert it to ABC.

Then, try to check the status of the listener.

Br,

Venky

[Former Member]

Hi Raj,

The env is pointing to right system i.e ABC.

Path also defined is fine.

Thanks and Regards

Gaurav

[Former Member]

Hi Venkatesh,

env -i | grep XYZ

The output is null. Env is fine.

Thanks and regards

Gaurav

[Former Member]

Hi Gaurav,

Please post the contents of the file /oracle/ABC/112_64/network/admin/listener.ora.

You can rename the hostname and port numbers.

Br,

Venky

[Former Member]

Hi Venky

I tried but nothing is working . The tnsping to ABC is OK. nOnly the issue is listener patameter file location.

Please find the log :-

################

1. Filename......: listener.ora

2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

3. Name..........:

4. Date..........:

5. @(#) $Id: //bas/720_REL/src/krn/tpls/ora/LISTENER.ORA#1 $

################

ADMIN_RESTRICTIONS_LISTENER_ABC = on

LISTENER_ABC =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = ABC.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = ABC)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = aytgfsredaa)

(PORT = 1521)

)

)

STARTUP_WAIT_TIME_LISTENER_ABC = 0

CONNECT_TIMEOUT_LISTENER_ABC = 10

TRACE_LEVEL_LISTENER_ABC = OFF

SID_LIST_LISTENER_ABC =

(SID_LIST =

(SID_DESC =

(SID_NAME = ABC)

(ORACLE_HOME = /oracle/ABC/112_64)

)

)

Thanks and regards

Gaurav

[Former Member]

Hi Gaurav,

what is echo $ORACLE_HOME ?

Set the env variable ORACLE_HOME to /oracle/ABC/112_64/ explicitly and then try to check the status of the listener.

Br,

Venky

[Former Member]

Hi Venky

Its already pointing to /oracle/ABC/112_64.

No issue is in env as tnsping is fine.

Thanks and regards

Gaurav

[Former Member]

So you installed three oracle databases in one server.

But how many listeners did you install?

Possible answers are: 1, 2, 3.

In case of 2 or 3: Did you use different port numbers for them?

[Former Member]

Hi Joe,

Yes its 3 and all different port.

Thanks

Gaurav

[Former Member]

Now let's see what listeners are running on your system,

try this:

ps -ef | grep -i listener

[nicholas_chang]

Hi,

Please ensure the tnsname.ora and sqlnet.ora are insync in /usr/sap/SID/sys/profile/oracle.

Cheers,

Nicholas CHang