This doc describe Oracle Single Instance 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.Enter 1 Enterprise Edition to create Single Instance Database.
5. Select the Node to host the Single Instance database.
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]# oakcli create database -db LONDON -oh OraDb11204_home1
INFO: 2017-03-07 10:55:44: Please check the logfile '/opt/oracle/oak/log/ABC1x5-2/tools/12.1.2.9.0/createdb_LONDON_25792.log' for more details
INFO: 2017-03-07 10:55:45: 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 => ABC1x5-2
2 => ABC2x5-2
1
The selected value is : ABC1x5-2
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 .. 7] :
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)
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-20170307105648.log and traces in the file /opt/oracle/oak/onecmd/tmp/ABC1x5-2-
20170307105648.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 32756 (node: 192.168.16.27) gets done with the exit code 0
INFO : Background process 32817 (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 34017 (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 34087 (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-20170307105730.sh
INFO : Background process 34234 (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-20170307105730.sh
INFO : Background process 34311 (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-20170307105756.sh
INFO : Running on the local node: /bin/su oracle -c /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307105756.sh
INFO : Background process 36647 (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-20170307105756.sh
INFO : Background process 36708 (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_25792.sh
INFO : Background process 37061 (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_25792.sh
INFO : Background process 37122 (node: ABC2x5-2) gets done with the exit code 0
INFO: 2017-03-07 10:58:10: Successfully setup the storage structure for the database 'LONDON'
SUCCESS: Successfully setup ACFS storage for the database LONDON
INFO : Creating Database using DBCA...
INFO : Running as root: /usr/bin/ssh -l root ABC1x5-2 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307105810.sh
INFO : Background process 40834 (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-20170307105810.sh
INFO : Background process 40895 (node: ABC2x5-2) gets done with the exit code 0
INFO : Running DBCA using /opt/oracle/oak/onecmd/tmp/dbca-LONDON.sh on ABC1x5-2 as oracle...
INFO : Check output in /opt/oracle/oak/onecmd/tmp/dbca-LONDON-20170307105648.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-LONDON.sh
INFO : Running on the local node: /bin/su oracle -c /opt/oracle/oak/onecmd/tmp/dbca-LONDON.sh
Instance LONDON is running on node ABC1x5-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 LONDON -t
'TZ=Asia/Manila' to set DB timezone
INFO : Running the command /u01/app/12.1.0.2/grid/bin/crsctl stat resource ora.LONDON.db -p
...
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-LONDON.sh
INFO : Running on the local node: /bin/su oracle -c /opt/oracle/oak/onecmd/tmp/dbupdates-LONDON.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 LONDON
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 LONDON
INFO: 2017-03-07 11:05:53: Successfully set the RMAN SNAPSHOT control file
SUCCESS: 2017-03-07 11:05:54: Successfully created the Database : LONDON
Verify the database.
[root@ABC1x5-2]# 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)
LONDON SINGLE ACFS OraDb11204_home1 /u01/app/oracle/product/11.2.0.4/dbhome_1 11.2.0.4.161018(24006111,23054319)
Cheers.
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.Enter 1 Enterprise Edition to create Single Instance Database.
5. Select the Node to host the Single Instance database.
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]# oakcli create database -db LONDON -oh OraDb11204_home1
INFO: 2017-03-07 10:55:44: Please check the logfile '/opt/oracle/oak/log/ABC1x5-2/tools/12.1.2.9.0/createdb_LONDON_25792.log' for more details
INFO: 2017-03-07 10:55:45: 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 => ABC1x5-2
2 => ABC2x5-2
1
The selected value is : ABC1x5-2
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 .. 7] :
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)
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-20170307105648.log and traces in the file /opt/oracle/oak/onecmd/tmp/ABC1x5-2-
20170307105648.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 32756 (node: 192.168.16.27) gets done with the exit code 0
INFO : Background process 32817 (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 34017 (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 34087 (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-20170307105730.sh
INFO : Background process 34234 (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-20170307105730.sh
INFO : Background process 34311 (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-20170307105756.sh
INFO : Running on the local node: /bin/su oracle -c /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307105756.sh
INFO : Background process 36647 (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-20170307105756.sh
INFO : Background process 36708 (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_25792.sh
INFO : Background process 37061 (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_25792.sh
INFO : Background process 37122 (node: ABC2x5-2) gets done with the exit code 0
INFO: 2017-03-07 10:58:10: Successfully setup the storage structure for the database 'LONDON'
SUCCESS: Successfully setup ACFS storage for the database LONDON
INFO : Creating Database using DBCA...
INFO : Running as root: /usr/bin/ssh -l root ABC1x5-2 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20170307105810.sh
INFO : Background process 40834 (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-20170307105810.sh
INFO : Background process 40895 (node: ABC2x5-2) gets done with the exit code 0
INFO : Running DBCA using /opt/oracle/oak/onecmd/tmp/dbca-LONDON.sh on ABC1x5-2 as oracle...
INFO : Check output in /opt/oracle/oak/onecmd/tmp/dbca-LONDON-20170307105648.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-LONDON.sh
INFO : Running on the local node: /bin/su oracle -c /opt/oracle/oak/onecmd/tmp/dbca-LONDON.sh
Instance LONDON is running on node ABC1x5-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 LONDON -t
'TZ=Asia/Manila' to set DB timezone
INFO : Running the command /u01/app/12.1.0.2/grid/bin/crsctl stat resource ora.LONDON.db -p
...
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-LONDON.sh
INFO : Running on the local node: /bin/su oracle -c /opt/oracle/oak/onecmd/tmp/dbupdates-LONDON.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 LONDON
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 LONDON
INFO: 2017-03-07 11:05:53: Successfully set the RMAN SNAPSHOT control file
SUCCESS: 2017-03-07 11:05:54: Successfully created the Database : LONDON
Verify the database.
[root@ABC1x5-2]# 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)
LONDON SINGLE 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