Solved

Oracle database connection

Posted on 2013-01-28
5
479 Views
Last Modified: 2013-01-29
Oracle 11g client installed in a public place on c:\ in windows. For example, c:\oracle\production\client_1, but tnsnames.ora and sqlnet.ora files are located in another driver. For example, e:\oracle\files\tnsnames.ora and sqlnet.ora. The two files can't be copied to Oracle home on c:\. Can the databases in the tnsnames.ora be connected and how to do that?
0
Comment
Question by:jl66
5 Comments
 
LVL 73

Accepted Solution

by:
sdstuber earned 200 total points
ID: 38828849
set TNS_ADMIN=e:\oracle\files
0
 
LVL 23

Assisted Solution

by:David
David earned 100 total points
ID: 38829019
Agreed, if you are comfortable doing so, the TNS_ADMIN variable may be set as a system default under the CP / system / advanced / environment.  Secondly, consider placing a shortcut to the E: folder in your other oracle home(s).

For the fun of it, please always remember to backup your source file prior to making ANY changes with its content.
0
 
LVL 36

Assisted Solution

by:Geert Gruwez
Geert Gruwez earned 150 total points
ID: 38830011
there is no need to create a link e:
the unc patch can be specified too

set tns_admin=\\server\share

as a backup plan copy the tnsnames.ora and sqlnet.ora to a local folder
when the \\server\share becomes unavailable it's possible to revert
too see how this works:
start tnsping with a share or reverting if it fails:
md c:\oracle\tns
robocopy \\server\share c:\oracle\tns *.ora
if exist \\server\share ( 
  set tns_admin=\\server\share
) else (
  set tns_admin=c:\oracle\tns
)
tnsping db_alias

Open in new window

0
 
LVL 15

Assisted Solution

by:Franck Pachot
Franck Pachot earned 50 total points
ID: 38830068
Hi,
You can also set the TNS_ADMIN in the registery for a specific ORACLE_HOME.
Note that environment variable takes precedence on registery.
Regards,
Franck.
0
 

Author Closing Comment

by:jl66
ID: 38832749
Thanks a lot.
0

Featured Post

Want to promote your upcoming event?

Attending an event? Speaking at a conference? Or exhibiting at a tradeshow? Easily inform your contacts by using a promotional banner in your email signature. This will ensure your organization’s most important contacts are in the know.

Join & Write a Comment

Suggested Solutions

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
This video shows how to recover a database from a user managed backup
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now