Listener Not working

[Former Member]

Hi,

We have installed ECC6 in a clustered environment.

We have a scenario where we have two nodes CPDB(Database) and CPCI(application).

As we did not have the oracle file system in CPDB, we moved the same from CPCI to CPDB as a directory...

we also have a script that was written for startsap stopsap dbstart dbstop.

Now after the oracle file system has been copied to CPDB, we are not able to up the system.

the listener does not start while we login as ora<sid> and instead we are able to start db using <sid>adm ...

While starting sap in the application node CPCI, we get the following.

CPCI:cpladm 1> startsap r3

Checking CPL Database

-

---

ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-

---

18:13:28 29.11.2007 LOG: Effective User Id is root

***********************************************************************

• This is Saposcol Version COLL 20.90 700 - AIX v6.55 5L-64 bit 060323

• Usage: saposcol -l: Start OS Collector

• saposcol -k: Stop OS Collector

• saposcol -d: OS Collector Dialog Mode

• saposcol -s: OS Collector Status

• The OS Collector (PID 536592) is already running .....

************************************************************************

saposcol already running

ABAP Database CPL must be started on remote server

But while we try to start the listener we get the following in both the nodes

CPCI:oracpl 1> lsnrctl start

lsnrctl: Command not found.

CPCI:oracpl 2> pwd

/oracle/CPL

CPCI:oracpl 3>

CPDB:oracpl 16> lsnrctl start

lsnrctl: Command not found.

CPDB:oracpl 17> pwd

/oracle/CPL

The listener is not starting up and it is the vice versa in the case of starting database...where <sid>adm does the database start instead of ora<sid>....

Regards,

Radeesh V

[Former Member]

Hi Radeesh

You can access in the directory /bin/sh...it may be in .profile or .login file.

Bourne or Korn shell example ( .profile)

...

LD_LIBRARY_PATH=$ORACLE_

HOME/lib32:$LD_LIBRARY_PATH; export

LD_LIBRARY_PATH

Thanks

Rupali

[former_member193294]

Hi Radeesh,

Are your ORACLE_HOME and PATH environment variables pointing to the same oracle software directory?

what happens when you start the listener after you do this:

$ export PATH=$/bin:$

$ lsnrctl start

Rgds,

Loukas

[Former Member]

Hi Loukas,

Can I know how do check whether the ORACLE_HOME and PATH are pointing to the same Oracle software directory.

and also the proceedure for setting the Correct Path.

Kindly help.

Regards,

Radeesh

[Former Member]

HI,

Make sure to login as ora<sid> and start the lisc...

THanks,

[Former Member]

Hi,

We are logged as ora<sid> and started the listener,but it still says the same..

CPDB:oracpl 1> pwd

/oracle/CPL

CPDB:oracpl 2> lsnrctl start

lsnrctl: Command not found.

[Former Member]

Check the LD_LIBRARY_PATH.

regards

tamilboy

[Former Member]

Hi,

Please let me know how do we check the LD_LIBRARY PATH?

Regards,

Radeesh V

[Former Member]

If I understood your question correctly, your database is on CPDB. As I see, you are trying to start the listener in CPCI. Did you try starting the listener in CPDB?

regards,

tamilboy

Message was edited by:

tamilboy

Message was edited by:

tamilboy

[Former Member]

Hi,

I have started in CPDB (the database node whereby it says)

CPDB:oracpl 15> lsnrctl status

LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 30-NOV-2007 11:30:20

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

Message 1053 not found; No message file for product=network, facility=TNSTNS-12541: Message 12541 not found; No message file for product=network, facility=TNS

TNS-12560: Message 12560 not found; No message file for product=network, facility=TNS

TNS-00511: Message 511 not found; No message file for product=network, facility=TNS

IBM/AIX RISC System/6000 Error: 79: Connection refused

CPDB:oracpl 16> pwd

/oracle/CPL/102_64/bin

CPDB:oracpl 17> lsnrctl start

LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 30-NOV-2007 11:32:29

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

Message 1070 not found; No message file for product=network, facility=TNSTNS-12545: Message 12545 not found; No message file for product=network, facility=TNS

TNS-12560: Message 12560 not found; No message file for product=network, facility=TNS

TNS-00515: Message 515 not found; No message file for product=network, facility=TNS

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

CPDB:oracpl 1> pwd

/oracle/CPL

CPDB:oracpl 2> lsnrctl start

lsnrctl: Command not found.