?
Solved

How to connect to oracle 9i data base using XEClient

Posted on 2008-10-22
3
Medium Priority
?
636 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 1500 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

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

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…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

589 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