http://onlineAppsDBA.com

hi atul,

thanks for sharing with us. May I ask you a couple of questions. for those of us with 11.5.5 and not autoconfig enabled, how do we go about doing cloning?

Can we apply patch 2942559 & 5107107?

for first timer, is it sufficient to follow notes 282930?

Please share your experience with us.

thanks
Kenny

 

Kenny,
Yes for first time its sufficient to follow note 282930.
Later you can apply all prereq. rapid clone patch mentioned in Rapid Clone Note # 230672.1 and use rapid clone .

Atul

 

hi Atul,

thanks for your replied. Just need further input from you.

Based on your advice, we can simply follow note 282930 to clone 11.5.5.

thereafter, we can use the patches mentioned in 230672.1 and apply to the 11.5.5? or, we need to apply these patches before the cloning 11.5.5?

thanks for your advice
Kenny

 

Kenny,
since these patches are rapid clone patches so if you wish to clone instance via rapid clone you have to apply these patches before clone. If you wish to clone without rapid clone via note 282930 then you can apply rapid clone patches any time ( before or after )

Atul

 

hi atul,

there is another system that I need to clone. It is a 11.5.9 oracle payroll system.

I had created a checklist for myself. Please give me your comments.

1) OUI22: latest patch 5035661
2) JRE: 1.1.8 in DB tier
3) JRE: 1.3.1_1.5 in DB tier for autoconfig
4) JDK: 1.3.1
5) AD minipack: all nodes: version I
6) Rapid clone patches: 3453499 (11i.ADX.F) & 5225940 (Post ADX.F. Fixes)

thanks
Kenny

 

Kenny,
Thats perfect.

Atul

 

hi atul,

As I was reading the patch info, I
realized that for AD minipack I and
OUI22, they were only meant for
Solaris Sunsparc 32bit. Does that
mean if the 11i is running on the
Solaris8, which is 64bit, it will
not be applicable?

thanks
Kenny

 

Kenny,
Could you guide me documentation which you are refering above . I'll check & get back to you.

Atul

 

hi atul,

the documentation note id is 230672.1
when I try to download both OUI22 and
AD minipack I for Solaris, I realized
that it was only available for 32 bits
sparc. 64 bits sparc is not available.

The current system that I'm going to
clone is running on Sun Solaris 8,
which is 64bits.

Hope you can enlighten me.

Thanks
Kenny

 

Kenny,
Give me some time, I need to check on this.

Though Applications are always 32 bit where as database can be 32 or 64 bit. I suppose you have to apply 32 bit patch . I know its confusing when it comes to bit. I'll recommend that you raise Tar as well just to be on safe side.

Atul

 

hi atul,

Oracle had replied. we can apply a
32bit patch onto a 64bit OS.

Regards,
Kenny

 

Thats good kenny & tahnks for sharing this with everybody

Atul

 

hi atul,

need to seek your advice.

i have this new situation. i have
2 servers. one is running 11.5.9 and
the other is an empty server.

furthermore, i do not have software
to install 11.5.9 in the new server.

can I restore the existing 11.5.9
to the new server and then do a
cloning.

please advice

thanks
Kenny

 

Kenny,
I suppose when you say empty server , you mean there is no Oracle software Installed on this .

Yes you can very well clone from you first server where you have 11.5.9 . Run adpreclone on db tier & apps tier on first server ( 11.5.9) , copy content from first server to empty server & run adcfgclone on both database tier & application tier as per metalink note mentioned above .

Atul

 

hi atul,

do i need to restore the binaries from
the first server and before I can do
the cloning?

Kenny

 

Kenny ,
Apologies for saying this but I suppose you have not read my cloning clearly I request you to go through it once again & metalink note for rapid clone & then get back to me for any doubts .

Atul

 

hi atul,

i had read it many times. just wonder
does it really work. for example, if
we clone databases, we need to
have the database binaries in the new
machine before we can copy the
database files from the original
machine to the new machine.

so, i was having this thought.

please bear with me as I'm
inexperience in 11i cloning.

Kenny

 

Kenny,
No issues I know oracle's documentation is very tough to understand specially when you just started learning . I have gone through your phase.

If you check metalink note # 230672.1 for rapid clone

Under Section 2 Clone Oracle Applications 11i

at point 2 Copy the Source System to the Target System
under that point b Copy the database tier file system

in that you have third point
that

"Copy the source database ORACLE_HOME to the target system " this is the binaries which you are taling about .

Do let me know if this is clear now.

Feel free to raise as many doubts as possible as thats motto of this site and apologies for my previous update ;-)

Atul

 

hi atul,

i had successfully cloned the 11.5.9
system. thanks for your help.

everything was smooth.

cheers
Kenny

 

Kenny,
Thats really great news . I can remember the Day when I did clone first time . I knwo its great feeling . Good job .

