Since I have shifted the database to a new server machine, the clients are unable to connect to it. But the database is working fine locally.
Steps taken so far:
- I have made sure that listener service is up and running.
- I have made sure that the settings for SID, port and Address are the same in my tnsames.ora and server listener and tnsnames.
- I restarted the listener service.
Very interestingly, after doing the third step clients happen to connect but after opening a few sessions, or when the database server is rebooted or even if the services window of the server is closed and opened a number of times, the same error message again comes back.
Does it have something to do with the Dedicated/Shared mode setting of the server?
One way to resolve this is to use the server's IP address in the listener.ora rather than hostname. A better way is to add the server's IP address, hostname and fully qualified domain name to the name resolution method that the network is using. If this is not possible, add this information instead to the client machine's hosts file.
Dig Deeper on Oracle database installation, upgrades and patches
Related Q&A from Maria Anderson
Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ... Continue Reading
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error: "Error in invoking target install of makefile /opt/oracle/...../*.mk." Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.