With Oracle Real Application Clusters the Oracle database can be configured to restart as each node in the cluster is restarted. For single instance databases that are on a standalone server, often times the database is not configured to restart on a server bounce. In the past, Oracle recommended to set the database for restart in the /etc/oratab file and create as script in the /etc/init.d directory to force the restart. This approach often times did not work (in my experience). How do we enable a restart of a single instance database successfully?
Oracle Restart! Oracle Restart is a component of the Oracle Grid Infrastructure (GI) package which is used to configure a restart of items on the server, ie Oracle Database (single instance). The added benefit of using Oracle Restart (Grid Infrastructure) is the usage of Automatic Storage Management (ASM) is included. Databases that are created after Oracle Restart is installed will use ASM; all previous databases (file system based) will not be configured in the Cluster Ready Service (CRS) stack. How do we add a database to the CRS stack after Oracle Restart is installed?
To add a database to the CRS stack, we need to use the Server Control (SRVCTL) command. The below command will add a database named “bc11gtst” to the stack and enable it to be restarted when the server is restarted. Each of the options used can be looked up with the help option ($GRID_HOME/bin/srvctl –h).
srvctl add database
-d bc11gtst
-o /opt/oracle/11.2.0.3/dbhome_1
-m acme.com
-p /opt/oracle/11.2.0.3/dbhome_1/dbs/spfilebc11gtst.ora
-s OPEN
-t IMMEDIATE
-y AUTOMATIC
After configuring the database in the CRS, if the need to remove it from the CRS arises; the following command can be used.
srvctl remove database
-d bc11gtst
-f
As with the CRS ona full RAC, we can get the list of targets and check on the status of them using the same command (crs_stat –t –v).
[oracle@tester Desktop]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
———————————————————————-
ora.DATA.dg ora….up.type 0/5 0/ ONLINE ONLINE tester
ora….ER.lsnr ora….er.type 0/5 0/ ONLINE ONLINE tester
ora.asm ora.asm.type 0/5 0/ ONLINE ONLINE tester
ora….gtst.db ora….se.type 0/2 0/1 ONLINE ONLINE tester
ora.cssd ora.cssd.type 0/5 0/5 ONLINE ONLINE tester
ora.diskmon ora….on.type 0/10 0/5 OFFLINE OFFLINE
ora.evmd ora.evm.type 0/10 0/5 ONLINE ONLINE tester
ora.ons ora.ons.type 0/3 0/ OFFLINE OFFLINE
In closing, using Oracle Restart is a great approach to enabling single instance databases for successful restarts. Also, the ability to use Automatic Storage Management (ASM) and Cluster Ready Services (CRS) enables a DBA to learn more about these options before moving to a full Real Application Cluster (RAC). More information can be found here.
Enjoy!
twitter: @dbasolved
Blog: http://dbasolved.com
Please follow and like:
Current Oracle Certs
Bobby Curtis
I’m Bobby Curtis and I’m just your normal average guy who has been working in the technology field for awhile (started when I was 18 with the US Army). The goal of this blog has changed a bit over the years. Initially, it was a general blog where I wrote thoughts down. Then it changed to focus on the Oracle Database, Oracle Enterprise Manager, and eventually Oracle GoldenGate.
If you want to follow me on a more timely manner, I can be followed on twitter at @dbasolved or on LinkedIn under “Bobby Curtis MBA”.
Follow if you like:
Muchas gracias. ?Como puedo iniciar sesion?
Metastatic means the cancer has spread to other parts of the body cheapest priligy uk
Schedule an Appointment with a Tampa Dermatologist order priligy online usa The antithrombotic effect of warfarin requires reduction of prothrombin factor II, which has a relatively long half life of 60 to 72 hours, compared with 6 to 24 hours for other K dependent factors responsible for the more rapid anticoagulant effect
NABCG contributed one third of all patient enrollments in the TEXT and SOFT trials, whereas two thirds enrolled from cooperative oncology groups affiliated with the Breast International Group BIG network how can i get cheap cytotec price
buying cheap cytotec pill The All Pro pass rusher acknowledged his case is under appeal and promised he would provide some candid answers once the appeal is resolved
Featuring professional pieces, job assessments, and tailored guidance, Career Guide can aid you discover your strengths and locate the best job match. It’s like possessing a career coach at your command!