Steps for Manual Cloning……

1) Restored the backup from the tape to the source destination.

2) Changed the ownership of all the directories.

chown -R appltest:dba *

chown -R oratest:dba * — Incase its multi-user.

3) Created a control file in the name of control.sql

In the source database … issue conmmand … alter database backup control file to trace;

We would find the trace file in udump.

Modify he contents of the control.sql to match the structure in the destination.

4) Changed the environment file to have the necessary settings and set the environment. Once you source th .env … it woulgive you the errors where it does not match and you may make the changes accordingly in various files.

.env file … please make sure that we change all the .env files. Even the ones in 8.0.6 and iAS Oracle Home along with the Appl_Top.

Also make the changes in the listener.ora, tnsnames.ora and sqlnet.ora.

Rename the folders too.

Make the changes in the .xml file.

Changes required would be in the hostname, Location, DB name, OS owners of Application and Database.

5) Source the environment file

6) Change the initSID.ora for correct control file location and bdump,cdump,udump

7) Rename the existing control and log files.

mv cntrl01.dbf cntrl01.dbf.bak

mv log01a.dbf log01a.dbf.bak

8) sqlplus “/as sysdba”

startup nomount

@control.sql

This will create the control file.

9) alter database open resetlogs;

10) lsnrctl start DBNAME

Sinc ewe have made the changes in the listener file we would not have any difficulties.

11) Run AutoConfig on the DBTIER.

12) Run the following in order to clean the nodes in the database.

The Databse would have the entries for the Source DB.

If you query: select node_name, node_id, server_id from fnd_nodes; — you would see that.

For cleaning:

sqlplus apps/apps

EXEC FND_CONC_CLONE.SETUP_CLEAN;

commit;

TO make sure that its cleaned up, you can also test with the following query:

select session_cookie_domain from icx_parameters;

This would provide no results.

Shutdown the DB Listener and DB … Start the DB and DB Listener.

Re-run AutoConfig on the DB node.

13) Run AutoConfig on the Application tier as we have made the changes on the Application side files.

14) Get the application services up and check the URL.

15) If you do face issues in getting the managers up and running … shutdown only the application and run cmclean.sql (available on metalink)

If you still face any issues … go to profile — system — query for %GSM% — Modify to NO … Save the changes and bounce the application.

The application and the Database should work fine after this.

Thanks To Mr. Fouad for sharing .

Advertisements

8 thoughts on “Steps for Manual Cloning……

  1. hi,
    i did full coning by manually in 11.5.9 version exactly you mentioned in the above every thing is fine .concurrent managers ,Apache ,everything is running but listner is showing problem even auto config run smoothely on all the nodes listner is not starting up showing below problem .can you guide me regarding this.

    $ adalnctl.sh start

    adalnctl.sh version

    Checking for FNDFS executable.
    adalnctl.sh[127]: 18899 Abort(coredump)
    Starting listener process APPS_DRCDEV.
    adalnctl.sh[145]: 18902 Abort(coredump)

    adalnctl.sh: exiting with status 134

    $ adalnctl.sh status

    adalnctl.sh version

    Checking status for listener process APPS_DRCDEV.
    /usr/lib/dld.sl: Can’t open shared library: /d02/oracle/drcprdora/8.0.6/lib//lib
    clntsh.sl.1.0
    /usr/lib/dld.sl: No such file or directory
    adalnctl.sh[164]: 18881 Abort(coredump)

    adalnctl.sh: exiting with status 134

    thanks,
    ram.

  2. Go to sqlnet.ora … and comment (#) all the lines with names tcp invited.
    Only 2 lines should be there:

    SQLNET.AUTHENTICATION_SERVICES= (NTS)

    NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, EZCONNECT, ONAMES, HOSTNAME)
    Bounce the Listener.
    It should work fine.

  3. hi,
    In my sqlnet.ora file i have only two lines

    NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME)
    SQLNET.EXPIRE_TIME= 10

    IFILE=/d02/oracle/drcdevdb/9.2.0/network/admin/DRCDEV_orcltest/sqlnet_ifile.ora

    but i added 2lines what you gave still same problem with listner.can you address it.

    $ adalnctl.sh start

    adalnctl.sh version

    Checking for FNDFS executable.
    adalnctl.sh[127]: 3107 Abort(coredump)
    Starting listener process APPS_DRCDEV.
    adalnctl.sh[145]: 3110 Abort(coredump)

    adalnctl.sh: exiting with status 134

    $ adalnctl.sh status

    adalnctl.sh version

    Checking status for listener process APPS_DRCDEV.
    /usr/lib/dld.sl: Can’t open shared library: /d01/oracle/drcprdora/8.0.6/lib//lib
    clntsh.sl.1.0
    /usr/lib/dld.sl: No such file or directory
    adalnctl.sh[164]: 3675 Abort(coredump)

    adalnctl.sh: exiting with status 134

    thanks,
    ramu.

    • Hi Ram,

      what did you do with the network library to resolve this issue?

      adalnctl.sh: exiting with status 134

      thanks
      Sandeep

      • run make statement on the below shown files
        ins_network.mk
        env_oemagent.mk
        env_network.mk
        env_oemagent.mk

        location of the files
        /8.0.6/network/lib
        /iAS/network/lib

  4. Hi Bilal,
    After full cloning the self services are worked initially . but after 2days i did database clone now self services are not working the loginn id below mentioned is not working
    http://my company :port/OA_HTML/AppsLocalLogin.jsp
    but this login id what mentione below is working in dev instance .
    http://my company :port/dev60cgi/f60cgi

    can you suggest me what might be the problem.

    thanks,
    ram.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s