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]

No comments:

Post a Comment