Determine basic server operation
Ask these questions:
Can any workstation or server connect to the server? If so, then the server is operating properly and you should diagnose the client.
Is the database running? If not, start the database and retest the connection.
Is the listener running? If not, start the listener and retest the connection.
Can a loopback test be performed on the server? If so, you should diagnose the client. If not, the problem lies either in the SQL*Net configuration or in the network protocol stack on the server host.
If you are using Oracle Names, is the Names server running and reachable? If not, start the Names server or correct any connectivity problem.
Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.