Solved

How to connect to oracle 9i data base using XEClient

Posted on 2008-10-22
3
613 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
ID: 22784174
Search for the directory NETWORK under your oracle home.
tnsnames.ora should go to admin directory under that.
0
 

Author Comment

by:dclsoft
ID: 22785020
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
ID: 22788930
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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
VB.Net - CSV to Oracle table 4 71
data lookup in Oracle - need suggestions 55 113
dbms_crypto.decrypt   errors out 6 31
SQL2016 to ORACLE11G linked-server 6 15
Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

803 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