Solved

Oracle database connection

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

Want to promote your upcoming event?

Are you going to an event? Are you going to be exhibiting at a tradeshow? Talking at a conference? Using a promotional banner in your email signature ensures that your organization’s most important contacts stay in the know and can potentially spread the word about the event.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
pdf convertor 7 66
DHCP Server 14 66
what is Visual Studio Tools for Office Runtime Redistributable 2 18
gpupdate /force to all workstations 4 19
Our Group Policy work started with Small Business Server in 2000. Microsoft gave us an excellent OU and GPO model in subsequent SBS editions that utilized WMI filters, OU linking, and VBS scripts. These are some of experiences plus our spending a lo…
In this article, I will show you HOW TO: Perform a Physical to Virtual (P2V) Conversion the easy way from a computer backup (image).
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

867 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

21 Experts available now in Live!

Get 1:1 Help Now