Smazání databáze a db_home
[root@oda1 ~]# oakcli show dbhomes
Oracle Home Name Oracle Home version Home Location
---------------- ------------------- ------------
OraDb11204_home1 11.2.0.4.2(18031668,18031740) /u01/app/oracle/product/11.2.0.4/dbhome_1
OraDb11204_home2 11.2.0.4.2(18031668,18031740) /u01/app/oracle/product/11.2.0.4/dbhome_2
[root@oda1 ~]# oakcli show databases
Database Name Database Type Database HomeName Database HomeLocation Database Version
---------------- ----------- ---------------- --------------------------------------- ---------------------
test RAC OraDb11204_home2 /u01/app/oracle/product/11.2.0.4/dbhome_2 11.2.0.4.2(18031668,18031740)
orcl RAC OraDb11204_home1 /u01/app/oracle/product/11.2.0.4/dbhome_1 11.2.0.4.2(18031668,18031740)
prod RAC OraDb11204_home2 /u01/app/oracle/product/11.2.0.4/dbhome_2 11.2.0.4.2(18031668,18031740)
[root@oda1 ~]# oakcli delete database -db orcl
Please enter the 'root' user password:
Please re-enter the 'root' user password:
Please enter the 'oracle' user password:
Please re-enter the 'oracle' user password:
INFO: 2014-05-26 07:43:45: Setting up ssh
............done
SUCCESS: Ran /usr/bin/rsync -tarqvz /opt/oracle/oak/onecmd/ root@192.168.55.55:/opt/oracle/oak/onecmd --exclude=*zip --exclude=*gz --exclude=*log --exclude=*trc --exclude=*rpm and it returned: RC=0
..........done
..........done
...
SUCCESS: All nodes in /opt/oracle/oak/onecmd/tmp/db_nodes are pingable and alive.
INFO: 2014-05-26 07:44:57: Successfully setup the ssh
INFO: 2014-05-26 07:44:57: Deleting the database ARTESA. It will take few minutes. Please wait...
WARNING: Database orcl is not running. Attempting to start the database
...
...
SUCCESS: 2014-05-26 07:48:05: Successfully deleted the database orcl
SUCCESS: 2014-05-26 07:48:05: Successfully deleted the database orcl
[root@oda1 ~]# oakcli show databases
Database Name Database Type Database HomeName Database HomeLocation Database Version
---------------- ----------- ---------------- --------------------------------------- ---------------------
test RAC OraDb11204_home2 /u01/app/oracle/product/11.2.0.4/dbhome_2 11.2.0.4.2(18031668,18031740)
prod RAC OraDb11204_home2 /u01/app/oracle/product/11.2.0.4/dbhome_2 11.2.0.4.2(18031668,18031740)
[root@oda1 ~]# oakcli delete dbhome -oh OraDb11204_home1
Please enter the 'root' user password:
Please re-enter the 'root' user password:
Please enter the 'oracle' user password:
Please re-enter the 'oracle' user password:
............done
SUCCESS: Ran /usr/bin/rsync -tarqvz /opt/oracle/oak/onecmd/ root@192.168.55.55:/opt/oracle/oak/onecmd --exclude=*zip --exclude=*gz --exclude=*log --exclude=*trc --exclude=*rpm and it returned: RC=0
..........done
..........done
...
SUCCESS: All nodes in /opt/oracle/oak/onecmd/tmp/db_nodes are pingable and alive.
SUCCESS: 2014-05-26 08:02:18: Successfully deinstalled the dbhome OraDb11204_home1
[root@oda1 ~]# oakcli show dbhomes
Oracle Home Name Oracle Home version Home Location
---------------- ------------------- ------------
OraDb11204_home2 11.2.0.4.2(18031668,18031740) /u01/app/oracle/product/11.2.0.4/dbhome_2
Vytvoření databáze a db_home
[root@oda1 ~]# oakcli create dbhome -version 11.2.0.4.2
[root@oda1 ~]# oakcli create database -db test -oh OraDb11204_home2
INFO: 2014-05-08 09:46:08: Database parameter file is not provided. Will be using default parameters for DB creation
Please enter the 'root' user password:
Please re-enter the 'root' user password:
Please enter the 'oracle' user password:
Please re-enter the 'oracle' user password:
Please enter the 'SYSASM' user password: (During deployment we set the SYSASM password to 'welcome1'):
Please re-enter the 'SYSASM' user password:
Please select one of the following for Database Deployment [1 .. 3]:
1 => EE : Enterprise Edition
2 => RACONE
3 => RAC
3
Selected value is: RAC
Please select one of the following for Database Class [1 .. 6]:
1 => Very Very Small
2 => Very Small
3 => Small
4 => Medium
5 => Large
6 => Extra Large
3
Selected value is: Small
Do you want to set up the EM Dbconsole for this database: [ Y | N ]?Y
Please enter the 'ASMSNMP' user password: (During deployment we set the ASMSNMP password to 'welcome1'):
Please re-enter the 'ASMSNMP' user password:
INFO : Logging all actions in /opt/oracle/oak/onecmd/tmp/oda1-20140508094848.log and traces in /opt/oracle/oak/onecmd/tmp/oda1-20140508094848.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.27 /root/DoAllcmds.s
...
Komentáře