Idiotic RAC installation

From: Mladen Gogala <mgogala.SPAM-ME_at_not-at-verizon.net>
Date: Tue, 10 Jul 2007 19:27:14 +0200 (CEST)
Message-ID: <pan.2007.07.10.17.21.51@not-at-verizon.net>

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

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

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 Received on Tue Jul 10 2007 - 12:27:14 CDT