This content has been marked as final. Show 6 replies
do one thing create a string in registry for sid something like this.
note: you have to create string for all oracle homes.
ORA-12154: TNS error...if you connect to internet and ur tnsnames.ora is set to u r computer name or some other ip address then also it will give u the same error.
please modify the tnsnames.ora with correct IP address.
hope this helps u.
Edited by: SaRaH on Jun 27, 2010 3:19 AM
ashosheh wrote:BINGO!!!!!!!!!! We have a winner! Thank you so much "ashosheh". I looked and there WAS a tnsnames in the directory "Oracle/Middleware/asinst_1/config"....*BUT* it was a sample one. Meaning there was no entry just comments showing you a sample version of a TNS Names entry. So I copied my entry from another TNSNAMES and put it in there and voila...I was able to connect.
Also keep in mind that tnsnames.ora file in forms 11g is under $ORACLE_INSTANCE/config
Thank you very much. This was driving me nutz all of last week!