I want to restart a 10g database on ASM ? startp and shutdown sequence?I would like to shutdown everything including database, ASM and cluster and startup again
I read at various places but not sure of the sequence For database DB with database instance DB01 and DB02 having ASM instances ASM01 and ASM02 on node1 and node2, I understand following would be the sequence
1)
Login as root on node1
cd $CRS_HOME/bin
./crsctl start crs
2)
Login as root on node2
cd $CRS_HOME/bin
./crsctl start crs
3)
login as oracle on node1
$ORACLE_HOME/bin/srvctl start nodeapps -n node1
4)
login as oracle on node2
$ORACLE_HOME/bin/srvctl start nodeapps -n node2
5)
login as oracle on node1
start ASM instance on node1
$ORACLE_HOME/bin/srvctl start asm01 -n node1
6)
login as oracle on node2
start ASM instance on node2
$ORACLE_HOME/bin/srvctl start asm02 -n node2
7)
Start oracle database (from any node)
$ORACLE_HOME/bin/srvctl start database -d DB
A. confirm if the above sequence is correct?
B. This sequence if corrrect, is same for 10g and 11g?
C. Is shutdown sequence exact reverse of the above?
We are having a problem trying to automate our 11g database startup on a Linux Platform (Redhat). This is the procedure we followed.
1. Logged in as the root user.
2. Edited the oratab file for the platform.
vi /etc/oratab db:/u01/app/oracle/product/11.2.0/dbhome_1:Y
3. Create a file called dbora in /etc/init.d directory
4. Entered the following in dbora:
#! /bin/sh -x # # Change the value of ORACLE_HOME to specify the correct Oracle home # directory for your installation. ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
[Code] .....
4. Changed permissions of dbora
chgrp dba dbora chmod 750 dbora
5. Created symbolic links to the dbora script in the appropriate run-level script directories:
Tue Apr 27 14:22:26 2010 ARC0: Becoming the 'no FAL' ARCH ARC0: Becoming the 'no SRL' ARCH Tue Apr 27 14:22:26 2010 ARC1: Becoming the heartbeat ARCH Tue Apr 27 14:22:26 2010 db_recovery_file_dest_size of 2048 MB is 36.88% used.
This is auser-specified limit on the amount of space that will be used by thisdatabase for recovery-related files, and does not reflect the amount ofspace available in the underlying filesystem or ASM diskgroup.Tue Apr 27 14:22:27 2010Errors in file h:oracleproduct10.2.0adminorcl4udumporcl4_ora_3704.trc:ORA-00600: internal error code, arguments: [kccext_info_4], [], [],
[code]...
If i connect with scott user ,following message occurs ,
ORA-01033: ORACLE initialization or shutdown in progress
the strange thing is "lkinstrdmetdev" is the wrong name(sid is rdmetdev), and the file does not exist in the FS too. the correct file name should be "lkrdmetdev" and i've deleted this file from the directory. I did not do any changes. and no any oralce processes running while i started up the oracle instance.
Thu Feb 14 09:25:20 EST 2013 sculkget: failed to lock /u01/app/oracle/product/10.2/dbs/lkinstrdmetdev exclusive Thu Feb 14 09:25:20 EST 2013 sculkget: lock held by PID: 272600512 Thu Feb 14 09:25:20 EST 2013 Oracle Instance Startup operation failed. Another process may be attempting to startup or shutdown this Instance. Thu Feb 14 09:25:20 EST 2013 Failed to acquire instance startup/shutdown serialization primitive [code]....
Oracle Instance Startup operation failed. Another process may be attempting to startup or shutdown this Instance. Failed to acquire instance startup/ shutdown serialization primitive
im new to DBA.i installed oracle on my pc but im not able to startup database...im manually creating database ..CRD files r still not created as im unable to startup nomount..im getting this error.
SQL> startup nomount ORA-24324: service handle not initialized ORA-24323: value not allowed ORA-03113: end-of-file on communication channel
i almost worked on this for 10 days but im getting the same error...
I am new user using oracle XE. During the installing process, all see is Ok, but, when database is over startup process, the process NOT RESPONDING, and i don't know the cause.
My environment
Hardware: NOTEBOOK HP Genuine Inter (R) CPU T2500 @ 2.00GHz 1.66 GHz, 2 GB of RAM SO : Windows XP with services pack 3
Installation flow implement:
1. Download Oraclexe from oracle site 2. The installation & configuration process finish succeful, but when el flow are in startup point and i treat to login the login step give me the next message:
ERROR: ORA-01089: Immediate shutdown in progress - no operations are permitted Process ID:0 sESSION id: 0 Serial number: 0
I Hope about 5 hours and the message is the same, while when i hope about 5 hours.
I am running ORACLE 10.2.0 on Windows Virtual PC. System: Microsoft Windows XP SP3.
Yesterday I wanted to make a copy of my Virtual Machine Hard Drive Image. I directly copied all the files to my external hard drive, but I forgot shutting down my virtual machine when I was doing this.
Today I found my instance failed startup.
In OEM, it is showing:
Agent Connection to Instance Status: Failed Details ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)
In SQLPlus:
SQL> connect sys/password as sysdba Connected to an idle instance SQL> startup ORACLE instance started.
Find an appropriate script to automate Oracle DBs in one server? This db server have 6 instances. We always done the starting up and shutting down manually, although we have a reference script that does this but in Oracle v7.3.4. We do want to include the automatic start/stop of dbconsole for accessing it via OEM.
I want the DB to startup with SPFILE at next login.So i fired the below command.
CREATE SPFILE='path/SPFILEPRAGAT.ORA' FROM PFILE='path/file.ora'.
But it shows the error as below:
ORA-01078: failure in processing system parameters ORA-27040: file create error, unable to create file OSD-04002: unable to open file O/S-Error: (os 123) The filename, directory name,or volume label syntax is incorrect.
I recently installed Oracle 10g on my windows Xp laptop. It has become considerably slow since then. I want to start the database server only when I need it, and not every time I start my laptop. I looked around in OEM and did found a way.
CREATE SEQUENCE hyd1_seq START WITH 2100000 INCREMENT BY 1 NOCACHE NOCYCLE;
this is how i created a sequence in database 10g.
if :SHIP_MSTR.PLACE_FROM = 'hyd1' then SELECT hyd1_seq.NEXTVAL INTO :SHIP_MSTR.BILL_ID FROM dual;
this is how iam calling sequence in form.my problem is once the sequence is generated in form and even if i am not saving a form its generating next value next time.what i want to do is if i am not saving the form that sequence number should again come in bill_id.
The problem i mentioned in my last posting "CRS installation/PRIF-10: failed to initialize the cluster registry" was due to the fact i was using Redhat Linux 9 that seems to have some missing packages. I installed White Box RH 3 and everything worked fine.
if it's possible to connect to a 10g RAC database using the jdbc java thin client. the java thin client requires an ip, and database sid. I am running a two node cluster and i have two ip's and a service name that uses TAF option.
we need to take care of all the components in a RAC Database 11g rel 2 . what is the sequence of stopping RAC database ? databsae ?? ASM ??? listeners ??? cluster services ??? commands and also sequence to start / stop ...and to check status of each components
here we have san server and rac database two node database.i want to know how can i create directory on rac database. i know how to create directory on single database but i do not know how can i create directory on rac database.
we had our Oracle RAC database at primary and Standby database as DR. It was running in 10g (10.2.0.1.0) in HP UX 11i platform.
We need to upgrade both the setups from 10.2.0.1.0 to 10.2.0.4.0 . I will go through the upgrade guide, i like to know is there any special case for upgrading when we do for both primary and standby database.
And whether i need to create a new Oracle home with 10.2.0.4.0 software or i can upgrade in the same oracle home which already exists.
we encounter a problem with a 2-nodes RAC with 11gR2 SE : Database RAC is correctly running but we encounter problems using RAC TNS entry, obtaining the message ORA-01033.We can access to the DB using a TNS entry using each one of IP addresses but when we use the SCAN address, it fails. 2 weeks ago RAC2 node could connect perfectly with the SCAN address but RAC1 (used as a client) obtained error message almost 30% of tries.
We made a reboot of RAC1 node and now SCAN address works correctly from RAC1 and RAC2 (used as a client) fails systematically with SCAN address but works perfectly with direct access to the database.On both nodes, SCAN address is perfectly resolved by DNS server, cluster seems correct, listeners seems correct...We have opened an SR on Metalink 4 weeks ago but we don't progress.
if it is possible to create a failover setup without RAC and DG...For example:
I have 11.2.0.2 database (with EBS 12.1.3) on dbnode1...I would like to create another node to failover my primary datbas in case of any failure.
Steps i will follow: 1: creat dbnode2 2: install same os as dbnode1 3: install same oracle as dbnode1 4: share dbnode2 database between dbnode1 and dbnode2
Now, if hardware fails on dbnode1, can i manually failover and start my database on dbnode2?
I know we can do with RAC and DG,BUT without RAC and DG If not possible..
i'm keep on getting below error every morning in my Database.this indicate in Grid control every morning.
Metrics "Database Time Spent Waiting (%)" is at 34.336 for event class "Concurrency" Metrics "Database Time Spent Waiting (%)" is at 100 for event class "Other" Metrics "Database Time Spent Waiting (%)" is at 44.78 for event class "Other"
i need to know, this is something that i should consider as a critical warning and how can i solve this .
suggest on the dependenecy between the database service and the database instance?
srvctl start instance -i db1 will this start service as well for which the above instance is either preferred or available instance? will it start the listener as well?
srvctl stop instance -i db1 will this stop service as well for which the above instance is either preferred or available instance? will it stop the listener as well?
srvctl start service -d db -s dbserve will this start service as well for which the above instance is either preferred or available instance?
srvctl stop servive -d db -s dbserve will this stop service as well for which the above instance is either preferred or available instance?
srvctl start database -d db will it start instance, listener and service as well?
srvctl stop database -d db will it stop instance, listener and service as well?
