Thursday, July 28, 2016

Creating database with "oakcli" command in Oracle Database Appliance (ODA)


[oracle@server01 ~]$ sudo su -

[sudo] password for oracle:
[ root@server01 : Thu Jul 28, 09:20 AM : /root ]

$ oakcli create database -db contdb -oh OraDb11204_home1

INFO: 2016-07-28 09:20:31: Please check the logfile  '/opt/oracle/oak/log/server01/tools/12.1.2.7.0
/createdb_contdb_45344.log'  for more details
INFO: 2016-07-28 09:20:32: Database parameter file is not provided. Will be using default parameters for DB creation

Please enter the 'SYSASM'  password : (During deployment we set the SYSASM password to 'welcome1'):
Please re-enter the 'SYSASM' password:
Please select one of the following for Database type  [1 .. 2] :
1    => OLTP
2    => DSS
1
The selected value is : OLTP
Please select one of the following for Database Deployment  [1 .. 3] :
1    => EE : Enterprise Edition
2    => RACONE
3    => RAC
1
The selected value is : EE
Please select one of the following for Node Number  [1 .. 2] :
1    => server01
2    => server02
2

The selected value is : server02
...
Specify the  Database Class (1. odb-01 '1 core, 8 GB memory'   2. Others) [1] : 1
The selected value is : odb-01 '1 core, 8 GB memory'

Do you want to setup the EM DB Console for this database [ Y | N ] ? : N
INFO   : Logging all actions in the file /opt/oracle/oak/log/server01/patch/12.1.2.7.0/server01-20160728093352.log and 
traces in  the file /opt/oracle/oak/log/server01/patch/12.1.2.7.0/server01-20160728093352.trc
INFO   : Loading the configuration file /opt/oracle/oak/onecmd/create_database.params...
INFO   : Creating the node list files...
INFO   : Setting up ssh for root...
INFO   : Setting up SSH across the Private Network...
...INFO   : Running as root: /usr/bin/ssh -l root 192.168.16.24 /root/DoAllcmds.sh
INFO   : Running as root: /usr/bin/ssh -l root 192.168.16.25 /root/DoAllcmds.sh
INFO   : Background process 80671 (node: 192.168.16.24) gets done with the exit code 0
INFO   : Background process 80694 (node: 192.168.16.25) gets done with the exit code 0
INFO   : Setting up SSH completed successfully
INFO   : Running the command /usr/bin/rsync -tarqvz /opt/oracle/oak/onecmd/ root@192.168.16.25:/opt/oracle/oak/onecmd 
--exclude=*zip --exclude=*gz --exclude=*log --exclude=*trc --exclude=*rpm to sync directory 
on node <192.168.16.25>

SUCCESS: Ran /usr/bin/rsync -tarqvz /opt/oracle/oak/onecmd/ root@192.168.16.25:/opt/oracle/oak/onecmd 
--exclude=*zip --exclude=*gz --exclude=*log --exclude=*trc --exclude=*rpm and it returned: RC=0

...INFO   : Did not do scp for node : server01
INFO   : Running as root: /usr/bin/ssh -l root server01 /root/DoAllcmds.sh
INFO   : Running as root: /usr/bin/ssh -l root server02 /root/DoAllcmds.sh
INFO   : Background process 81640 (node: server01) gets done with the exit code 0
INFO   : Background process 81667 (node: server02) gets done with the exit code 0
INFO   : Did not do scp for node : server01
INFO   : Running as root: /usr/bin/ssh -l root server01 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160728093433.sh
INFO   : Running as root: /usr/bin/ssh -l root server02 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160728093433.sh
INFO   : Background process 81713 (node: server01) gets done with the exit code 0
INFO   : Background process 81736 (node: server02) gets done with the exit code 0
INFO   : Setting up SSH for user oracle...
...INFO   : checking nodes in /opt/oracle/oak/onecmd/tmp/db_nodes...
...
SUCCESS: All nodes in /opt/oracle/oak/onecmd/tmp/db_nodes are pingable and alive.
INFO   : Checking SSH setup for user (oracle) on nodes in /opt/oracle/oak/onecmd/tmp/db_nodes...
INFO   : Did not do scp for node : server01
INFO   : This is root, will become oracle and run: /bin/su oracle -c /usr/bin/ssh -l oracle server01 /opt/oracle/oak
/onecmd/tmp/DoAllcmds-20160728093452.sh
INFO   : Running on the local node: /bin/su oracle -c /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160728093452.sh
INFO   : Background process 82624 (node: server01) gets done with the exit code 0
INFO   : This is root, will become oracle and run: /bin/su oracle -c /usr/bin/ssh -l oracle server02 /opt/oracle/oak
/onecmd/tmp/DoAllcmds-20160728093452.sh
INFO   : Background process 82649 (node: server02) gets done with the exit code 0
INFO   : Setting up ACFS storage
INFO   : Did not do scp for node : server01
INFO   : Running as root: /usr/bin/ssh -l root server01 /opt/oracle/oak/onecmd/tmp/acfsm_45344.sh
INFO   : Running as root: /usr/bin/ssh -l root server02 /opt/oracle/oak/onecmd/tmp/acfsm_45344.sh
INFO   : Background process 82768 (node: server01) gets done with the exit code 0
INFO   : Background process 82791 (node: server02) gets done with the exit code 0
INFO: 2016-07-28 09:35:05: Successfully setup the storage structure for the database 'contdb'
SUCCESS: Successfully setup ACFS storage for the database contdb
INFO   : Creating Database using DBCA...
INFO   : Did not do scp for node : server01
INFO   : Running as root: /usr/bin/ssh -l root server01 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160728093505.sh
INFO   : Running as root: /usr/bin/ssh -l root server02 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20160728093505.sh
INFO   : Background process 84414 (node: server01) gets done with the exit code 0
INFO   : Background process 84439 (node: server02) gets done with the exit code 0
INFO   : Running DBCA using /opt/oracle/oak/onecmd/tmp/dbca-contdb.sh on server02 as oracle...
INFO   : Check output in /opt/oracle/oak/onecmd/tmp/dbca-contdb-20160728093352.log on server02
...
INFO   : This is root, will become oracle and run: /bin/su oracle -c /usr/bin/ssh -l oracle server02 /opt/oracle/oak
/onecmd/tmp/dbca-contdb.sh
         Instance contdb is running on node server02
INFO   : One or more Instances running on the cluster nodes.
INFO   : Running export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1;/u01/app/oracle/product/11.2.0.4/
dbhome_1/bin/srvctl setenv database -d contdb -t 'TZ=America/New_York' to set DB timezone
INFO   : Running the command /u01/app/12.1.0.2/grid/bin/crsctl stat resource ora.contdb.db -p
...
INFO   : This is root, will become oracle and run: /bin/su oracle -c /usr/bin/ssh -l oracle server02 /opt/oracle/oak
/onecmd/tmp/dbupdates-contdb.sh
INFO   : Running export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1;/u01/app/oracle/product/11.2.0.4/
dbhome_1/bin/srvctl stop database -d contdb
INFO   : Running export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1;/u01/app/oracle/product/11.2.0.4/
dbhome_1/bin/srvctl start database -d contdb
INFO: 2016-07-28 09:42:41: Successfully set the RMAN SNAPSHOT control file
SUCCESS: 2016-07-28 09:42:45: Successfully created the Database : contdb
[ root@server01 : Thu Jul 28, 09:42 AM : /root ]
$
[ root@server01 : Thu Jul 28, 09:44 AM : /root ]
$