Solved

Oracle database connection

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
NTFS file system has been developed by Microsoft that is widely used by Windows NT operating system and its advanced versions. It is the mostly used over FAT file system as it provides superior features like reliability, security, storage, efficienc…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

776 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