This discussion is archived
1 2 Previous Next 25 Replies Latest reply: Feb 16, 2013 5:22 AM by 864103 RSS

cloning oracle home

864103 Newbie
Currently Being Moderated
Hi expert ,

kindly i need your support with me as usual

i have oracle 11.2.2 under oracle linux 5.6 in source server in test server i install oracle linux 5.6 and then i cloning the oracle home
and i get successfully cloning oracle home , now i need to do cloning of my database but rman and sqlplus not work
[oracle@TCCBS bin]$ ./sqlplus
./sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory
[oracle@TCCBS bin]$ ./rman
./rman: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory
[oracle@TCCBS bin]$
please advice .
  • 1. Re: cloning oracle home
    Sunny kichloo Expert
    Currently Being Moderated
    Please check environment variable.

    Also look into this

    -bash: sqlplus: command not found / Oracle file permissons

    http://mrothouse.wordpress.com/tag/libsqlplus-so/
  • 2. Re: cloning oracle home
    Nicolas.Gasparotto Oracle ACE
    Currently Being Moderated
    To make the picture clearer, it is continuing the thread Re: 11.2.2
    Are you sure you set the same env. variables of oracle user on the target as is on source server ? Such as ORACLE_HOME, LD_LIBRARY_PATH...

    Nicolas.
  • 3. Re: cloning oracle home
    ShishirTekadeR Explorer
    Currently Being Moderated
    set all oracle env parameter
    then run:-

    $ORACLE_HOME/bin/relink all

    after finish relink please try to connect sqlplus


    *****************************************
    Best Regards,
    Shishir Tekade.
    My Blog: http://shishirtekade.blogspot.com
  • 4. Re: cloning oracle home
    864103 Newbie
    Currently Being Moderated
    be informed please i do all of these but not work
     env | sort
    _=/bin/env
    G_BROKEN_FILENAMES=1
    HISTSIZE=1000
    HOME=/home/oracle
    HOSTNAME=TCCBS
    INPUTRC=/etc/inputrc
    LANG=en_US.UTF-8
    LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/lib
    LESSOPEN=|/usr/bin/lesspipe.sh %s
    LOGNAME=oracle
    LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
    MAIL=/var/spool/mail/root
    OLDPWD=/home/oracle
    ORACLE_HOME=/u01/app/oracle/product/11.2.0
    ORACLE_SID=ABSNL1
    PATH=/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin
    PWD=/u01/app/oracle/product/11.2.0
    SHELL=/bin/bash
    SHLVL=2
    SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
    SSH_CLIENT=172.200.20.8 34278 22
    SSH_CONNECTION=172.200.20.8 34278 172.240.5.185 22
    SSH_TTY=/dev/pts/0
    TERM=xterm
    USER=oracle
    and after run relink i get the below
    [oracle@TCCBS bin]$ ./relink all
    writing relink log to: /u01/app/oracle/product/11.2.0/install/relink.log
    [oracle@TCCBS bin]$ tail -10 /u01/app/oracle/product/11.2.0/install/relink.log
    /bin/sh: gcc: command not found
    make: *** [trcroute] Error 127
    Error in invoking target 'itrcroute' of makefile '/u01/app/oracle/product/11.2.0/network/lib/ins_net_client.mk'. See '/u01/app/oracle/product/11.2.0/install/relinkActions2013-02-15_06-00-50-PM.log' for details.
    
     - Linking recovery manager (rman)
    rm -f /u01/app/oracle/product/11.2.0/rdbms/lib/rman
    gcc -o /u01/app/oracle/product/11.2.0/rdbms/lib/rman -m64 -L/u01/app/oracle/product/11.2.0/rdbms/lib/ -L/u01/app/oracle/product/11.2.0/lib/ -L/u01/app/oracle/product/11.2.0/lib/stubs/   /u01/app/oracle/product/11.2.0/lib/s0main.o /u01/app/oracle/product/11.2.0/rdbms/lib/sskrmed.o /u01/app/oracle/product/11.2.0/rdbms/lib/skrmpt.o -ldbtools11 -lclient11 -lsql11 -lpls11  -lrt -lplp11 -lsnls11 -lunls11 -lnls11 -lslax11 -lpls11  -lrt -lplp11 /u01/app/oracle/product/11.2.0/lib/libplc11.a -lclntsh  `cat /u01/app/oracle/product/11.2.0/lib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u01/app/oracle/product/11.2.0/lib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnnz11 -lzt11 -lztkg11 -lztkg11 -lclient11 -lnnetd11  -lvsn11 -lcommon11 -lgeneric11 -lmm -lsnls11 -lnls11  -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 `cat /u01/app/oracle/product/11.2.0/lib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u01/app/oracle/product/11.2.0/lib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lclient11 -lnnetd11  -lvsn11 -lcommon11 -lgeneric11   -lsnls11 -lnls11  -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 -lclient11 -lnnetd11  -lvsn11 -lcommon11 -lgeneric11 -lsnls11 -lnls11  -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11   `cat /u01/app/oracle/product/11.2.0/lib/sysliblist` -Wl,-rpath,/u01/app/oracle/product/11.2.0/lib -lm    `cat /u01/app/oracle/product/11.2.0/lib/sysliblist` -ldl -lm   -L/u01/app/oracle/product/11.2.0/lib
    /bin/sh: gcc: command not found
    make: *** [/u01/app/oracle/product/11.2.0/rdbms/lib/rman] Error 127
    Error in invoking target 'irman ioracle' of makefile '/u01/app/oracle/product/11.2.0/rdbms/lib/ins_rdbms.mk'. See '/u01/app/oracle/product/11.2.0/install/relinkActions2013-02-15_06-00-50-PM.log' for details.
    [oracle@TCCBS bin]$
    please advice
  • 5. Re: cloning oracle home
    sb92075 Guru
    Currently Being Moderated
    new system must have gcc installed on it.
  • 6. Re: cloning oracle home
    864103 Newbie
    Currently Being Moderated
    thanks for your quick answer but when i check the docs it's said there is no need to install the packages
    due to it's cloning with everything software and referances ?? also i can't run yum due to this server is oracle linux 5.6
    and it is test and not register :
    yum install gcc
    
    .
    .
    .
    
    You could try using --skip-broken to work around the problem
     You could try running: package-cleanup --problems
                            package-cleanup --dupes
                            rpm -Va --nofiles --nodigest
    The program package-cleanup is found in the yum-utils package.
    please i need your advice
  • 7. Re: cloning oracle home
    EdStevens Guru
    Currently Being Moderated
    861100 wrote:
    thanks for your quick answer but when i check the docs it's said there is no need to install the packages
    due to it's cloning with everything software and referances ??
    What docs stated that? All I've seen posted in this thread are links to blogs. And blogs are not the official docs. Having a blog is no guarantee that the person writing the blog know what he is talking about. I've seen some that appear to be written by a guy that could say "Yesterday I couldn't spell Oracle, now I'm an expert".

    I would not expect an ORACLE_HOME clone operation to also pull over OS -level packages.
    also i can't run yum due to this server is oracle linux 5.6
    and it is test and not register :
    yum install gcc
    
    .
    .
    .
    
    You could try using --skip-broken to work around the problem
    You could try running: package-cleanup --problems
    package-cleanup --dupes
    rpm -Va --nofiles --nodigest
    The program package-cleanup is found in the yum-utils package.
    please i need your advice
    What does being "test and not register" have to do with it? I build a 5.6 server under virtual box almost every week. They are not registered with ULN and I have no problem at all installing the latest gcc from Oracle's public yum server.
  • 8. Re: cloning oracle home
    864103 Newbie
    Currently Being Moderated
    thanks you are right ....


    so now you mean i must install virtual box and then install the oracle linux 5.6 and i can install any package that i want ???

    if yes please share with me the link of virtual box in order to downloaded.

    thanks
  • 9. Re: cloning oracle home
    sb92075 Guru
    Currently Being Moderated
    http://www.lmgtfy.com/?q=virtualbox+download
  • 10. Re: cloning oracle home
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    861100 wrote:
    thanks for your quick answer but when i check the docs it's said there is no need to install the packages
    due to it's cloning with everything software and referances ?? also i can't run yum due to this server is oracle linux 5.6
    and it is test and not register :
    yum install gcc
    
    .
    .
    .
    
    You could try using --skip-broken to work around the problem
    You could try running: package-cleanup --problems
    package-cleanup --dupes
    rpm -Va --nofiles --nodigest
    The program package-cleanup is found in the yum-utils package.
    please i need your advice
    You seem to have ignored my advice in your duplicate thread - Re: 11.2.2

    Srini
  • 11. Re: cloning oracle home
    EdStevens Guru
    Currently Being Moderated
    861100 wrote:
    thanks you are right ....


    so now you mean i must install virtual box and then install the oracle linux 5.6 and i can install any package that i want ???
    I can't say you "must" install Virtual Box because I don't know what the requirement and usage of this server is. But I can say I have VBox installed on both my company desktop and my personal laptop, I have multiple vms' created on both, most of which run some update of Oracle Linux 5, and I download packages all the time.

    if yes please share with me the link of virtual box in order to downloaded.
    Google is your friend, but only if you use it. I'd be embarrassed to ask such a question.

    >
    thanks
  • 12. Re: cloning oracle home
    864103 Newbie
    Currently Being Moderated
    i use relink all but not work ,
  • 13. Re: cloning oracle home
    864103 Newbie
    Currently Being Moderated
    from yesterday till now i check in google and not found the solution .and sometime is good for all member here
    to share with us your knowledge .
  • 14. Re: cloning oracle home
    EdStevens Guru
    Currently Being Moderated
    861100 wrote:
    from yesterday till now i check in google and not found the solution .and sometime is good for all member here
    to share with us your knowledge .
    I was referring to your question of asking for a link to download Virtual Box. Surly you can do that yourself.

    http://lmgtfy.com/?q=download+Virtual+Box
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points