And it is a REAL mess under Windows. You can sure tell BIll and Larry do
not
like each other...
Richard
"Eberhard Niendorf" <eberhard.niendorf_schrott_at_t-online.de> wrote in message
news:f72kdu$2vs$00$1_at_news.t-online.com...
> 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 Fri Jul 13 2007 - 11:02:51 CDT
