I am using a Dell laptop with 1 GB RAM and 80 GB hdd with Symantec Antivirus and McAfee Firewall running on a Win XP sp2. I tried doing all these workarounds but it was no use:
- Disabling the firewall and connecting.
- Adding a connect_timeout_listener parameter to the listener.ora file and setting it to 1000 or zero.
- Changing sqlnet.authentication_services to none(NTS).
Can you please suggest some other workarounds? Do I need to create another instance and try? Do I have to reinstall Oracle again? Thanks in advance.
Another way to check is to exit to the DOS prompt and type in:
lsnrctl statusThis should report back information about the instances this listener is listening for.
My second suggestion is to include the parameter local_listener in the init.ora or spfile so that it correctly identifies the listener. This is not required but may help the instance register with the listener if you find (from performing the above command) that the instance has not registered with the listener. Note that it may take up to 60 seconds after startup for an instance to register with the listener.
Finally, you should check to make sure that the information contained in your tnsnames.ora file is correct. In particular, check that there is an entry for the Oracle instance you are trying to connect to and that the proper hostname or IP address is used.
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.