This content has been marked as final. Show 4 replies
You are right in that they would normally share the same TNSNAMES file, providing you are using the same version.
Are you running in Apps mode or standard mode? If Apps mode you need to make sure you check the Oracle Applications checkbox in both.
You said, and I quote "Both of these products are installed on my pc". Does this mean you installed a different Desktop version than the Administration one or perhaps installed them separately and have 2 different Oracle Homes? If you do have 2 different Oracle Homes they will not share the same TNSNAMES and you will have 2 copies.
You can check quickly by using Windows Explorer and examing the contents of the c:\oracle folder. What do you see? Do you see only C:\Oracle\BIToolsHome_1 or do you by chance see that and something else?
It is possible to force all Oracle Homes to share a TNSNAMES file and in order to do that follow this workflow:
1. Launch Windows Control Panel
2. Select SYSTEM
3. Click on the Advanced tab
4. Click on the Environment Variables button
5. At the bottom of the screen click the button called New
6. In Variable Name enter TNS_ADMIN
7. In Variable Value enter something like c:\oracle\tnsadmin
8. Click the OK button as many time as needed to save and close the Control Panel
9. Launch Windows Explorer
10. Make sure the folder you referenced in step 7 exists, and if not create it
11. Copy a good TNSNAMES.ORA into this location
Once this is done, irrespective of the Oracle client being used, c:\oracle\tnsadmin\tnsnames.ora will be the tnsnames.ora file used to resolve oracle names.
Hope this helps
We are running in Standard mode. Also only have have 1 Oracle Home on my pc.
When I check Windows Explorer and and look under C:\Oracle, I am only seeing BIToolsHome_1.
I tried setting up the environment variable and I am still having the same issue.
Any other suggestions ? Is there a way to track / trace where it is picking this up ?
Are you seeing any error messages?
Also, are the people who are not gaining access via Desktop also administrators or are these on different machines? If on different machines, each one needs to have its own copy of TNSNAMES.ORA. The file is only shared on the application server. It is not shared from machine to machine unless you place a central copy on a shared network drive and map that drive as I described in my earlier posting.
The error message I am getting is :
Unable to connect to :eul_admin@rmsuat2 Failed to connect to database - ORA-12154:could no resolve the connect identifier specified.
Currently, I am the only one having this issue. I am the only one in the company with Plus, Viewer, Discoverer Desktop(Drake), and the Discoverer Administrator Version on my desktop. Using the eul_admin account and db or rmsuat2, I can sign on to the Admin version and also onto Discoverer Plus. I cannot signon to Desktop (Drake) with the eul_admin account and the db of rmsuat2.
I have set-up an environment system variable to point to our N:\tns_admin but it has not worked.