Eberhard Niendorf wrote:
> 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
correction!!!
NOT vipca, but "netca" configures the listener to the cluster services.
Received on Wed Jul 11 2007 - 08:02:54 CDT
