Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Oracle database connection

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

Connect further...control easier

With the ATEN CE624, you can now enjoy a high-quality visual experience powered by HDBaseT technology and the convenience of a single Cat6 cable to transmit uncompressed video with zero latency and multi-streaming for dual-view applications where remote access is required.

Question has a verified solution.

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

A Bare Metal Image backup allows for the restore of an entire system to a similar or dissimilar hardware. They are highly useful for migrations and disaster recovery. Bare Metal Image backups support Full and Incremental backups. Differential backup…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
This Micro Tutorial will give you a basic overview of Windows DVD Burner through its features and interface. This will be demonstrated using Windows 7 operating system.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

789 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