1 2 Previous Next 16 Replies Latest reply on Nov 20, 2019 9:52 AM by Beauty_and_dBest

Cloning EBS 12.2.9

Beauty_and_dBest Nov 14, 2019 12:54 PM

Hi ALL,

I am cloning EBS 12.2.9 Vision demo instance.

I am starting at database tier first, but I got error below:

Usually database tier easiest part to clone, and I seldom get error in 12.2.8 and below.

But this 12.2.9 is a little bit weird.

Trying to connect using SID as ServiceName

getConnectionUsingServiceName() -->

JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lcctest2.lccgroup.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=VIS)))

WARNING: Exception occurred: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

Trying to connect using SID as ServiceName.DomainName

getConnectionUsingServiceName() -->

JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lcctest2.lccgroup.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=VIS.lccgroup.com)))

WARNING: Exception occurred: java.sql.SQLRecoverableException: Listener refused the connection with the following error:

ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

Connection could not be obtained; returning null

-------------------ADX Database Utility Finished---------------

WARNING: RC-00118: Error occurred during creation of database

Raised by oracle.apps.ad.clone.ApplyDatabase

StackTrace:

java.lang.Exception: Control file creation failed

at oracle.apps.ad.clone.ApplyDatabase.doConf(ApplyDatabase.java:672)

at oracle.apps.ad.clone.ApplyDatabase.doApply(ApplyDatabase.java:502)

at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:393)

at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:116)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

at java.lang.reflect.Constructor.newInstance(Unknown Source)

at oracle.apps.ad.clone.util.CloneProcessor.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

I tried to check the password of the source instance, and it is apps/apps. Why do I get ORA-01017: invalid username/password; logon denied?

Please help.....

Kind regards,

1. Re: Cloning EBS 12.2.9

yoonas Nov 14, 2019 2:37 PM (in response to Beauty_and_dBest)

Hi,

When wrong password was passed during adcfgclone.sh, i remember apps user got locked on 12.1.3.
May be the same case here i doubt.
what happens when you try to connect with apps/apps after clone has failed?

did you try running dbtier again?

Regards,
Yoonas
Like Show 0 Likes(0)

Actions
2. Re: Cloning EBS 12.2.9

Beauty_and_dBest Nov 15, 2019 8:28 AM (in response to yoonas)

Thanks yoonas,

I tried to run the stop / start script and it went okay? The database was able to start normally?

But the apps tier has warning below:

Configuring: Run file system....
LogFile located at /u01/appvis/VIS/fs1/inst/apps/VIS_lcctest2/admin/log/clone/run/RCloneApplyAppstier_11150747.log

<Nov 15, 2019 8:14:13 AM GMT+00:00> <Warning> <JNDI> <BEA-050001> <WLContext.close() was called in a different thread than the one in which it was created.>

Please help...

Kind regards
Like Show 0 Likes(0)

Actions
3. Re: Cloning EBS 12.2.9

yoonas Nov 15, 2019 10:52 AM (in response to Beauty_and_dBest)

Its failing with a warning or completing with this warning?

Adcfgclone.pl failing on target system (Doc ID 2574776.1)
Like Show 0 Likes(0)

Actions
4. Re: Cloning EBS 12.2.9

Beauty_and_dBest Nov 16, 2019 1:13 PM (in response to yoonas)

Hi yoonas, and ALL

Yes its completed. So I just ignore the warning.

Another question please,

Here in this new installed EBS 12.2.9
I want to test apply a sample small patch using adop, and demo it to a newbie appsdba.
I do not know where to find patches not yet applied.
Is it possible to re-apply a patch that are already applied via adop?

Please help,

Kind regards,
Like Show 0 Likes(0)

Actions
5. Re: Cloning EBS 12.2.9

lmu Nov 16, 2019 4:15 PM (in response to Beauty_and_dBest)

Yes, use options=forceapply in the adop command.

