11gR2 Oracle Restart errors : CRS-0259, CRS-2680, CRS-5802

June 22nd, 2011 | Posted in 11gR2, Blog, oracle restart, RAC | No Comments


This is a quick post of how to fix an CRS-0259 error when trying to add manually a resource (database, listener) to the Oracle Restart configuration.

I have successfully installed the grid infrastructure for standalone server without ASM and I have successfully configured Oracle Restart after executing roothas.pl script with root user.

Now, I would like to add the database already created to Oracle Restart Configuration.,
According to the documentation http://download.oracle.com/docs/cd/E11882_01/server.112/e17120/restart002.htm#ADMIN12721

1- Make sure grid user is a part of dba group => This is done.
2- srvctl command from the Oracle Home.
3- I log into Oracle account and I executed the command:

-bash-3.2$ srvctl add database -d db01 -o /a01/app/oracle/product/11.2.0/db_1
PRCR-1006 : Failed to add resource ora.db01.db for null
PRCR-1071 : Failed to register or update resource ora.db01.db
CRS-0259: Owner of the resource does not belong to the group.
-bash-3.2$

This is the content of my /etc/group :

....
oinstall:x:501:oracle,grid,root
dba:x:502:oracle,root,grid
asmadmin:x:504:grid
asmdba:x:506:grid,oracle
asmoper:x:507:grid

Now How to fix the problem:

This is how I fixed the problem:

1- First Deconfig Oracle Restart: As a root user:


[root@dbt05 ~]# /a01/11.2.0/grid/perl/bin/perl -I /a01/11.2.0/grid/perl/lib/ -I /a01/11.2.0/grid/crs/install/ /a01/11.2.0/grid/crs/install/roothas.pl -deconfig
Using configuration parameter file: /a01/11.2.0/grid/crs/install/crsconfig_params
PRKO-2573 : ONS daemon is already stopped.
CRS-2500: Cannot stop resource 'ora.cssd' as it is not running
CRS-4000: Command Stop failed, or completed with errors.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'dbt05'
CRS-2673: Attempting to stop 'ora.evmd' on 'dbt05'
CRS-2677: Stop of 'ora.evmd' on 'dbt05' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'dbt05' has completed
CRS-4133: Oracle High Availability Services has been stopped.
ACFS-9200: Supported
Successfully deconfigured Oracle Restart stack

2- Configure again Oracle Restart:


[root@dbt05 ~]# /a01/11.2.0/grid/perl/bin/perl -I /a01/11.2.0/grid/perl/lib/ -I /a01/11.2.0/grid/crs/install/ /a01/11.2.0/grid/crs/install/roothas.pl
Using configuration parameter file: /a01/11.2.0/grid/crs/install/crsconfig_params
LOCAL ADD MODE
Creating OCR keys for user 'grid', privgrp 'oinstall'..
Operation successful.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4664: Node dbt05 successfully pinned.
Adding daemon to inittab
ACFS-9300: ADVM/ACFS distribution files found.
ACFS-9307: Installing requested ADVM/ACFS software.
ACFS-9308: Loading installed ADVM/ACFS drivers.
ACFS-9321: Creating udev for ADVM/ACFS.
ACFS-9323: Creating module dependencies - this may take some time.
ACFS-9327: Verifying ADVM/ACFS devices.
ACFS-9309: ADVM/ACFS installation correctness verified.
 
dbt05     2011/06/22 13:12:00     /a01/11.2.0/grid/cdata/dbt05/backup_20110622_131200.olr
Successfully configured Oracle Grid Infrastructure for a Standalone Server
[root@dbt05 ~]#


3- Add the database to Oracle restart configuration:


-bash-3.2$ id
uid=502(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),506(asmdba)
-bash-3.2$ srvctl add database -d db01 -o /a01/app/oracle/product/11.2.0/db_1
-bash-3.2$

Now, after adding the listener to Oracle restart configuration using srvctl command from Oracle home:

You may face the problem below:



From Oracle home:
 
-bash-3.2$ lsnrctl status listener
 
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 22-JUN-2011 14:37:36
 
Copyright (c) 1991, 2010, Oracle.  All rights reserved.
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=168.110.90.32)(PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
-bash-3.2$
 
 
 
-bash-3.2$ srvctl start LISTENER
PRCR-1079 : Failed to start resource ora.LISTENER.lsnr
CRS-2680: Clean of 'ora.LISTENER.lsnr' on 'db06' failed
CRS-5802: Unable to start the agent process
 
 
-bash-3.2$ srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is not running
-bash-3.2$
 
-bash-3.2$ lsnrctl start LISTENER
 
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 22-JUN-2011 14:38:31
 
Copyright (c) 1991, 2010, Oracle.  All rights reserved.
 
Starting /a01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...
 
TNSLSNR for Linux: Version 11.2.0.2.0 - Production
System parameter file is /a01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Log messages written to /a01/app/oracle/diag/tnslsnr/db06/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=168.110.90.32)(PORT=1521)))
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date                22-JUN-2011 14:38:33
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /a01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /a01/app/oracle/diag/tnslsnr/dbt06/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=168.110.90.32)(PORT=1521)))
The listener supports no services
The command completed successfully
 
-bash-3.2$ srvctl start LISTENER
PRCR-1079 : Failed to start resource ora.LISTENER.lsnr
CRS-2680: Clean of 'ora.LISTENER.lsnr' on 'db06' failed
CRS-5802: Unable to start the agent process
 
