This method can be used to create a 2 node-RAC DB on an ODA . The two nodes are oda1 and oda2. This method assumes an existing DB template template_abcdev for values like
characterset/nls_lang, region etc. Requires root connection.
Using username "oracle".
Last login: Fri Nov 13 10:54:21 2015 from localhost.net
Active Database List on host oda1
+ASM1
-MGMTDB
+APX1
ABCDEV12
ABCDEV121
USE : sdb ORACLE_SID
ORACLE_SID = [ABCDEV121] ?
oracle@oda1 ABCDEV121:/home/oracle>sudo -i
[sudo] password for oracle:
root@oda1 /root #clear
root@oda1 /root #ps -ef | grep pmon | grep -v grep
oracle 3125 1 0 05:05 ? 00:00:01 ora_pmon_ABCDEV121
grid 24359 1 0 Aug21 ? 00:05:35 mdb_pmon_-MGMTDB
grid 27269 1 0 Aug21 ? 00:08:30 asm_pmon_+ASM1
grid 28061 1 0 Aug21 ? 00:06:21 apx_pmon_+APX1
root@oda1 /root #oakcli show dbhomes
Oracle Home Name Oracle Home version Home Location
---------------- ------------------- ------------
OraDb11204_home1 11.2.0.4.6(20299013) /u01/app/oracle/product/11.2.0.4/dbhome_1
OraDb12102_home1 12.1.0.2.3(20299023,20299022) /u01/app/oracle/product/12.1.0.2/dbhome_1
root@oda1 /root #oakcli show db_config_params -conf template_abcdev -detail
DATABASE_BLOCK_SIZE => 8192
DATABASE_LANGUAGE => AMERICAN
DATABASE_CHARACTERSET => WE8MSWIN1252
DATABASE_TERRITORY => AMERICA
COMPONENT_LANGUAGES => en
root@oda1 /root #oakcli create database -db XYZDEV12 -oh OraDb12102_home1 -params template_abcdev
INFO: 2015-11-13 11:17:48: Look at the logfile '/opt/oracle/oak/log/oda1/tools/12.1.2.3.0/createdb_XYZDEV12_55525.log' for more details
INFO: 2015-11-13 11:17:48: Only alphanumeric characters are allowed in the database name, and the database name must start with an alphabetical character
INFO: 2015-11-13 11:17:48: Database name should not be more than 8 chars
Please enter a name for the Database:XYZDEV12
Please enter the 'root' password :
Please re-enter the 'root' password:
Please enter the 'oracle' password :
Please re-enter the 'oracle' password:
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 .. 3]:
1 => OLTP
2 => DSS
3 => In-Memory
1
Selected value is : OLTP
Please select one of the following for Database Deployment [1 .. 3]:
1 => EE : Enterprise Edition
2 => RACONE
3 => RAC
3
Selected value is : RAC
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 .. 8] :
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-24 ( 24 cores , 192 GB memory)
2
Selected value is: odb-01 ( 1 cores , 8 GB memory)
INFO : Logging all actions in /opt/oracle/oak/log/oda1/patch/12.1.2.3.0/oda1-20151113113021.log and traces in /opt/oracle/oak/log/oda1/patch/12.1.2.3.0/oda1-20151113113021.trc
INFO : Loading configuration file /opt/oracle/oak/onecmd/create_database.params...
INFO : Creating nodelist files...
INFO : Setting up ssh for root...
INFO : Setting up ssh across the private network...
............done
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 4911 (node: 192.168.16.24) gets done with the exit code 0
INFO : Background process 4957 (node: 192.168.16.25) gets done with the exit code 0
INFO : Done setting up ssh
INFO : Running /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
..........done
INFO : did not do scp for node: oda1
INFO : Running as root: /usr/bin/ssh -l root oda1 /root/DoAllcmds.sh
INFO : Running as root: /usr/bin/ssh -l root oda2 /root/DoAllcmds.sh
INFO : Background process 6394 (node: oda1) gets done with the exit code 0
INFO : Background process 6440 (node: oda2) gets done with the exit code 0
INFO : did not do scp for node: oda1
INFO : Running as root: /usr/bin/ssh -l root oda1 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20151113113107.sh
INFO : Running as root: /usr/bin/ssh -l root oda2 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20151113113107.sh
INFO : Background process 6515 (node: oda1) gets done with the exit code 0
INFO : Background process 6561 (node: oda2) gets done with the exit code 0
INFO : setting up ssh for user oracle...
..........done
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: oda1
INFO : This is root, will become oracle and run: /bin/su oracle -c /usr/bin/ssh -l oracle oda1 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20151113113127.sh
INFO : Running on the local node: /bin/su oracle -c /opt/oracle/oak/onecmd/tmp/DoAllcmds-20151113113127.sh
INFO : Background process 7887 (node: oda1) 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 oda2 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20151113113127.sh
INFO : Background process 7933 (node: oda2) gets done with the exit code 0
INFO : Setting up ACFS storage
INFO : did not do scp for node: oda1
INFO : Running as root: /usr/bin/ssh -l root oda1 /opt/oracle/oak/onecmd/tmp/acfsm_55525.sh
INFO : Running as root: /usr/bin/ssh -l root oda2 /opt/oracle/oak/onecmd/tmp/acfsm_55525.sh
INFO : Background process 8051 (node: oda1) gets done with the exit code 0
INFO : Background process 8097 (node: oda2) gets done with the exit code 0
INFO: 2015-11-13 11:31:39: Successfully setup the storage structure for the database 'XYZDEV12'
SUCCESS: Successfully setup ACFS storage for the database XYZDEV12
INFO : Creating database using dbca...
INFO : did not do scp for node: oda1
INFO : Running as root: /usr/bin/ssh -l root oda1 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20151113113139.sh
INFO : Running as root: /usr/bin/ssh -l root oda2 /opt/oracle/oak/onecmd/tmp/DoAllcmds-20151113113139.sh
INFO : Background process 9308 (node: oda1) gets done with the exit code 0
INFO : Background process 9363 (node: oda2) gets done with the exit code 0
INFO : Running dbca using /opt/oracle/oak/onecmd/tmp/dbca-XYZDEV12.sh on oda1 as oracle...
INFO : Check output in /opt/oracle/oak/onecmd/tmp/dbca-XYZDEV12-20151113113021.log on oda1
INFO : This is root, will become oracle and run: /bin/su oracle -c /usr/bin/ssh -l oracle oda1 /opt/oracle/oak/onecmd/tmp/dbca-XYZDEV12.sh
INFO : Running on the local node: /bin/su oracle -c /opt/oracle/oak/onecmd/tmp/dbca-XYZDEV12.sh
Instance XYZDEV121 is running on node oda1
Instance XYZDEV122 is running on node oda2
INFO : One or more instances running on the cluster nodes.
INFO : Running export ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/dbhome_1;/u01/app/oracle/product/12.1.0.2/dbhome_1/bin/srvctl setenv database -d XYZDEV12 -t 'TZ=America/Los_Angeles' to set DB timezone
INFO : Running the command /u01/app/12.1.0.2/grid/bin/crsctl stat resource ora.XYZDEV12.db -p
.INFO : did not do scp for node: oda1
..
INFO : This is root, will become oracle and run: /bin/su oracle -c /usr/bin/ssh -l oracle oda1 /opt/oracle/oak/onecmd/tmp/dbupdates-XYZDEV12.sh
INFO : Running on the local node: /bin/su oracle -c /opt/oracle/oak/onecmd/tmp/dbupdates-XYZDEV12.sh
INFO : Running export ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/dbhome_1;/u01/app/oracle/product/12.1.0.2/dbhome_1/bin/srvctl stop database -d XYZDEV12
INFO : Running export ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/dbhome_1;/u01/app/oracle/product/12.1.0.2/dbhome_1/bin/srvctl start database -d XYZDEV12
INFO: 2015-11-13 11:47:21: Successfully set the rman snapshot controlfile
SUCCESS: 2015-11-13 11:47:23: Successfully created the database XYZDEV12
INFO : Resecuring environment... oda1 oda2
INFO : Remvoing the SSH setup for root...
INFO : Running as root: /usr/bin/ssh -l root oda1 chmod 751 /opt/oracle/oak/onecmd/tmp
INFO : Running as root: /usr/bin/ssh -l root oda2 chmod 751 /opt/oracle/oak/onecmd/tmp
INFO : Running as root: /usr/bin/ssh -l root oda2 /bin/rm -rf /root/.ssh
INFO : Running as root: /usr/bin/ssh -l root oda1 /bin/rm -rf /root/.ssh
root@oda1 /root #
root@oda1 /root #ps -ef | grep pmon | grep -v grep
grid 24359 1 0 Aug21 ? 00:06:57 mdb_pmon_-MGMTDB
grid 27269 1 0 Aug21 ? 00:10:35 asm_pmon_+ASM1
grid 28061 1 0 Aug21 ? 00:07:55 apx_pmon_+APX1
oracle 36297 1 0 Sep22 ? 00:07:08 ora_pmon_ABCDEV121
oracle 37701 1 0 Nov16 ? 00:01:36 ora_pmon_XYZDEV121
root@oda1 /root #su oracle
oracle@oda1 /root #cd
oracle@oda1 /home/oracle # sdb XYZDEV121
oracle@oda1 XYZDEV121:/home/oracle>sd
SQL*Plus: Release 12.1.0.2.0 Production on Thu Dec 3 13:26:17 2015
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Advanced Analytics
and Real Application Testing options
SQL> @cc
INSTANCE_NAME HOST_NAME STATUS LOGINS
---------------- ---------------------------------------- ------------ ----------
XYZDEV121 oda1 OPEN ALLOWED
XYZDEV122 oda2 OPEN ALLOWED
2 rows selected.
MACHINE USERNAME COUNT(1)
---------------------------------------- ------------------------- ----------
oda1.localhost.net DBSNMP 3
oda1 SYS 5
oda2.localhost.net DBSNMP 2
oda2 SYS 1
5 rows selected.
SQL>
No comments:
Post a Comment