SAP (Documents/Screen shots/Complete Solution): RE: [oracle-db-l] ORA-12541:TNS: No Listener Error While Connecting to Database Using SQL*Plus in Oracle 9i

Reply from Aac on Jul 28 at 7:14 PM

Hi:

Can I see this information: (for windows systems)
1) tracert "database server" command, from the client machine to database server
2) ip of machine making nat
3) ipconfig /all of database server

(trying to help).
Regards

---------------Original Message---------------
From: Tom Falconer
Sent: Saturday, July 28, 2012 10:45 AM
Subject: ORA-12541:TNS: No Listener Error While Connecting to Database Using SQL*Plus in Oracle 9i

Hi Throataj,

Try these steps to identify where the problem is:

On the database server, connect to the database using a SQLNet connection: sqlplus scott/tiger@databasename.

If this doesn't work, there is an issue with the connection setup on the server. Investigate the listener log file. Try tnsping'ing from the server and see if the settings are the same as they are on the client.

If it does work, check the listener log for failed connections. Increase the trace level if you need to get additional information.

Can you telnet from the client on port 1621? If that doesn't get any response, there is probably a firewall or something in the way.

There are many other possibilities but these are where I would start.

HTH,

Tom

Reply to this email to post your response.

__.____._

Manage Settings | Unsubscribe | Create FAQ | Send Feedback