Now you can raise all your issues (Hope you never encounter) but you can now help other apps dba's with their issues at forum http://teachmeoracle.com/forum dedicated to Apps DBA's

Atul

 

Hi Atul,

Can you please provide us with Oracle Portal topics too..

 

Thanks a lot for your suggestion , You will see some in near future . Few are already there under 10g Application Server..

 

Hi Atul,

i am installing Oracle Apps 11.5.8 on platform Linux AS 3.0,

after passing 3-4 stag ,it stuck with error "error code received when running external process..."

Please help me with install doc and workaround,as i am unable to find the install doc for 11.5.8

Regards
Asif

 

Asif could you look at error message in log file about which external process its trying to run , please raise it in forum at http://TeachMeOracle.com/forum

Atul

 

Hey Atul,

I saw your note on JVM. have a question on that.
is there a way to find how many jvm's are running?. I know i can check in the xml file. but i dont want to trust entry in xml file. how can i check how many jvms are running at Os level?

 

Hi Anonymous

In your Jserv.conf you will see entry like this here first 1 is entry & second one is weightage of that JVM

ApJServGroup OACoreGroup 1 1 /PATH_TO_IAS_TOP/Apache/Jserv/etc/jserv.
properties

ApJServGroup DiscoGroup 1 1 /PATH_TO_IAS_TOP/Apache/Jserv/etc/viewer
4i.properties

#ApJServGroup FormsGroup 1 1 /PATH_TO_IAS_TOP/Apache/Jserv/etc/forms
.properties

ApJServGroup XmlSvcsGrp 1 1 /PATH_TO_IAS_TOP/Apache/Jserv/etc/xmlsvc
s.properties


In below example there are in turnm three JVM & forth one commented

 

you mean to say
ApJServGroup OACoreGroup 1 1 /PATH_TO_IAS_TOP/Apache/Jserv/etc/jserv.
properties

means only one jvm is running?. if so then how should i change it to reflect 2 jvms?

 

There are three JVM's running one for discoverer services , other for XML & third one OACoreGroup for other process (This si used by self services)

How to increase Number of JVM's and more on JVM check at

http://www.teachmeoracle.com/jvm02.html

 

Hi Atul,
I am system adminstrator , bcoz of our dba guy is on leave , they want me to clone the prod instance .

Its the first time i am doing cloning & that to of production server. I have gone through the your specified doc ids.

I have summarized the things .. please go through this , add any thing is missing in it.. I want to make sure that cloning process goes off smoothly. Doing it on linux OS.

Also is this patch required for 11.5.9 PROD instance. Apply OHS patch 2674529.?? As per document 165195.1 . I am in PROD environment to make sure nothing happens to my prod instance.

============================
Prerequesties :

JRE 1.3.1
JDK 1.3.1
Zip 2.3
Unzip 5.x
Perl 5.004

Apply patch : 5478710

Apply rapid clone patches – 3453499 , 5225940

Step 5b ..

Is this patch really required for 11.5.9 Apply OHS patch 2674529.?? As per document 165195.1 .

Prepare the Source System

Copy the Source System to the Target System

Configure the Target System
======================

Please reply to my email id: rnaidu73@gmail.com

Also if possible guide me in simple steps to be followed n sequence.. step1..step 2....step n

Thanking you in advance.Appreciate your patience.

Thanks once agian.

 

Naidu doc 165195.1 is for autoconfig & not for rapid clone .

For rapid clone follow metalink note # 230672.1 Cloning Oracle Applications Release 11i with Rapid Clone

For any issues/doubts/questions kindly raise them in forum http://teachMeOracle.com/forum

 

Hi Atul,

I have read your article they are really nice.My quesition is how would i clone 2 Node RAC DB / 2 Node APP Nodes to 2 Node RAC DB / 2 APP Nodes with the Hot backup(RMAN) on a Red HAT Linux Platform RHEL 3.
I know the metalink link but can you explain it bit more

Thanks & Regards,
ASD

 

Hi ASD,
I think cloning note is self explanatory Do let me know what doubt you have in that doc.

Atul

 

Hello

I understand your comment about "pain" cloning a 10gAS infrastructure tier when apps is integrated with single-sign on. Do you have a method to achieve this - how exactly do you go about cloning an infrastructure tier?

Thanks
Simon

 

Simon,
There is not direct and supported way to clone infra tier. I'll cover workaround to clone in coming posts

 

hi atul
thanks for sharing with us,i am working on 11.5.10.2 and doing manual cloning and after cloning my forms are not opening ,so how to resolove this type of errors

 

Check if appsweb_SID_HOSTNAME.cfg is correct and ICX form launcher profile option is pointing to right server. Also check if form server is up nd running

 

Atul, I got this error.. while ececuting this ..please have a look and let me have your suggestion..

