Operating System - HP-UX
1752689 Members
5436 Online
108789 Solutions
New Discussion юеВ

Re: Oracle 10g r2 RAC: netca fails

 
Anar
New Member

Oracle 10g r2 RAC: netca fails

Hi.
I'd like to ask whether Safeguard Extensions for RAC are inevitably required?
If yes, do they have some relation with the listeners? (netca fails at the end. I suspect /opt/nmapi is missing that leads to failure)
And how can I get Oracle 10.2.0.3 while the Oracle site only provides 10.2.0.1 for the "HP-UX B.11.23 U ia64" that we got?

Thanks in advance.
Regards.
3 REPLIES 3
Steven E. Protter
Exalted Contributor

Re: Oracle 10g r2 RAC: netca fails

Shalom,

A full set up updates are provided by http://metalink.oracle.com

You of course need a software contract to access this site.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Anar
New Member

Re: Oracle 10g r2 RAC: netca fails

Thanks for the reply Steven.
Anar
New Member

Re: Oracle 10g r2 RAC: netca fails

Here is the detailed version of the problem.

The output from `crs_stat -t`:
ora...._1.lsnr application OFFLINE OFFLINE
ora....0_1.gsd application ONLINE ONLINE rx3600_1
ora....0_1.ons application ONLINE ONLINE rx3600_1
ora....0_1.vip application ONLINE ONLINE rx3600_1
ora...._2.lsnr application OFFLINE OFFLINE
ora....0_2.gsd application ONLINE ONLINE rx3600_2
ora....0_2.ons application ONLINE ONLINE rx3600_2
ora....0_2.vip application ONLINE ONLINE rx3600_2

where listener names as follows
NAME=ora.rx3600_1.LISTENER_RX3600_1.lsnr
NAME=ora.rx3600_2.LISTENER_RX3600_2.lsnr

And as I try to `crs_start ora.rx3600_1.LISTENER_RX3600_1.lsnr` I got the message like:
Attempting to start `ora.rx3600_1.LISTENER_RX3600_1.lsnr` on member `rx3600_1`
Start of `ora.rx3600_1.LISTENER_RX3600_1.lsnr` on member `rx3600_1` failed.
rx3600_2 : CRS-1018: Resource ora.rx3600_1.vip (application) is already running on rx3600_1


CRS-0215: Could not start resource 'ora.rx3600_1.LISTENER_RX3600_1.lsnr'.
The same is the case for LISTENER_RX3600_2.

And I got following files in $ORACLE_HOME/network/admin:
listener.ora.rx3600_1
listener.ora.rx3600_2
tnsnames.ora

Contents of the listener.ora.rx3600_1:
SID_LIST_LISTENER_RX3600_1 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/oracle/ora_base/products/db_home1)
(PROGRAM = extproc)
)
)

LISTENER_RX3600_1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rx3600_1-vip)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.0.0.233)(PORT = 1521)(IP = FIRST))
)
)

and listener.ora.rx3600_2:
SID_LIST_LISTENER_RX3600_2 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/oracle/ora_base/products/db_home1)
(PROGRAM = extproc)
)
)

LISTENER_RX3600_2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rx3600_2-vip)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.0.0.235)(PORT = 1521)(IP = FIRST))
)
)

Contents of tnsnames.ora:
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

Besides I got following output from `lsnrctl status`:
LSNRCTL for HPUX: Version 10.2.0.1.0 - Production on 24-DEC-2007 07:19:37

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for HPUX: Version 10.2.0.1.0 - Production
Start Date 24-DEC-2007 06:04:54
Uptime 0 days 1 hr. 14 min. 42 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /home/oracle/ora_base/products/db_home1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rx3600_1)(PORT=1521)))
The listener supports no services
The command completed successfully

Thanks in advance.
Regards.