1 2 Previous Next 26 Replies Latest reply: Nov 25, 2013 12:35 PM by Kareem Ahamed Go to original post Branched to a new discussion. RSS
      • 15. Re: Unable to change to the patch directory
        Kareem Ahamed

        Thanks Hussein,josephart

         

        I had applied patches.Kindly help on 2 issues

         

        There is warning when executing adformsctl.sh or deploying forms. kindly check below error,

         

         

        Executing service control script:

        /u01/applR12/testerp1/inst/apps/testerp1_erpappl1/admin/scripts/adformsctl.sh start

        Timeout specified in context file: 100 second(s)

         

        script returned:

        ****************************************************

         

        You are running adformsctl.sh  version 120.16.12010000.3

         

        Starting OPMN managed FORMS OC4J instance  ...

        Calling txkChkFormsDeployment.pl to check whether latest FORMSAPP.EAR is deployed...

        Program : /u01/applR12/testerp1/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChkFormsDeployment.pl started @ Fri Aug 16 21:52:42 2013

         

        *** Log File = /u01/applR12/testerp1/inst/apps/testerp1_erpappl1/logs/appl/rgf/T                                                                                        XK/txkChkFormsDeployment_Fri_Aug_16_21_52_41_2013/txkChkFormsDeployment_Fri_Aug_ 16_21_52_41_2013.log

         

        File "/u01/applR12/testerp1/apps/tech_st/10.1.3/j2ee/forms/applications/forms/formsweb/WEB-INF/lib/frmsrv.jar" exists. Proceeding to check the size...

         

        =============================================

        *** Latest formsapp.ear has been deployed ***

        =============================================

         

         

        Program : /u01/applR12/testerp1/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChkFormsDeployment.pl completed @ Fri Aug 16 21:52:43 2013

         

        Perl script txkChkFormsDeployment.pl got executed successfully

         

         

         

        adformsctl.sh: exiting with status 0

         

        adformsctl.sh: check the logfile /u01/applR12/testerp1/inst/apps/testerp1_erpappl1/logs/appl/admin/log/adformsctl.txt for more information ...

         

         

        .end std out.

        *** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS

        *** Log File = /u01/applR12/testerp1/inst/apps/testerp1_erpappl1/logs/appl/rgf/T                                                                                        XK/txkChkFormsDeployment_Fri_Aug_16_21_52_41_2013/txkChkFormsDeployment_Fri_Aug_ 16_52_41_2013.log

         

        .end err out.

         

        is it ok when i check the status its alive

        ---------------------------------+--------------------+---------+---------

        OC4JGroup:default_group          | OC4J:oafm          |    7409 | Alive

        OC4JGroup:default_group          | OC4J:forms         |    7345 | Alive

        OC4JGroup:default_group          | OC4J:oacore        |    7201 | Alive

        HTTP_Server                             | HTTP_Server        |    7149 | Alive

         

         

        2) i am unable to get the forms page , in mozilla fire fox, iam trying to get  it in linux os not in windows, its giving the error as missing plugins, and ask to execute the .exe file in linux . kindly help in it. i had check some of the forums in which they are try to get the form in firefox broswer in win box not in linux 

         

        Thanks & Regards

        Shaik Kareem Ahamed

        • 16. Re: Unable to change to the patch directory
          Hussein Sawwan-Oracle

          Shaik,

           

          Please see (adapcctl.sh: exiting with status 150 (Doc ID 1106795.1)).

           

          What do you get when you try to access the main login page? An error or a blank screen?

           

          Please check Apache log files for any error messages.

           

          Thanks,

          Hussein

          • 17. Re: Unable to change to the patch directory
            Kareem Ahamed

            Thanks Hussein

             

            I had followed the doc which u had posted

            [applmgr@erpappl1 appl]$ . APPStesterp1_erpappl1.env

            [applmgr@erpappl1 appl]$ cd $INST_TOP/ora/10.1.3/opmn/logs/

            [applmgr@erpappl1 logs]$ ls -lrth .opmndat

            ls: .opmndat: No such file or directory

             

            As u can see there is no file , when i start the apps tire with adstrtal.sh it going to check forms deployment error every time , is it normal or i need to work around

             

             

            Executing service control script:

            /u01/applR12/testerp1/inst/apps/testerp1_erpappl1/admin/scripts/adformsctl.sh start

            script returned:

            ****************************************************

             

            You are running adformsctl.sh  version 120.16.12010000.3

             

            Starting OPMN managed FORMS OC4J instance  ...

            Calling txkChkFormsDeployment.pl to check whether latest FORMSAPP.EAR is deployed...

            Program : /u01/applR12/testerp1/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChkFormsDeployment.pl started @ Mon Aug 19 19:36:57 2013

             

            *** Log File = /u01/applR12/testerp1/inst/apps/testerp1_erpappl1/logs/appl/rgf/TXK/txkChkFormsDeployment_Mon_Aug_19_19_36_56_2013/txkChkFormsDeployment_Mon_Aug_19_19_36_56_2013.log

             

            File "/u01/applR12/testerp1/apps/tech_st/10.1.3/j2ee/forms/applications/forms/formsweb/WEB-INF/lib/frmsrv.jar" exists. Proceeding to check the size...

             

            =============================================

            *** Latest formsapp.ear has been deployed ***

            =============================================

             

             

            Program : /u01/applR12/testerp1/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChkFormsDeployment.pl completed @ Mon Aug 19 19:36:57 2013

             

            Perl script txkChkFormsDeployment.pl got executed successfully

             

             

             

            adformsctl.sh: exiting with status 0

             

            adformsctl.sh: check the logfile /u01/applR12/testerp1/inst/apps/testerp1_erpappl1/logs/appl/admin/log/adformsctl.txt for more information ...

             

             

            .end std out.

            *** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS

            *** Log File = /u01/applR12/testerp1/inst/apps/testerp1_erpappl1/logs/appl/rgf/TXK/txkChkFormsDeployment_Mon_Aug_19_19_36_56_2013/txkChkFormsDeployment_Mon_Aug_19_19_36_56_2013.log

             

            I will discuss the form page in mozilla later.

             

             

            Here , I am trying to upgrade the single DB(11gR1 11.1.0.7.0) node to 11gr2(11.2.0.1.0) 2 node RAC ,for apps 12.1.1,Can u kindly provide the DOC for this.

             

            Thanks

            Shaik Kareem Ahamed

            • 18. Re: Unable to change to the patch directory
              Hussein Sawwan-Oracle

              If you issue " ls -ltra" you should be able to see the file.

               

              For RAC doc, please refer to (Oracle E-Business Suite Release 12 High Availability Documentation Roadmap (Doc ID 1072636.1)) -- Please note that 11.2.0.3 is the latest 11gR2 certified version with 11i/R12

               

              Thanks,

              Hussein

              • 19. Re: Unable to change to the patch directory
                Kareem Ahamed

                Hi Hussein,

                 

                Provided doc is to convert single nod to rac, Actually, my requirement is , present i have 11.1 of single node db , i need to upgrade 11gr2 two node RAC. Shell i upgrade first to 11gr2 in sigle node into asm , than convert to RAC? .or any other option plz provide

                 

                Thanks

                Shaik Kareem Ahamed

                • 20. Re: Unable to change to the patch directory
                  Hussein Sawwan-Oracle

                  Upgrade to 11.2.0.3 by following the steps in (Interoperability Notes EBS 12.0 and 12.1 with Database 11gR2 (Doc ID 1058763.1)) then convert to RAC by referring to the doc(s) in the my previous reply.

                   

                  Thanks,

                  Hussein

                  • 21. Re: Unable to change to the patch directory
                    Kareem Ahamed

                    Hi Hussein,

                     

                    After long time,

                     

                    I had upgrade the apps db to 11gr2 thanks for your help , now i am trying to convert in to RAC,i had experienced  some strange thing.

                     

                    converting with rconfig , its failed at RMAN error, looks like some issue in ASM , not able to right in asmdisk,Trying to loging manually in AMS Instance. I had set the proper home dir for gird home, and using the proper sid,

                    when i grep it showing up,and also check with srvctl its showing up, when i manually try to login its sid is not matching, when i check the grid_home/dbs there is no pfile, then where its picking the pfile (check the below details). kindly help

                     

                    akcdb1-> srvctl status asm

                     

                    ASM is running on akcdb1,akcdb2

                     

                    akcdb1-> ps -ef |grep pmon

                     

                    oramgr    4476     1  0 08:27 ?        00:00:01 asm_pmon_+ASM1

                     

                    oramgr   16588 14758  0 23:50 pts/2    00:00:00 grep pmon

                     

                    akcdb1-> cd $ORACLE_GRID

                     

                    akcdb1-> pwd

                     

                    /u02/11g_grid

                     

                    akcdb1-> ls -lrth

                     

                    total 276K

                     

                    -rw-r--r--  1 oramgr dbaerp   37 Nov 21 09:38 install.platform

                     

                    drwxr-xr-x  6 oramgr dbaerp 4.0K Nov 21 09:38 nls

                     

                    drwxr-xr-x  5 oramgr dbaerp 4.0K Nov 21 09:38 md

                     

                    drwxr-xr-x  7 oramgr dbaerp 4.0K Nov 21 09:38 javavm

                     

                    drwxr-xr-x  3 oramgr dbaerp 4.0K Nov 21 09:38 hs

                     

                    drwxr-xr-x  3 oramgr dbaerp 4.0K Nov 21 09:38 has

                     

                    drwxr-xr-x  3 oramgr dbaerp 4.0K Nov 21 09:38 diagnostics

                     

                    drwxr-xr-x  3 oramgr dbaerp 4.0K Nov 21 09:38 demo

                     

                    drwxr-xr-x  3 oramgr dbaerp 4.0K Nov 21 09:38 csmig

                     

                     

                     

                    akcdb1-> export ORACLE_SID=+ASM1

                    akcdb1-> sqlplus "/as sysdba"

                     

                    SQL*Plus: Release 11.2.0.1.0 Production on Sat Nov 23 23:53:08 2013

                     

                    Copyright (c) 1982, 2009, Oracle.  All rights reserved.

                     

                    Connected to an idle instance.

                     

                    SQL> startup

                    ORA-01078: failure in processing system parameters

                    LRM-00109: could not open parameter file '/u02/11grac_db/oramgr/product/11.2.0/dbhome_1/dbs/init+ASM1.ora'

                    SQL> exit

                    Disconnected

                    akcdb1-> sqlplus "/as sysasm"

                     

                    SQL*Plus: Release 11.2.0.1.0 Production on Sat Nov 23 23:53:28 2013

                     

                    Copyright (c) 1982, 2009, Oracle.  All rights reserved.

                     

                    ERROR:

                    ORA-01031: insufficient privileges

                     

                     

                    Enter user-name:

                    ora.asm
                                   ONLINE  ONLINE       akcdb1                   Started
                                   ONLINE  ONLINE       akcdb2                   Started

                    ora.DATA.dg

                                   ONLINE  ONLINE       akcdb1

                                   ONLINE  ONLINE       akcdb2

                     

                     

                     

                    Setting Data Files and Control Files

                    <?xml version="1.0" ?>

                    <RConfig version="1.1" >

                    <ConvertToRAC>

                        <Convert>

                          <Response>

                            <Result code="1" >

                              Got Exception

                            </Result>

                           <ErrorDetails>

                                 oracle.sysman.assistants.rconfig.engine.StorageCreationException: oracle.sysman.assistants.util.rmanEngine.RMANFatalErrorException: RMAN  restore spfile to  '+DATA/spfiletesterp.ora'  from  '+DATA/sp_testerp_backup';

                    Starting restore at 23-NOV-13

                    allocated channel: ORA_DISK_1

                    channel ORA_DISK_1: SID=27 device type=DISK

                    channel ORA_DISK_1: restoring spfile from AUTOBACKUP +DATA/sp_testerp_backup

                    RMAN-00571: ===========================================================

                    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

                    RMAN-00571: ===========================================================

                    RMAN-03002: failure of restore command at 11/23/2013 16:34:13

                    ORA-32011: cannot restore SPFILE to location already being used by the instance

                     

                    Operation Failed. Refer logs at /u02/app/cfgtoollogs/rconfig/rconfig_11_23_13_15_22_13.log for more details.

                     

                           </ErrorDetails>

                          </Response>

                        </Convert>

                      </ConvertToRAC></RConfig>

                     

                     

                    Thanks & Regards

                    Shaik Kareem Ahamed

                    • 22. Re: Unable to change to the patch directory
                      Hussein Sawwan-Oracle
                      LRM-00109: could not open parameter file '/u02/11grac_db/oramgr/product/11.2.0/dbhome_1/dbs/init+ASM1.ora'


                      Does this file exist?


                      Thanks,

                      Hussein

                      • 23. Re: Unable to change to the patch directory
                        Kareem Ahamed

                        No its not there

                         

                        /u02/11grac_db/oramgr/product/11.2.0/dbhome_1/dbs/init+ASM1.ora


                        its actually the oracle home


                        Grid home will be /u02/11g_grid, i don't know why it is searching here, and ASM is up and running


                        Thanks

                        Kareem

                        • 24. Re: Unable to change to the patch directory
                          Hussein Sawwan-Oracle

                          Kareem,

                           

                          Please make sure none of the env variables in set in the OS user's profile -- LRM-109: Could Not Open Parameter File (Doc ID 734930.1)

                           

                           

                          For the ORA-01301 error, what is the output of "id" command?

                           

                           

                          Non-ASM User (grid) Is Unable To Connect To The ASM Instance As (“sysdba”) Due To ORA-01031. (Doc ID 1544562.1)

                          ORA-01031: insufficient privileges From srvctl Commands on ASM Resources or When Connecting Through Listener (Doc ID 1330604.1)

                          ORA-01031, ORA-01017 While Connecting as SYSASM (Doc ID 578796.1)

                          ORA-1031 When Connection As SYSASM If Unix Group Member List Is Large. (Doc ID 1522908.1)

                           

                          Thanks,

                          Hussein

                          • 25. Re: Unable to change to the patch directory
                            Kareem Ahamed

                            Thanks Hussein , for your help, i had installed with separate user for the ASM, and its work fine.

                             

                             

                            Thanks

                            Shaik Kareem Ahamed

                            • 26. Re: Unable to change to the patch directory
                              Hussein Sawwan-Oracle

                              Thanks for the update, Shaik.

                               

                              Regards,

                              Hussein

                              1 2 Previous Next