Sqlnet [message #66450] |
Mon, 17 June 2002 02:01 |
deen
Messages: 5 Registered: November 2001
|
Junior Member |
|
|
Hi experts,
I like to trace sqlnet at my application server. I can see my sqlnet.log at my application server and it's updated daily but i do not know where the sqlnet.ora located. I'am using 3-tier system which my application and database were separated. I'am using HP-UX 10.20 at both servers(database & application)
Anybody can tell me where the sqlnet.ora located?
Thanks,
regards
deen
|
|
|
|
Re: Sqlnet [message #66459 is a reply to message #66450] |
Fri, 21 June 2002 02:02 |
deen
Messages: 5 Registered: November 2001
|
Junior Member |
|
|
Hi experts,
I do not have TNS_ADMIN in my unix system, i do not know how they configure sqlnet.ora last time since i'am new in this company and field. So how can do i set up TNS_ADMIN since it is not currently set up in my Unix system.
Thanks
regards
deen
|
|
|
Re: Sqlnet [message #66461 is a reply to message #66450] |
Fri, 21 June 2002 10:22 |
Grant
Messages: 578 Registered: January 2002
|
Senior Member |
|
|
The easiest way is to determine where the files are located. If they are in $ORACLE_HOME/network/admin for eaxample then just add the environment variable to your profile and restart the listener.
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN
|
|
|