RE: Urgent Help - RAC Deployment on RH Linux AS 3 and Oracle 9i

RE: Urgent Help - RAC Deployment on RH Linux AS 3 and Oracle 9i

 

  

Whats the output of

srvctl tracing using -DTRACING.LEVEL=2 and -DTRACING.ENABLED=TRUE

-----Original Message-----
From: subbarao
[mailto:oracledba-ezmlmshield-x54711827.[Email address protected]
Sent: Wednesday, May 04, 2005 7:55 AM
To: LazyDBA Discussion
Subject: Urgent Help - RAC Deployment on RH Linux AS 3 and Oracle 9i

Hi Gurus:

I am having some issues when trying to start the Database from a
different node.
I created the Database from a node - "node1" and to test the complete
functionality, I shutdown the DB from "node1" and trying to start the DB
from "node2" and could not do it.

Here are the errors and some details which might help you guys to let me
know where to look into to fix the problem and I really appreciate some
one's response ASAP as I need to provide a report on this tests in 2
days.

Operating System : RH Linux AS 3.0

Oracle 9.2.0.4.0

Database Name = orcl

Host Names = node1 , node2 ( Both Public and Private )

Instance Names = node1 , node2


Database "orcl" has been created from the node - "node1" .


-bash-2.05b$ srvctl status database -d orcl
PRKR-1007 : getting of cluster database orcl configuration failed,
PRKR-1001 :
cluster database orcl does not exist
PRKO-2005 : Application error: Failure in getting Cluster Database
Configuration
for: orcl


On Node1:
---------

-bash-2.05b$ ps -ef | grep pmon_
oracle 7226 1 0 16:28 ? 00:00:00 ora_pmon_node1
oracle 7590 6827 0 16:52 pts/2 00:00:00 grep pmon_

-bash-2.05b$ hostname
node1
-bash-2.05b$ gsdctl stat
GSD is running on the local node

-bash-2.05b$ ps -ef |grep oracm
root 7661 1 0 Apr22 ? 00:00:00 oracm
root 7663 7661 0 Apr22 ? 00:00:00 oracm
root 7664 7663 0 Apr22 ? 00:00:00 oracm
root 7665 7663 0 Apr22 ? 00:00:00 oracm
root 7666 7663 0 Apr22 ? 00:00:10 oracm
root 7667 7663 0 Apr22 ? 00:00:00 oracm
root 7668 7663 0 Apr22 ? 00:00:00 oracm
root 7669 7663 0 Apr22 ? 00:00:00 oracm
root 7670 7663 0 Apr22 ? 00:00:00 oracm
root 5261 7663 0 13:35 ? 00:00:00 oracm
root 6194 7663 0 14:33 ? 00:00:00 oracm
root 6241 7663 0 14:33 ? 00:00:00 oracm
oracle 7704 6827 0 17:03 pts/2 00:00:00 grep oracm



On Node2:
---------

-bash-2.05b$ ps -ef | grep pmon_
oracle 9495 9414 0 12:54 pts/3 00:00:00 grep pmon_

-bash-2.05b$ hostname
node2
-bash-2.05b$ gsdctl stat
GSD is running on the local node

-bash-2.05b$ ps -ef |grep oracm
root 7024 1 0 09:37 ? 00:00:00 oracm
root 7026 7024 0 09:37 ? 00:00:00 oracm
root 7027 7026 0 09:37 ? 00:00:00 oracm
root 7028 7026 0 09:37 ? 00:00:00 oracm
root 7029 7026 0 09:37 ? 00:00:01 oracm
root 7031 7026 0 09:37 ? 00:00:00 oracm
root 7032 7026 0 09:37 ? 00:00:00 oracm
root 7033 7026 0 09:37 ? 00:00:00 oracm
root 7034 7026 0 09:37 ? 00:00:00 oracm
root 7037 7026 0 09:37 ? 00:00:00 oracm
root 8786 7026 0 10:39 ? 00:00:00 oracm
root 8828 7026 0 10:39 ? 00:00:00 oracm
oracle 9634 9414 0 13:05 pts/3 00:00:00 grep oracm



When trying to startup the DB from "node2", I get this error:

SQL> startup;
ORA-27504: IPC error creating OSD context


-bash-2.05b$ df -k
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/hda2 75789360 8185712 63753720 12% /
/dev/hda1 102454 19638 77526 21% /boot
none 251924 0 251924 0% /dev/shm
/dev/sdb1 245101792 605024 244496768 1%
/var/opt/oracle/oradata/orcl

( /dev/sdb1 - This is a Firewire Drive, 250 GB Maxtor Drive , which is
recognised by both Node1 and Node2 )


-bash-2.05b$ ls -lrt /var/opt/oracle/oradata/orcl total 564603
-rw-r--r-- 1 oracle dba 12288 Apr 21 14:45 CMQuorumFile
-rw-r--r-- 1 oracle dba 10557440 Apr 23 12:30
SharedSrvctlConfigFile
-rwSr----- 1 oracle dba 9216 Apr 23 15:20 orapwdorcl
-rw-r----- 1 oracle oracle 1323008 Apr 23 16:06 ctrl
-rw-r----- 1 oracle oracle 15729152 Apr 23 16:06 log1a.dbf
-rw-r----- 1 oracle oracle 15729152 Apr 23 16:06 log1b.dbf
-rw-r----- 1 oracle oracle 419434496 Apr 23 16:09 system.dbf
-rw-r----- 1 oracle oracle 41947136 Apr 23 16:10 undo.dbf
-rw-r----- 1 oracle oracle 15732736 Apr 23 16:10 temp.dbf
-rwSr----- 1 oracle dba 2048 Apr 23 16:10 orapw
-rw-r----- 1 oracle oracle 41947136 Apr 23 16:17 undo2.dbf
-rw-r----- 1 oracle oracle 15729152 Apr 23 16:17 log2a.dbf

Thanks
-Subbarao


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html




Oracle LazyDBA home page