This content has been marked as final. Show 6 replies
Thanks for reply.
I've tried both SUPPORT and 16 for TRACLE_LEVEL_CLIENT, different dirs and empty string for TRACE_DIRECTORY_CLIENT, with and without quotes. I've also tried upper and lower case. But no file is created at all.
I'm currently trying this from root user, exports are the same as in previous post, SELinux is in permissive state. Seems like SQL*Plus is not looking to my *.ora files.
insanepi wrote:Add EZ_CONNECT to your names.directory_path for this.
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Aug 28 14:45:18 2012 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. ERROR: ORA-12154: TNS:could not resolve the connect identifier specified
Also you may put .tnsnames.ora file into your $HOME path.
And tracing is a good starting point for troubleshooting.
The failure to produce a trace file is a good clue.
There are two possibilities:
1) No write permission to the directory in TRACE_DIRECTORY_CLIENT
2) tnsnames.ora is not found.
If you can rule out 1), it must be 2).
Does "echo $TNS_ADMIN" immediately before calling sqlplus show what you expect?
You could use "strace -f -o log sqlplus ..." to find out where Oracle looks for tnsnames.ora.