RE: sqlplus "/as sysdba" giving error

  • From: William Wagman <wjwagman@xxxxxxxxxxx>
  • To: "avadhanimys@xxxxxxxxx" <avadhanimys@xxxxxxxxx>, Subodh Deshpande <subodh_deshpande@xxxxxxxxx>
  • Date: Fri, 2 Jan 2009 10:37:29 -0800

If you are attempting to install Netbackup for use with Oracle certain pieces 
must be relinked. See Metalink note 209117.1 for details.

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman@xxxxxxxxxxx
(530) 754-6208 
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Avadhani mys
Sent: Wednesday, December 24, 2008 5:10 AM
To: Subodh Deshpande
Cc: oracle-l
Subject: Re: sqlplus "/as sysdba" giving error

Hi,
Thanks a ton for your quick replies.

Actually the netbackup binaries were installed by storage team in 
path /usr/openv/netbackup and also i see they have created soft link of 
libobk.so to /usr/openv/netbackup as shown below.

i believe relinking oracle binaries might slove the issue.

There are 2 instances running and it was running when they have installed 
netbackup binaries/


bash-2.05$ ls -ltr /opt/app/oracle8i/products/817/lib/libobk.so
lrwxrwxrwx   1 oracle8i dba           36 Dec 23 16:24 
/opt/app/oracle8i/products/817/lib/libobk.so -> 
/usr/openv/netbackup/bin/libobk.so.1
bash-2.05$ 

On Wed, Dec 24, 2008 at 5:54 PM, Subodh Deshpande <subodh_deshpande@xxxxxxxxx> 
wrote:
0) where did you installed the netbackup binaries, in the $ORACLE_HOME itself..
1) was the instance and databse running while installing netbackup
2) is the instance and database running  now
3) primafacie it seems to be just an issue of environement variable or some 
soft links only
thanks!
subodh

________________________________________
From: Avadhani mys <avadhanimys@xxxxxxxxx>
To: oracle-l <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, 24 December, 2008 16:42:52
Subject: sqlplus "/as sysdba" giving error

Hi Guru's 

I'm facing this problem in oracle 8i Dev database running on solaris, this we 
are facing after installing netbackup binaries. i have to do clone by shutting 
down the database to validate the netbackup.

Please suggest should i kill the instance and relink of libraries would solve 
my problem. I checked in metalink but did not get any help.
Please help me on this

Thanks in advance.
Avadhani



bash-2.05$ sqlplus "/as sysdba"

SQL*Plus: Release 8.1.7.0.0 - Production on Wed Dec 24 01:30:32 2008

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

ld.so.1: oracle<SID>: fatal: relocation error: file 
/opt/app/oracle8i/products/817/lib/libobk.so: symbol disableAutoMsgCacheUnload: 
referenced symbol not found
ERROR:
ORA-12547: TNS:lost contact



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


Other related posts: