| RAC Installation Problem [message #468043] |
Wed, 28 July 2010 12:45  |
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 #468143 is a reply to message #468070] |
Thu, 29 July 2010 01:42  |
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 |
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 |
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 |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
