Cloning multinode

[latifa]

Hello Erman,

Because of a network shutdown, cloning process interrupted and then failed. The issue I have when adding nodes with the following errors:

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

WARNING: udkfinp05 entry is there in AD_NODES_CONFIG_STATUS
ERROR: udkfinp05 entry is there in ADOP_VALID_NODES
ERROR: udkfinp05 already registered in AutoConfig tables
ERROR: Some old configuration footprints still exists
Run ebs-delete-node before re-running add node

> I have already clean nodes, run autoconf on DB and previous App Tiers. Removed all files created after running : perl adcfgclone.pl appsTier dualfs

> ebs-delete-node doesn't work because I don't have context_file in the new node.


> How can I clean all these entries and continue adding my nodes ?

Thanks in advance for your prompt reply.

Regards,
Latifa

[latifa]

Hi Erman,

I deleted entries in tables AD_NODES_CONFIG_STATUS, ADOP_VALID_NODES.
Actually only last error message is appearing:


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

ERROR: Some old configuration footprints still exists
Run ebs-delete-node before re-running add node

>> I can't run :
perl $AD_TOP/patch/115/bin/adProvisionEBS.pl ebs-delete-node \

Because I have no $AD_TOP on this node ...

Regards

Latifa

[ErmanArslansOracleBlog]

Check document: "Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone (Doc ID 1383621.1)"
*"Section : 5.4 Deleting an Application Tier Node"
**"Case 2: If the secondary node to be deleted is not accessible, execute the following steps to remove the node from the FND topology and the EBS domain"

[latifa]

Hi erman,

I suppressed all EBSapps and recharge (copied from the source) it again.

Actually, I have another error :

Do you want the target system to have the same port values as the source system (y/n) [y] ? : y
Complete port information available at /opt/application/V12/fs2/EBSapps/comn/clone/bin/out/DBOFINP_udkfinp05/portpool.lst
RC-40201: Unable to connect to Database DBOFINP.

In the sqlnet.ora I have added the server as invited node as requested by the procedure. Same error.

Regards
Latifa

[ErmanArslansOracleBlog]

Answer "n" to the question above and give the port pool. (For ex: 0 if your db port is 1521 , 1 for 1522 ...etc)

Update me with the outcome

2 Şub 2017 21:13 tarihinde "latifa [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

Hi erman,

I suppressed all EBSapps and recharge (copied from the source) it again.

Actually, I have another error :

Do you want the target system to have the same port values as the source system (y/n) [y] ? : y
Complete port information available at /opt/application/V12/fs2/EBSapps/comn/clone/bin/out/DBOFINP_udkfinp05/portpool.lst
RC-40201: Unable to connect to Database DBOFINP.

In the sqlnet.ora I have added the server as invited node as requested by the procedure. Same error.

Regards
Latifa

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/Cloning-multinode-tp2046p2052.html

To start a new topic under EBS 12.2, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

[latifa]

Hi Erman,

I have done it before. I restarted DB and done again but the error is the same:

Do you want the target system to have the same port values as the source system (y/n) [y] ? : n

Target System Port Pool [0-99] : 1

Checking the port pool 1
done: Port Pool 1 is free
Report file located at /opt/application/V12/fs2/inst/apps/DBOFINP_udkfinp05/admin/out/portpool.lst
RC-40201: Unable to connect to Database DBOFINP.

Enter the Database listener port [1522] :

 

[latifa]

More infos:

 CloneContext_0202212718.log:

WARNING:     Exception occurred: java.sql.SQLException: Got minus one from a read call
    Connection could not be obtained; returning null


02022118.log

CLONE-23955-SVR  Filename provided already exists. Provide a new filename

regards,

Latifa

[ErmanArslansOracleBlog]

You added the apps node hostname to the tcp.invited_nodes and even after that the issue is not resolved right?
1)Make sure that all host name(s) (including any alias's) are correctly added to the /etc/hosts.
2)Did you restart the db listener after modifying tcp.invited_nodes, please restart the listener and retry the failing operation...

If the issue persists even doing the things above, please send me the complete log file. I need to see the jdbc error. (TNS- messages)

[latifa]

Hi Erman,

I restarted only listener (weblo and DB no). The error passed but it still error message as previously.
Please find attached logs.
regards,
Latifa

[latifa]

udkfinp05_Logs.zip

with logs is better :)

[ErmanArslansOracleBlog]

There are no attached files in your previous update?
Can you reaattach them.

[latifa]

RCloneApplyAppstier_02030909.log

log of Adcfgclone

[latifa]

udkfinp05_Logs.zip

[ErmanArslansOracleBlog]

The ERRORS are :

*
CLONE-23955-SVR  Filename provided already exists. Provide a new filename

*
"Some old configuration footprints still exists
Run ebs-delete-node before re-running add node"

As I already commented on one of my previous updates, please follow the action plan below;