oracle@dash:/home/oracle/9.2.0/appsutil/clone/bin:>> perl adcfgclone.pl database
Enter the APPS password [APPS]:
apps
ERROR : Unable to set CLASSPATH
/home/oracle/9.2.0/appsutil/clone/bin/../jlib/classes111.zip: is missing

 

Atul, I got this error.. while ececuting this ..please have a look and let me have your suggestion..

oracle@dash:/home/oracle/9.2.0/appsutil/clone/bin:>> perl adcfgclone.pl database
Enter the APPS password [APPS]:
apps
ERROR : Unable to set CLASSPATH
/home/oracle/9.2.0/appsutil/clone/bin/../jlib/classes111.zip: is missing

 

For any issues kindly raise them at http://teachMeOracle.com/forum

 

Hi Atul,
I refer to your site regularly especially if i am facing some problem.we have 11.5.8 on windows, I did cloning for the first time using note:230672.1 using Rapid clone.
What I wanted to know is there any checklist for the Post clone settings.To verify that everything is working fine, which are the configuration that we need to check.

thanks
Sunita

 

I use 10 point checkist mentioned at http://www.teachmeoracle.com/healthcheck.html

You can add yor custom steps as well

 

Hi Atul,


Can u plz list the diffence b/w

perl adpreclone.pl appsTier merge

perl adpreclone.pl appltop merge

and what exactly happenns internally.

 

appstier will be used on node which is choosen as Primary Node like

perl adpreclone.pl appsTier merge


and appltop will be used on secondary nodes which you wish to merge with primary node

perl adpreclone.pl appltop merge

For more information open perl script adpreclone.pl and look for function appltop and appstier

 

Hai Atul this is RamaKrishna, I am New to this group i want some details or any PDf about Cloning and also i want some Real Time Qusetions also. Plz Mail me

 

Hi Atul,

When using adcfgclone.pl (rapid clone), we will prompt for the values required to create the new context file manually. It means that we can't put it in a script. Does it have options?

Thks,
Paven

 

What is the difference b/w adcfgclone dbTier vs database vs dbTechstack.

 

dbTechstack doesn't create control file where as dbTier creates control file.

so if you are cloning from standby database or hot backup and created control file manually use dbTechstack but dbTier will recreate control file .

 

Hi Atul,

Copied all the files from source system to target system.Created database on the target system using a template from the source system.Now my doubt is as database got created which option do i need to run on the target system i.e, should i run adcfgclone.pl database or dbTier or dbTechctack. Please clarify my doubt.

Thanks

 

How you created database ? Why don't you let adcfgclone.pl dbTier do everything for you .

For any issues / doubts raise them in forum at http://teachMeOracle.com/forum

 

Hi atul

can u please tell me what is metalink and how to find ur cloning documents there.sorry for asking you . im new to this forum

thanks in advance

santhi

 

hi, Atul,

I wonder if you ever encounter this problem or not. We have a problem in PR summary at line level, whenever we click on Tools-> Control , it will prompt up error say "No error found in this documents", but this function working fine in the test environment(with the latest data).

I wonder if this is something to do we the envinroment settings or anythings that is not being cloned?

please help . thanks

regards
ng

 

Hi Atul,

Your post mentions the document https://metalink.oracle.com/metalink/plsql/docs/CLONING.PDF for early 11i clones.

I have a requirement for doing an 11.5.3 clone in the near future, but this link no longer seem sto work. I've had a unt arount MetaLink (or My oracle Support as they now call it), and in various DBA APPS dba forums but so far no joy. You don;t happen to have kept a copy of the document have you?

Thanks
Des

 

Hi Atul, please help me in fixing the issue,

Here ia the error message we got while running the adcfgclone.pl and failed in autoconfig.

[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:
(filename) (phase) (return code where appropriate)

[PROFILE PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /d02/wfmgold/common/admin/install/SGOLD_pdc-al-lnx50
afcpctx.sh INSTE8_PRF 1


AutoConfig is exiting with status 1

RC-50014: Fatal: Execution of AutoConfig was failed
Raised by oracle.apps.ad.clone.ApplyApplTop

Completed ApplyApplTop.
ERROR: AutoConfig completed with errors. Check logfile at /d02/wfmgold/11.5/admin/SGOLD_pdc-al-lnx50/log/ApplyAppsTier_08072052.log for details.
# Checking the status of AutoConfig run of ApplyApplTop
Warning : AutoConfig has completed with errors .
Please review the AutoConfig section in the logfile. If required, you can re-run AutoConfig from command line after fixing the problem


The log says:
Oracle error -6502: ORA-06502: PL/SQL: numeric or value error: character string buffer too small has been detected in FND_GSM_UTIL.upload_context_file.

 

Hi,

Check your temporary tablespace in the database. I think it's not there. Just verify it and create/increase the temporary tablespace if it's not there. Run again autoconfig after this and your issue should be resolved.

Thanks,