ORA-12541: TNS: no listener

[Former Member]

Hi,

I have installed two SAP systems on the same host (both with same Oracle-version) and have the problem accessing Database with "sqlplus /nolog"-commando.

I received "'sqlplus' is not recognized as an internal or external command, operable program or batch file"

If I try to cennect with Programms ... --> Application Development --> SQLPLUS

I received the error "ORA-12541: TNS: no listener".

The environment variables are set: ORA_SID, ORACLE_HOME, PATH

Can someone tell me the solution?

Thank you!

regards

[markus_doehr2]

You say "The environment variables are set", with which user are your trying to execute sqlplus?

what gives

echo %PATH%

in a cmd?

--

Markus

[Former Member]

Hi Markus!

Thank you!

I am trying to execute sqlplus with user <sid>adm.

What should give the comando echo %PATH% ,

even if I have two SAP Systems...

Thank you!

regards

[markus_doehr2]

You write, that sqlplus is not recognized, so it's missing in your PATH, that's what I wanted to check.

The PATH should contain

%ORACLE_HOME%\bin

where ORACLE_HOME is the one of the actual sap<sid>.

--

Markus

[Former Member]

Hi!

Thank you!

Do you mean PATH (System) or PATH from the current <sid>adm.

You write that ORACLE_HOME should bethe one of the current sap<sid>, but we set ORACLE_HOME to the first SAP system. ORACLE_HOME refers to the the oracle-folder.

Thank you!

regards

[markus_doehr2]

Try if

echo %PATH% contains a PATH to the sqlplus executable for <sid>adm.

Don't look in the "my computer" environment, open a cmd.exe and try there.

--

Markus

[Former Member]

when installing more than one ORACLE_HOME, that is installing the Oracle software at least twice into diferent paths on disk, you have to follow the section in SAP installation guide describing the necessary manual changes to environment.

in short words (for 2 ORACLE_HOMES):

you have to remove ORACLE_HOME1\BIN and ORACLE_HOME2\bin directories from system environment PATH.

you have to add ORACLE_HOME1\BIN to SID1adm's user environment variable PATH

you have to add ORACLE_HOME2\BIN to SID2adm's user environment variable PATH

in the second (SID2) system you have to use a different tcp/ip port (default is 1527) in the tnsnames and listener configuration.

in short words, hope that you can handle it.

regards

Peter