How to drop a rac database safely and update in OCRThis has been tested in 1. R2  running under 1. GquioeU7d4I/UJ6bhDhKGBI/AAAAAAAAAuY/MutMHWx6tRY/s1600/List_add_4.jpg' alt='Create Rac Database Using Dbca 11Gr2 Srvctl' title='Create Rac Database Using Dbca 11Gr2 Srvctl' />Oracle Documentation. While this guide provides detailed instructions for successfully installing a complete Oracle Database 11g Release 2 system using Oracle ASM, it. This has been tested in 11gR2 running under 11. Car Mp5 Player Software. CRS. This can be run for any number of nodes. Executive Summary. Oracle JD Edwards is a suite of products from Oracle that caters to the Enterprise Resource Planning ERP requirements of an organization. If you would like to bypass the Database Configuration Assistant dbca, you can use the following steps with appropriate alterations to create your. On 11gR2 dbca can not manage oracle services after created database we can use the DBMSSERVICE procedures and SRVCTL to createmanage Oracle services. Oracle supports the following methods to convert a singleinstance database to an RAC database as long as the RAC and the standalone environments are running on the. R2-database-windows-installation-option.png' alt='Create Rac Database Using Dbca 11Gr2 Srvctl' title='Create Rac Database Using Dbca 11Gr2 Srvctl' />CRS. This can be run for any number of nodes. Drop database using RMAN1. Set env  . oraenv lt sid 3. Please note we can use drop database alone incase if we want to retain the archivelog and backup of the database o   Drop database deletes Datafiles,logfiles,controlfiles and spfileso   Drop database includeing backups deletes it additionally deletes archivelogs and backup peices generated by rman 2. Update OCR1.          login as oracle in the same server. NB 1.        if oracle has been already removed and remove database is throwing error, please create ORACLEHOMEbin folder and touch a file touch ORACLEHOMEbinoracle and then run the srvctl remove command. OCR due to unknon state in the ocr,login as Grid Home owner  and remove the resource using crsctl delete resource lt resourcename for ex crsctl delete resource ora. Ideally drop database should remove all files from the ASM storage. Please follow the below steps otherwise skip this step. Grid Home owner in the same server and connect to ASM through ASMCMD interface ASMCMD lsdg. State    Type    Rebal  Sector  Block       AU  TotalMB   FreeMB  ReqmirfreeMB  UsablefileMB  Offlinedisks  Votingfiles  Name. MOUNTED  NORMAL  N         5. N  DATA0. 1MOUNTED  NORMAL  N         5. N  FRA0. 1MOUNTED  NORMAL  N         5. Y  SYSTEMDG2.   verify the space has been released. ASMCMD cd DATA0. PROD1SBASMCMD pwdDATA0. PROD1SBASMCMD rm fr DATA0. PROD1SBNB Sometime ASM is not removing all filesdirectories. Files can be removed manually through asmcmd. Sometimes it can happen that the ASM contains empty system directories which cannot be removed. It is due to a bug  Ref How To Remove An Empty ASM System Directory ID 4. Solution          Create a new database with the DBCA having the same name as the old directory and subsequently drop the database with the DBCA. Or          Create a dummy tablespace having a datafile within the directory to be dropped, drop the tablespace and then remove the datafile   using the ASMCMD tool. The old directory will be removed automatically. How to create Oracle Service on 1. R2. On 1. 1g. R2 dbca can not manage oracle services after created database we can use the DBMSSERVICE procedures and SRVCTL to createmanage Oracle services. Anyway Oracle recommends using srvctl to manage services, if we use Oracle Clusterware and Oracle Restart DBMSSERVICE procedures do not update the CRS attributes. Examplecreate service by using srvctl srvctl add service d orcl s service. Not Found . crsstat service. HA Resource Target State Host ora. OFFLINE OFFLINE srvctl start service d orcl s service. HA Resource Target State Host ora. ONLINE ONLINE on rhel. Service service. Examplecreate service by using DBMSSERVICE SQL exec DBMSSERVICE. CREATESERVICEservice. PLSQL procedure successfully completed. HA Resource Target State Host lsnrctl services grep service. Not Found SQL show parameter servicenames. NAME TYPE VALUE servicenames string service. SQL alter system set servicenamesservice. Energizers Training Programs. System altered. SQL show parameter servicenames NAME TYPE VALUE servicenames string service. Service service. HA Resource Target State Host DBMSSERVICE procedures do not update the CRS attributes. So,we dont see Reference begin crsstat begin binbashif le 1 then. GREPKEY1elseecho Please Check arguments. Nissan 240Sx Manual Transmission For Sale there. Wordechoecho Word use to find word in result echo . ORACRSHOME then. ORACRSHOMECRSHOMEif ORACRSHOME thenecho Please Check ORACRSHOME Environment ORACRSHOMEexit 1fifi. AWKusrbinawkif AWK then. AWKbinawkfiAWK BEGIN printf 4. HA Resource, Target, State Host printf 4. ORACRSHOMEbincrsstat AWK BEGIN FS state 0 1NAME 2GREPKEY appname 2 state1 state 0 next 1TARGET state 1 apptarget 2 state2 1STATE state 2 appstate 2 state3 state 3 printf 4.