OraFAQ Forum: RAC & Failsafe » Enabling second instance on 10g RAC Rel2

Home » Server Options » RAC & Failsafe » Enabling second instance on 10g RAC Rel2 (Oracle 10g RAC, Rel2 , Linux AS4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Enabling second instance on 10g RAC Rel2 [message #341816]

Wed, 20 August 2008 07:27

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

Hello All,

We are implementing a 2 node cluster database . I did create the database on the first node successfully . For enabling the second node when I'm starting the ASM instance its giving me as :

[oracle@node2 ~]$ export ORACLE_SID=+ASM2
[oracle@node2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Aug 20 17:55:22 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-01506: missing or illegal database name
SQL>

I dont understand what is the problem . I did enabled the cluster_database=true ,created the undo tablespace and the second thread also and bounced the database also on the fist node.

On the second node , all the services are up and running (CRS Services)

Please help me out .

Regards,
Raj

Report message to a moderator

Re: Enabling second instance on 10g RAC Rel2 [message #341819 is a reply to message #341816]

Wed, 20 August 2008 07:36

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Error:
ORA-01506: missing or illegal database name
Cause:
You tried to execute an ALTER DATABASE command without a specified database name, and there is no value specified for the DB_NAME initialization parameter in the initialization file.
Action:
The options to resolve this Oracle error are:
Either specify a database name in the ALTER DATABASE command or set a value for the DB_NAME parameter in the initialization file.

and also check alertlog file for more information.

Report message to a moderator

Re: Enabling second instance on 10g RAC Rel2 [message #341829 is a reply to message #341819]

Wed, 20 August 2008 08:09

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

But i guess in the ASM instance pfile we dont specify any database name .

The error is not matching with the given error no. message .

As i told you I'm starting the ASM instance and not the Database instance.

Please help me out.

Regards,
Raj

Report message to a moderator

Re: Enabling second instance on 10g RAC Rel2 [message #341837 is a reply to message #341829]

Wed, 20 August 2008 09:00

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

As i told you I'm starting the ASM instance and not the Database instance.
...Sorry i didn't read it properly.

but did you set INSTANCE_TYPE=ASM in pfile/spfile of ASM instance?

Report message to a moderator

Re: Enabling second instance on 10g RAC Rel2 [message #341847 is a reply to message #341837]

Wed, 20 August 2008 09:35

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

Yes, Taj . I specify that instance_type=asm

Report message to a moderator

Re: Enabling second instance on 10g RAC Rel2 [message #341854 is a reply to message #341847]

Wed, 20 August 2008 10:10

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Why not just post your file exactly, instead of explaining what you did.
While it is certainly possible to create instances manually, for beginners i strongly recommend DBCA.
Use DBCA to identify the RAC nodes and create ASM instances in both nodes followed by creating RAC databases.

Report message to a moderator

Re: Enabling second instance on 10g RAC Rel2 [message #341956 is a reply to message #341854]

Wed, 20 August 2008 21:20

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

HI Mahesh ,

Below is my pfile

cluster_database=false
cluster_database_instances=5
compatible=10.2.0
control_files='+DIG1/control.ctl'
db_name=DBRAC
db_domain=rp.com
db_files=50
global_names=true
job_queue_processes=3
log_checkpoint_interval=10000
undo_management=auto
shared_pool_size=120m
open_cursors=50
processes=50
dbrac1.instance_number=1
dbrac2.instance_number=2
dbrac1.thread=1
dbrac2.thread=2
dbrac1.instance_name=dbrac1
dbrac2.instance_name=dbrac2
dbrac1.undo_tablespace=undo1
dbrac2.undo_tablespace=undo2
background_dump_dest=/home/oracle/DBRAC/bdump
core_dump_dest=/home/oracle/DBRAC/cdump
user_dump_dest=/home/oracle/DBRAC/udump
remote_login_passwordfile=exclusive

Please look into that and help me out .

Regards,
Raj

Report message to a moderator

Re: Enabling second instance on 10g RAC Rel2 [message #341957 is a reply to message #341847]

Wed, 20 August 2008 21:25

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

rsreddy28 wrote on Wed, 20 August 2008 07:35

Yes, Taj . I specify that instance_type=asm

I guess old age has finally caught up with me & I am officially blind.

I can not see "instance_type=asm" pfile details in post above.

You can lead folks to knowledge, but you can't make them think.

Report message to a moderator

Re: Enabling second instance on 10g RAC Rel2 [message #341958 is a reply to message #341957]

Wed, 20 August 2008 21:54

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

sorry anacedent,

I did paste you the other pfile and below is my ASM instance pfile:

cluster_database=true
instance_type=asm
asm_diskstring='/dev/sdb*'
background_dump_dest=/home/ASM/bdump
user_dump_dest=/home/ASM/udump
core_dump_dest=/home/ASM/cdump
large_pool_size=12m
remote_login_passwordfile=shared
+ASM1.instance_number=1
+ASM2.instance_number=2

I'm really sorry once again for misleading you ,please look into that .

Regards,
Raj

Report message to a moderator

Previous Topic:	RAC Storage Options ( openfiler or Wasabi )
Next Topic:	User Connections using Listener

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 00:22:00 CST 2024