?
Solved

Oracle11gR2: Installed client and need to set up sqlnet, how and where do I do that?

Posted on 2011-03-21
2
Medium Priority
?
424 Views
Last Modified: 2013-11-11
Hello experts,

Installed client and need to set up sqlnet, how and where do I do that?

here is my current environmental variables (for client, linux):

ORACLE_HOME=/oracle
ORACLE_SID=orcl
ORACLE_BASE=/home/oracle/app/oracle
TMP=/oracle/tmp
TMPDIR=/oracle/tmp
PATH=/oracle:$PATH
LD_LIBRARY_PATH=$ORACLE_HOME:$PATH
TNS_ADMIN=/oracle/tnsnames.ora

also, need to install TCP/IP Adapter, not sure what this is..

thanks,

Regards,
0
Comment
Question by:epifanio67
[X]
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
2 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 35185521
First I believe TNS_ADMIN points to the folder where the tnsnames.ora and sqlnet.ora file reside.

Back to the question: what makes you think it isn't set up properly?  What isn't working?  Error messages? Etc..
0
 

Author Closing Comment

by:epifanio67
ID: 35185720
thank you....

regards,
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
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.
Suggested Courses

801 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