RAC database issues
Raj
We are having mixed 10.2.0.5.0 and 11.2.0.3.0 databases. We migrated
10gR2 CRS/ASM to 11.2.0.3.0 Grid Home. But we did not reboot the nodes
after migration to check if CRS/ASM and databases are coming up. But
we did brought down crs and then brought up and everything was working
fine.
The environment was running fine for 2 months.
Last week due to memory issue, we had to reboot one node. Now no 10g
database is coming up. But 11g DBs are running fine. We are able to
bring up the 10g databases with the help of sqlplus but not with
srvctl. We are not sure if it is because of migration.
Does anybody have experienced this kind of issue before?
How can i approach this issue ?
Regards,
Rajeev
Romain Salmon
I think you just have to register the 10g DB in the 11.2.0.3 cluster stack with srvctl add database command to use srvctl functionnality and db auto start.
Here is the syntax :
Set Oracle Home and PATH on CRS :
srvctl add database database_name path_10g_oracle_home
Regards
--
Romain
--
You received this message because you are subscribed to the Google Groups "ORACLE_DBA_EXPERTS" group.
To post to this group, send email to oracle_db...@googlegroups.com.
To unsubscribe from this group, send email to oracle_dba_expe...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/oracle_dba_experts?hl=en.
Mogale Madisha
srvctl add database -d orcl -o /u01/app/oracle/product/10.2.0.1/orcl
-r PRIMARY -c RAC -s OPEN
Add instances :
srvctl add instance -d orcl -i orcl1 -n node1
srvctl add instance -d orcl -i orcl2 -n node2
--
Regards,
Kenneth
ORACLE DATABASE ADMINISTRATOR
TEL : 0861 RDC RDC
FAX : 0861 RDC FAX
email 1: mogo...@gmail.com
email 2: kenn...@rdc.co.za
Relational Database Consulting
http://www.rdc.co.za
This email message and all attachments thereto ("this message")
contain information intended for the perusal, and/or use by the stated
addressee(s) only. This Message is confidential and may contain
proprietary or privileged information. If you are not the intended
recipient, please notify the sender immediately and do not read,
disclose or use the information in any way. Any views expressed in
this message are those of the individual sender, except where the
message states otherwise. Relational Database Consulting (Pty) Ltd
(RDC)does not accept responsibility for such views and opinions and
this message should not be read as representing the views and opinions
of RDC. No liability shall attach to RDC, except where the message
states otherwise and the sender
is authorised thereto.
Raj
On 10 Mrz., 08:50, Mogale Madisha <mogoba...@gmail.com> wrote:
> Correct :
>
> srvctl add database -d orcl -o /u01/app/oracle/product/10.2.0.1/orcl
> -r PRIMARY -c RAC -s OPEN
>
> Add instances :
>
> srvctl add instance -d orcl -i orcl1 -n node1
> srvctl add instance -d orcl -i orcl2 -n node2
>
>
>
>
>
> On Thu, Mar 8, 2012 at 11:08 PM, Romain Salmon <salmo...@gmail.com> wrote:
> > Hi,
>
> > I think you just have to register the 10g DB in the 11.2.0.3 cluster stack
> > with srvctl add database command to use srvctl functionnality and db auto
> > start.
>
> > Here is the syntax :
>
> > Set Oracle Home and PATH on CRS :
>
> > srvctl add database database_name path_10g_oracle_home
>
> > Regards
>
> > --
> > Romain
>
> email 2: kenne...@rdc.co.za
>
> Relational Database Consultinghttp://www.rdc.co.za
> This email message and all attachments thereto ("this message")
> contain information intended for the perusal, and/or use by the stated
> addressee(s) only. This Message is confidential and may contain
> proprietary or privileged information. If you are not the intended
> recipient, please notify the sender immediately and do not read,
> disclose or use the information in any way. Any views expressed in
> this message are those of the individual sender, except where the
> message states otherwise. Relational Database Consulting (Pty) Ltd
> (RDC)does not accept responsibility for such views and opinions and
> this message should not be read as representing the views and opinions
> of RDC. No liability shall attach to RDC, except where the message
> states otherwise and the sender
>
> - Zitierten Text anzeigen -
As you can see below it's not working :
srvctl add database -d bigtest -o /oracle/dbsystem/product/rdbms/
10.2_1 -s open
PRKP-1073 : Cannot create database bigtest because a database named
bigtest already exists.
srvctl add instance -d bigtest -i bigtest2 -n bigq2
PRKO-2010 : Error in adding instance to node: bigq2
PRKR-1008 : adding of instance bigtest2 on node bigq2 to cluster
database bigtest failed.
CRS-2539: A resource with the name 'ora.bigtest.bigtest2.inst' is
already registered
CRS-0211: Resource 'ora.bigtest.bigtest2.inst' has already been
registered.
crsctl stat res ora.bigtest.db
NAME=ora.bigtest.db
TYPE=application
TARGET=ONLINE
STATE=ONLINE on bigq1
crsctl stat res ora.bigtest.bigtest1.inst
NAME=ora.bigtest.bigtest1.inst
TYPE=application
TARGET=ONLINE
STATE=ONLINE on bigq1
crsctl stat res ora.bigtest.bigtest2.inst
NAME=ora.bigtest.bigtest2.inst
TYPE=application
TARGET=OFFLINE
STATE=OFFLINE
srvctl start instance -d bigtest -i bigtest2
PRKP-1001 : Error starting instance bigtest2 on node bigq2
CRS-0215: Could not start resource 'ora.bigtest.bigtest2.inst'.
Any more ideas ?
Thanks and Regards
Raj
Agustin Utrera
Rajeev Tomar
------------------------------------ ----------- ------------------------------
cluster_database_instances integer 4
instance_name string +ASM2
instance_number integer 2
instance_type string asm
SQL> sho parameter comp
------------------------------------ ----------- ------------------------------
nls_comp string BINARY
SQL> sho parameter compatible
------------------------------------ ----------- ------------------------------
compatible string 10.2.0.5.0
------------------------------------ ----------- ------------------------------
active_instance_count integer
cluster_database_instances integer 2
instance_groups string
instance_name string bigtest1
instance_number integer 1
instance_type string RDBMS
open_links_per_instance integer 4
parallel_instance_group string
parallel_server_instances integer 2
Rajeev Tomar
------------------------------------------------------------
10.1.0.0.0
10.1.0.0.0
Please let me know.
Rajeev Tomar
SQL> set linesize 1000
SQL> select NAME TYPE ,COMPATIBILITY , DATABASE_COMPATIBILITY from v$asm_diskgroup;
TYPE COMPATIBILITY DATABASE_COMPATIBILITY
------------------------------ ------------------------------------------------------------ ------------------------------------------------------------
BIGZTQ 10.1.0.0.0 10.1.0.0.0
TEST 10.1.0.0.0 10.1.0.0.0
Agustin Utrera
It seem be ok.
Mogale Madisha
Compatibility is not as issue because the rdbms version is lower than
the oracle real application cluster version.
You only need to consider the ASM instance and diskgroup compatibilities.
Regards,
K
--
Regards,
Kenneth
email 1: mogo...@gmail.com
email 2: kenn...@rdc.co.za
Relational Database Consulting