This content has been marked as final. Show 5 replies
user3025332 wrote:A couple of quick things to try:
Install folder: /opt/oracle/instantclient_11_2
Remove / at end of TNS_ADMIN. Try connecting again.
Even with TNS_ADMIN set, put ldap.ora in
Many thanks for your reply.
I tried your suggestions, but no dice. I get the same error each time.
Any idea why I'm not getting a trace file ?
It might be carriage return characters in the parameter files - make sure that your sqlnet.ora and ldap.ora are in Unix format.
Linux versions of vi tend to switch seamlessly between unix and dos modes so it isn't always obvious - you can double check with something like 'od -c sqlnet.ora'
Did you set your ORACLE_HOME var?
it might help solve the problem.
rgoold, you are a star ! I should have thought about line endings of course. Many thanks for your suggestion, that fixed the problem.
# file *.ora
ldap.ora: ASCII text, with CRLF line terminators
sqlnet.ora: ASCII text, with CRLF line terminators
# dos2unix *.ora
dos2unix: converting file ldap.ora to UNIX format ...
dos2unix: converting file sqlnet.ora to UNIX format ...
# ./sqlplus -L user@database
SQL*Plus: Release 184.108.40.206.0 Production on Mon Sep 5 15:26:16 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
WOHOOOOO !!! :-)