-bash-3.2$
-bash-3.2$ srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is not running

According to the Oracle documentation:

http://download.oracle.com/docs/cd/E11882_01/server.112/e17120/restart002.htm#sthref461

See : Table 4-6 Determining the Oracle Home from which to Start SRVCTL
Click on Foot 1:

The content of Foot 1 is:

“Footnote 1

Assumes the listener was started from the Oracle Grid Infrastructure home. If you installed Oracle Restart for an existing database, the listener may have been started from the database home, in which case you start SRVCTL from the database home.

In my case, this is wrong. In my case, I would like to add the listener in Oracle restart configuration for an existing database: If you try to start the listener using srvctl command from Oracle home, you may receive the following error:


-bash-3.2$ srvctl start LISTENER
PRCR-1079 : Failed to start resource ora.LISTENER.lsnr
CRS-2680: Clean of 'ora.LISTENER.lsnr' on 'db06' failed
CRS-5802: Unable to start the agent process

So to fix the error, you should follow the steps below:

-bash-3.2$ id
uid=501(grid) gid=501(oinstall) groups=501(oinstall),502(dba),504(asmadmin),50                                                                                          6(asmdba),507(asmoper)
-bash-3.2$ srvctl config listener -l LISTENER
Name: LISTENER
Home: /a01/11.2.0/grid
End points: TCP:1521
-bash-3.2$ srvctl status listener -l LISTENER
Listener LISTENER is enabled
Listener LISTENER is not running
-bash-3.2$ srvctl start listener -l LISTENER
PRCR-1079 : Failed to start resource ora.LISTENER.lsnr
CRS-2680: Clean of 'ora.LISTENER.lsnr' on 'dbt05' failed
CRS-5802: Unable to start the agent process
 
 
connect with oracle user and do:
-bash-3.2$ srvctl add listener -l LISTENER -o /a01/app/oracle/product/11.2.0/db_1 -p "TCP:1521/IPC:EXTPROC1521"
PRCN-3004 : Listener LISTENER already exists
-bash-3.2$ srvctl remove listener -l LISTENER
-bash-3.2$
 
Now from grid user:
 
-bash-3.2$ srvctl config listener -l LISTENER
PRCR-1001 : Resource ora.LISTENER.lsnr does not exist
-bash-3.2$ srvctl add listener -l LISTENER
-bash-3.2$ srvctl config listener -l LISTENER
Name: LISTENER
Home: /a01/11.2.0/grid
End points: TCP:1521
-bash-3.2$ srvctl status listener -l LISTENER
Listener LISTENER is enabled
Listener LISTENER is not running
-bash-3.2$ srvctl start listener -l LISTENER
-bash-3.2$ srvctl config listener -l LISTENER
Name: LISTENER
Home: /a01/11.2.0/grid
End points: TCP:1521
-bash-3.2$ srvctl status listener -l LISTENER
Listener LISTENER is enabled
Listener LISTENER is running on node(s): dbt05
-bash-3.2$

Hope it helps,
Wissem



No Comments to “11gR2 Oracle Restart errors : CRS-0259, CRS-2680, CRS-5802

There are no comments yet, add one below.


Leave a Comment





Polls

which oracle topic interests you most?

View Results

Loading ... Loading ...


Oracle Class Tweets


Recent Posts


Recent Comments

  • wissem: Post result off; crsctl check has crsctl check crs
  • ron: unable to connect to Cluster Synchronization Service
  • KevinB: Please post or attach the response file
  • nnarimanov: I’d like to clarify the reason why rman restores all datafiles into +DATA. It’s because of...
  • Sergio: Hi, Where is declared the function agent_clean() ? I dont see agent_clean() definition !! regards, Sergio
  • Sikandar: I do salute you brother, This is very………..nti mes helpful and correct documents. I...
  • Karthik Singh: Thanks for sharing a useful article. Looks like you have installed weblogic 10.3.4. Then shall I...
  • Joseph: Paul, Here target is from which database we are taking cloning. and auxilary is the cloning database. Wissem,...
  • sundar: In Doc ID 1472171.1 it says that the snapshot control file should be in a shared location for RAC databases....
  • Taoqir: Hello, This is a wonderfull and very helping material.now I am going to configure Data Guard. Thanks
  • Adrian Iriarte: Saludos, Que buen articulo, casi siempre al momento de querer implementar soluciones para el...
  • Patricia: Hi Wissem, is there a workaround for this? I mean I want to use the sqlnet.authentication_services =none,...
  • Brian: I created the cdb manually using the instruction, but then I tried to create pdb within in, it failed. have...
  • Farmer Johnson: Hi Wissem. How did you avoid the error you had previsouly encountered: “sudo opatch auto...
  • Héctor Moro: Querido Nelson; Después de entrevistar a mas de 50 profesionales de primer nivel en Uruguay, al fin te...
  • What is NO2 Maximus: I genuinely apрreciated your site! You shoulԁ update it wiϳth new info!
  • Nav: Indeed helpful, to the point article..
  • Koti: Can you please explain all the sections of AWR report in RAC. I mean to ask output produced by awrgrpt.sql...
  • Himanshu: Nice post.can you please comment on this Why RMAN restored the DATA_REORTING datafie to +DATA diskgroup?
  • gabriel: what version of sqldeveloper support plugable database?