RE: What am I missing?

The sqlnet.ora files are identical on each server, they were actually copied from a central location.

I agree with your guess about connect as I have tried various methods of tracing it within sql and am unable to. I guess I should try strace on the devel server and see if I see a difference.

Thanks.

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman_at_ucdavis.edu
(530) 754-6208
From: Dan Norris [mailto:dannorris_at_dannorris.com] Sent: Thursday, February 19, 2009 1:47 PM To: William Wagman; oracle-l
Subject: Re: What am I missing?

Bill,

Make sure your sqlnet.ora files are the same on dev vs the other environment you're testing. I'm not positive, but those libraries seem like they might have to do with advanced security (like Kerberos, etc) and your sqlnet.ora settings might cause them to be invoked (or not).

Not a complete guess (BAAG!), but not an absolute certain solution either. I don't think that CONNECT is treated the same as other commands, so it is possible that WHENEVER somehow triggers a code path that would cause the parameters in sqlnet.ora to be employed whereas CONNECT may not (that's a bit more of a guess, though).

Dan

-----Original Message-----
From: William Wagman [mailto:wjwagman_at_ucdavis.edu<mailto:wjwagman_at_ucdavis.edu>] Sent: Thursday, February 19, 2009 4:20 PM To: oracle-l
Subject: What am I missing?

Greetings,

I'm running oracle 9.2.0.8.0EE on RHEL4, all 64-bit. I have a login.sql where a few usernames and passwords are defined and I am able to connect successfully...

[oracle_at_critpinn ~]$ sqlplus /

SQL*Plus: Release 9.2.0.8.0 - Production on Thu Feb 19 12:58:33 2009 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.8.0 - Production

SQL> CONNECT &&UCD_USER/&&UCD_PASSWORD;
Connected.

However if I initially issue a whenever oserror the connection fails with a no such file or directory message...

[oracle_at_critpinn ~]$ sqlplus /

.
.
SQL> WHENEVER OSERROR EXIT SQL.SQLCODE ROLLBACK SQL> CONNECT &&UCD_USER/&&UCD_PASSWORD
O/S Message: No such file or directory
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.8.0 - Production

This behaves differently on the development box, ie, I don't get disconnected as a result of the whenever oserror clause. I am unable to find a difference between the two boxes which would cause the error and web searching has not revealed anything yet. Strace reveals that the files

$ORACLE_HOME/lib/libngss9.so &
$ORACLE_HOME/lib/libnnts9.so

Don't exist but they do not exist on the devel box either. I see many seeks and immediately before it dumps there is a line with text...

Lseek (7, 0, SEEK_CUR) = -1 ESPIPE (Illegal seek)

But I have no idea what that means. I can't for the life of me determine what file is being sought in this case. Any suggestions would greatly appreciated. Even suggestions for how to trace the problem further.

--
http://www.freelists.org/webpage/oracle-l