This content has been marked as final. Show 6 replies
Set TRACLE_LEVEL_CLIENT to SUPPORT and add an appropriate TRACE_DIRECTORY_CLIENT to sqlnet.ora.1 person found this helpful
Then retry and read the trace file (or post relevant parts here).
That will show what the problem is.
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.
1 person found this helpful
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.
Albe, thanks a lot! I found a problem in strace log.
It was quite silly though. Since I've modified .ora files from windows client, they got \r at line ends and it was confusing sqlplus.
Thanks for sharing the solution.
Yet another thing that can go wrong (and is hard to detect).