Oracle Cloud - Cloning of Oracle EBS R12.2 Application Tier on OCI

Introduction:

How to clone Oracle EBS R12.2 APPS tier on Oracle Cloud.

Resolution:

Please follow the Oracle support document (Doc ID 2912000.1)

Cloning the Oracle E-Business Suite Release 12.2 Application Tier on 

Oracle Cloud Infrastructure Compute (Doc ID 2912000.1)

Lock the OCI Oracle cloud linux OS user

 Introduction:

Some times there is requirement not to delete the OS user but to lock it. Following can be followed to lock the user account on OCI Oracle cloud.

Resolution:

[root@oraclecloudlinuxserver ~]# passwd -l username

Locking password for user username.

passwd: Success

Server refused our key - No supported authentication methods available (server sent: publickey.gssapt-keyex,gssapi-with-mic)

 Introduction:

after setting up the ssh private and public key, error message coming "Server refused our key"

Resolution:

Check the following steps and check if it resolve the issue.

1- login to server and switch to root user

2- go to /home/user_not_connecting_with_ssh e.g. /home/testuser

3- go to .ssh

4- vi the authorized_keys

5- insert the following on the first line and make sure there is space at the end of the following

ssh-rsa 

6- test the issue

Reset EBS Cloud manager password when current password not working

 Steps to rest the EBS Cloud Manager password when current password not working

1. Make sure no jobs are running in EBS Cloud Manager UI.

2. Make sure NodeJS, Quartz server, Chef server and MySQL Database server are down.

$ ps aux | awk '/[s]erver.js/'
$ ps aux | awk '/[j]ob_scheduler.sh/'
$ ps aux | awk '/[m]ysqld/'
$ ps aux | awk '/[o]c_erchef/'

2.1 If they are running, bring them down:

A. for NodeJS: $ sudo pkill -f server.js

B. for Quartz server: $ sudo pkill -f job_scheduler.sh
: $ sudo pkill -f quartz-2.2.3.jar

C. for Chef server: $sudo chef-server-ctl stop

D. MySQL Database server: $ sudo pkill -f mysqld


3. Create file /tmp/resetpassword.ini with 777 permission

$ touch /tmp/resetpassword.ini

$ chmod 777 /tmp/resetpassword.ini


4. Using ViM Add below content to file : /tmp/resetpassword.ini

ALTER USER 'root'@'localhost' IDENTIFIED BY 'Reset@123';
ALTER USER 'ebsoc'@'localhost' IDENTIFIED BY 'Reset@123';
ALTER USER 'quartz'@'localhost' IDENTIFIED BY 'Reset@123';
FLUSH PRIVILEGES;

5. Stat mysql server

$ sudo mysqld --init-file=/tmp/resetpassword.ini --user=mysql &

6. Kill the process

$ sudo pkill -f mysqld

7. Remove file /tmp/resetpassword.ini

$ rm -f /tmp/resetpassword.ini

8. Restart all services and when prompted, enter the new Cloud Manager admin password
$ cd /u01/install/APPS/apps-unlimited-ebs/bin
$ sh ebscloudmgrctl.sh startall

ERROR: Invalid Oracle E-Business Suite Cloud Manager Administration Password - Reset EBS Cloud manager password when current password not working

 Introduction:

-ERROR: Invalid Oracle E-Business Suite Cloud Manager Administration Password -

-Reset EBS Cloud manager password when current password not working

Resolution:

Following command can be used to reset password if the current password is working

./ebscmadmin change-admin-password

But if the current password is not working then follow the following steps to reset the EBC Cloud manager administrator password.

Steps:

1. Make sure no jobs are running in EBS Cloud Manager UI.

2. Make sure NodeJS, Quartz server, Chef server and MySQL Database server are down.

$ ps aux | awk '/[s]erver.js/'
$ ps aux | awk '/[j]ob_scheduler.sh/'
$ ps aux | awk '/[m]ysqld/'
$ ps aux | awk '/[o]c_erchef/'

2.1 If they are running, bring them down:

A. for NodeJS: $ sudo pkill -f server.js

B. for Quartz server: $ sudo pkill -f job_scheduler.sh
: $ sudo pkill -f quartz-2.2.3.jar

C. for Chef server: $sudo chef-server-ctl stop

D. MySQL Database server: $ sudo pkill -f mysqld


3. Create file /tmp/resetpassword.ini with 777 permission

$ touch /tmp/resetpassword.ini

$ chmod 777 /tmp/resetpassword.ini


4. Using ViM Add below content to file : /tmp/resetpassword.ini

ALTER USER 'root'@'localhost' IDENTIFIED BY 'Reset@123';
ALTER USER 'ebsoc'@'localhost' IDENTIFIED BY 'Reset@123';
ALTER USER 'quartz'@'localhost' IDENTIFIED BY 'Reset@123';
FLUSH PRIVILEGES;

5. Stat mysql server

$ sudo mysqld --init-file=/tmp/resetpassword.ini --user=mysql &

6. Kill the process

$ sudo pkill -f mysqld

7. Remove file /tmp/resetpassword.ini

$ rm -f /tmp/resetpassword.ini

8. Restart all services and when prompted, enter the new Cloud Manager admin password
$ cd /u01/install/APPS/apps-unlimited-ebs/bin
$ sh ebscloudmgrctl.sh startall

OCI EBS Cloud Manager - User profile validation failed

 Introduction:

OCI EBS Cloud Manager giving errors of "User profile validation failed".

and it was giving the following messages to resolve the error, but it did not work.

User Profile Validation failed - Make sure following is done

1. Provide the correct "OCI userID"
2. Upload the corresponding public key to OCI console (IAM). If the public key has already been uploaded to OCI, please wait for few minutes before retry the validation.

Resolution:

Checked the user ebs_cloud_manager details with the navigation "Identity & Security > Identity > Domains > Default domain > Users " and found the group "Application Administrator" was missing.

Added the group with the following navigation on OCI Console, and it resolved the errors.

Identity & Security > Identity > Domains > Default domain > Security > Administrators > Application Administrator