CODEWITHSUNDEEP
oracle-databaselistenertnsnames
LauraH
LauraH

Reputation: 3

"ORA-12541: TNS:no listener" but there are log entries in the listener log

I am using SQLPlus on a remote machine and after I put in my username and password it says "ORA-12541: TNS:no listener", but when I look at the listener log on the Oracle 19c server, there is an entry showing the connection. What am I doing wrong?

I was trying to log in to SQLPlus when I got the error.

Here are my test results:

  1. TNSPing Server Test Results: Attempting to contact (ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.132.16)(PORT = 1521)) OK (30 msec)

  2. Yes, I can connect to sqlplus on the server

  3. lsnrctl status listener Services Summary... Service "CLRExtProc" has 1 instance(s). Instance "CLRExtProc", status UNKNOWN, has 2 handler(s) for this service... Service "RADB" has 1 instance(s). Instance "RADB", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully

  4. TNSPing Client Test Results: Message 3513 not found; No message file for product=NETWORK, facility=TNSMessage 3509 not found; No message file for product=NETWORK, facility=TNS

  5. Telnet OK

Upvotes: 0

Views: 901

Answers (1)

Joaquim Carvalho
Joaquim Carvalho

Reputation: 61

It seems you are with wrong configuration environment variables, and my guess is you are trying to connect from a windows machine as client, correct?

Does the ORACLE_HOME was set at the System / Environment level on the Windows client? Do you have more than one Oracle Client installed?

You can try going to the Oracle Home Client bin folder, unset the ORACLE_HOME env (if is it set).

Test in a CMD prompt session like:

E:>\oracle\product\12.1\client_1\bin>set ORACLE_HOME=

Now try to TNSPing again. The "no message file" errors should clear.

Is it the TNS_ADMIN env set? If not, you can try to set it to the correct ORACLE_HOME\network\admin folder, with the correct tnsnames.ora configured to your database.

Are you trying to connect with a user common account or using the sys as sysdba?

Upvotes: 0

Related Questions