Like this:
adop phase=apply patches=17309867:u17309867.drv, 17309867_PTB:u17309867.drv, 17309867_I:u17309867.drv, 17309867_D:u17309867.drv, 17309867_F:u17309867.drv merge=yes options=forceapply
Like Show 0 Likes(0)

Actions
6. Re: Cloning EBS 12.2.9

Beauty_and_dBest Nov 18, 2019 4:47 AM (in response to lmu)

Thanks Imu and ALL,

But in my adop command I usually do not include .drv file
Is it mandatory to include it?

Please help....

Kind regards,
jc
Like Show 0 Likes(0)

Actions
7. Re: Cloning EBS 12.2.9

VishnuVinnakota Nov 18, 2019 10:00 AM (in response to Beauty_and_dBest)

Hi,

It is not needed at all. Just apply any EBS 12.2 patch and its fine. You can apply CPU or a simple FND patch etc.

Since you said demo, Choosing a patch like AD, TXK 11 will give him perfect details like migrating autoconfig to DB Tier, running adgrants.sql etc.

You can refer to link for example:

https://vishnu.ae/oracle/oracle-ebs/applying-ad-and-txk-rup-11-on-ebs-12-2/

Thanks,
Vishnu
https://vishnu.ae
Like Show 1 Likes(1)

Actions
8. Re: Cloning EBS 12.2.9

Beauty_and_dBest Nov 18, 2019 1:38 PM (in response to VishnuVinnakota)

Thanks Vishnu and ALL,

What I mean is I already applied AD, TXK 11 on this TEST instance.
So just to validate if my understanding is correct that, I can repeat apply AD, TXK 11 on our instance? By using options=forceapply?

Kind regards,
Like Show 0 Likes(0)

Actions
9. Re: Cloning EBS 12.2.9

VishnuVinnakota Nov 18, 2019 4:56 PM (in response to Beauty_and_dBest)
Hi,

Yes you can always re-apply. But you have plenty of new patches also to apply like:
CPU July or Oct 2019
Workflow Patches

Thanks,
Vishnu
Like Show 3 Likes(3)

Actions
10. Re: Cloning EBS 12.2.9

Beauty_and_dBest Nov 19, 2019 2:30 PM (in response to VishnuVinnakota)
Thanks Vishnu,

But what i mean is just for demo purpose only. If I had applied it previously with the same set of "old" patches, can I not repeat that process agian?
So I do not need below:
CPU July or Oct 2019
Workflow Patches

Kind regards,
Like Show 0 Likes(0)

Actions
11. Re: Cloning EBS 12.2.9

VishnuVinnakota Nov 20, 2019 8:04 AM (in response to Beauty_and_dBest)

Hi,

Yes. You can.

Use options=forceapply and you can also try apply=no which will run adop in testmode.

Thanks,
Vishnu
https://vishnu.ae
Like Show 0 Likes(0)

Actions
12. Re: Cloning EBS 12.2.9

Beauty_and_dBest Nov 20, 2019 9:06 AM (in response to VishnuVinnakota)

Thanks Vishnu and ALL

Can you list me again all the ORACLE_HOMES in EBS 12.2.x or 12.2.9

I am searching my post here about this but I can not find it anymore

I understand we have four or five Oracle homes all in all in EBS that need to be patched?

1. Weblogic
2. FMW
3. Forms & Report
4. RDBMS HOME
5. ?

Please help...
Like Show 0 Likes(0)

Actions
13. Re: Cloning EBS 12.2.9

EBSDBA Nov 20, 2019 9:11 AM (in response to Beauty_and_dBest)

Oracle E-Business Suite 12.2 Patching Technology Components Guide (Doc ID 1355068.1)
Like Show 0 Likes(0)

Actions
14. Re: Cloning EBS 12.2.9

EBSDBA Nov 20, 2019 9:14 AM (in response to Beauty_and_dBest)

Webtier and utilities (OHS)

Oracle E-Business Suite 12.2 Patching Technology Components Guide (Doc ID 1355068.1)
Like Show 0 Likes(0)

Actions

1 2 Previous Next

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.