Forgot your password?    
+ Reply to Thread
Results 1 to 9 of 9

Thread: Post Clone Checks,Procedures for 11i / R12

  1. #1
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427

    Post Clone Checks,Procedures for 11i / R12

    Clone Procedures are outlined in :
    Clone-ie-Refresh-Oracle-Applications-11i-R12
    Cloning-from-Multinode-to-Single-Node-Merge-APPL_TOP

    Post Clone checks and steps can differ .
    Listed are some of the common Post clone activities :

    (Here DEV is the target and PROD is the source)

    CHECKS
    ===========

    THE CHECKS/STEPS LISTED HERE SHOULD BE PERFORMED AFTER DATABASE CLONE BEFORE APPLICATIONS CLONE

    1 Check the Target - If its in ARCHIVELOG / NOARCHIVELOG MODE as desired.

    2 Create the Temp datafiles , using the commands taken from the control file , if the temporary tablespace tempfiles is not existing.

    ALTER TABLESPACE TEMP ADD TEMPFILE __________

    Verify dba_temp_files, for all the temp file entries added to TEMP

    SQL> select file_name from dba_temp_files;

    Check for the Default Temporary file –
    ===========================
    select * from database_properties where property_name = 'DEFAULT_TEMP_TABLESPACE';

    Confirm that this TEMP.
    If the default is not TEMP,

    SQL>alter database default temporary tablespace TEMP

    3 Update global_name if it contains source

    select * from global_name;
    update global_name set global_name='<global db name>';
    commit;

    SQL> select * from global_name;

    GLOBAL_NAME
    --------------------------------------------------------------------------------
    DEV

    4 Restoration of files backed up on Target Instance prior to the clone.

    - You may need to restore the tnsnames.ora , listener.ora (which was backed up for the target instance prior to clone)
    - You may need to restore the spfile/init file , so that the target instance takes the original init parameters (memory/performance parameters) and restart the database.

    5 Change the directories – if any need to be changed

    set heading off
    set pages 1000
    set linesize 100
    select 'CREATE OR REPLACE DIRECTORY '||DIRECTORY_NAME||' AS '||''''||DIRECTORY_PATH||''''||';'
    from all_directories;
    spool off

    - Edit the commands by replacing PROD with DEV ie source with target and Execute.

    - You would also be required to check and recreate the DB links as per tns entries and requirements in the Target Instance.


    6 Update apps.wf_systems
    (This should show the target Instance and not the source Instance)

    SQL>select name,display_name from apps.wf_systems;
    SQL>update apps.wf_systems set name=’<SID>’,display_name=’ <SID>.<hostname.domainname>’;
    SQL>COMMIT;

    Example after change
    SQL> select name,display_name from apps.wf_systems;

    NAME DISPLAY_NAME
    ------------------------------ --------------------------------------------------------------------------------
    DEV DEV.DBALOUNGE.COM


    7 Update Notification status
    (This needs to be bone before running adcfgclone on the apps tier , to avoid any Notifications to be sent from the Target Instance)

    UPDATE wf_notifications SET status ='CLOSED', mail_status ='SENT', end_date ='01-JAN-01' WHERE mail_status in ('MAIL','INVALID','OPEN') ;

    Commit;

    update wf_agents set address = replace ( address,'PROD','DEV' ) ;
    select name ,display_name from wf_systems;

    update wf_systems set
    DISPLAY_NAME = replace ( DISPLAY_NAME, 'PROD.DBALOUNGE.COM','DEV.DBALOUNGE.COM');

    Commit;


    8 Update the target node in CM fnd_concurrent_queues table :

    update fnd_concurrent_queues set node_name='<target_conc_node>' where node_name='<source_conc_node>';

    commit;

    THE CHECKS/STEPS LISTED HERE SHOULD BE PERFORMED AFTER APPLICATIONS CLONE BUT with APPS SERVICES DOWN

    9 You may want to Restore the backed up target xml file (DEV xml) file to its proper location.
    We may want to use the same xml file which was in place prior to the clone so that the same ports / configuration is in use.

    10 remove the log files from APPLCSF/APPLLOG:

    Make sure Dir are existing ; Use command to confirm
    cd $APPLCSF/$APPLLOG

    Delete all files under $APPLCSF/$APPLLOG


    11 You can set the logfile to NULL

    update fnd_concurrent_requests set logfile_name = null, logfile_node_name = null,
    outfile_name = null, outfile_node_name = null;

    commit;

    12 You may need to run

    exec FND_CONC_CLONE.SETUP_CLEAN;
    commit;

    to clear FND_NODES entries and rerun autoconfig (on all application tiers) as per step given below

    For Details , Refer to : How-to-cleanup-FND_NODES-table-to-clear-corrupted-setup

    13 Run Autoconfig

    14. Change apps , system and sysadmin and a module specific passwords.
    Change apps password in wdbsvr.app and CGIcmd.dat files

    Refer to :
    FNDCPASS-to-Change-Passwords

    15 Log in to the target system application tier node as the applications User

    Run the following tasks in adadmin for all products:
    - generate JAR files
    - generate message files
    - relink executables


    16 Run cmclean.sql
    (This may be required to clean Concurrent Queue Status and Request Status)


    THE CHECKS/STEPS LISTED HERE SHOULD BE PERFORMED AFTER APPLICATIONS CLONE with APPS SERVICES UP and RUNNING

    17 Bring up all services

    18 Set the Site Name Profile Option

    19 Set the Java Color profile option
    Changing-Look-and-feel-of-Oracle-Application&highlight=java+color

    20 Configure Workflow Mailer

    Login to OAM. Click on
    Notification Mailer => Edit Button => Advanced.
    Make sure to type in the Target instance password.

    PROCESS and DISCARD should exist on the Server for wf<sid> user.
    The name of the Process and the Discard directory can be got from the workflow configuration

    21 Check and Schedule the Concurrent Requests - these would include Gather Statistics , Purge old data and Workflow related Concurrent Requests.
    You can submit these Conc. Requests using forms or use CONCSUB as described in Concsub-to-Quickly-submit-Concurrent-Requests

    Purge-concurrent-request-and-or-manager-data
    Purge-Obsolete-Workflow-Runtime-Data-Concurrent-Program
    Purge-Obsolete-Workflow-Runtime-Data-Concurrent-Program

    22 Do a comprehensive Status check

    23 Release the Instance to Users

  2. #2
    Hi all,
    I am facing problem in postcloning at step of generate jarfiles for all products using adadmin but i am facing follwing problem :

    Dropping AD_DEFERRED_JOBS table...

    DROP TABLE AD_DEFERRED_JOBS


    AD_DEFERRED_JOBS table dropped.

    Connecting to APPS......Connected successfully.

    Review the messages above, then press [Return] to continue.


    Time is: Wed Mar 28 2012 01:56:26


    Backing up restart files, if any......Done.

    Connecting to APPLSYS......Connected successfully.

    Generate Applications Files
    ----------------------------------------

    1. Generate message files

    2. Generate form files

    3. Generate report files

    4. Generate graphics files

    5. Generate product JAR files

    6. Return to Main Menu









    Enter your choice [6] : 5

    Connecting to APPS......Connected successfully.


    Do you wish to force regeneration of all jar files? [No] ? No


    Generating any out of date or missing jar files.


    Time is: Wed Mar 28 2012 01:57:30


    Time is: Wed Mar 28 2012 01:57:30


    Time is: Wed Mar 28 2012 01:57:31


    STRT_TASK: [Generate JAR files] [] [Wed Mar 28 2012 01:57:31]



    STRT_TASK: [Generate JAR files under JAVA_TOP] [] [Wed Mar 28 2012 01:57:31]


    Signing product JAR files in JAVA_TOP -
    /u05/stage/oracleapps/testcomn/java
    using entity PROD_localhost and certificate 1.

    Calling /u05/stage/oracleapps/testcomn/util/java/1.4/j2sdk1.4.2_04/bin/jre ...

    Successfully created javaVersionFile.

    Creating directory /u05/stage/oracleapps/testappl/fpt/11.5.0/java/jar...

    Creating directory /u05/stage/oracleapps/testappl/ibu/11.5.0/java/jar...

    Creating directory /u05/stage/oracleapps/testappl/pos/11.5.0/java/jar...

    Creating directory /u05/stage/oracleapps/testappl/mwa/11.5.0/java/jar...

    Creating directory /u05/stage/oracleapps/testappl/asl/11.5.0/java/jar...

    Creating directory /u05/stage/oracleapps/testappl/bne/11.5.0/java/jar...

    Generating product JAR files in JAVA_TOP -
    /u05/stage/oracleapps/testcomn/java with command:

    adjava -mx512m -nojit oracle.apps.ad.jri.adjmx @/u05/stage/oracleapps/testappl/admin/test/out/genjars.cmd


    Reading product information from file...

    Reading language and territory information from file...

    Reading language information from applUS.txt ...
    Temporarily resetting CLASSPATH to:
    "/u05/stage/oracleapps/testappl/ad/11.5.0/java/adjri.zip:/u05/stage/oracleapps/testcomn/util/java/1.4/j2sdk1.4.2_04/lib/rt.jar:/u05/stage/oracleapps/testcomn/util/java/1.4/j2sdk1.4.2_04/lib/i18n.jar:/u05/stage/oracleapps/testcomn/util/java/1.4/j2sdk1.4.2_04/lib/tools.jar:/u05/stage/oracleapps/testcomn/java/appsborg.zip:/u05/stage/oracleapps/testcomn/java/apps.zip:/u05/stage/oracleapps/testora/8.0.6/forms60/java:/u05/stage/oracleapps/testcomn/java"

    Calling /u05/stage/oracleapps/testcomn/util/java/1.4/j2sdk1.4.2_04/bin/jre ...
    Unrecognized option: -nojit
    Could not create the Java virtual machine.

    AD Run Java Command is complete.

    Copyright (c) 2002 Oracle Corporation
    Redwood Shores, California, USA

    AD Java

    Version 11.5.0

    NOTE: You may not use this utility for custom development
    unless you have written permission from Oracle Corporation.

    Failed to generate product JAR files in JAVA_TOP -
    /u05/stage/oracleapps/testcomn/java.


    adogjf() Unable to generate jar files under JAVA_TOP


    Time is: Wed Mar 28 2012 01:57:37


    Backing up restart files, if any......Done.

    You should check the file
    /u05/stage/oracleapps/testappl/admin/test/log/adadmin.log

    for errors.

    Thanks and Regards,
    Gyanendra Jaiswal

  3. #3
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Posts
    120
    It seems that you are missing some files on the below given directory in comparison to source.

    /u05/stage/oracleapps/testcomn/util/java. You should validate it. Or you had copied this directory from other source. So the JRE is not recognizing the options.

    You should validate your apps environment to get all pass before trying to generate the jar files.

    follow the metalink note: 277366.1

    Regards

  4. #4
    i matched the /u05/stage/oracleapps/testcomn/util/java on source and target both are same.
    but still problem exist. please give me some solution.

  5. #5
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Posts
    120
    First check that you had properly sourced the environment variable. Also check $JDK_TOP if its properly showing.
    Second your JRE version may be low than what is required by this instance.
    Third you may need to apply patches.

    For this follow the metalink notes to understand your current technology stack and what is needed:

    1. 277366.1
    2. 139684.1
    3. 300482.1

    Regards

  6. #6
    Dear All,

    $JDK_TOP is not giving any value but $OA_JRE_TOP gives the follwoing value
    $ echo $OA_JRE_TOP

    /u05/stage/oracleapps/testcomn/util/java/1.4/j2sdk1.4.2_04

    And i also set the unix format for all files under the /u05/stage/oracleapps/testcomn/util/java/1.4/j2sdk1.4.2_04/bin

    and i again generate the jar files using the adadmin utility but same problem arised as before.


    And i have also gone through the metalink 277366.1 but i could not understand which patch i should apply because with this metalink lots of option was there.

    Please help me out to resolve this problem..

    Please hemant sir or anyone give me solution..

    Thanks and Regards,
    Gyanendra Jaiswal

  7. #7
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Posts
    120
    Are you able to start all the services for Apps Tier and also able to connect thru browser and if you are able to open forms.

    Regards

  8. #8
    Yes ,
    But when i open the thru browser and when i login on Apps Login then it become hang.
    On Started adstrtal.sh it is giving the following report :




    Setting service Oracle Apache Server test_localhost to mode 2
    Executing service control script:
    /u05/stage/oracleapps/testcomn/admin/scripts/test_localhost/adapcctl.sh start
    Timeout specified in context file: 100 second(s)

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

    adapcctl.sh version 115.43

    Starting Apache Web Server Listener (dedicated HTTP) ...
    Starting Apache Web Server Listener (dedicated PLSQL) ...

    adapcctl.sh: exiting with status 0


    .end std out.

    .end err out.

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


    Setting service OracleTNSListener80APPS_test_localhost to mode 2
    Executing service control script:
    /u05/stage/oracleapps/testcomn/admin/scripts/test_localhost/adalnctl.sh start
    Timeout specified in context file: 100 second(s)

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

    adalnctl.sh version

    Checking for FNDFS executable.
    Starting listener process APPS_test.

    adalnctl.sh: exiting with status 0


    .end std out.

    .end err out.

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


    Setting service OracleConcMgrtest_localhost to mode 2
    Executing service control script:
    /u05/stage/oracleapps/testcomn/admin/scripts/test_localhost/adcmctl.sh start
    Timeout specified in context file: 1000 second(s)

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

    You are running adcmctl.sh version 115.19

    Starting concurrent manager for test ...
    Starting test_0410@test Internal Concurrent Manager
    Default printer is noprint

    adcmctl.sh: exiting with status 0


    .end std out.

    .end err out.

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


    Setting service OracleFormsServer-Forms60test_localhost to mode 2
    Executing service control script:
    /u05/stage/oracleapps/testcomn/admin/scripts/test_localhost/adfrmctl.sh start
    Timeout specified in context file: 100 second(s)

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

    You are running adfrmctl.sh version 115.33

    Starting forms server for test on port 9063.

    adfrmctl.sh: exiting with status 0


    .end std out.

    .end err out.

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


    Setting service OracleReportServer-Rep60_test to mode 2
    Executing service control script:
    /u05/stage/oracleapps/testcomn/admin/scripts/test_localhost/adrepctl.sh start
    Timeout specified in context file: 100 second(s)

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

    You are running adrepctl.sh version 115.26

    starting Reports Server for test on port 7063.

    adrepctl.sh: exiting with status 0


    .end std out.

    .end err out.

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


    Setting service Oracle Metrics Client test_localhost to mode 2
    Executing service control script:
    /u05/stage/oracleapps/testcomn/admin/scripts/test_localhost/adfmcctl.sh start
    Timeout specified in context file: 100 second(s)

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

    You are running adfmcctl.sh version 115.16

    Starting forms load balancing client for test.

    adfmcctl.sh: exiting with status 0


    .end std out.

    .end err out.

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


    Setting service Oracle Metrics Server test_localhost to mode 2
    Executing service control script:
    /u05/stage/oracleapps/testcomn/admin/scripts/test_localhost/adfmsctl.sh start
    Timeout specified in context file: 100 second(s)

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

    You are running adfmsctl.sh version 115.12

    starting forms metrics server for test.

    adfmsctl.sh: exiting with status 0


    .end std out.

    .end err out.

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


    Setting service Oracle Fulfillment Server test_localhost to mode 2
    Executing service control script:
    /u05/stage/oracleapps/testcomn/admin/scripts/test_localhost/jtffmctl.sh start
    Timeout specified in context file: 100 second(s)

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

    You are running jtffmctl.sh version 115.16

    Validating Fulfillment patch level via /u05/stage/oracleapps/testcomn/java
    Fulfillment patch level validated.
    Starting Fulfillment Server for test on port 9363 ...

    jtffmctl.sh: exiting with status 0


    .end std out.

    .end err out.

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


    Setting service Oracle Discoverer services test_localhost to mode 2
    Executing service control script:
    /u05/stage/oracleapps/testcomn/admin/scripts/test_localhost/addisctl.sh start
    Timeout specified in context file: 300 second(s)

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

    addisctl.sh version 115.14

    /u05/stage/oracleapps/testora/8.0.6/vbroker/bin/osagent
    Started osagent.
    Osagent logs messages to the file /u05/stage/oracleapps/testora/8.0.6/discwb4/util/osagent.log.
    Waiting for OAD to start...
    Started OAD.
    OAD logs messages to the file /u05/stage/oracleapps/testora/8.0.6/discwb4/util/oad.log.
    Failed to start locator.
    Cannot bind to OAD. Re-starting...

    OAD is stopped
    Osagent is stopped
    Unable to stop locator. No process-id file found.
    Unable to stop gatekeeper. No process-id file found.
    Unable to stop any Discoverer Sessions. No process-id file found.
    Unable to stop any Discoverer Preference. No process-id file found.
    Unable to stop any Discoverer Collector. No process-id file found.
    /u05/stage/oracleapps/testora/8.0.6/vbroker/bin/osagent
    Started osagent.
    Osagent logs messages to the file /u05/stage/oracleapps/testora/8.0.6/discwb4/util/osagent.log.
    Waiting for OAD to start...
    Started OAD.
    OAD logs messages to the file /u05/stage/oracleapps/testora/8.0.6/discwb4/util/oad.log.
    Failed to start locator.
    Registering Discoverer Session
    Registering the Collector
    Applying preferences from file : /u05/stage/oracleapps/testora/8.0.6/discwb4/util/pref.txt
    Finished applying preferences

    Closing down registry..
    Registry File sync...
    Registering Discoverer Preference Repository

    addisctl.sh: exiting with status 1


    .end std out.
    /u05/stage/oracleapps/testora/8.0.6/jre1183o/lib/i686/green_threads/libzip.so: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference (libzip.so)
    Unable to initialize threads: cannot find class java/lang/Thread
    Could not create Java VM
    /u05/stage/oracleapps/testora/8.0.6/jre1183o/lib/i686/green_threads/libzip.so: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference (libzip.so)
    Unable to initialize threads: cannot find class java/lang/Thread
    Could not create Java VM
    /u05/stage/oracleapps/testora/8.0.6/jre1183o/lib/i686/green_threads/libzip.so: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference (libzip.so)
    Unable to initialize threads: cannot find class java/lang/Thread
    Could not create Java VM
    /u05/stage/oracleapps/testora/8.0.6/jre1183o/lib/i686/green_threads/libzip.so: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference (libzip.so)
    Unable to initialize threads: cannot find class java/lang/Thread
    Could not create Java VM
    /u05/stage/oracleapps/testora/8.0.6/jre1183o/lib/i686/green_threads/libzip.so: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference (libzip.so)
    Unable to initialize threads: cannot find class java/lang/Thread
    Could not create Java VM
    /u05/stage/oracleapps/testora/8.0.6/jre1183o/lib/i686/green_threads/libzip.so: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference (libzip.so)
    Unable to initialize threads: cannot find class java/lang/Thread
    Could not create Java VM
    /u05/stage/oracleapps/testora/8.0.6/jre1183o/lib/i686/green_threads/libzip.so: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference (libzip.so)
    Unable to initialize threads: cannot find class java/lang/Thread
    Could not create Java VM

    .end err out.

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



    [Service Control Execution Report]
    The report format is:
    <Service> <Script> <Status>

    Oracle Apache Server test_localhost adapcctl.sh Started
    OracleTNSListener80APPS_test_localhost adalnctl.sh Started
    OracleConcMgrtest_localhost adcmctl.sh Started
    OracleFormsServer-Forms60test_localhost adfrmctl.sh Started
    OracleReportServer-Rep60_test adrepctl.sh Started
    Oracle Metrics Client test_localhost adfmcctl.sh Started
    Oracle Metrics Server test_localhost adfmsctl.sh Started
    Oracle Fulfillment Server test_localhost jtffmctl.sh Started
    Oracle Discoverer services test_localhost addisctl.sh Failed
    Oracle Restricted Apache Server test_localhost adaprstctl.sh Disabled
    Oracle Apache Server test_localhost for PL/SQL adapcctl.sh Disabled
    Oracle TCF SocketServer test_localhost adtcfctl.sh Disabled
    Oracle ICSM test_localhost ieoicsm.sh Disabled
    Oracle iProcurement Bulk Loader test_localhost icxblkctl.sh Disabled


    ServiceControl is exiting with status 1


    Please help me..

  9. #9
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Posts
    120
    You had not mentioned which OS and Apps instanse you are using.

    Meanwhile if you are using OEL 4 or REDHAT 4 then set in the environment variable LD_ASSUME_KERNEL=2.4.19

    And if you are using OEL 5 or REDHAT 5 then unset LD_ASSUME_KERNEL in the environment variable.

    Also you can see metalink notes :377217.1 for further reference .

    See if it helps.

    Regards

+ Reply to Thread

Similar Threads

  1. Configuration Steps for OIM Post Install
    By Hemant in forum Oracle Fusion Middleware 11G - OIM , OAM , ODS , Weblogic , Webgate ..
    Replies: 0
    Last Post: 04-24-2012, 01:15 AM
  2. Operating System Check ,OS Patch Checks and System Utilities Checks failed.
    By pkumar in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 4
    Last Post: 03-23-2012, 11:45 AM
  3. Oracle 11g Health Checks.
    By ajaychandi in forum Core Database Administration and Monitoring
    Replies: 0
    Last Post: 01-31-2012, 04:17 PM
  4. Autoconfig fails Post Clone or after Host / Domain changes
    By Hemant in forum AD Utilities , Autoconfig , FND Utilities
    Replies: 0
    Last Post: 10-30-2011, 02:51 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics