[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 ] $
Thursday, July 28, 2016
Creating database with "oakcli" command in Oracle Database Appliance (ODA)
Subscribe to:
Posts (Atom)