Home » Server Options » RAC & Failsafe » RAC Installation Problem (RHEL 4.8, Cluserware 10.2.0, Oracle10g DB 10.2.0.1)
RAC Installation Problem [message #468043] Wed, 28 July 2010 12:45 Go to next message
sabir1p2p
Messages: 4
Registered: July 2010
Location: NA
Junior Member
Dear friends:
I am new to RAC. My node details are as follows:

02 nodes running RHEL 4.8, 32-bit
01 storage server running RHEL 5.4, 64-bit

The hosts file is as under

127.0.0.1 localhost
192.168.1.191 rac1pub.org.pk rac1pub
192.168.1.192 rac2pub.org.pk rac2pub
192.168.1.193 rac1pub-vip.org.pk rac1pub-vip
192.168.1.194 rac2pub-vip.org.pk rac2pub-vip
10.2.1.1 rac1pub-pvt.org.pk rac1pub-pvt
10.2.1.2 rac2pub-pvt.org.pk rac2pub-pvt
10.1.1.10 storage.org.pk storage

The storage is mounted through OCFS and folders are mounted correctly.
My install procedure is as follows:

1. Install of Oracle cluster ware, successful
2. Install of Oracle 10g (Database software only), successful

The problem starts when I run "netca" from the oracle user. When the finish button is pressed I encounter the error. I am attaching the error message. When I press retry in the image, It again generates an error message with error CRS-1028 and CRS0223.
Please help me to resolve this problem.


Re: RAC Installation Problem [message #468070 is a reply to message #468043] Wed, 28 July 2010 15:14 Go to previous messageGo to next message
mkounalis
Messages: 147
Registered: October 2009
Location: Dallas, TX
Senior Member
The first most obvious question - is a listener already running? (ps -ef | grep tns)
Re: RAC Installation Problem [message #468143 is a reply to message #468070] Thu, 29 July 2010 01:42 Go to previous messageGo to next message
sabir1p2p
Messages: 4
Registered: July 2010
Location: NA
Junior Member
I have run the command as you told and it indicates that listener is already running on node1. But when I check the node2, the listener was not running and also when I run it, it started running without any services. The complete procedure is below:

[oracle@rac1pub ~]$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-JUL-2010 11:25:25
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER_RAC1PUB
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 29-JUL-2010 11:00:18
Uptime 0 days 0 hr. 25 min. 6 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/product/10.2.0.1/db_1/network/admin/listener.ora
Listener Log File /oracle/product/10.2.0.1/db_1/network/log/listener_rac1pub.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.193)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.191)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

[oracle@rac1pub ~]$ ssh 192.168.1.192
Last login: Wed Jul 28 17:56:53 2010 from rac1pub.mitc.cdns.pk

[oracle@rac2pub ~]$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-JUL-2010 11:26:31
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused

[oracle@rac2pub ~]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-JUL-2010 11:26:52
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /oracle/product/10.2.0.1/db_1//bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /oracle/product/10.2.0.1/db_1/network/admin/listener.ora
Log messages written to /oracle/product/10.2.0.1/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac2pub.mitc.cdns.pk)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 29-JUL-2010 11:26:52
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/product/10.2.0.1/db_1/network/admin/listener.ora
Listener Log File /oracle/product/10.2.0.1/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac2pub.mitc.cdns.pk)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@rac2pub ~]$ exit


======================
The listener_rac1pub.log have following lines:
======================
TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 29-JUL-2010 11:00:18

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

System parameter file is /oracle/product/10.2.0.1/db_1/network/admin/listener.ora
Log messages written to /oracle/product/10.2.0.1/db_1/network/log/listener_rac1pub.log
Trace information written to /oracle/product/10.2.0.1/db_1/network/trace/listener_rac1pub.trc
Trace level is currently 0

Started with pid=28106
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.193)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.191)(PORT=1521)))
Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
29-JUL-2010 11:00:19 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=rac1pub.mitc.cdns.pk)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER_RAC1PUB)(VERSIO N=169869568)) * status * 0
29-JUL-2010 11:11:53 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=rac1pub.mitc.cdns.pk)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER_RAC1PUB)(VERSIO N=169869568)) * status * 0
29-JUL-2010 11:21:53 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=rac1pub.mitc.cdns.pk)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER_RAC1PUB)(VERSIO N=169869568)) * status * 0
29-JUL-2010 11:25:25 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=rac1pub.mitc.cdns.pk)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869 568)) * status * 0
29-JUL-2010 11:31:53 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=rac1pub.mitc.cdns.pk)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER_RAC1PUB)(VERSIO N=169869568)) * status * 0
=========================================

