1 2 3 Previous Next 34 Replies Latest reply: May 10, 2013 10:10 AM by Hussein Sawwan-Oracle RSS

    RC-50004: Fatal: Error occurred in ApplyDatabase: Control file creation fai

    Clamarion
      Hi guys,

      I am cloning and EBS 12.1.3 from one server to another, and when Configuring the target system database server with ''perl adcfgclone.pl dbTier'', I am getting the following error:

      RC-50004: Fatal: Error occurred in ApplyDatabase:
      Control file creation failed

      MOS is saying that it is due to wrong permissions on the /var/tmp/.oracle directory and we should give it the following permissions:

      chmod 777 /var/tmp/.oracle

      After giving those permissions and rebooting the server , and running the perl adcfgclone.pl dbTier script, I am still having the same problem:

      RC-50004: Fatal: Error occurred in ApplyDatabase:
      Control file creation failed

      This is the contents of the ApplyDBTier log file (since the file exceed 30.000 characters, i am going to post the parts where the errors occur:

      [oratest@DLAERPSRV01 ERP_DLAERPSRV01]$ cat ApplyDBTier_05021530.log
      #############################################################
      Started ApplyDBTier at Thu May 02 15:30:44 WAT 2013
      Version:
      ApplyDBTier.java : 120.6.12010000.3
      #############################################################
      ApplyDBTier (prog) -1 true true true...
      # Calling ApplyDBTechStack...
      Executing runInstallDriver...
      Started unzipping files...
      Completed runInstallDriver.


      Executing home registration for s_db_oh...

      instantiate file:
      source : /u02/oratest/db/tech_st/11.1.0/appsutil/template/adouidb.pl
      dest : /u02/oratest/db/tech_st/11.1.0/appsutil/clone/ouicli.pl
      backup : /u02/oratest/db/tech_st/11.1.0/appsutil/clone/ouicli.pl to /u02/oratest/db/tech_st/11.1.0/appsutil/out/ouicli20.pl
      setting permissions: 700
      setting ownership: oratest:dba

      instantiate file:
      source : /u02/oratest/db/tech_st/11.1.0/appsutil/template/config_ux.tmp
      dest : /u02/oratest/db/tech_st/11.1.0/rdbms/lib/config.c
      backup : /u02/oratest/db/tech_st/11.1.0/rdbms/lib/config.c to /u02/oratest/db/tech_st/11.1.0/appsutil/out/config21.c
      setting permissions: 700
      setting ownership: oratest:dba

      instantiate file:
      source : /u02/oratest/db/tech_st/11.1.0/appsutil/template/adlnkoh.sh
      dest : /u02/oratest/db/tech_st/11.1.0/appsutil/clone/adlnkoh.sh
      backup : /u02/oratest/db/tech_st/11.1.0/appsutil/clone/adlnkoh.sh to /u02/oratest/db/tech_st/11.1.0/appsutil/out/adlnkoh20.sh
      setting permissions: 700
      setting ownership: oratest:dba

      Executing script in InstantiateFile:
      /u02/oratest/db/tech_st/11.1.0/perl/bin/perl -I /u02/oratest/db/tech_st/11.1.0/perl/lib/5.8.3 -I /u02/oratest/db/tech_st/11.1.0/perl/lib/site_perl/5.8.3 -I /u02/oratest/db/tech_st/11.1.0/appsutil/perl /u02/oratest/db/tech_st/11.1.0/appsutil/clone/ouicli.pl

      script returned:
      ****************************************************
      Beginning OUI CLI cloning for s_db_ohThu May 2 15:30:46 2013
      /u02/oratest/db/tech_st/11.1.0/appsutil/jre/bin/java -classpath /u02/oratest/db/tech_st/11.1.0/appsutil/java:/u02/oratest/db/tech_st/11.1.0/oui/jlib/OraInstaller.jar:/u02/oratest/db/tech_st/11.1.0/appsutil/java/xmlparserv2.jar oracle.apps.ad.clone.util.OracleHomeCloner -OUICLI -e /u02/oratest/db/tech_st/11.1.0/appsutil/ERP_DLAERPSRV01.xml -nolink -oaVar s_db_oh -homestub db -log /u02/oratest/db/tech_st/11.1.0/appsutil/log/ERP_DLAERPSRV01/ohclone.log
      Running OUI CLI home cloning from within OracleHomeCloner:
      /u02/oratest/db/tech_st/11.1.0/oui/bin/runInstaller -clone -silent -force -nolink -waitForCompletion -invPtrLoc /u02/oratest/db/tech_st/11.1.0/admin/oui/ERP_DLAERPSRV01/oraInst.loc ORACLE_HOME=/u02/oratest/db/tech_st/11.1.0 ORACLE_BASE=/u02/oratest/db/tech_st/11.1.0 ORACLE_HOME_NAME=ERP_DB__u02_oratest_db_tech_st_11_1_0 -J-Doracle.installer.noLink=true
      Finished OUI CLI cloning for s_db_oh with return code: 0Thu May 2 15:30:56 2013

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


      Executing script in InstantiateFile:
      /u02/oratest/db/tech_st/11.1.0/appsutil/clone/adlnkoh.sh

      script returned:
      ****************************************************

      adlnkoh.sh started at Thu May 2 15:30:56 WAT 2013
      Log file located at /u02/oratest/db/tech_st/11.1.0/appsutil/log/ERP_DLAERPSRV01/make_05021530.log

      Using make file "ins_emagent.mk" for linking SYSMAN utilities...
      Error while running adlnkoh.sh.
      return code = .16
      Please check logfile located at /u02/oratest/db/tech_st/11.1.0/appsutil/log/ERP_DLAERPSRV01/make_05021530.log


      .end std out.

      .end err out.
      ****************************************************

      Executing Technology Stack Configuration...
      Executing runAutoConfig...

      Deleting files of type INSTALL

      Checking for file: /u02/oratest/db/tech_st/11.1.0/network/admin/ERP_DLAERPSRV01/sqlnet.ora
      Processing driver file: /u02/oratest/db/tech_st/11.1.0/appsutil/template/addbtmpl.drv

      Checking for file: /u02/oratest/db/tech_st/11.1.0/appsutil/install/ERP_DLAERPSRV01/txkConfigDbOcm.pl
      File exists
      File deleted

      Checking for file: /u02/oratest/db/tech_st/11.1.0/dbs/initERP.ora
      File exists
      File deleted

      Checking for file: /u02/oratest/db/tech_st/11.1.0/network/admin/ERP_DLAERPSRV01/listener.ora
      File exists
      File deleted

      Checking for file: /u02/oratest/db/tech_st/11.1.0/network/admin/ERP_DLAERPSRV01/tnsnames.ora
      File exists
      File deleted
      Testing for RAC specific parameters before running autoconfig
      No RAC specific parameters were found, running with CVM
      Starting CVM in INSTE8_SETUP mode

      Using Context file : /u02/oratest/db/tech_st/11.1.0/appsutil/ERP_DLAERPSRV01.xml

      Attempting to create a back up of the Context file
      Created back up file of name :
      /u02/oratest/db/tech_st/11.1.0/appsutil/out/ERP_DLAERPSRV01/05021531/ERP_DLAERPSRV01.xml

      ===========================================================================
      Starting synchronization of file system Context file and its templates with those in the database

      Database connection : Failed
      OAM Context editing support feature: Unverified
      OAM Customization support feature : Unverified

      File system template : /u02/oratest/db/tech_st/11.1.0/appsutil/template/adxdbctx.tmp

      Checking for customizations to Context template
      Warning: Unable to connect to Database.
      If the system is OAM enabled, this may result in loss of customizations.
      Looking for custom template at : /u02/oratest/db/tech_st/11.1.0/appsutil/template/custom/adxdbctx.tmp
      Custom template : Not Available
      Customizations found : None
      ----------------------------------------------------------------
      File system Context file :/u02/oratest/db/tech_st/11.1.0/appsutil/ERP_DLAERPSRV01.xml

      Checking the Context file for possible updates from the Database
      Warning: Unable to connect to Database.
      If the system is OAM enabled, this may result in loss of customizations and the Context files in DataBase and in the file system may be unsynchronized

      ===========================================================================
      Starting Updates of Context file Thu May 02 15:31:44 WAT 2013

      found context version : 120.34.12010000.14
      available update version : 120.34.12010000.14

      No updates to apply

      Starting DB listener with command:
      /u02/oratest/db/tech_st/11.1.0/appsutil/scripts/ERP_DLAERPSRV01/addlnctl.sh start ERP
      Logfile: /u02/oratest/db/tech_st/11.1.0/appsutil/log/ERP_DLAERPSRV01/addlnctl.txt

      You are running addlnctl.sh version 120.1.12010000.4


      Starting listener process ERP ...


      LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 02-MAY-2013 15:32:23

      Copyright (c) 1991, 2008, Oracle. All rights reserved.

      Starting /u02/oratest/db/tech_st/11.1.0/bin/tnslsnr: please wait...

      TNSLSNR for Linux: Version 11.1.0.7.0 - Production
      System parameter file is /u02/oratest/db/tech_st/11.1.0/network/admin/ERP_DLAERPSRV01/listener.ora
      Log messages written to /u02/oratest/db/tech_st/11.1.0/admin/ERP_DLAERPSRV01/diag/tnslsnr/DLAERPSRV01/erp/alert/log.xml
      Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DLAERPSRV01.camairco.local)(PORT=1523)))

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DLAERPSRV01.camairco.local)(PORT=1523)))
      STATUS of the LISTENER
      ------------------------
      Alias ERP
      Version TNSLSNR for Linux: Version 11.1.0.7.0 - Production
      Start Date 02-MAY-2013 15:32:23
      Uptime 0 days 0 hr. 0 min. 0 sec
      Trace Level off
      Security ON: Local OS Authentication
      SNMP OFF
      Listener Parameter File /u02/oratest/db/tech_st/11.1.0/network/admin/ERP_DLAERPSRV01/listener.ora
      Listener Log File /u02/oratest/db/tech_st/11.1.0/admin/ERP_DLAERPSRV01/diag/tnslsnr/DLAERPSRV01/erp/alert/log.xml
      Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DLAERPSRV01.camairco.local)(PORT=1523)))
      Services Summary...
      Service "ERP" has 1 instance(s).
      Instance "ERP", status UNKNOWN, has 1 handler(s) for this service...
      The command completed successfully

      addlnctl.sh: exiting with status 0

      addlnctl.sh: check the logfile /u02/oratest/db/tech_st/11.1.0/appsutil/log/ERP_DLAERPSRV01/addlnctl.txt for more information ...


      .end std out.

      .end err out.

      checking DB Connection...
      DEBUG: checkDBConnection in()

      ---------------------------------------------------------------
      ADX Database Utility
      ---------------------------------------------------------------

      getConnection() -->
      sDbHost : DLAERPSRV01
      sDbDomain : camairco.local
      sDbPort : 1523
      sDbSid : ERP
      sDbUser : apps
      Trying to connect using SID...
      getConnectionUsingSID() -->
      JDBC URL: jdbc:oracle:thin:@DLAERPSRV01.camairco.local:1523:ERP
      Exception occurred: java.sql.SQLRecoverableException: ORA-01034: ORACLE not available
      ORA-27101: shared memory realm does not exist
      Linux-x86_64 Error: 2: No such file or directory

      Trying to connect using SID as ServiceName
      getConnectionUsingServiceName() -->
      JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DLAERPSRV01.camairco.local)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=ERP)))
      Exception occurred: java.sql.SQLRecoverableException: ORA-01034: ORACLE not available
      ORA-27101: shared memory realm does not exist
      Linux-x86_64 Error: 2: No such file or directory

      Trying to connect using SID as ServiceName.DomainName
      getConnectionUsingServiceName() -->
      JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DLAERPSRV01.camairco.local)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=ERP.camairco.local)))
      Exception occurred: java.sql.SQLException: Listener refused the connection with the following error:
      ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

      Connection could not be obtained; returning null

      -------------------ADX Database Utility Finished---------------

      DEBUG: checkDBConnection out()

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


      Skipping Profile Phase
      Skipping Apply Phase
      Executing CreateDB...

      ---------------------------------------------------------------
      ADX Database Utility
      ---------------------------------------------------------------

      getConnectionUsingAppsJDBCConnector() -->
      APPS_JDBC_URL='null'
      Trying to get connection using SID based connect descriptor
      getConnection() -->
      sDbHost : DLAERPSRV01
      sDbDomain : camairco.local
      sDbPort : 1523
      sDbSid : ERP
      sDbUser : apps
      Trying to connect using SID...
      getConnectionUsingSID() -->
      JDBC URL: jdbc:oracle:thin:@DLAERPSRV01.camairco.local:1523:ERP
      Exception occurred: java.sql.SQLRecoverableException: ORA-01034: ORACLE not available
      ORA-27101: shared memory realm does not exist
      Linux-x86_64 Error: 2: No such file or directory

      Trying to connect using SID as ServiceName
      getConnectionUsingServiceName() -->
      JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DLAERPSRV01.camairco.local)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=ERP)))
      Exception occurred: java.sql.SQLRecoverableException: ORA-01034: ORACLE not available
      ORA-27101: shared memory realm does not exist
      Linux-x86_64 Error: 2: No such file or directory

      Trying to connect using SID as ServiceName.DomainName
      getConnectionUsingServiceName() -->
      JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DLAERPSRV01.camairco.local)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=ERP.camairco.local)))
      Exception occurred: java.sql.SQLException: Listener refused the connection with the following error:
      ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

      Connection could not be obtained; returning null

      -------------------ADX Database Utility Finished---------------

      adcrdb.sh started at Thu May 2 15:32:40 WAT 2013

      The environment settings are as follows ...

      ORACLE_HOME : /u02/oratest/db/tech_st/11.1.0
      ORACLE_SID : ERP
      TWO_TASK :
      PATH : /u02/oratest/db/tech_st/11.1.0/perl/bin:/u02/oratest/db/tech_st/11.1.0/bin:/usr/bin:/usr/sbin:/u02/oratest/db/tech_st/11.1.0/appsutil/jre/bin:/bin:/usr/bin/X11:/usr/local/bin:/u02/oratest/db/tech_st/11.1.0/appsutil/clone/bin/../jre/bin:/u02/oratest/db/tech_st/11.1.0/appsutil/clone/bin/../jre/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oratest/bin:.
      LD_LIBRARY_PATH : /u02/oratest/db/tech_st/11.1.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/u02/oratest/db/tech_st/11.1.0/lib:/usr/dt/lib:/u02/oratest/db/tech_st/11.1.0/ctx/lib

      Executable : /u02/oratest/db/tech_st/11.1.0/bin/sqlplus

      The log information will be written to
      /u02/oratest/db/tech_st/11.1.0/appsutil/log/ERP_DLAERPSRV01/adcrdb_ERP.txt


      Creating the control file for ERP_DLAERPSRV01 database ...


      SQL*Plus: Release 11.1.0.7.0 - Production on Thu May 2 15:32:40 2013

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

      Connected to an idle instance.
      ORACLE instance shut down.
      Connected to an idle instance.
      ORA-27154: post/wait create failed
      ORA-27300: OS system dependent operation:semget failed with status: 22
      ORA-27301: OS failure message: Invalid argument
      ORA-27302: failure occurred at: sskgpbitsper
      CREATE CONTROLFILE REUSE SET DATABASE "ERP"
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      alter database open resetlogs
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      alter tablespace TEMP add tempfile '/u02/oratest/db/apps_st/data/temp01.dbf' REUSE
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      ALTER DATABASE RENAME GLOBAL_NAME TO "ERP.camairco.local"
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      ORA-01034: ORACLE not available
      ORA-27101: shared memory realm does not exist
      Linux-x86_64 Error: 2: No such file or directory
      Connected to an idle instance.
      ORA-27154: post/wait create failed
      ORA-27300: OS system dependent operation:semget failed with status: 22
      ORA-27301: OS failure message: Invalid argument
      ORA-27302: failure occurred at: sskgpbitsper
      BEGIN dbms_backup_restore.zeroDbid(0); END;

      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      ORACLE instance shut down.
      Connected to an idle instance.
      ORA-27154: post/wait create failed
      ORA-27300: OS system dependent operation:semget failed with status: 22
      ORA-27301: OS failure message: Invalid argument
      ORA-27302: failure occurred at: sskgpbitsper
      CREATE CONTROLFILE REUSE SET DATABASE "ERP"
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      alter database open resetlogs
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      alter tablespace TEMP add tempfile '/u02/oratest/db/apps_st/data/temp01.dbf' REUSE
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      ALTER DATABASE RENAME GLOBAL_NAME TO "ERP.camairco.local"
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      declare lib_ver varchar2(3);
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available
      Process ID: 0
      Session ID: 0 Serial number: 0


      ERROR:
      ORA-01012: not logged on
      Process ID: 0
      Session ID: 0 Serial number: 0


      Disconnected
      exit_code=1

      Checking for errors ...

      The database has not been successfully created. Shutting down the instance ...

      SQL*Plus: Release 11.1.0.7.0 - Production on Thu May 2 15:32:42 2013

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

      Connected to an idle instance.
      ORACLE instance shut down.
      Disconnected

      .end std out.

      .end err out.


      ---------------------------------------------------------------
      ADX Database Utility
      ---------------------------------------------------------------

      getConnectionUsingAppsJDBCConnector() -->
      APPS_JDBC_URL='null'
      Trying to get connection using SID based connect descriptor
      getConnection() -->
      sDbHost : DLAERPSRV01
      sDbDomain : camairco.local
      sDbPort : 1523
      sDbSid : ERP
      sDbUser : apps
      Trying to connect using SID...
      getConnectionUsingSID() -->
      JDBC URL: jdbc:oracle:thin:@DLAERPSRV01.camairco.local:1523:ERP
      Exception occurred: java.sql.SQLRecoverableException: ORA-01034: ORACLE not available
      ORA-27101: shared memory realm does not exist
      Linux-x86_64 Error: 2: No such file or directory

      Trying to connect using SID as ServiceName
      getConnectionUsingServiceName() -->
      JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DLAERPSRV01.camairco.local)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=ERP)))
      Exception occurred: java.sql.SQLRecoverableException: ORA-01034: ORACLE not available
      ORA-27101: shared memory realm does not exist
      Linux-x86_64 Error: 2: No such file or directory

      Trying to connect using SID as ServiceName.DomainName
      getConnectionUsingServiceName() -->
      JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DLAERPSRV01.camairco.local)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=ERP.camairco.local)))
      Exception occurred: java.sql.SQLException: Listener refused the connection with the following error:
      ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

      Connection could not be obtained; returning null

      -------------------ADX Database Utility Finished---------------

      RC-00118: Error occurred during creation of database
      Raised by oracle.apps.ad.clone.ApplyDatabase


      StackTrace:
      java.lang.Exception: Control file creation failed
      at oracle.apps.ad.clone.ApplyDatabase.doConf(ApplyDatabase.java:635)
      at oracle.apps.ad.clone.ApplyDatabase.doApply(ApplyDatabase.java:473)
      at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:366)
      at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:110)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
      at java.lang.reflect.Constructor.newInstance(Unknown Source)
      at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:67)
      at java.lang.Thread.run(Unknown Source)

      [oratest@DLAERPSRV01 ERP_DLAERPSRV01]$



      Please guys, how can I solve this problem?
        • 1. Re: RC-50004: Fatal: Error occurred in ApplyDatabase: Control file creation fai
          Clamarion
          Hope @Hussein sawwan is there, generally very helpful. Thanks
          • 2. Re: RC-50004: Fatal: Error occurred in ApplyDatabase: Control file creation fai
            Hussein Sawwan-Oracle
            I'm here now :)

            Is this the first time you clone to this target node? Do you have the kernel settings set properly in /etc/sysctl.conf file?

            The errors you are getting (ORA-27154 AND ORA-27300) are generic, so I would suggest you review the following docs.

            The Database Can Not Be Started. Getting ORA-27154 and sskgpbitsper [ID 825001.1]
            Troubleshooting ORA-27300 ORA-27301 ORA-27302 errors [ID 579365.1]
            Database Startup Fails with ORA-27300: OS system dependent operation:semget failed with status: 28 [ID 949468.1]
            ORA-27154 on Database Startup After System Crash [ID 123905.1]

            Thanks,
            Hussein
            • 3. Re: RC-50004: Fatal: Error occurred in ApplyDatabase: Control file creation fai
              Clamarion
              Hi Hussein,

              Yes this is the first time I am cloning to this target.
              Here is the contents of my /etc/sysctl.conf:

              [root@DLAERPSRV01 ~]# cat /etc/sysctl.conf
              # Kernel sysctl configuration file for Red Hat Linux
              #
              # For binary values, 0 is disabled, 1 is enabled. See sysctl(8) and
              # sysctl.conf(5) for more details.

              # Controls IP packet forwarding
              net.ipv4.ip_forward = 0

              # Controls source route verification
              net.ipv4.conf.default.rp_filter = 1

              # Do not accept source routing
              net.ipv4.conf.default.accept_source_route = 0

              # Controls the System Request debugging functionality of the kernel
              kernel.sysrq = 0

              # Controls whether core dumps will append the PID to the core filename
              # Useful for debugging multi-threaded applications
              kernel.core_uses_pid = 1

              # Controls the use of TCP syncookies
              net.ipv4.tcp_syncookies = 1

              # Controls the maximum size of a message, in bytes
              kernel.msgmnb = 65535

              # Controls the default maxmimum size of a mesage queue
              kernel.msgmax = 8192

              # Controls the maximum shared segment size, in bytes
              kernel.shmmax = 5368709120

              # Controls the maximum number of shared memory segments, in pages
              kernel.shmall = 4294967296

              kernel.sem = 25632000100142

              net.ipv4.ip_local_port_range = 10000 65000

              kernel.shmmni = 4096

              kernel.msgmni = 2878

              fs.file-max = 131072

              net.core.rmem_default = 262144

              net.core.rmem_max = 4194304

              net.core.wmem_default = 262144

              net.core.wmem_max = 262144

              [root@DLAERPSRV01 ~]#

              I prepared the target OS (RHEL 5.5 64 bits) before begining the cloning. I will read the docs you posted.
              Thanks
              • 4. Re: RC-50004: Fatal: Error occurred in ApplyDatabase: Control file creation fai
                Hussein Sawwan-Oracle
                In addition to those docs, please make sure you verify all the requirements as per (Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86-64 [ID 761566.1]).

                Thanks,
                Hussein
                • 6. Re: RC-50004: Fatal: Error occurred in ApplyDatabase: Control file creation fai
                  Clamarion
                  @Hussein Sawwan

                  I have good news!!!! my problems were caused by wrond kernel parameter settings, mostly the semaphores. So I gave a good value, rebooted the server and ran the perl adcfgclone.pl dbTier script. The script completed successfully.
                  semaphores values: kernel.sem = 256 32000 100 228

                  Thanks for your help again Hussein.

                  Now configuring AppsTier with perl adcfgclone.pl appsTier
                  • 7. Re: RC-50004: Fatal: Error occurred in ApplyDatabase: Control file creation fai
                    Hussein Sawwan-Oracle
                    Good to hear that.

                    Thanks for the update!

                    Thanks,
                    Hussein
                    • 8. Can't connect to web interface in EBS R12.1.3 after cloning
                      Clamarion
                      @Hussain Sawwan
                      Hi Hussain,

                      After successfully configured the DbTier and AppsTier with their respective post clone scripts the appstier was automatically started at the end.

                      But now, I can't seem to connect with my IE 9 and Firefow browsers.

                      Link: http://dlaerpsrv01.camairco.local:8002/OA_HTML/

                      Contents of the portpool.lst:
                      ***** List of ports allocated based on port pool 2 *****
                      Database Port : 1523 (EXT_PORT)
                      RPC Port : 1628
                      Web SSL Port : 4445
                      ONS Local Port : 6102
                      ONS Remote Port : 6202
                      ONS Request Port : 6502
                      Web Listener Port : 8002
                      Active Web Port : 8002 (DUP_PORT)
                      Forms Port : 9002
                      Metrics Server Data Port : 9102
                      Metrics Server Request Port : 9202
                      JTF Fulfillment Server Port : 9302
                      MSCA Server Port : 10212-10217
                      MCSA Telnet Server Port : 10212,10214,10216 (DUP_PORT)
                      MSCA Dispatcher Port : 10806
                      Java Object Cache Port : 12347
                      OC4J JMS Port Range for Oacore : 23010-23014
                      OC4J JMS Port Range for Forms : 23510-23514
                      OC4J JMS Port Range for Home : 24010-24014
                      OC4J JMS Port Range for Oafm : 24510-24514
                      OC4J JMS Port Range for Forms-c4ws : 26510-26514
                      OC4J AJP Port Range for Oacore : 21510-21514
                      OC4J AJP Port Range for Forms : 22010-22014
                      OC4J AJP Port Range for Home : 22510-22514
                      OC4J AJP Port Range for Oafm : 25010-25014
                      OC4J AJP Port Range for Forms-c4ws : 26010-26014
                      OC4J RMI Port Range for Oacore : 20010-20014
                      OC4J RMI Port Range for Forms : 20510-20514
                      OC4J RMI Port Range for Home : 21010-21014
                      OC4J RMI Port Range for Oafm : 25510-25514
                      OC4J RMI Port Range for Forms-c4ws : 27510-27514
                      [root@DLAERPSRV01 appltest]#

                      Entry in the /etc/hosts in my Win 7 Laptop:

                      192.168.0.245 dlaerpsrv01.camairco.local dlaerpsrv01

                      What could be the cause of this problem? It is unfortunate to reach at this point and not being able to connect.
                      • 9. Re: Can't connect to web interface in EBS R12.1.3 after cloning
                        Hussein Sawwan-Oracle
                        Did AutoConfig complete successfully on all tier nodes?

                        What is the output of "adopmnctl.sh status" command?

                        What is the error you get when you access the application?

                        Can you access the main login page from the server?

                        Thanks,
                        Hussein
                        • 10. Re: RC-50004: Fatal: Error occurred in ApplyDatabase: Control file creation fai
                          Clamarion
                          I think Autoconfig completed succeessfully in the DbTier and AppTier since I didn't see errors in the respective post clone scripts.

                          The script to configure the AppTier completed this way:

                          Log file located at /u01/appltest/inst/apps/ERP_DLAERPSRV01/admin/log/ApplyAppsTier_05061541.log
                          - 78% completed

                          Completed Apply...
                          Mon May 6 15:49:29 2013

                          status of OPMNCTL

                          Starting Oracle Process Manager (OPMN) ...
                          opmnctl: opmn started.

                          adopmnctl.sh: exiting with status 0

                          When trying to access the application, the web browser tells me that web page can't be found.

                          And I can't access the main login page from the server.

                          [appltest@DLAERPSRV01 scripts]$ ./adopmnctl.sh status

                          You are running adopmnctl.sh version 120.6.12010000.5

                          Checking status of OPMN managed processes...

                          Processes in Instance: ERP_DLAERPSRV01.DLAERPSRV01.camairco.local
                          --------------------------------------------------------------+---------
                          ias-component | process-type | pid | status
                          --------------------------------------------------------------+---------
                          OC4JGroup:default_group | OC4J:oafm | 21742 | Alive
                          OC4JGroup:default_group | OC4J:forms | 21674 | Alive
                          OC4JGroup:default_group | OC4J:oacore | 21529 | Alive
                          HTTP_Server | HTTP_Server | 21473 | Alive


                          adopmnctl.sh: exiting with status 0

                          adopmnctl.sh: check the logfile /u01/appltest/inst/apps/ERP_DLAERPSRV01/logs/appl/admin/log/adopmnctl.txt for more information ...
                          • 11. Re: RC-50004: Fatal: Error occurred in ApplyDatabase: Control file creation fai
                            Hussein Sawwan-Oracle
                            What is the error you get when you access the application?

                            Can you access the main login page from the server?

                            Thanks,
                            Hussein
                            • 12. Re: RC-50004: Fatal: Error occurred in ApplyDatabase: Control file creation fai
                              Clamarion
                              Hi,
                              When I access the application home page with my firefox browser, I just get
                              The connection has timed out.
                              The server at dlaerpsrv01.camairco.local is taking too long to respond.

                              I can't access the web interface directly from the server, since I don't have access to graphical interface.
                              • 13. Re: RC-50004: Fatal: Error occurred in ApplyDatabase: Control file creation fai
                                Hussein Sawwan-Oracle
                                Clamarion wrote:
                                Hi,
                                When I access the application home page with my firefox browser, I just get
                                The connection has timed out.
                                The server at dlaerpsrv01.camairco.local is taking too long to respond.
                                Do you get the same error with IE?

                                Can you ping the server name as well as the IP Address from your client?

                                Is the firewall disabled on the server?

                                Can you access the application from your client if you use the IP Address instead on hostname.domainname in the application URL?

                                Do you have proper entry in the hosts file?

                                What about Apache log files (error_log* and access_log*)?

                                Thanks,
                                Hussein
                                • 14. Re: RC-50004: Fatal: Error occurred in ApplyDatabase: Control file creation fai
                                  Clamarion
                                  I'm having the same issue with IE9
                                  I can ping dlaerpsrv01.camairco.local and dlaerpsrv01

                                  About the status of the firewall on the server, i will check it and get back to you.

                                  I still can't access the application from my Win 7 client when I use the IP address instead of the hostname.domainname.

                                  This is the entry in my /etc/hosts file in my Win 7 client
                                  192.168.0.245 DLAERPSRV01.camairco.local DLAERPSRV01

                                  About the Apache log files, I am going to check them and let you know.

                                  I will contact you again in 11-13 hours..... It is getting late here in Douala.

                                  Thanks a lot Hussein for your time and help.
                                  1 2 3 Previous Next