Solved

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

Posted on 2011-03-21
2
418 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
2 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

863 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

20 Experts available now in Live!

Get 1:1 Help Now