ODA (Oracle Database Appliance): create dbhome failed

Asset ID:	1-72-1940827.1
Update Date:	2014-12-02
Keywords:

Solution Type Problem Resolution Sure

Solution 1940827.1 : ODA (Oracle Database Appliance): create dbhome failed

Applies to:

Oracle Database Appliance Software - Version 12.1.2 and later
Oracle Database Appliance - Version All Versions and later
Information in this document applies to any platform.

Symptoms

You are creating a new dbhome and you are getting the following error

Case 1

# oakcli create dbhome -version 11.2.0.4.3
INFO: 2014-10-31 02:08:35: Look at the logfile '/opt/oracle/oak/log/oda101/tools/12.1.2.0.0/createdbhome_43233.log' for more details

Please enter the 'root' password :
Please re-enter the 'root' password:

Please enter the 'oracle' password :
Please re-enter the 'oracle' password:

Please enter the 'SYSASM' password : (During deployment we set the SYSASM password to 'welcome1'):
Please re-enter the 'SYSASM' password:
INFO: 2014-10-31 02:08:54: Installing a new home: OraDb11204_home1 at /u01/app/oracle/product/11.2.0.4/dbhome_1
INFO   : Logging all actions in /opt/oracle/oak/log/oda101/patch/12.1.2.0.0/oda101-20141031020900.log and traces in /opt/oracle/oak/log/oda101/patch/12.1.2.0.0/oda101-20141031020900.trc
INFO   : Loading configuration file /opt/oracle/oak/onecmd/create_database.params...
INFO   : Creating nodelist files...
INFO   : Setting up ssh for root...
INFO   : Setting up ssh across the private network...
............done
INFO   : Running as root: /usr/bin/ssh -l root 192.168.16.27 /root/DoAllcmds.sh
INFO   : INFO   : Running as root: /usr/bin/ssh -l root 192.168.16.28 /root/DoAllcmds.sh
Background process 48146 (node: 192.168.16.27) gets done with the exit code 0
INFO   : Background process 48174 (node: 192.168.16.28) gets done with the exit code 0
INFO   : Done setting up ssh
INFO   : Running /usr/bin/rsync -tarqvz /opt/oracle/oak/onecmd/ root@192.168.16.28:/opt/oracle/oak/onecmd --exclude=*zip --exclude=*gz --exclude=*log --exclude=*trc --exclude=*rpm to sync directory</opt/oracle/oak/onecmd> on node <192.168.16.28>
SUCCESS: Ran /usr/bin/rsync -tarqvz /opt/oracle/oak/onecmd/ root@192.168.16.28:/opt/oracle/oak/onecmd --exclude=*zip --exclude=*gz --exclude=*log --exclude=*trc --exclude=*rpm and it returned: RC=0

..........done
INFO   : did not do scp for node: oda101
INFO   : Running as root: /usr/bin/ssh -l root oda101 /root/DoAllcmds.sh
INFO   : Background process 50139 (node: oda101) gets done with the exit code 0
INFO   : Running as root: /usr/bin/ssh -l root oda102 /root/DoAllcmds.sh
INFO   : Background process 50193 (node: oda102) gets done with the exit code 0
INFO   : did not do scp for node: oda101
INFO   : Running as root: /usr/bin/ssh -l root oda101 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20141031020945.sh
INFO   : Running as root: /usr/bin/ssh -l root oda102 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20141031020945.sh
INFO   : Background process 50268 (node: oda101) gets done with the exit code 0
INFO   : Background process 50312 (node: oda102) gets done with the exit code 0
INFO   : setting up ssh for user oracle...
....
Output to help diagnose the issue:
Warning: Permanently added 'oda101,10.214.120.17' (RSA) to the list of known hosts.
oracle@oda101's password:
Permission denied, please try again.

ERROR: DoCmd2 failed on oda101 (see output above), exit code: 25344 at /opt/oracle/oak/onecmd/GridSteps.pm line 6569
ERROR : failed to set up ssh for usr oracle
Exiting...

Case 2

[root@ldoda01 ~]# oakcli create dbhome -version 12.1.0.2.0
INFO: 2014-11-05 19:06:18: Look at the logfile '/opt/oracle/oak/log/ldoda01/tools/12.1.2.0.0/createdbhome_38632.log' for more details

Please enter the 'root' password :
Please re-enter the 'root' password:

Please enter the 'oracle' password :
Please re-enter the 'oracle' password:

Please enter the 'SYSASM' password : (During deployment we set the SYSASM password to 'welcome1'):
Please re-enter the 'SYSASM' password:
INFO: 2014-11-05 19:07:22: Installing a new home: OraDb12102_home1 at /u01/app/oracle/product/12.1.0.2/dbhome_1
INFO : Logging all actions in /opt/oracle/oak/log/ldoda01/patch/12.1.2.0.0/ldoda01-20141105190731.log and traces in /opt/oracle/oak/log/ldoda01/patch/12.1.2.0.0/ldoda01-20141105190731.trc
INFO : Loading configuration file /opt/oracle/oak/onecmd/create_database.params...
INFO : Creating nodelist files...
INFO : Setting up ssh for root...
INFO : Setting up ssh across the private network...
.....ERROR: cannot open file /tmp/setssh-root/tmpfile at /opt/oracle/oak/onecmd/GridSteps.pm line 6078

Cause

Case 1 - You did not provide the right or empty (also if you are using 'welcome1') sysasm password :

(...)
Please enter the 'SYSASM' password : (During deployment we set the SYSASM password to 'welcome1'): <<<--- just press enter
Please re-enter the 'SYSASM' password: <<<--- just press enter
(...)

Case 2 - Changed the root password from the default 'welcome1'

Solution

Case 1 - Retry the dbcreation providing the right sysasm password

Case 2 - You are hitting the Bug 19591549

This is happening only when we try to create only database home. If we create a database then we are able to create a new home and create database from that.
Therefore as a work around you can use the following method:

oakcli create database -db mydb

-> creates a new home and then creates the database for that home

References

<BUG:19591549> - LNX64-121-CMT: CHANGE ROOT PASSWORD, 'CREATE DBHOME' HIT ERROR DURING SETUP SSH

Attachments

This solution has no attachment