Go Premium for a chance to win a PS4. Enter to Win



Posted on 2004-09-15
Medium Priority
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 ld.so.1 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 300 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.
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

LVL 23

Accepted Solution

seazodiac earned 450 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 Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

963 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