RE: What am I missing?
- From: William Wagman <wjwagman@xxxxxxxxxxx>
- To: Jeffrey Beckstrom <JBECKSTROM@xxxxxxxxx>, "gparc@xxxxxxx" <gparc@xxxxxxx>
- Date: Mon, 23 Feb 2009 12:34:17 -0800
Jeffrey, that fixes the problem, thanks.
Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman@xxxxxxxxxxx
(530) 754-6208
From: Jeffrey Beckstrom [mailto:JBECKSTROM@xxxxxxxxx]
Sent: Monday, February 23, 2009 10:57 AM
To: gparc@xxxxxxx; William Wagman
Cc: oracle-l
Subject: RE: What am I missing?
We had something similar a few years ago. Check out BUG 2546111.
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
>>> William Wagman <wjwagman@xxxxxxxxxxx> 2/23/09 1:39 PM >>>
I have been investigating further. I found the bug report you mentioned but I
have not applied the patch to either server. The error does not occur on the
test/devel server but does on the production. Do you have any further
suggestions?
Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman@xxxxxxxxxxx
(530) 754-6208
-----Original Message-----
From: gparc@xxxxxxx [mailto:gparc@xxxxxxx]
Sent: Friday, February 20, 2009 12:46 AM
To: William Wagman
Subject: Re: What am I missing?
Bill,
maybe a difference in patches applied on these two platforms as you probably hit
Bug #5495695 (See ML Note #5495695.8)
HTH
Regards
Quoting William Wagman <wjwagman@xxxxxxxxxxx>:
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@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@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.
Thanks.
Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman@xxxxxxxxxxx
(530) 754-6208
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
---------------------------------------------------------------------
Scanning of this message and addition of this footer is performed
by SurfControl E-mail Filter software in conjunction with
virus detection software.
Other related posts:
