http://onlineAppsDBA.com

thank you so much for writing this appsdba blog.when are you posting clonning interview question?

appreciate your response

 

I'll do it by tomorrow.

Atul

 

hey atul,

This template rocks...so does its content.can I nick it?

http://oracle.anilpassi.com

cheers
anil passi

 

Hi
Please explain what profiles, Printer settings; Workflow has to be updated after cloning
Thanks&Regards
Karthi

 

Karthi,

You can check post Install manual updates from Metalink Note # 230672.1 Cloning Oracle Applications Release 11i with Rapid Clone.

Profiles: You need to change profile values which are not site specific like Server Level,Instance Level, Responsibility Level ....other profiles which are pointing to source Instance.

Printer: You need to define new printer if target instance is using some other printer . If it has to use same printer as source no need to change any thing.

Workflow : you can check in above note

 

Hi Atul,

Appreciate your blog. Its been a good learning. I wanted to know about configuring a load balancer environment. For Example, I have a server on which my DB, conc processing, Reports reside and another server for my Web and Forms. Now I need to add another server on which I would like to loadbalance web and Forms. How to do that? I think I need to rapidclone the first Web & Forms server to the second one. Can you please elaborate the steps on how to do this. Thank you very much.

 

grande kabul!!!w juventus!:)

 

Hey Atul,

Great material and easy t understand

Regards,
Raghav

 

Dear Atul,

Need your opinion on an issue with Database cloning using Read Only tablespaces

I have an 11.5.9 database production called as PRODN on node A.

To improve my backup timings I have made a few archive tablespaces as Read only

I can successfully recover this database on another Node with same SID as PRODN

No issues up to here and I have the tablespaces as Read only on DEVP node also.

I go to the prodn and run adpreclone and bring it over to the devp machine,I still see refernces to the read only tablespace datafiles in dbinfo.lst

Now when i make these tablespaces as Read write and runm my adcfgclone.pl there are no issue

1)However when i run adcfgclone.pl with RO tablespaces,it breaks


2)Does adcfgclone support RO tablespaces?Also shall it work if I make the tablespaces offline before running the adcfgclone and then i make them online after the adcfgclone

My database is big and dev env sql-backtrack has some license issue that i could not try the option 2 above

Regards
Praveen

 

Praveen,
Your issue is really different but good one. I don't see any refernces regarding certification for RO tablespace in rapid clone but if you could share error message which you are getting & at what point your rapid clone is breaking so that I can find out in which phase of rapid clone RO tablespace is creating issue (In my views its during recreate control file phase)

Other readers any views on this ?

Atul

 

This is the error i get here

From log of the adcfgclone cloning a database with RO Tbalespaces on a new machine --->

PL/SQL procedure successfully completed.

ORACLE instance shut down.
Connected to an idle instance.
ORACLE instance started.

Total System Global Area 628322632 bytes
Fixed Size 737608 bytes
Variable Size 452984832 bytes
Database Buffers 163840000 bytes
Redo Buffers 10760192 bytes

Control file created.

alter database open resetlogs
*
ERROR at line 1:
ORA-01152: file 505 was not restored from a sufficiently old backup
ORA-01110: data file 505: '/ORACLE/PROD/data/arch_invd01.dbf'


alter tablespace temp add tempfile '/ORACLE/PROD/system/temp01.dbf' REUSE
*


#################################################################################################

Now if also make the RO tablespaces datafiles offline ,hoping that it shall let the resetlogs go thru manually this is what I get here

#################################################################################################

@PROD-> 10 >
@PROD-> 10 > alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01245: offline file 505 will be lost if RESETLOGS is done
ORA-01110: data file 505: '/ORACLE/PROD/data/arch_invd01.dbf'


@PROD-> 10 > alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


@PROD-> 10 > alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01245: offline file 505 will be lost if RESETLOGS is done
ORA-01110: data file 505: '/ORACLE/PROD/data/arch_invd01.dbf'


@PROD-> 10 > exit

 

Hi,
I'll check on this RO tablespace & get back to you .

Atul

 

Prasad,
You should run adpreclone after applying any AD patches.

Though its not required to run adpreclone each time before cloning but you should do it after Big Patches (Minipacks) & definately after ATG , Tech Stack & AD Patches

Now you can raise these questions at forum dedicated to Apps DBAs at http://teachmeoracle.com/forum

 

Posting what Oracle said for RO tablespaces

---->

When cloning you cannot have read only tablespaces. These tablespaces needs to be tagged with the target dbid but this implies f

or you to follow appendix B of cloning document: Note 230672.1

Usually for this you need to run rman to copy datafiles from source to target.



Ususally during the clone adcfgclone sets the dbid to be unique using an rman api (dbms_backup_re

store.zeroDbid(0)) the datafiles need to be written to, and all the tablespaces

would need to be writable



