Error in Oracle after a frecover

mª del Carmen_1 — Wed, 17 Nov 2004 04:49:37 GMT

Hi all,
I'm working in a HP-UX server, model 9000/800/N4000-44 and version 11.00.
I have done a fbackup of the oracle installation.
I have restored the fbackup with the command "/usr/sbin/frecover -xv -i -f /dev/rmt/1m".

I have connected to oracle owner user and when I have launched a "sqlplus internal", I have had the following error:

# sqlplus internal

SQL*Plus: Release 8.1.7.0.0 - Production on Wed Nov 17 10:37:38 2004

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

/usr/lib/pa20_64/dld.sl: '/apls/orasw/neo/bin/oracle' is not a valid load module.
ERROR:
ORA-24314: service handle not initialized

If I try connect as "svrmgrl", I have the following error:

# svrmgrl

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

/usr/lib/pa20_64/dld.sl: '/apls/orasw/neo/bin/oracle' is not a valid load module.
/usr/lib/pa20_64/dld.sl: '/apls/orasw/neo/bin/oracle' is not a valid load module.
ORA-12547: TNS:lost contact

I have exported the variable SHLIB_PATH correctly.

When I check the $ORACLE_HOME/bin/oracle file I have the following error:

# chatr $ORACLE_HOME/bin/oracle
chatr(warning): file "/apls/orasw/neo/bin/oracle" appears to be corrupted and does not have a DT_FLAGS dynamic table entry. Therefore, the -B options will not function properly.
/apls/orasw/neo/bin/oracle:
64-bit ELF executable
shared library dynamic path search:
LD_LIBRARY_PATH enabled first
SHLIB_PATH enabled second
embedded path enabled third /apls/orasw/neo/rdbms/lib64:/apls/orasw/neo/lib64:/usr/lib/pa20_64:/opt/langtools/lib/pa20_64:
shared library list:
libjox8.sl
libobk.sl
librt.2
libpthread.1
libnss_dns.1
libdl.1
libm.2
libc.2
shared library binding:
deferred
global hash table disabled
shared library mapped private disabled
shared library segment merging disabled
shared vtable support disabled
segments:
index type address flags size
6 text 4000000000000000 z-r-c 16M
7 data 8000000100000000 ---m- 64M
executable from stack: D (default)
static branch prediction enabled
kernel assisted branch prediction enabled
lazy swap allocation for dynamic segments disabled
nulptr references disabled

Anyone knows why ORACLE worked ok before the frecover and after it ORACLE doesn’t work?

Thanks in advance

Re: Error in Oracle after a frecover

Fred Ruffet — Wed, 17 Nov 2004 05:35:37 GMT

Seems your backup may be corrupted. Try to restore from a different backup.

You may also try to relink kernel. I believe it can be done with "relink all" command, logged on as oracle user (all running oracle processes must be stopped : listener, agent...)

Regards,

Fred

Re: Error in Oracle after a frecover

Sunil Sharma_1 — Wed, 17 Nov 2004 05:46:52 GMT

I always restore database not oracle home.

Try to relink all and if don't work you can reinstall oracle. It won't affect you database.

sunil

Re: Error in Oracle after a frecover

Steve Steel — Wed, 17 Nov 2004 06:16:31 GMT

Hi

Check if there are some Oracle shadowprocesses still hanging around
after client sessions were terminated

If so kill and try again

Steve Steel

topic Re: Error in Oracle after a frecover in Operating System - HP-UX

Error in Oracle after a frecover

Re: Error in Oracle after a frecover

Re: Error in Oracle after a frecover

Re: Error in Oracle after a frecover