Check document: "Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone (Doc ID 1383621.1)"
*"Section : 5.4 Deleting an Application Tier Node"
**"Case 2: If the secondary node to be deleted is not accessible, execute the following steps to remove the node from the FND topology and the EBS domain"

[latifa]

Hi Erman,

Please tell me , this document asks us to connect to primary node ! so to delete the secondary node in a remote way: --> it will not change something in the

so it will be :

opfinbac@udkfinp03:~$ hostname
udkfinp03
opfinbac@udkfinp03:~$perl $AD_TOP/patch/115/bin/adProvisionEBS.pl ebs-delete-node \
-contextfile=/opt/application/V12/fs2/inst/apps/DBOFINP_udkfinp05/appl/admin/DBOFINP_udkfinp05.xml -hostname=udkfinp05 -logfile=/opt/application/V12/delete_node_05.log

the result:
ERROR: Can't open /opt/application/V12/fs2/inst/apps/DBOFINP_udkfinp05/appl/admin/DBOFINP_udkfinp05.xml: No such file or directoryopfinbac@udkfinp03:~$

if I do that from the node to be deleted:

opfinapp@udkfinp05:/opt/application/V12/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin$ perl /opt/application/V12/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl ebs-delete-node \
perl /opt/application/V12/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl ebs-delete-node \
> -contextfile=/opt/application/V12/fs2/inst/apps/DBOFINP_udkfinp05/appl/admin/DBOFINP_udkfinp05.xml -hostname=udkfinp05 -logfile=/opt/application/V12/delete_node_05.log
-contextfile=/opt/application/V12/fs2/inst/apps/DBOFINP_udkfinp05/appl/admin/DBOFINP_udkfinp05.xml -hostname=udkfinp05 -logfile=/opt/application/V12/delete_node_05.log
Enter the APPS Schema password:
Enter the WebLogic AdminServer password:

/opt/application/V12/fs2/FMW_Home/wlserver_10.3/server/bin/setWLSEnv.sh is not having EXECUTE_ACCESS access
opfinapp@udkfinp05:/opt/application/V12/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin$ ls -l /opt/application/V12/fs2/FMW_Home/wlserver_10.3/server/bin/setWLSEnv.sh
ls -l /opt/application/V12/fs2/FMW_Home/wlserver_10.3/server/bin/setWLSEnv.sh
/opt/application/V12/fs2/FMW_Home/wlserver_10.3/server/bin/setWLSEnv.sh: No such file or directory

opfinapp@udkfinp05:/opt/application/V12/fs2$ ls -l
ls -l
total 35062463
drwxr-xr-x   5 opfinapp gpfinapp       5 Dec 17 00:16 EBSapps
drwxr-xr-x   3 opfinapp gpfinapp       3 Feb  3 09:05 inst

No FMW_Home directory in fs2

Regards

[ErmanArslansOracleBlog]

This document that I m suggesting to you is an Oracle Support Document, but you are afraid and it is normal :)

Okay let's do the steps in Case 1 then.

One by one, step by step and tell me the outcome.

Attention: Execute the ebs-delete-node option of the adProvisionEBS.pl script from the patch file system as follows (this step should be performed only "if you are on R12.TXK.C.Delta.4 or lower"):

So if you are > delta.4 , then you do all the other steps and you skip the ebs-delete-node step.

Case 1: If the secondary node to be deleted is accessible, execute the following steps:

Login to the secondary node to be deleted.

Source the run file system.

Ensure that all application tier services from the run and patch file system for the node to be deleted are shut down.

Execute the ebs-delete-node option of the adProvisionEBS.pl script as follows:

$ perl <AD_TOP>/patch/115/bin/adProvisionEBS.pl ebs-delete-node \

-contextfile=<CONTEXT_FILE> -logfile=<LOG_FILE>

This will delete the managed servers, OHS instances and Node Manager on the current node from the run file system WebLogic domain.

If the node is a non-shared node, verify and remove the following Oracle Home entries from the Oracle Inventory:

<FMW_HOME>/webtier

<FMW_HOME>/oracle_common

<FMW_HOME>/Oracle_EBS-app1

If any of the above Oracle Home entries are already registered in Oracle Inventory, you can execute the following command to de-register or detach that Oracle Home:

$ cd <Oracle Home>/oui/bin

$ ./runInstaller -detachhome ORACLE_HOME=<Oracle Home Location>

For example:

$ cd /u02/r122/fs1/FMW_Home/oracle_common/oui/bin

$ ./runInstaller -detachhome \

ORACLE_HOME=/u02/r122/fs1/FMW_Home/oracle_common -silent

Note: The Oracle Home <FMW_HOME>/webtier should be de-registered from the Oracle Inventory before trying to remove the Oracle Home <FMW_HOME>/oracle_common.

If the node is a non-shared node, verify and remove the following Oracle Home entry from the Oracle Inventory:

<OracleAS Tools 10.1.2 ORACLE_HOME>

If the above Oracle Home entry is registered in Oracle Inventory, you can execute the following command to de-register the Oracle Home:

