Idiotic RAC installation

Giganews Newsgroups
Subject: Idiotic RAC installation
Posted by:  Mladen Gogala (mgogala.SPAM-…@not-at-verizon.net)
Date: Tue, 10 Jul 2007

I had well known problem with "public IP address" and I had to
run srvctl to fix it. I was able to create ASM diskgroups and
the database. The only thing left are the listeners:

-bash-3.00$ srvctl start listener -n oracle10
CRS-1028: Dependency analysis failed because of:
CRS-0223: Resource 'ora.oracle10.LISTENER_ORACLE10.lsnr' has placement
error.
-bash-3.00$

Listener, of course, exists in the running state:

LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 10-JUL-2007 13:18:16

Copyright (c) 1991, 2006, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                    LISTENER
Version                  TNSLSNR for Linux: Version 10.2.0.3.0 -
Production
Start Date                10-JUL-2007 11:48:52
Uptime                    0 days 1 hr. 29 min. 23 sec
Trace Level              off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File  /ORACLE/app/oracle/product/10.2.0/network/admin/
listen
er.ora
Listener Log File        /ORACLE/app/oracle/product/10.2.0/network/log/
listener
..log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle10)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
  Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
Service "VMSP" has 2 instance(s).
  Instance "VMSP1", status READY, has 2 handler(s) for this service...
  Instance "VMSP2", status READY, has 1 handler(s) for this service...
Service "VMSPXDB" has 2 instance(s).
  Instance "VMSP1", status READY, has 1 handler(s) for this service...
  Instance "VMSP2", status READY, has 1 handler(s) for this service...
Service "VMSP_XPT" has 2 instance(s).
  Instance "VMSP1", status READY, has 2 handler(s) for this service...
  Instance "VMSP2", status READY, has 1 handler(s) for this service...

-bash-3.00$ sqlplus system/xxxxx

SQL*Plus: Release 10.2.0.3.0 - Production on Tue Jul 10 13:19:30 2007

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining
options

SQL>
SQL> select inst_id,instance_name,host_name from gv$instance;

  INST_ID INSTANCE_NAME
---------- ----------------
HOST_NAME
----------------------------------------------------------------
        1 VMSP1
oracle10

        2 VMSP2
oracle11

So, I have ASM, listeners, database and CRS running, but srvctl
tells me that "resource has placement errors"???? Of course, the
documentation on Metastink is of no help. CRS_STAT tells me that the
state of the resource is "UNKNOWN":
$ORA_CRS_HOME/bin/crs_stat -l
NAME=ora.VMSP.VMSP1.inst
TYPE=application
TARGET=ONLINE
STATE=ONLINE on oracle10

NAME=ora.VMSP.VMSP2.inst
TYPE=application
TARGET=ONLINE
STATE=ONLINE on oracle11

NAME=ora.VMSP.db
TYPE=application
TARGET=ONLINE
STATE=ONLINE on oracle10

NAME=ora.oracle10.ASM1.asm
TYPE=application
TARGET=ONLINE
STATE=ONLINE on oracle10

NAME=ora.oracle10.LISTENER_ORACLE10.lsnr
TYPE=application
TARGET=ONLINE
STATE=UNKNOWN on oracle10

NAME=ora.oracle10.gsd
TYPE=application
TARGET=ONLINE
STATE=ONLINE on oracle10

NAME=ora.oracle10.ons
TYPE=application
TARGET=ONLINE
STATE=ONLINE on oracle10

NAME=ora.oracle10.vip
TYPE=application
TARGET=ONLINE
STATE=ONLINE on oracle10

NAME=ora.oracle11.ASM2.asm
TYPE=application
TARGET=ONLINE
STATE=ONLINE on oracle11

NAME=ora.oracle11.LISTENER_ORACLE11.lsnr
TYPE=application
TARGET=ONLINE
STATE=UNKNOWN on oracle11

NAME=ora.oracle11.gsd
TYPE=application
TARGET=ONLINE
STATE=ONLINE on oracle11

NAME=ora.oracle11.ons
TYPE=application
TARGET=ONLINE
STATE=ONLINE on oracle11

NAME=ora.oracle11.vip
TYPE=application
TARGET=ONLINE
STATE=ONLINE on oracle11

Does anybody know how to fix the problem? What are the @#$%^ "placement
errors"? Why is every RAC installation such a terrific pain?

--
http://www.mladen-gogala.com

Replies