Preclone

[latifa]

Hi Erman,

Thank you very much  for your reply. you understood very well what I want to do ... and you resumed that very well ... thank you ...

The aim of all these cloning is to migrate my AppsTiers to RAC. My appsTier consists of six nodes previously. autoconf was not enough to configure AppsTiers  from DBOFINP to DBOFINP1 (the new dbname for RAC) .

So you suggested in a previous post to do an in place adcfgclone even without preclone because it doesn't work. So that's what I have done on the primary server. I prefered to clone only run system in order to isolate errors step by step (there was lot errors as you can saw in my posts). It works and patch file system finished well.

Now I will clone the other nodes but I'll use dualfs. However we should dele node before cloning.

Your idea worked fine Erman thank you very much. I am cloning the second node of CP it seems in a good way.

Regards,
Latifa

[latifa]

Hi Erman,

The cloning is a bit strange. I am cloning a node and it still running from yesterday 22:01:26 !

logfile:
-------
Configuring: Run file system....
LogFile located at /opt/application/V12/fs2/inst/apps/DBOFINP1_udkfinp05/admin/log/clone/run/RCloneApplyAppstier_03312203.log
AutoConfig has completed with errors for run
You can review AutoConfig portion log later

Continuing with Patch file system configuration

Configuring: Patch file system....
LogFile located at /opt/application/V12/fs2/inst/apps/DBOFINP1_udkfinp05/admin/log/clone/patch/RCloneApplyAppstier_04010244.log


Errors:

Configuring: Run file system....
LogFile located at /opt/application/V12/fs2/inst/apps/DBOFINP1_udkfinp05/admin/log/clone/run/RCloneApplyAppstier_03312203.log
AutoConfig has completed with errors for run
You can review AutoConfig portion log later

<>>: END: Calling adcloneutil.pl...
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
<>>

WARNING: [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: /opt/application/V12/fs2/inst/apps/DBOFINP1_udkfinp05/admin/install
      adadmprf.sh             INSTE8_PRF         -1

  [APPLY PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /opt/application/V12/fs2/FMW_Home/webtier/perl/bin/perl -I /opt/application/V12/fs2/FMW_Home/webtier/perl/lib/5.10.0 -I /opt/application/V12/fs2/FMW_Home/webtier/perl/lib/site_perl/5.10.0 -I /opt/application/V12/fs2/EBSapps/appl/au/12.0.0/perl -I /opt/application/V12/fs2/FMW_Home/webtier/ohs/mod_perl/lib/site_perl/5.10.0/sun4-solaris-thread-multi-64 /opt/application/V12/fs2/inst/apps/DBOFINP1_udkfinp05/admin/install
      adadmat.pl              INSTE8_APPLY       -1

and for the patch file system it's sticking here:

Running:
perl adaddnode.pl -appsuser=APPS -promptmsg=hide

as processes, I have two porcesses both comming scripts:

adadmprf.sql
and
adadmat.sql


Should I cancel this cloning ? or leave it ? May be it will not finish. this status is not normal.

Regards,
Latifa

[ErmanArslansOracleBlog]

Hi Latifa,

It basically fails. I don't think you should wait.
Send me the whole log, so I can analyze.

[latifa]

Hi Erman,

please find attached the log files.

Thank you in advance for your help.

Regards,
Latifa
01avril.zip

[ErmanArslansOracleBlog]

You get timeouts while running the failing scripts...

Gathered info from the logs:

Timed out( 3750000 ): Interrupted Exception

[ErmanArslansOracleBlog]

Let me check these perl scripts and see what they are written for.

[ErmanArslansOracleBlog]

Okay let's concantrate on;

adadmprf.pl: Script to set profiles in the database

It runs adadmprf.sql.

This scripts does some validations,updates and deletes.

Db tier related issue may cause it be in hang status.

This script has a spool file though...

It should log its activities to the "$INST_TOP/admin/log/adadmprf.txt"

What is written there?
Any errors?

Also, I suggest your to review the database sessions and their waits , during your next run.(during these kinds of hangs)

[latifa]

Hi Erman,

There is nothing written in that file.

I will restart all (DB & Apps Tiers) and run auconfig. It may refresh DB and free wait sessions.

Regards,
Latifa

[ErmanArslansOracleBlog]

okay.

the perl script itself may be in hang also.
Let's see the second try.. (after restarting the database and clearing all the apps processes)

[latifa]

Hi Erman,

Autoconf works successfully on run files systems but not on patch file system.

Error appearing in adconfig.log :

Enter value for 1: Enter value for 2: Enter value for 3: Enter value for 4: ERROR:
ORA-12521: TNS:listener does not currently know of instance requested in
connect descriptor

so I tried to do: tnsping DBOFINP1
results:

run FS:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=prdc1pdb01-vip.dalkia.net)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=DBOFINP1) (INSTANCE_NAME=DBOFINP11)))
OK (0 msec)

patch FS:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=prdc1pdb01-scan)(PORT=1521)) (CONNECT_DATA=(SID=DBOFINP1)))
OK (0 msec)


Where can I modify this to have : prdc1pdb01-scan and prdc1pdb01-vip ?

For the master server, there is no difference between run and patch files systems: tnsping DBOFINP1 gives as results : HOST=prdc1pdb01-vip.

Regards,
Latifa

[latifa]

Hi Erman,

May I modify CONTEXT_FILE and run adconfig using that context_file to make updates every where ? May I do that even on the master server ?

Regards

Latifa

[ErmanArslansOracleBlog]

why do you have different TNS info in your  patch filesystem?

I suggest you to do an fs_clone and retry.

[latifa]

Hi Erman,

Okay for this suggestion.

However, what is correct in RAC:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=prdc1pdb01-vip.dalkia.net)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=DBOFINP1) (INSTANCE_NAME=DBOFINP11)))
OK (0 msec)

OR

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=prdc1pdb01-scan)(PORT=1521)) (CONNECT_DATA=(SID=DBOFINP1)))
OK (0 msec)

If it should be second configuration (I mean prdc1pdb01-scan) than master server should be again recloned ! and reclone the other servers ?

Regards,
Latifa

[ErmanArslansOracleBlog]

tnsping is a client based check.
The important thing is the TNS entry that is used by your application components.
the two_task variables...
You need to check the context file to see the two tasks..
concurrent may use a load balanced tns, while apache is using a dedicated node tns.
These are all configured using autoconfig. ( for concurrent tier, the related tag is s_cp_twotask)

Send me your run filesystem tnsnames.ora , so I can see if there is a problem there.

[latifa]

tnsnames.ora

this is tnsnames.ora of the master server for the run file system.

[ErmanArslansOracleBlog]

If you don't use scan listener, then this is ok.

[ErmanArslansOracleBlog]

if you use scan listener, then it is recommend to use it. (with EBS)

Check : Using Oracle 11g Release 2 Real Application Clusters and Automatic storage management with Oracle E-Business Suite Release 12.2 (Doc ID 1453213.1)

[latifa]

This note is for 11gR2 ... My database is 12c (12.1.0.2.0 ). Is it appliable with ?

[ErmanArslansOracleBlog]

Here is the 12c version of it:

Using Oracle 12c Release 1 (12.1) Real Application Clusters with Oracle E-Business Suite Release R12.2 (Doc ID 1626606.1)

[latifa]

Hi Erman,

Thank you for the note ID.

Paragraph 4.7.1 Preparatory Steps is not very explicit for me.

please have a look on attached document.

Erman_04042017.txt

Alos, is the tnsnames.ora correct:

tnsnames.txt

Thanks in advance for your help.

Regards,
Latifa