Solved

Oracle database connection

Posted on 2013-01-28
5
483 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 74

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 37

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A project that enables an administrator to perform actions within a user session context not just at the time of login but any time later on day(s) or week(s) later.
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
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…
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

679 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