************Signal node_Signal User************
STEP:-1#. PREPARE THE SOURCE SYSTEM DATABASE TIER FOR CLONING:-
[oracle@sujeet ~]$ cd /oracle/idea/db/tech_st/11.1.0/appsutil/scripts/idea_sujeet
[oracle@sujeet idea_sujeet]$ ll
total 60
-rwx------ 1 oracle dba 1525 Nov 24 11:56 adautocfg.sh
-rwx------ 1 oracle dba 5079 Nov 24 11:56 adchknls.pl
-rwx------ 1 oracle dba 2772 Nov 24 11:56 addbctl.sh
-rwx------ 1 oracle dba 4110 Nov 24 11:56 addlnctl.sh
-rwx------ 1 oracle dba 7112 Nov 24 11:56 adexecsql.pl
-rwx------ 1 oracle dba 3405 Nov 24 11:56 adlsnodes.sh
-rwx------ 1 oracle dba 15247 Nov 24 11:56 adpreclone.pl
-rw------- 1 oracle dba 805 Nov 24 11:56 adstopdb.sql
-rw------- 1 oracle dba 1207 Nov 24 11:56 adstrtdb.sql
[oracle@sujeet idea_sujeet]$ perl adpreclone.pl dbTier
Enter the APPS User Password:apps
59% completed
Completed Stage...
Fri Nov 25 10:26:17 2011
STEPS:-2
#. PREPARE THE SOURCE SYSTEM APPLICATION TIER FOR CLONING:-
[oracle@sujeet /]$ cd /oracle/idea/apps/apps_st/appl/
[oracle@sujeet appl]$ . APPSidea_sujeet.env
[oracle@sujeet appl]$ cd $ADMIN_SCRIPTS_HOME
[oracle@sujeet scripts]$ perl adpreclone.pl appsTier
/ 80% completed
Completed Stage...
Fri Nov 25 11:23:39 2011
STEPS:-3
#. DOWN APPLICATION TIER AND DATABASE TIER:-
[oracle@sujeet idea_sujeet]$ cd /oracle/idea/apps/apps_st/appl/
[oracle@sujeet appl]$ . APPSidea_sujeet.env
cd [oracle@sujeet appl]$ cd $ADMIN_SCRIPTS_HOME
[oracle@sujeet scripts]$ ./adstpall.sh apps/apps
[oracle@sujeet scripts]$ cd /oracle/idea/db/tech_st/11.1.0/appsutil/scripts/idea_sujeet/
[oracle@sujeet idea_sujeet]$ ./addlnctl.sh stop idea
[oracle@sujeet idea_sujeet]$ ./addbctl.sh stop immediate
STEPS:-4
#. COPY Base dir Source to target System:-
[oracle@sujeet R12_clone]$ cd /oracle/
[oracle@sujeet oracle]$ ll
drwxr-xr-x 5 oracle dba 4096 Nov 24 10:54 idea
[oracle@sujeet oracle]$ du -sh
78G .
[oracle@sujeet oracle]$ cp -r idea/ /R12_clone/
time:-11:54am-1:43pm
STEPS:-5
#. CONFIGURE THE TARGET SYSTEM DATABASE NODE:-
[oracle@sujeet ~]$ cd /R12_clone/idea/db/tech_st/11.1.0/appsutil/clone/bin/
[oracle@sujeet bin]$ ls
adcfgclone.pl adchkutl.sh adclonectx.pl adclone.pl
[oracle@sujeet bin]$ perl adcfgclone.pl dbTier
Enter the APPS password :apps
Target System Hostname (virtual or normal) [sujeet] :
Target Instance is RAC (y/n) [n] : n
Target System Database SID : idea
Target System Base Directory : /R12_clone/idea
Target System utl_file_dir Directory List : /tmp
Number of DATA_TOP's on the Target System [1] :
Target System DATA_TOP Directory 1 [/oracle/idea/db/apps_st/data] : /R12_clone/idea/db/apps_st/data
Target System RDBMS ORACLE_HOME Directory [/R12_clone/idea/db/tech_st/11.1.0] :
Do you want to preserve the Display [null] (y/n) ? : n
Target System Display [sujeet:0.0] :
Target System Port Pool [0-99] : 11
15% completed
Completed Apply...
Fri Nov 25 14:16:38 2011
[oracle@sujeet bin]$ cd /R12_clone/idea/db/tech_st/11.1.0/
[oracle@sujeet 11.1.0]$ . idea_sujeet.env
[oracle@sujeet 11.1.0]$ sqlplus
Enter user-name: sys as sysdba
Enter password:sys
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1071333376 bytes
Fixed Size 1318172 bytes
Variable Size 427819748 bytes
Database Buffers 629145600 bytes
Redo Buffers 13049856 bytes
Database mounted.
Database opened.
SQL> !
[oracle@sujeet 11.1.0]$
STEPS:-6
#. CONFIGURE THE TARGET SYSTEM APPLICATION NODE:-
[oracle@sujeet ~]$ cd /R12_clone/idea/apps/apps_st/comn/clone/bin
[oracle@sujeet bin]$ perl adcfgclone.pl appsTier
Enter the APPS password : apps
Target System Hostname (virtual or normal) [sujeet] :
Target System Database SID : idea
Target System Database Server Node [sujeet] :
Target System Base Directory : /R12_clone/idea
Target System Tools ORACLE_HOME Directory [/R12_clone/idea/apps/tech_st/10.1.2] :
Target System Web ORACLE_HOME Directory [/R12_clone/idea/apps/tech_st/10.1.3] :
Target System APPL_TOP Directory [/R12_clone/idea/apps/apps_st/appl] :
Target System COMMON_TOP Directory [/R12_clone/idea/apps/apps_st/comn] :
Target System Instance Home Directory [/R12_clone/idea/inst] :
Target System Root Service [enabled] :
Target System Web Entry Point Services [enabled] :
Target System Web Application Services [enabled] :
Target System Batch Processing Services [enabled] :
Target System Other Services [disabled] :
Do you want to preserve the Display [sujeet:0.0] (y/n) ? : y
RC-00217: Warning: Configuration home directory (s_config_home) evaluates to /R12_clone/idea/inst/apps/idea_sujeet. A directory with this name already exists and is not empty.
Do you want to continue (y/n) ? : y
Target System Port Pool [0-99] : 11
Checking the port pool 11
done: Port Pool 11 is free
Report file located at /R12_clone/idea/inst/apps/idea_sujeet/temp/portpool.lst
Complete port information available at /R12_clone/idea/inst/apps/idea_sujeet/temp/portpool.lst
UTL_FILE_DIR on database tier consists of the following directories.
1. /usr/tmp
2. /tmp
3. /R12_clone/idea/db/tech_st/11.1.0/appsutil/outbound/idea_sujeet
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] :
STEPS:-7
#.CHECK APPLICATION LOGIN PAGE WORKS:-
OPEN mozilla
URL:-http://sujeet.oracle.com:8011/
HOME PAGE OPEN
USER:-sysadmin
password:-sysadmin
>>>>>>>>END CLONE STEPS>>>>>>>>>>>>>>>>>>>>>>>>
No comments:
Post a Comment