10 Replies Latest reply on Apr 6, 2015 7:01 AM by GatotRu

    Adpreclone on EBS 12.2.4 after upgrade Database to 12c get ERROR

    GatotRu

      I've got error after upgrade Oracle E-Business Suite 12.2.4 with Oracle Database 11gR2 to Oracle Database 12c.

       

      [oravis@ebs VIS_ebs]$ ./adpreclone.pl dbTier

      perl: warning: Setting locale failed.

      perl: warning: Please check that your locale settings:

        LANGUAGE = (unset),

        LC_ALL = (unset),

        LC_CTYPE = "UTF-8",

        LANG = "en_US.UTF-8"

          are supported and installed on your system.

      perl: warning: Falling back to the standard locale ("C").

       

                           Copyright (c) 2011, 2014 Oracle Corporation

                              Redwood Shores, California, USA

       

                              Oracle E-Business Suite Rapid Clone

       

                                       Version 12.2

       

                            adpreclone Version 120.31.12020000.16

       

      Enter the APPS User Password:

      Running:

      perl /source/VIS/12.1.0/appsutil/bin/adclone.pl java=/source/VIS/12.1.0/appsutil/jre mode=stage stage=/source/VIS/12.1.0/appsutil/clone component=dbTier method=CUSTOM dbctx=/source/VIS/12.1.0/appsutil/VIS_ebs.xml showProgress

      perl: warning: Setting locale failed.

      perl: warning: Please check that your locale settings:

        LANGUAGE = (unset),

        LC_ALL = (unset),

        LC_CTYPE = "UTF-8",

        LANG = "en_US.UTF-8"

          are supported and installed on your system.

      perl: warning: Falling back to the standard locale ("C").

      Can't locate Switch.pm in @INC (@INC contains: /source/VIS/12.1.0/perl/lib/5.10.0 /source/VIS/12.1.0/perl/lib/site_perl/5.10.0 /source/VIS/12.1.0/appsutil/perl /source/VIS/12.1.0/perl/lib/site_perl/5.14.1/x86_64-linux-thread-multi /source/VIS/12.1.0/perl/lib/site_perl/5.14.1 /source/VIS/12.1.0/perl/lib/5.14.1/x86_64-linux-thread-multi /source/VIS/12.1.0/perl/lib/5.14.1 .) at /source/VIS/12.1.0/appsutil/bin/adclone.pl line 40.

      BEGIN failed--compilation aborted at /source/VIS/12.1.0/appsutil/bin/adclone.pl line 40.

       

      ERROR while running perl /source/VIS/12.1.0/appsutil/bin/adclone.pl java=/source/VIS/12.1.0/appsutil/jre mode=stage stage=/source/VIS/12.1.0/appsutil/clone component=dbTier method=CUSTOM dbctx=/source/VIS/12.1.0/appsutil/VIS_ebs.xml showProgress ...

      Sat Mar 28 12:41:03 2015

      [oravis@ebs VIS_ebs]$

       

      What's wrong with my EBS?

        • 1. Re: Adpreclone on EBS 12.2.4 after upgrade Database to 12c get ERROR
          Kj - Kiran Jadhav

          Please see- ODA: oakcli command failed with perl: warning: Setting locale failed. (Doc ID 1526079.1)

          • 2. Re: Adpreclone on EBS 12.2.4 after upgrade Database to 12c get ERROR
            GatotRu

            I've tried it but nothing happen. I know the idea it's just i want to running perl version 5.14.1 but the version running on 5.10.0.

            My limitation i don't know how to change the directory of version perl?

            export also already execute for that Doc. ID.

             

            Regards,

             

            GatotRu

            • 3. Re: Adpreclone on EBS 12.2.4 after upgrade Database to 12c get ERROR
              Hussein Sawwan-Oracle

              Please post the output of "which perl" and "perl -v" commands.

               

              Did you source the database env file before running adpreclone? Issue "env | sort" to confirm.

               

              Thanks,

              Hussein

              • 4. Re: Adpreclone on EBS 12.2.4 after upgrade Database to 12c get ERROR
                GatotRu

                [oravis@ebs ~]$ which perl

                /source/VIS/11.2.0/perl/bin/perl

                [oradev@ebs ~]$ perl -v

                 

                This is perl, v5.10.0 built for x86_64-linux-thread-multi

                 

                Copyright 1987-2007, Larry Wall

                 

                Perl may be copied only under the terms of either the Artistic License or the

                GNU General Public License, which may be found in the Perl 5 source kit.

                 

                Complete documentation for Perl, including FAQ lists, should be found on

                this system using "man perl" or "perldoc perl".  If you have access to the

                Internet, point your browser at http://www.perl.org/, the Perl Home Page.

                 

                [oravis@ebs ~]$ env | sort

                ADJREOPTS=-Xms128M -Xmx512M

                ADJVAPRG=/source/VIS/12.1.0/appsutil/jre/bin/java

                ADPERLPRG=/source/VIS/11.2.0/perl/bin/perl

                CONTEXT_FILE=/source/VIS/11.2.0/appsutil/VIS_ebs.xml

                CONTEXT_NAME=VIS_ebs

                CVS_RSH=ssh

                DISPLAY=localhost:10.0

                G_BROKEN_FILENAMES=1

                HISTCONTROL=ignoredups

                HISTSIZE=1000

                HOME=/home/oradev

                HOSTNAME=ebs.lab

                LANG=en_US.UTF-8

                LD_LIBRARY_PATH=/source/VIS/12.1.0/lib

                LESSOPEN=|/usr/bin/lesspipe.sh %s

                LIBPATH=/source/VIS/11.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/source/VIS/11.2.0/lib:/usr/dt/lib:/source/VIS/11.2.0/ctx/lib

                LINK_CNTRL=

                LOGNAME=oradev

                LS_COLORS=rs=0:di=38;5;27:ln=38;5;51:mh=44;38;5;15:pi=40;38;5;11:so=38;5;13:do=38;5;5:bd=48;5;232;38;5;11:cd=48;5;232;38;5;3:or=48;5;232;38;5;9:mi=05;48;5;232;38;5;15:su=48;5;196;38;5;15:sg=48;5;11;38;5;16:ca=48;5;196;38;5;226:tw=48;5;10;38;5;16:ow=48;5;10;38;5;21:st=48;5;21;38;5;15:ex=38;5;34:*.tar=38;5;9:*.tgz=38;5;9:*.arj=38;5;9:*.taz=38;5;9:*.lzh=38;5;9:*.lzma=38;5;9:*.tlz=38;5;9:*.txz=38;5;9:*.zip=38;5;9:*.z=38;5;9:*.Z=38;5;9:*.dz=38;5;9:*.gz=38;5;9:*.lz=38;5;9:*.xz=38;5;9:*.bz2=38;5;9:*.tbz=38;5;9:*.tbz2=38;5;9:*.bz=38;5;9:*.tz=38;5;9:*.deb=38;5;9:*.rpm=38;5;9:*.jar=38;5;9:*.rar=38;5;9:*.ace=38;5;9:*.zoo=38;5;9:*.cpio=38;5;9:*.7z=38;5;9:*.rz=38;5;9:*.jpg=38;5;13:*.jpeg=38;5;13:*.gif=38;5;13:*.bmp=38;5;13:*.pbm=38;5;13:*.pgm=38;5;13:*.ppm=38;5;13:*.tga=38;5;13:*.xbm=38;5;13:*.xpm=38;5;13:*.tif=38;5;13:*.tiff=38;5;13:*.png=38;5;13:*.svg=38;5;13:*.svgz=38;5;13:*.mng=38;5;13:*.pcx=38;5;13:*.mov=38;5;13:*.mpg=38;5;13:*.mpeg=38;5;13:*.m2v=38;5;13:*.mkv=38;5;13:*.ogm=38;5;13:*.mp4=38;5;13:*.m4v=38;5;13:*.mp4v=38;5;13:*.vob=38;5;13:*.qt=38;5;13:*.nuv=38;5;13:*.wmv=38;5;13:*.asf=38;5;13:*.rm=38;5;13:*.rmvb=38;5;13:*.flc=38;5;13:*.avi=38;5;13:*.fli=38;5;13:*.flv=38;5;13:*.gl=38;5;13:*.dl=38;5;13:*.xcf=38;5;13:*.xwd=38;5;13:*.yuv=38;5;13:*.cgm=38;5;13:*.emf=38;5;13:*.axv=38;5;13:*.anx=38;5;13:*.ogv=38;5;13:*.ogx=38;5;13:*.aac=38;5;45:*.au=38;5;45:*.flac=38;5;45:*.mid=38;5;45:*.midi=38;5;45:*.mka=38;5;45:*.mp3=38;5;45:*.mpc=38;5;45:*.ogg=38;5;45:*.ra=38;5;45:*.wav=38;5;45:*.axa=38;5;45:*.oga=38;5;45:*.spx=38;5;45:*.xspf=38;5;45:

                MAIL=/var/spool/mail/oradev

                NLS_DATE_FORMAT=DD-MON-RR

                NLS_LANG=American_America.AL32UTF8

                NLS_NUMERIC_CHARACTERS=.,

                NLS_SORT=binary

                OLDPWD=/source/VIS/11.2.0/admin/VIS_ebs

                ORACLE_HOME=/source/VIS/12.1.0

                ORACLE_SID=VIS

                ORA_NLS10=/source/VIS/12.1.0/nls/data/9idata

                ORA_TZFILE=

                PATH=/source/VIS/12.1.0/bin:/source/VIS/12.1.0/OPatch:/source/VIS/11.2.0/perl/bin:/source/VIS/11.2.0/bin:/usr/bin:/usr/sbin:/source/VIS/11.2.0/appsutil/jre/bin:/bin:/usr/bin/X11:/usr/local/bin:/source/VIS/11.2.0/perl/bin:/source/VIS/11.2.0/bin:/usr/bin:/usr/sbin:/source/VIS/11.2.0/appsutil/jre/bin:/bin:/usr/bin/X11:/usr/local/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oradev/bin:.:.

                PERL5LIB=/source/VIS/11.2.0/perl/lib/5.10.0:/source/VIS/11.2.0/perl/lib/site_perl/5.10.0:/source/VIS/11.2.0/appsutil/perl

                PWD=/home/oradev

                QTDIR=/usr/lib64/qt-3.3

                QTINC=/usr/lib64/qt-3.3/include

                QTLIB=/usr/lib64/qt-3.3/lib

                SELINUX_LEVEL_REQUESTED=

                SELINUX_ROLE_REQUESTED=

                SELINUX_USE_CURRENT_RANGE=

                SHELL=/bin/bash

                SHLIB_PATH=/source/VIS/11.2.0/lib:/usr/lib:/source/VIS/11.2.0/ctx/lib

                SHLVL=1

                SSH_CLIENT=172.16.181.1 61730 22

                SSH_CONNECTION=172.16.181.1 61730 172.16.181.226 22

                SSH_TTY=/dev/pts/0

                TERM=xterm-256color

                TNS_ADMIN=/source/VIS/12.1.0/network/admin/VIS_ebs

                USER=oradev

                _=/usr/bin/env

                [oravis@ebs ~]$

                 

                There's the log. Thanks a lot.

                • 5. Re: Adpreclone on EBS 12.2.4 after upgrade Database to 12c get ERROR
                  ;) ApPsMasTi ;)

                  please see

                   

                  The error is occurring because Perl cannot find the "Switch.pm" Perl module. From my 12.2 instance, I have the module in question here:

                   

                  -bash-3.2$ pwd

                  /oracle/VISION/12.2/fs1/FMW_Home/webtier/perl

                   

                  -bash-3.2$ find . -name Switch.pm

                  ./lib/5.10.0/Switch.pm

                  ./lib/5.10.0/CGI/Switch.pm

                   

                  -bash-3.2$ which perl

                  ~/VISION/12.2/fs1/FMW_Home/webtier/perl/bin/perl

                   

                  You need to make sure that your $PATH is set properly to use the Perl executable & installation which has a Switch.pm file in it's "lib" directory. You may also set $PERL5LIB to add the location of Perl modules that Perl will use at runtime.

                   

                  source:- https://community.oracle.com/message/12980568#12980568

                   

                  ApPsMaStI

                  sharing is Caring

                  • 6. Re: Adpreclone on EBS 12.2.4 after upgrade Database to 12c get ERROR
                    GatotRu

                    Sorry, i can't login to https://community.oracle.com/message/12980568#12980568

                     

                    so for that case i sould redirect/change my environment to fs1/FMW_Home/webtier/perl/bin/perl directory?

                    Before :

                    #######################################

                    # Add perl to the PATH and set PERL5LIB

                    #######################################

                     

                    #export PERLBIN=`/source/VIS/12.1.0/perl/lib/5.14.1`

                    #export PERL5LIB=/source/VIS/12.1.0/perl/lib/5.14.1:/source/VIS/12.1.0/perl/lib/site_perl/5.14.1:/source/VIS/12.1.0/appsutil/perl

                    #export PATH=$PERL5BIN:$PATH

                    #export ADPERLPRG=/source/VIS/12.1.0/perl/bin/perl

                     

                    After :

                    #######################################

                    # Add perl to the PATH and set PERL5LIB

                    #######################################

                     

                    #export PERLBIN=`/source/VIS/fs1/FMW_Home/webtier/perl`

                    #export PERL5LIB=/source/VIS/fs1/FMW_Home/webtier/perl:/source/VIS/fs1/FMW_Home/webtier/perl:/source/VIS/fs1/FMW_Home/webtier/perl

                    #export PATH=$PERL5BIN:$PATH

                    #export ADPERLPRG=/source/VIS/fs1/FMW_Home/webtier/perl

                    Is that correct?

                     

                    Thanks

                    • 7. Re: Adpreclone on EBS 12.2.4 after upgrade Database to 12c get ERROR
                      ;) ApPsMasTi ;)

                      Go ahead and Re test the issue
                      please post the error if you face it again

                       

                      AppsmAsti
                      sharing is Caring

                      • 8. Re: Adpreclone on EBS 12.2.4 after upgrade Database to 12c get ERROR
                        GatotRu

                        Hello AppsMasTi,

                         

                        Thanks for your help. I've got confuse here and still don't have any clue.

                        I've already change my environment like yours, but stil can't adpreclone.pl

                         

                        PERLBIN=`dirname /source/DEV/12.1.0/perl/bin/perl`

                         

                        export PATH=${PERLBIN}:${PATH}

                         

                        export PERL5LIB=/source/DEV/12.1.0/perl/lib/5.10.0:/source/DEV/12.1.0/perl/lib/site_perl/5.10.0:/source/DEV/12.1.0/appsutil/perl

                         

                        export ADPERLPRG=/source/DEV/12.1.0/perl/bin/perl

                         

                        Here's the environment about PERLBIN.

                        Thanks a lot.

                        • 9. Re: Adpreclone on EBS 12.2.4 after upgrade Database to 12c get ERROR
                          GatotRu

                          Also already run with 5.14.1 :

                          $ ./adpreclone.pl dbTier

                          Perl lib version (5.10.0) doesn't match executable version (v5.14.1) at /source/PROD/fs1/FMW_Home/webtier/perl/lib/5.10.0/x86_64-linux-thread-multi/Config.pm line 46.

                          Compilation failed in require at ./adpreclone.pl line 35.

                          BEGIN failed--compilation aborted at ./adpreclone.pl line 35.

                          $

                          • 10. Re: Adpreclone on EBS 12.2.4 after upgrade Database to 12c get ERROR
                            GatotRu

                            Thanks AppsmAsti,

                             

                            Finally i found what i'm looking for. Just change chmod Switch.pm

                            Thanks a lot.

                             

                            Regards,

                             

                            GatotRu