Many thanks for your reply :). Bur No luck. After checking all the below tips. , Please find my answers below for your tips in red.
I believe it’s a tnsnames.ora file issue
- On windows systems check the path for your tnsnames.ora file
tnsnames.ora path - D:\oracle\product\10.2.0\db_2\NETWORK\ADMIN
TNS-ADMIN variable also has same path.
2) Make sure it exists and it’s placed in the correct place
Yes. I confirm that.
- Check within this file, your service name, don’t confuse it with it’s alias
I have attached my tnsnames.ora file. Please check and let me know if any issuesany issues. I am trying to connect to CRMPREP
- check your global name using this SQL:
select * from global_name
The above query returned CRMPREP.REGRESS.RDBMS.DEV.US.ORACLE.COM
And after checking the below link i altered it according to the syntax db_name.db_name to CRMPREP.us.acme.com which i found in ini.ora file. I have also attached the ini.ora file for your reference.
Please check and let me know what can be done further. Many thanks for your help in advance.
init.ora (7.33 KB)