Posted on 2004-09-15
Last Modified: 2008-01-09
I tried to retore a 64 bit oracle install running on Solaris 9 from a tape backup.  The tar checked fine and untarred into the proper directories.  WHen I went into sql plus or rman i get the message oracledwproddb fatal /u01/app/oracle/product/ ELF class ELFCLASS64.
How do I fix it?
Question by:xoxomos
  • 5
  • 2
LVL 23

Expert Comment

ID: 12071302
Did you uninstall Oracle 32 bit cleanly?
If there is any installation of other oracle products in between before you restore Oracle64 bit, you have to relink oracle executables, which is a painful, unworthy process

Otherwise, you need to reinstall Oracle 64 bits.
LVL 48

Assisted Solution

schwertner earned 100 total points
ID: 12072500
What kind of tape backup you have? Is it created with 64 or 32 bit?
I will be surprised if you can use 32 bits backups for 64 bit instance (I expect differences in the file formats).
So the working alternative is Export/Import.

Author Comment

ID: 12076749
This is different.  The Oracle was installed 64 bits.  It was shutdown and a .tar created.
The problem with the 32 bit Oracle on 64 bit linux is different on a different box.
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

LVL 23

Accepted Solution

seazodiac earned 150 total points
ID: 12077362
Let me try to understand:

So you are using a tape backup from the machine installed with Oracle64 bit , try to restore to a brand new machine, to set up Oracle that way instead of install from the scratch?

is that what you try to do here?

No, you cannot do that. In Oracle install process, there is a lot of linking processes going on.

Author Comment

ID: 12077457
Maybe next time arount but No.  Essentially I am in a situation where the oracle server was wiped out.  I'm trying to restore the same oracle server on the same Solaris system it has always been on from a tape backup the systems people take nightly.

Author Comment

ID: 12077741
Tried doing 'relink all'
Got about a dozen error code 1

 - Linking /u01/app/oracle/product/
rm -f tnslsnr
/usr/ccs/bin/ld -o tnslsnr -L/u01/app/oracle/product/ -L/u01/app/oracle/product/ -dy /u01/app/oracle/product/ /u01/app/oracle/product/ /u01/app/oracle/product/ /u01/app/oracle/product/ -lnonc9 -lnl9     -ln9  -lnlsnr9 -lnlsnrc9 -lnsgr9  -lnmd -lnms  -lncm9 -lnmsp -lpeer  -lnro9 -ln9   -ltrace9 -lnl9  -lnonc9  -lnlsnr9 -lnlsnrc9  -lnmd -lnms -lncm9 -lnmsp  -ln9       -lclntsh  `cat /u01/app/oracle/product/`    -lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lnro9 `cat /u01/app/oracle/product/`    -lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lclient9  -lvsn9 -lwtc9  -lcommon9 -lgeneric9 -lwtc9 -lmm -lnls9  -lcore9 -lnls9 -lcore9  -lnls9 -lxml9 -lcore9 -lunls9 -lnls9 `cat /u01/app/oracle/product/`    -lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lnro9 `cat /u01/app/oracle/product/`    -lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lclient9  -lvsn9 -lwtc9  -lcommon9 -lgeneric9  -ltrace9 -lnls9  -lcore9 -lnls9 -lcore9  -lnls9 -lxml9 -lcore9 -lunls9 -lnls9  -lclient9  -lvsn9 -lwtc9  -lcommon9 -lgeneric9 -lnls9  -lcore9 -lnls9 -lcore9  -lnls9 -lxml9 -lcore9 -lunls9 -lnls9   `cat /u01/app/oracle/product/` -R /opt/SUNWcluster/lib:/u01/app/oracle/product/  -Y P,:/opt/SUNWcluster/lib:/usr/ccs/lib:/usr/lib  -Qy -lc -laio   -lm  /u01/app/oracle/product/ -lpeer -lm
*** Error code 1

 - Linking Oracle
rm -f /u01/app/oracle/product/
/usr/ccs/bin/ld   -o /u01/app/oracle/product/ -L/u01/app/oracle/product/ -L/u01/app/oracle/product/ -dy /u01/app/oracle/product/ /u01/app/oracle/product/  /u01/app/oracle/product/ /u01/app/oracle/product/ /u01/app/oracle/product/  /u01/app/oracle/product/ /u01/app/oracle/product/ /u01/app/oracle/product/ /u01/app/oracle/product/ /u01/app/oracle/product/  -lserver9 -lodm9  -lskgxp9 -lskgxn9 -lclient9  -lvsn9 -lwtcserver9  -lcommon9 -lgeneric9 /u01/app/oracle/product/  -lknlopt `if /usr/ccs/bin/ar tv /u01/app/oracle/product/ | grep xsyeolap.o > /dev/null 2>&1 ; then echo "-loraolap9" ; fi`   -lslax9 -lpls9 -lplp9 -lserver9 -lclient9  -lvsn9 -lwtcserver9  -lcommon9 -lgeneric9  -lknlopt -lslax9 -lpls9 -lplp9 -ljox9 -lserver9  -locijdbcst9 -lwwg9  `cat /u01/app/oracle/product/`    -lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lnro9 `cat /u01/app/oracle/product/`    -lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lmm -lnls9  -lcore9 -lnls9 -lcore9  -lnls9 -lxml9 -lcore9 -lunls9 -lnls9 `cat /u01/app/oracle/product/`    -lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lnro9 `cat /u01/app/oracle/product/`    -lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9  -ltrace9 -lnls9  -lcore9 -lnls9 -lcore9  -lnls9 -lxml9 -lcore9 -lunls9 -lnls9 `if /usr/ccs/bin/ar tv /u01/app/oracle/product/ | grep "kxmnsd.o" > /dev/null 2>&1 ; then echo " " ; else echo "-lordsdo9"; fi` -lctxc9 -lctx9 -lzx9 -lgx9 -lctx9 -lzx9 -lgx9 -lordimt9  -lnls9  -lcore9 -lnls9 -lcore9  -lnls9 -lxml9 -lcore9 -lunls9 -lnls9 -lsnls9 -lunls9 -lxsd9 -lnls9  -lcore9 -lnls9 -lcore9  -lnls9 -lxml9 -lcore9 -lunls9 -lnls9   `cat /u01/app/oracle/product/` -R /opt/SUNWcluster/lib:/u01/app/oracle/product/  -Y P,:/opt/SUNWcluster/lib:/usr/ccs/lib:/usr/lib  -Qy -lc -laio -lposix4 -lkstat -lm  /u01/app/oracle/product/  
*** Error code 1

Author Comment

ID: 12089976
I've just decided to restore from the tar file and start all over which brings up a different opportunity.

Author Comment

ID: 12089990
I've decided to restore from an older .tar.  Possibly that was dated after I had messed things up trying to patch the 64 bit oracle with a 32 bit patch.  That brings up a different opportunity.

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
This post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question