Re: Idiotic RAC installation

In an effort to be more like Microsoft, Oracle has started pushing their GUIs for everything. I've noticed that if you want to avoid using the DBCA in favor of the command line and SQLPLUS, it is becoming harder and harder to find out what you need to do in the documentation.

I don't know if your particular problem exists if you create the database and the listener using Oracle's GUI tools, but it wouldn't surprise me if it doesn't under those circumstances. I don't like the direction Oracle is pushing people.

• Rich

On Tue, 10 Jul 2007 19:27:14 +0200 (CEST), Mladen Gogala <mgogala.SPAM-ME_at_not-at-verizon.net> 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?
Received on Wed Jul 11 2007 - 03:49:01 CDT