Solved

How to connect to oracle 9i data base using XEClient

Posted on 2008-10-22
3
611 Views
Last Modified: 2013-12-19
Dear Friends,

I'm using  XEClient for Orcale 10g  and I need to reach a Oracle 9i data base on the server, where can I put tnsnames.ora in XEClient?

Thanks in adnvance!
Jose Luis
0
Comment
Question by:dclsoft
3 Comments
 
LVL 27

Expert Comment

by:sujith80
Comment Utility
Search for the directory NETWORK under your oracle home.
tnsnames.ora should go to admin directory under that.
0
 

Author Comment

by:dclsoft
Comment Utility
my client folder there are not folders \network, I know that qhen You have a Oracle Home, I Have only XECLIENT folder, then where can I put the TNSNAMES.ORA? Take a look in the image!
XECLIENT.jpg
0
 
LVL 2

Accepted Solution

by:
barfi earned 500 total points
Comment Utility
If you install full 10g client you should have network folder but try creating or adding a service thru Net Configuration Assistant or Net Manager.
Go to All programs -> Oracle-OraClient10g_home -> Net Configuraion Assistant to add your service name and then check under your xeclient directory and see if it generated a TNSNAMES.ora file and sqlnet.ora file.
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.

Join & Write a Comment

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
Via a live example, show how to take different types of Oracle backups using RMAN.

772 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

11 Experts available now in Live!

Get 1:1 Help Now