TNS-01150: The address of the specified listener name is incorrect - Two database on one host

[Former Member]

Dear All,

We are in a process of Installing SAP EHP7 ABAP+JAVA stack on Solaris. Abap stack has been successfully installed. But at the time of installation of Java Stack I am getting the below error and unable to start both the listners for ABAP Database and Java Database.

I have modified both the listeners as per the note - 98252

I have attach Listener.ora and tnsnames.ora

abap database - req

java database - rjd

Error -

sapqa:orarjd 2% lsnrctl start

LSNRCTL for Solaris: Version 11.2.0.3.0 - Production on 16-OCT-2014 11:39:14

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

Starting /oracle/RJD/112_64/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 11.2.0.3.0 - Production

System parameter file is /oracle/RJD/112_64/network/admin/listener.ora

Log messages written to /oracle/RJD/112_64/network/log/listener.log

TNS-01150: The address of the specified listener name is incorrect

NL-08014: Failed to initialize Diagnosability framework, falling back to old network tracing/logging

  NL-08002: Diagnosability  context creation failed

Listener failed to start. See the error message(s) above...

Logs..

System parameter file is /oracle/REQ/112_64/network/admin/listener.ora

Log messages written to /oracle/REQ/112_64/network/log/listener.log

Trace information written to /oracle/REQ/112_64/network/trace/listener.trc

Trace level is currently 0

NL-08014: Failed to initialize Diagnosability framework, falling back to old network tracing/logging

NL-08002: Diagnosability  context creation failed

Started with pid=19712

TNS-01150: The address of the specified listener name is incorrect

NL-08014: Failed to initialize Diagnosability framework, falling back to old network tracing/logging

  NL-08002: Diagnosability  context creation failed

Error - rjd

TNSLSNR for Solaris: Version 11.2.0.3.0 - Production

System parameter file is /oracle/RJD/112_64/network/admin/listener.ora

Log messages written to /oracle/RJD/112_64/network/log/listener.log

TNS-01150: The address of the specified listener name is incorrect

NL-08014: Failed to initialize Diagnosability framework, falling back to old network tracing/logging

  NL-08002: Diagnosability  context creation failed

Listener failed to start. See the error message(s) abov

Can any one please help..??

Thanks,

Regards,

Letz..

Listener.ora.txt.zip

tns.ora.txt.zip

[ACE-SAP · Accepted solution]

Hi

Did you have specific requirements for creating two databases ?

In fact you have two instances, that creates a major overhead on your system.

The best practice, if all the components (abap & java engine + DB instance) are installed on one host,

is to create a new schema in the same DB for Java (MCOD)

388866 - Multiple Components on One Database - Installation

Regards

[Former Member · Accepted solution]

Could you please let me know where can I found the installation guide with MCOD procedure. I am unable to find on the above link.

Thanks,

Regards,
Letz..

[ACE-SAP · Accepted solution]

No specific procedure to follow.

You just need to provide the SID of the existing ABAP DB and then select the appropriate option in the SWPM.

The installer will then create the new schema in the Oracle database used by the ABAP stack.

Regards

[Former Member · Accepted solution]

Thanks.Followed your procedure. Installation done successfully.