SSH IN MULTINODE APPLICATIONS FOR ADOP

[baig]

Dear Erman,

I have multi node setup.

For Adop :

1) i have setup password less ssh from primary to secondary.
do i need to have password less ssh from secondary to primary as well?


2) if yes, do i need to do some changes at application level?

please update. Thanks in advance

[ErmanArslansOracleBlog]

 To use SSH, adop requires the SSH equivalency from the admin node to all the application nodes in a multinode environment setup, because adop is not designed to supply a password while connecting the application nodes using SSH.
To set up the SSH equivalency (in other words, to configure the application OS user of the admin node to be able to connect all the other application nodes without needing to supply a password), you can use the ssh-keygen utility to create private and public key pairs.
You place the private key pairs into the admin node and the public key pairs into all the application nodes
in the configuration, thus letting the admin node connect all the application nodes using SSH without a password.

[baig]

Hi,

Thanks so much for the updates. i have setup password less ssh from primary admin node to the secondary node and it is successfully able to connect from primary to secondary node.

My confusion is whether i need  password less ssh to be configured from secondary node to the primary node? or from primary to secondary would be enough to perform the patching?

Thanks a lot. really appreciate your help as always.

Thanks

[ErmanArslansOracleBlog]

As I already said;

You need to configure the application OS user of the "admin node" to be able to connect all the other application nodes without needing to supply a password.
so if you execute adop from app node 1, then configure that node and make it able to connect all the other application nodes without needing to supply a password.

[baig]

Hi,

Thanks it was successfully configured. When i tried to run the prepare phase i faced a warning as shown below.

Verifying existence of context files in database.

[WARNING]    adop has detected a configured disaster recovery site.
[WARNING]    Follow the instructions in the section "Oracle E-Business Suite
[WARNING]    Maintenance with Standby Database" of Business Continuity for
[WARNING]    Oracle E-Business Suite Release 12.2 depending on the database version used.
Do you want to continue with the prepare phase [Y/N] ?N

I have not faced this warning before when applying patches. its the first time i see this warning. I have select the N option as of now.
how to resolve this.
Thanks in advance.

[ErmanArslansOracleBlog]

Do you have a standby database for this EBS prod database?
Probably you have.. Or you have set the some LOG_ARCHIVE_DEST parameter to point to a standby service..

Please check this first.

If you don't have a standby database, then remove that parameter & retry.

If you have a standby database, then please follow the below document whenever you have to run ADOP to apply patches on an environment with a Disaster Recovery system enabled.

Business Continuity for Oracle E-Business Suite Release 12.2 Using Oracle 11g (11gR2) Physical Standby Database (Doc ID 1491855.1)

[baig]

Hi.

I went through the document. and issued the command as mentioned in section 7.1 of the document.

and tried running the prepare phase again. but i still see the same warning messages.

Thanks

[ErmanArslansOracleBlog]

connect to the db  ( sqlplus "/as sysdba")
and send me the output of  "show parameter log_archive_dest"