Home » Server Options » RAC & Failsafe » Enabling second instance on 10g RAC Rel2 (Oracle 10g RAC, Rel2 , Linux AS4)
Enabling second instance on 10g RAC Rel2 [message #341816] Wed, 20 August 2008 07:27 Go to next message
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

Re: Enabling second instance on 10g RAC Rel2 [message #341819 is a reply to message #341816] Wed, 20 August 2008 07:36 Go to previous messageGo to next message
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.
Re: Enabling second instance on 10g RAC Rel2 [message #341829 is a reply to message #341819] Wed, 20 August 2008 08:09 Go to previous messageGo to next message
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
Re: Enabling second instance on 10g RAC Rel2 [message #341837 is a reply to message #341829] Wed, 20 August 2008 09:00 Go to previous messageGo to next message
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?
Re: Enabling second instance on 10g RAC Rel2 [message #341847 is a reply to message #341837] Wed, 20 August 2008 09:35 Go to previous messageGo to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Yes, Taj . I specify that instance_type=asm
Re: Enabling second instance on 10g RAC Rel2 [message #341854 is a reply to message #341847] Wed, 20 August 2008 10:10 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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.
Re: Enabling second instance on 10g RAC Rel2 [message #341956 is a reply to message #341854] Wed, 20 August 2008 21:20 Go to previous messageGo to next message
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
Re: Enabling second instance on 10g RAC Rel2 [message #341957 is a reply to message #341847] Wed, 20 August 2008 21:25 Go to previous messageGo to next message
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.
Re: Enabling second instance on 10g RAC Rel2 [message #341958 is a reply to message #341957] Wed, 20 August 2008 21:54 Go to previous message
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
Previous Topic: RAC Storage Options ( openfiler or Wasabi )
Next Topic: User Connections using Listener
Goto Forum:
  


Current Time: Fri Mar 29 02:34:16 CDT 2024