This doc describe Oracle RAC Database creation on Oracle Database Appliance (ODA HA X5-2)
On ODA we use oakcli command line to create the database.
I'm using default database parameter file.
1. Execute oakcli create database command as root user and provide oracle home.
2. Enter password for SYSASM (default is welcome1)
3. Enter Database type.
4.Choose Database Deployment type.
5.Choose Flash Storage.
6. Choose Database class to allocate number of cores and memory for particular database.
7. Choose EM DB console.
8.Verify the database.
[root@ABC1x5-2 bin]# oakcli create database -db ORCL -oh OraDb11204_home1
INFO: 2017-03-07 10:38:59: Please check the logfile '/opt/oracle/oak/log/ABC1x5-2/tools/12.1.2.9.0/createdb_ORCL_61414.log' for more details
INFO: 2017-03-07 10:39:01: 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
3
The selected value is : RAC
Do you want to keep the data files on FLASH storage? : : [ Y | N ]?N
Specify the Database Class (1. odb-01 '1 core, 8 GB memory' 2. Others) [1] : 2
Please select one of the following for Database Class [1 .. 9] :
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)
6 => odb-12 ( 12 cores , 96 GB memory)
7 => odb-16 ( 16 cores , 128 GB memory)
8 => odb-20 ( 20 cores , 160 GB memory)
9 => odb-24 ( 24 cores , 192 GB memory)
5
The selected value is : odb-06 ( 6 cores , 48 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/onecmd/tmp/ABC1x5-2-20170307104009.log and traces in the file /opt/oracle/oak/onecmd/tmp/ABC1x5-2-20170307104009.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.27 /root/DoAllcmds.sh
INFO : Running as root: /usr/bin/ssh -l root 192.168.16.28 /root/DoAllcmds.sh
INFO : Background process 69884 (node: 192.168.16.27) gets done with the exit code 0
INFO : Background process 69945 (node: 192.168.16.28) 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.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
...INFO : Running as root: /usr/bin/ssh -l root ABC1x5-2 /root/DoAllcmds.sh
INFO : Background process 71369 (node: ABC1x5-2) gets done with the exit code 0
INFO : Running as root: /usr/bin/ssh -l root ABC2x5-2 /root/DoAllcmds.sh
INFO : Background process 71439 (node: ABC2x5-2) gets done with the exit code 0
INFO : Running as root: /usr/bin/ssh -l root ABC1x5-2 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307104050.sh
INFO : Background process 71577 (node: ABC1x5-2) gets done with the exit code 0
INFO : Running as root: /usr/bin/ssh -l root ABC2x5-2 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307104050.sh
INFO : Background process 71647 (node: ABC2x5-2) 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 : This is root, will become oracle and run: /bin/su oracle -c /usr/bin/ssh -l oracle ABC1x5-2 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307104117.sh
INFO : Running on the local node: /bin/su oracle -c /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307104117.sh
INFO : Background process 73261 (node: ABC1x5-2) 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 ABC2x5-2 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307104117.sh
INFO : Background process 73331 (node: ABC2x5-2) gets done with the exit code 0
INFO : Setting up ACFS storage
INFO : Running as root: /usr/bin/ssh -l root ABC1x5-2 /opt/oracle/oak/onecmd/tmp/acfsm_61414.sh
INFO : Background process 73770 (node: ABC1x5-2) gets done with the exit code 0
INFO : Running as root: /usr/bin/ssh -l root ABC2x5-2 /opt/oracle/oak/onecmd/tmp/acfsm_61414.sh
INFO : Background process 73842 (node: ABC2x5-2) gets done with the exit code 0
INFO: 2017-03-07 10:41:32: Successfully setup the storage structure for the database 'ORCL'
SUCCESS: Successfully setup ACFS storage for the database ORCL
INFO : Creating Database using DBCA...
INFO : Running as root: /usr/bin/ssh -l root ABC1x5-2 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307104132.sh
INFO : Background process 77322 (node: ABC1x5-2) gets done with the exit code 0
INFO : Running as root: /usr/bin/ssh -l root ABC2x5-2 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307104132.sh
INFO : Background process 77383 (node: ABC2x5-2) gets done with the exit code 0
INFO : Running DBCA using /opt/oracle/oak/onecmd/tmp/dbca-TWO.sh on ABC1x5-2 as oracle...
INFO : Check output in /opt/oracle/oak/onecmd/tmp/dbca-ORCL-20170307104009.log on ABC1x5-2
...
INFO : This is root, will become oracle and run: /bin/su oracle -c /usr/bin/ssh -l oracle ABC1x5-2 /opt/oracle/oak/onecmd/tmp/dbca-ORCL.sh
INFO : Running on the local node: /bin/su oracle -c /opt/oracle/oak/onecmd/tmp/dbca-ORCL.sh
Instance ORCL1 is running on node ABC1x5-2
Instance ORCL2 is running on node ABC2x5-2
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 ORCL -t 'TZ=Asia/Manila' to set DB timezone
INFO : Running the command /u01/app/12.1.0.2/grid/bin/crsctl stat resource ora.orcl.db -p
.INFO : Did not do scp for node : ABC1x5-2
..
INFO : This is root, will become oracle and run: /bin/su oracle -c /usr/bin/ssh -l oracle ABC1x5-2 /opt/oracle/oak/onecmd/tmp/dbupdates-ORCL.sh
INFO : Running on the local node: /bin/su oracle -c /opt/oracle/oak/onecmd/tmp/dbupdates-ORCL.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 ORCL
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 ORCL
INFO: 2017-03-07 10:52:48: Successfully set the RMAN SNAPSHOT control file
SUCCESS: 2017-03-07 10:52:49: Successfully created the Database : ORCL
Verify the database.
[root@ABC1x5-2 bin]# oakcli show databases
Name Type Storage HomeName HomeLocation Version
----- ------ -------- -------------- ---------------- ----------
ORCL RAC ACFS OraDb11204_home1 /u01/app/oracle/product/11.2.0.4/dbhome_1 11.2.0.4.161018(24006111,23054319)
On ODA we use oakcli command line to create the database.
I'm using default database parameter file.
1. Execute oakcli create database command as root user and provide oracle home.
2. Enter password for SYSASM (default is welcome1)
3. Enter Database type.
4.Choose Database Deployment type.
5.Choose Flash Storage.
6. Choose Database class to allocate number of cores and memory for particular database.
7. Choose EM DB console.
8.Verify the database.
[root@ABC1x5-2 bin]# oakcli create database -db ORCL -oh OraDb11204_home1
INFO: 2017-03-07 10:38:59: Please check the logfile '/opt/oracle/oak/log/ABC1x5-2/tools/12.1.2.9.0/createdb_ORCL_61414.log' for more details
INFO: 2017-03-07 10:39:01: 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
3
The selected value is : RAC
Do you want to keep the data files on FLASH storage? : : [ Y | N ]?N
Specify the Database Class (1. odb-01 '1 core, 8 GB memory' 2. Others) [1] : 2
Please select one of the following for Database Class [1 .. 9] :
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)
6 => odb-12 ( 12 cores , 96 GB memory)
7 => odb-16 ( 16 cores , 128 GB memory)
8 => odb-20 ( 20 cores , 160 GB memory)
9 => odb-24 ( 24 cores , 192 GB memory)
5
The selected value is : odb-06 ( 6 cores , 48 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/onecmd/tmp/ABC1x5-2-20170307104009.log and traces in the file /opt/oracle/oak/onecmd/tmp/ABC1x5-2-20170307104009.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.27 /root/DoAllcmds.sh
INFO : Running as root: /usr/bin/ssh -l root 192.168.16.28 /root/DoAllcmds.sh
INFO : Background process 69884 (node: 192.168.16.27) gets done with the exit code 0
INFO : Background process 69945 (node: 192.168.16.28) 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.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
...INFO : Running as root: /usr/bin/ssh -l root ABC1x5-2 /root/DoAllcmds.sh
INFO : Background process 71369 (node: ABC1x5-2) gets done with the exit code 0
INFO : Running as root: /usr/bin/ssh -l root ABC2x5-2 /root/DoAllcmds.sh
INFO : Background process 71439 (node: ABC2x5-2) gets done with the exit code 0
INFO : Running as root: /usr/bin/ssh -l root ABC1x5-2 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307104050.sh
INFO : Background process 71577 (node: ABC1x5-2) gets done with the exit code 0
INFO : Running as root: /usr/bin/ssh -l root ABC2x5-2 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307104050.sh
INFO : Background process 71647 (node: ABC2x5-2) 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 : This is root, will become oracle and run: /bin/su oracle -c /usr/bin/ssh -l oracle ABC1x5-2 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307104117.sh
INFO : Running on the local node: /bin/su oracle -c /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307104117.sh
INFO : Background process 73261 (node: ABC1x5-2) 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 ABC2x5-2 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307104117.sh
INFO : Background process 73331 (node: ABC2x5-2) gets done with the exit code 0
INFO : Setting up ACFS storage
INFO : Running as root: /usr/bin/ssh -l root ABC1x5-2 /opt/oracle/oak/onecmd/tmp/acfsm_61414.sh
INFO : Background process 73770 (node: ABC1x5-2) gets done with the exit code 0
INFO : Running as root: /usr/bin/ssh -l root ABC2x5-2 /opt/oracle/oak/onecmd/tmp/acfsm_61414.sh
INFO : Background process 73842 (node: ABC2x5-2) gets done with the exit code 0
INFO: 2017-03-07 10:41:32: Successfully setup the storage structure for the database 'ORCL'
SUCCESS: Successfully setup ACFS storage for the database ORCL
INFO : Creating Database using DBCA...
INFO : Running as root: /usr/bin/ssh -l root ABC1x5-2 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307104132.sh
INFO : Background process 77322 (node: ABC1x5-2) gets done with the exit code 0
INFO : Running as root: /usr/bin/ssh -l root ABC2x5-2 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307104132.sh
INFO : Background process 77383 (node: ABC2x5-2) gets done with the exit code 0
INFO : Running DBCA using /opt/oracle/oak/onecmd/tmp/dbca-TWO.sh on ABC1x5-2 as oracle...
INFO : Check output in /opt/oracle/oak/onecmd/tmp/dbca-ORCL-20170307104009.log on ABC1x5-2
...
INFO : This is root, will become oracle and run: /bin/su oracle -c /usr/bin/ssh -l oracle ABC1x5-2 /opt/oracle/oak/onecmd/tmp/dbca-ORCL.sh
INFO : Running on the local node: /bin/su oracle -c /opt/oracle/oak/onecmd/tmp/dbca-ORCL.sh
Instance ORCL1 is running on node ABC1x5-2
Instance ORCL2 is running on node ABC2x5-2
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 ORCL -t 'TZ=Asia/Manila' to set DB timezone
INFO : Running the command /u01/app/12.1.0.2/grid/bin/crsctl stat resource ora.orcl.db -p
.INFO : Did not do scp for node : ABC1x5-2
..
INFO : This is root, will become oracle and run: /bin/su oracle -c /usr/bin/ssh -l oracle ABC1x5-2 /opt/oracle/oak/onecmd/tmp/dbupdates-ORCL.sh
INFO : Running on the local node: /bin/su oracle -c /opt/oracle/oak/onecmd/tmp/dbupdates-ORCL.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 ORCL
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 ORCL
INFO: 2017-03-07 10:52:48: Successfully set the RMAN SNAPSHOT control file
SUCCESS: 2017-03-07 10:52:49: Successfully created the Database : ORCL
Verify the database.
[root@ABC1x5-2 bin]# oakcli show databases
Name Type Storage HomeName HomeLocation Version
----- ------ -------- -------------- ---------------- ----------
ORCL RAC ACFS OraDb11204_home1 /u01/app/oracle/product/11.2.0.4/dbhome_1 11.2.0.4.161018(24006111,23054319)
Cheers.
No comments:
Post a Comment