Showing posts with label Clone. Show all posts
Showing posts with label Clone. Show all posts

Thursday, September 3, 2009

Clone as new home

Scenario
While initialising Oracle home for oracle instance, not from a freshly installed home. Binaries are copied. I want to create a TEST database.
1.I have copied the 10.2.0 to a different location of freespace.
2.I relinked the binaries using (make -f ins_rdbms.mk ioracle)
3.I changed the tns and listener with a new port with TEST SID and home.
4.I tried to login with sysdba

Error found :
(1) ORA-12154: TNS: could not resolve the connect identifier specified
(OR)
(2) ORA-01034: ORACLE not available
ORA-27101: shared memory SVR4
Error: 2: No such file or directory

Solution:
First prepare oracle home
restore the dbf files to new location
recover this database with new name
run adcfgclone.pl dbconfig to configure new db.

In short:
1. adcfgclone.pl dbTechStack --> this will configre oracle home [will give the home]
under appsutil/clone/bin directory
[P.S#this will relink , prepare pfile, tnsnames.ora file , also listener.ora . you need to provide new values for instance. do not enter old values at all else it may overwrite original if possible use entirely different user fore new instance]
2. recover database manually with new name --> RMAN/sqlplus [will give database]
3. adcfgclone.pl dbconfig -> [update fnd tables]