If you choose to run Appendix B of above mentioned Note basically you need to run dbms_backup_restore.zeroDbid(0) after you manually

recreate the control file with the reference to the RO tablespaces.



So to specifically answer your question either you make writable all tablespaces before clo

ning or have in mind above considerations.

 

Hi Anonymous ,
Thanks a lot for sharing this information with Us. It would be nice if you could write your name as well so that readers can recognize you & can take help on other questions (Though u can always put comments as anonymous if you don't wish to post ur name)

 

Yes that answer from Oracle was posted by me (Praveen) who originally raised all this hue and cry over the RO tablespace issues with adcfgclone.pl

I do not know where to post this
but posting here just if someone can answer this

I wanted to know if the Beta Exams 1Z1-232 and 1Z1-233 are still available as of 2-Nov-2006

They seem to have been valid from 31-AUG-2006 to 31-OCT-2006

I cannot see the exams being offered by Prometric anymore

Does anyone know when the 1Z0-232 and 1Z0-233 (production exams) shall be available for test takers?

As I am in India and no one picks up the helpdesk phone’s (:- here so request someone located in US/UK to please verify and post for us here..

Another Issue related to above is this that Prometric is still offering the 1Z1-231 which Oracle website ( http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=41&p_exam_id=1Z0_231 where it says click here to register )

Beta Period: Testing concludes on September 30, 2006! This is a special testing opportunity available for a limited time.

However Prometric in India is still offering this Exam as of 2-NOV-2006 and the prometric.com website also allows one to take it anywhere in the world

Please advise.

 

Hi Praveen,
Thanks a lot for sharing this with us. You can write your name at bottom so that its easy for others to recognize .

About this questions you about Beta Test , you can post it in Forum under certification section at http://teachmeoracle.com/forum

I am in UK & will try to find information for you


Atul

 

Whevever ther eis change in database structure, u need to run adpreclone again. Else your database won't be in sync with source database.

I forgot once and it cloned but it ommited the missing datafiles. later on i had issues with instance and figureed out that i missed adpreclone after adding datafile.

 

Hello Atul. Thanks for this great service. I am very new to Apps and wanted to clone 11.5.10. If i install Apps on the test server and i use rman or manual means to replicate database from production to test, will it work?

 

Yes , it will work


Atul

 

Hello Atul. I am from Kenya and i do not have a metalink account. You have stated that i can clone by simply installing apps on test server and cloning database using rman. Could you please post detailed steps of Apps 11.5.10 cloning or mail to (info@kenyadba.com). Once again thanks for this great service.

 

Ogutu,
Metalink Note ID is best source but unfortunately I can't give you content of that note as this is against copy right . Take help from any of your friend who got metalink ID .

Regards
Atul Kumar

 

Hi Atul...
Is Oracle EBSSE 11.5.9 can be clone? as we know EBSSE is having activation code every new installation, and the code is unique on each node. Does this activation code is copied to the clone server?

Thanks
~Ivan~

 

Ivan , can you elaborate what is EBSSE ?

Specially SE bit in last

 

Hi Atul,

EBSSE means e-Business Suite Special Edition.
Oracle EBSSE 11.5.9 that called Oracle Discrete Manufacturing. That i know EBSSE is part of Oracle APPS 11i. We must input unique Activation Code every doing installed. As you know is this can be clone..?

Thanks,
~Ivan~

 

Ivan,
To be frank, I never heard of EBSSE but I am sure there might be option to clone same or to edit activation code after cloning (If code is dependent on SID or server name)

Check with Oracle Support on this .

Atul

 

Hi Atul,
We want upgrade 11.0.3/8.0.5 to 11.5.10.2/10.1.0.2 on Aix Machiens.

At present 11.0.3 on aix 4.3.3.
We have to upgrade 11.0.3 to 11.5.9 on AIX 4.3.3 & Upgrade OS Aix 4.3.3 to Aix 5L(5.3) then Upgrade 11.5.9 to 11.5.10.2 becoz of OS limitation.

Before that we have to upgrade our 8.0.5 database to 8.0.6.3, which basic version for 11.5.9/8.1.7.4 .

Could you give me clear picture & any related scripts.

Thanks & Regards
Seshu

 

Seshu,
I don't have any upgrade doc from 11.0.3 at this minute but I'll try to find if I can get upgarde doc from 11.0.3 from my old implementaion references

 

Hey Atul,

Do you have a presentation on Cloning..?

If you have one could you forward on sanjay203@yahoo.co.in

Sanjay

 

hi atul its really gr8 work n service u r providing can u give me some documents regarding the manual cloning n wht is the basic diff btvn manual n rapid cloning

 

hi atul im a child in apps i mean fresher n i want to play it, n really gr8 u toprovide this services can u help me by posting some documents on cloning well pls make the diffrnz betvn rapid clone n manual cloning n interview questions
thanking u mr.atul

 

Pradeep,
Check following metalink notes for cloning

230672.1 Cloning Oracle Applications Release 11i with Rapid Clone
406982.1 Cloning Oracle Applications Release 12 with Rapid Clone
364565.1 Troubleshooting RapidClone issues with Oracle Applications 11i
216664.1 FAQ: Cloning Oracle Applications Release 11i

 

hey atul,

i recently completed my course in oracle apps 11i but i am not feeling confident enough to face the interview,

please send me a list of questions,related to architecture,cloning,patching and upgradation.

eagerly waiting for your reply,

mohammed alimuddin
9985150241

 

Thank you very much for the amount of information you are giving us for appsdba. Actually I have a question regarding portal service to start first one has for starting instance, lsnr and db than, have to start portal with emctl and opmnctl for sso and portal both right? but for me it is not working can you pl guide me? Am i doing anything wrong This is new field for me

 

For start/stop on portal check

http://becomeappsdba.blogspot.com/2006/11/startup-shutdown-application-server.html

Order is start database and listener

Start insfrastructure tier using opmnctl

start portal middle tier using opmnctl

If you hit any issues raise them in forum at

http://teachMeOracle.com/forum

 

hi atul

i have 11.5.10.2 apps in linux
to do preclone i want to apply any
patch. or jsut
run perl adpreclone.pl dbTier command ha .. i run this command i get stage completed. if run post clone i am getting RC-00110 fatal error.

can u give soln for this


thanks

yaseen.a.r

 

Yaseen,
Update this in forum http://teachMeOracle.com/forum with log from post clone.

Atul

 

Hi, Atul,

If I just want to clone DB (archived mode),is there manual I can follow?

Thanks,

Hank

 

hi atul
i started doing cloning but two steps iam confusing 2.3 and 2.4 can u plz help me

 

Hi, I'm new in clone process. I want to clone my production enviroment, this process had done yet before. I don't execute the Section 1: Prerequisites at Note:230672.1. These steps are necesary everytime or in what case I have to do them.

 

i recently completed my course in oracle apps 11i but i am not feeling confident enough to face the interview,

please send me a list of questions,related to architecture,cloning,patching and upgradation.

eagerly waiting for your reply,
my mail id sasidhar_new@yahoo.com

 

i recently completed my course in oracle apps 11i but i am not feeling confident enough to face the interview,

please send me a list of questions,related to architecture,cloning,patching and upgradation.

eagerly waiting for your reply,
my mai id sasidhar_new@yahoo.com

 

Hi Atul,

As of now I have around 2 yrs of Core DBA exp and 1 yr os Apps DBA exp.I would like to know the scope for moving into Business Analyst/Project Management role after working as an Oracle/Oracle Apps DBA for say 3-4 yrs.As in My desire/Goal is to land as a Manager down the line say after 6-7 yrs from now.Hence request you to guide me in the right direction.

Awaiting your reply.

Warm Regards,
Rad

 

once we done with cloning what are the sanity checks we need to do,to confirm the application is working

 

Hi Atul,

Am from Hydrabad, India - regularly read your posts, can u please send me detailed notes on cloning ( ex :worklog )

thank you
dna_gopal@yahoo.com

 

Hi Athul,

I'm just fininshed my training on Oracle Apps R12 DBA. I'm working on cloning. I have precloned the instance and moved the folders APPS, DB to the 2nd machine.

I have installed linux and oracle R12 in other machine and moved the APPS and DB folders from 2nd machine. I have performed cloning by running perl adcfgclone.pl script. I have done cloning perfectly.

Now, when I try to clone the instance on the same machine (by copying the folders APPS and DB in the target instance folder PROD), I' getting RC - 5004 error creating controlfile.

Can you please send me the detail steps to clone an R12 instance on the same machine on linux. My email: parifs@gmail.com

Thanks

Arif

 

Is it possible to clone the oracle apps database with exp / imp process using transport tablespace, If so can you let me know the details to do that.

Thanks,
Ramesh

 

I am looking at creating the copy of Oracle Apps without any data. We used the process of exp/imp with no rows but it takes lot of time to complete the entire process. Is there any other way to accomplish the Empty Oracle APPS database (without any data)like truncating all the database objects in Oracle Apps?

Can you suggest a better way to do the above task.

Thanks,
RN

 

Hi Atul,
i am planning to clone my multinode production instance on single machine.
on production application(form,reports..) on one machine and database and concurrent on other machine. so while cloning on single machine how can i merge both application directory which is not shared?

 

I had a look at the clonig procedure.It is very good article.
I would like to have detailed cloing procedure.If have it pleae share it....
Would appreciate your response.

Thanks
Daya.

 

Hi Atul,

We are facing Apache hung issues frequently on 11.5.10 environment production. Home page will be blank and we need to bounce apache services. Could you please suggest me how we can resolve this issue?

Thanks,
Sree.