Re: Idiotic RAC installation

Mladen Gogala wrote:

> 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?
>

There are only ONE (documented and usable) way to get the listener under srvctl control. You have to use "vipca". I agree about the very terrible RAC installation. There are lots of bugs and problems, more under Solaris than linux...

Eberhard Niendorf Received on Tue Jul 10 2007 - 15:40:23 CDT