$ cd <Oracle Home>/oui/bin

$ ./runInstaller -removeHome ORACLE_HOME=<s_tools_oh> -silent

For example:

$ cd /u02/r122/fs1/EBSapps/10.1.2/oui/bin

$ ./runInstaller -removeHome \

ORACLE_HOME=/u02/r122/fs1/EBSapps/10.1.2 -silent

Source the patch file system.

 

Execute the ebs-delete-node option of the adProvisionEBS.pl script from the patch file system as follows (this step should be performed only if you are on R12.TXK.C.Delta.4 or lower):

$ perl <AD_TOP>/patch/115/bin/adProvisionEBS.pl ebs-delete-node \

-contextfile=<PATCH_CONTEXT_FILE> -logfile=<LOG_FILE>

This will delete the managed servers, OHS instances and Node Manager on the current node from the patch file system WebLogic domain. 

If the node is a non-shared node, verify and remove the following Oracle Home entries of the patch file system from the Oracle Inventory:

<FMW_HOME>/webtier

<FMW_HOME>/oracle_common

<FMW_HOME>/Oracle_EBS-app1

Refer to Step 5 above for complete details. 

If the node is a non-shared node, verify and remove the following Oracle Home entry from the Oracle Inventory:

<OracleAS Tools 10.1.2 ORACLE_HOME> 

Refer to Step 6 above for complete details.

2017-02-03 12:35 GMT+03:00 latifa [via Erman Arslan's Oracle Forum] <[hidden email]>:

Hi Erman,

Please tell me , this document asks us to connect to primary node ! so to delete the secondary node in a remote way: --> it will not change something in the

so it will be :

opfinbac@udkfinp03:~$ hostname
udkfinp03
opfinbac@udkfinp03:~$perl $AD_TOP/patch/115/bin/adProvisionEBS.pl ebs-delete-node \
-contextfile=/opt/application/V12/fs2/inst/apps/DBOFINP_udkfinp05/appl/admin/DBOFINP_udkfinp05.xml -hostname=udkfinp05 -logfile=/opt/application/V12/delete_node_05.log

the result:
ERROR: Can't open /opt/application/V12/fs2/inst/apps/DBOFINP_udkfinp05/appl/admin/DBOFINP_udkfinp05.xml: No such file or directoryopfinbac@udkfinp03:~$

if I do that from the node to be deleted:

opfinapp@udkfinp05:/opt/application/V12/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin$ perl /opt/application/V12/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl ebs-delete-node \
perl /opt/application/V12/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl ebs-delete-node \
> -contextfile=/opt/application/V12/fs2/inst/apps/DBOFINP_udkfinp05/appl/admin/DBOFINP_udkfinp05.xml -hostname=udkfinp05 -logfile=/opt/application/V12/delete_node_05.log
-contextfile=/opt/application/V12/fs2/inst/apps/DBOFINP_udkfinp05/appl/admin/DBOFINP_udkfinp05.xml -hostname=udkfinp05 -logfile=/opt/application/V12/delete_node_05.log
Enter the APPS Schema password:
Enter the WebLogic AdminServer password:

/opt/application/V12/fs2/FMW_Home/wlserver_10.3/server/bin/setWLSEnv.sh is not having EXECUTE_ACCESS access
opfinapp@udkfinp05:/opt/application/V12/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin$ ls -l /opt/application/V12/fs2/FMW_Home/wlserver_10.3/server/bin/setWLSEnv.sh
ls -l /opt/application/V12/fs2/FMW_Home/wlserver_10.3/server/bin/setWLSEnv.sh
/opt/application/V12/fs2/FMW_Home/wlserver_10.3/server/bin/setWLSEnv.sh: No such file or directory

opfinapp@udkfinp05:/opt/application/V12/fs2$ ls -l
ls -l
total 35062463
drwxr-xr-x   5 opfinapp gpfinapp       5 Dec 17 00:16 EBSapps
drwxr-xr-x   3 opfinapp gpfinapp       3 Feb  3 09:05 inst

No FMW_Home directory in fs2

Regards

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/Cloning-multinode-tp2046p2063.html

To start a new topic under EBS 12.2, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

--

[latifa]

Hi Erman,

Thank you Erman for your patience and advisis.
I restored FMW_HOME directory from the source server and I re-run (adProvisionEBS.pl ebs-delete-node) .
It works fine ... Please find the log file. :
delete_node_05.log

Should I continue with the other steps ?
Should I suppress all what in fs2 and fs1 (I leave only EBSapps directory) to reclone the clone properly.

 Regards,
Latifa

[latifa]

Hi Erman,

Cloning process is going on ...

Thank you very much for your help.

regards,
Latifa

[ErmanArslansOracleBlog]

Good for you.  Lets see the result.

[latifa]

Hi Erman,

Cloning WebApplications/Forms node finished successfully.
Now other nodes will be cloned (similar and web entries).

thank you very much Erman for your help.

Regards,

Latifa