Oracle ebs-R12.1.1 COLD CLONING Signal node Signal User.


COLD CLONING Oracle ebs-R12.1.1 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:

ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMP'

 ORA-01552: cannot use system rollback segment for non-system tablespace "string" Cause: Used the system rollback segment for non...