======================
The listener_rac2pub.log have following lines:
======================
TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 29-JUL-2010 11:00:22

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

System parameter file is /oracle/product/10.2.0.1/db_1/network/admin/listener.ora
Log messages written to /oracle/product/10.2.0.1/db_1/network/log/listener_rac2pub.log
Trace information written to /oracle/product/10.2.0.1/db_1/network/trace/listener_rac2pub.trc
Trace level is currently 0

Started with pid=27964
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac2pub-vip.mitc.cdns.pk)(PORT=1521)(IP=FIRST)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
Linux Error: 99: Cannot assign requested address
======================================================

Please help me to resolve this problem.
Re: RAC Installation Problem [message #468255 is a reply to message #468143] Thu, 29 July 2010 05:57 Go to previous messageGo to next message
sabir1p2p
Messages: 4
Registered: July 2010
Location: NA
Junior Member
I have copied the tnsnames.ora file from rac1pub to rac2pub, restarted both the nodes and used crs_stat -t. It shows that both the nodes are online. I used "ps -ef | grep lsnr | grep -v 'grep' | grep -v 'ocfs' | awk ' {print $9}'" command on both nodes and found that listeners are working ok as follows:

[root@rac1pub ~]# su - oracle
[oracle@rac1pub ~]$ ps -ef | grep lsnr | grep -v 'grep' | grep -v 'ocfs' | awk ' {print $9}'
LISTENER_RAC1PUB
[oracle@rac1pub ~]$ ssh rac2pub
Last login: Thu Jul 29 15:14:22 2010 from rac1pub.mitc.cdns.pk
[oracle@rac2pub ~]$ ps -ef | grep lsnr | grep -v 'grep' | grep -v 'ocfs' | awk '{print $9}'
LISTENER_RAC2PUB
[oracle@rac2pub ~]$

Is this ok? please guide me, since still after that i am unable to create a database using dbcc.



Re: RAC Installation Problem [message #468275 is a reply to message #468255] Thu, 29 July 2010 08:37 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

[root@rac1pub ~]# su - oracle
[oracle@rac1pub ~]$ ps -ef | grep lsnr | grep -v 'grep' | grep -v 'ocfs' | awk ' {print $9}'
LISTENER_RAC1PUB
[oracle@rac1pub ~]$ ssh rac2pub
Last login: Thu Jul 29 15:14:22 2010 from rac1pub.mitc.cdns.pk
[oracle@rac2pub ~]$ ps -ef | grep lsnr | grep -v 'grep' | grep -v 'ocfs' | awk '{print $9}'
LISTENER_RAC2PUB
[oracle@rac2pub ~]$


Why do you want recreate listener? Looks LISTENER already running.

>>Is this ok? please guide me,

Yes. Listener up and running fine.

>>since still after that i am unable to create a database using dbcc

Can we have your error/log/Screenshot

Babu

[Updated on: Thu, 29 July 2010 08:38]

Report message to a moderator

Re: RAC Installation Problem [Resloved] [message #468510 is a reply to message #468275] Fri, 30 July 2010 07:13 Go to previous messageGo to next message
sabir1p2p
Messages: 4
Registered: July 2010
Location: NA
Junior Member
Dear all:
At last I resolved the problem. I made a change in the sysctl.conf changing the "shmmax" value to the 2 GB of memory in bytes. The DBCA started working and now everything is fine.

Thankyou.
Re: RAC Installation Problem [Resloved] [message #468794 is a reply to message #468510] Mon, 02 August 2010 04:03 Go to previous message
hsczm
Messages: 1
Registered: August 2010
Junior Member
congratulations!
Previous Topic: RAC Installation - ocfs error
Next Topic: ADDING RAW DISKS TO ASM DISK GROUP
Goto Forum:
  


Current Time: Thu Mar 28 13:38:19 CDT 2024