Login as root to master node.
$ oakcli show dbhomes
[ root@server01 : Tue Aug 01, 10:09 AM : /root ]
$ oakcli create database -db test99sb -oh OraDb11204_home1
INFO: 2017-08-01 10:10:05: Please check the logfile '/opt/oracle/oak/log/server01/tools/12.1.2.11.0/createdb_test99sb_64379.log' for more details
INFO: 2017-08-01 10:10:06: 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 '*******'):
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
...Please select one of the following for Database Class [1 .. 5] :
1 => odb-01s ( 1 cores , 4 GB memory)
2 => odb-01 ( 1 cores , 8 GB memory)
3 => odb-02 ( 2 cores , 16 GB memory)
4 => odb-04 ( 4 cores , 32 GB memory)
5 => odb-06 ( 6 cores , 48 GB memory)
1
The selected value is : odb-01s ( 1 cores , 4 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.11.0/server01-20170801101324.log and traces in the file /opt/oracle/oak/log/server01/patch/12.1.2.11.0/server01-20170801101324.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 : Background process 78589 (node: 192.168.16.24) gets done with the exit code 0
INFO : Running as root: /usr/bin/ssh -l root 190.130.10.18 /root/DoAllcmds.sh
INFO : Background process 78614 (node: 190.130.10.18) 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@190.130.10.18:/opt/oracle/oak/onecmd --exclude=*zip --exclude=*gz --exclude=*log --exclude=*trc --exclude=*rpm to sync directory</opt/oracle/oak/onecmd> on node <190.130.10.18>
SUCCESS: Ran /usr/bin/rsync -tarqvz /opt/oracle/oak/onecmd/ root@190.130.10.18:/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 80186 (node: server01) gets done with the exit code 0
INFO : Background process 80209 (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-20170801101406.sh
INFO : Running as root: /usr/bin/ssh -l root server02 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170801101406.sh
INFO : Background process 80257 (node: server01) gets done with the exit code 0
INFO : Background process 80280 (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-20170801101439.sh
INFO : Running on the local node: /bin/su oracle -c /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170801101439.sh
INFO : Background process 82483 (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-20170801101439.sh
INFO : Background process 82506 (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_64379.sh
INFO : Running as root: /usr/bin/ssh -l root server02 /opt/oracle/oak/onecmd/tmp/acfsm_64379.sh
INFO : Background process 82813 (node: server01) gets done with the exit code 0
INFO : Background process 82837 (node: server02) gets done with the exit code 0
INFO: 2017-08-01 10:15:05: Successfully setup the storage structure for the database 'test99sb'
SUCCESS: Successfully setup ACFS storage for the database test99sb
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-20170801101505.sh
INFO : Running as root: /usr/bin/ssh -l root server02 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170801101505.sh
INFO : Background process 87128 (node: server01) gets done with the exit code 0
INFO : Background process 87152 (node: server02) gets done with the exit code 0
INFO : Running DBCA using /opt/oracle/oak/onecmd/tmp/dbca-test99sb.sh on server02 as oracle...
INFO : Check output in /opt/oracle/oak/onecmd/tmp/dbca-test99sb-20170801101324.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-test99sb.sh
Instance test99sb 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 test99sb -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.test99sb.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-test99sb.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 test99sb
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 test99sb
INFO: 2017-08-01 10:23:09: Successfully set the RMAN SNAPSHOT control file
SUCCESS: 2017-08-01 10:23:14: Successfully created the Database : test99sb
[ root@server01 : Tue Aug 01, 10:23 AM : /root ]
$ oakcli show dbhomes
Oracle Home Name Oracle Home version Home Location
---------------- ------------------- ------------
OraDb11204_home1 11.2.0.4.170418(24732075,23054319) /u01/app/oracle/product/11.2.0.4/dbhome_1
OraDb12102_home1 12.1.0.2.170418(25171037,25942196) /u01/app/oracle/product/12.1.0.2/dbhome_1
[ root@server01 : Tue Aug 01, 10:09 AM : /root ]
$ oakcli create database -db test99sb -oh OraDb11204_home1
INFO: 2017-08-01 10:10:05: Please check the logfile '/opt/oracle/oak/log/server01/tools/12.1.2.11.0/createdb_test99sb_64379.log' for more details
INFO: 2017-08-01 10:10:06: 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 '*******'):
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
...Please select one of the following for Database Class [1 .. 5] :
1 => odb-01s ( 1 cores , 4 GB memory)
2 => odb-01 ( 1 cores , 8 GB memory)
3 => odb-02 ( 2 cores , 16 GB memory)
4 => odb-04 ( 4 cores , 32 GB memory)
5 => odb-06 ( 6 cores , 48 GB memory)
1
The selected value is : odb-01s ( 1 cores , 4 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.11.0/server01-20170801101324.log and traces in the file /opt/oracle/oak/log/server01/patch/12.1.2.11.0/server01-20170801101324.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 : Background process 78589 (node: 192.168.16.24) gets done with the exit code 0
INFO : Running as root: /usr/bin/ssh -l root 190.130.10.18 /root/DoAllcmds.sh
INFO : Background process 78614 (node: 190.130.10.18) 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@190.130.10.18:/opt/oracle/oak/onecmd --exclude=*zip --exclude=*gz --exclude=*log --exclude=*trc --exclude=*rpm to sync directory</opt/oracle/oak/onecmd> on node <190.130.10.18>
SUCCESS: Ran /usr/bin/rsync -tarqvz /opt/oracle/oak/onecmd/ root@190.130.10.18:/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 80186 (node: server01) gets done with the exit code 0
INFO : Background process 80209 (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-20170801101406.sh
INFO : Running as root: /usr/bin/ssh -l root server02 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170801101406.sh
INFO : Background process 80257 (node: server01) gets done with the exit code 0
INFO : Background process 80280 (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-20170801101439.sh
INFO : Running on the local node: /bin/su oracle -c /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170801101439.sh
INFO : Background process 82483 (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-20170801101439.sh
INFO : Background process 82506 (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_64379.sh
INFO : Running as root: /usr/bin/ssh -l root server02 /opt/oracle/oak/onecmd/tmp/acfsm_64379.sh
INFO : Background process 82813 (node: server01) gets done with the exit code 0
INFO : Background process 82837 (node: server02) gets done with the exit code 0
INFO: 2017-08-01 10:15:05: Successfully setup the storage structure for the database 'test99sb'
SUCCESS: Successfully setup ACFS storage for the database test99sb
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-20170801101505.sh
INFO : Running as root: /usr/bin/ssh -l root server02 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170801101505.sh
INFO : Background process 87128 (node: server01) gets done with the exit code 0
INFO : Background process 87152 (node: server02) gets done with the exit code 0
INFO : Running DBCA using /opt/oracle/oak/onecmd/tmp/dbca-test99sb.sh on server02 as oracle...
INFO : Check output in /opt/oracle/oak/onecmd/tmp/dbca-test99sb-20170801101324.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-test99sb.sh
Instance test99sb 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 test99sb -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.test99sb.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-test99sb.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 test99sb
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 test99sb
INFO: 2017-08-01 10:23:09: Successfully set the RMAN SNAPSHOT control file
SUCCESS: 2017-08-01 10:23:14: Successfully created the Database : test99sb
[ root@server01 : Tue Aug 01, 10:23 AM : /root ]
No comments:
Post a Comment