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

  • T Robinson: In regard to the comment “In our case, RMAN didn’t found anything corrupted.” Please notice...
  • iftikhar: if we backup in multiple backupsets and will be command for restoring for more than one backupsets ,
  • Abey: Very helpful article.Thanks a lot. Can we follow this on oracle DG enabled deployment also?
  • Mauricio Daher: Need help configuring SBT for cloud backups. Does not seem to work for 12c. Thanks! RMAN>...
  • Leszek K: *.db_create_file_dest=’+ DATA’ create database command – why do you use full datafile...
  • Prabhakar Kumar: Thanks buddy!!! It really helps to DBAs who are novice to 12c ASM feature.
  • Wubeshet: I am getting the ORA-07445 This morning on the trace file. The following is the symptom of the problem. It...
  • Lakshmi N: Hi Thanks for the post. Just curious, is there a way to restore to a point wher my db is in no archive...
  • Shivakkumar P: This is really very good article. Iam learning Oracle 12c I used this to replicate testing from...
  • Uday: Hi Wissem, Once we apply the level 1 incremental backup to datafile copy it is no longed required. My question...
  • avnish: Can I set up active duplicate database in 11g standard edition (11.2.0.1)
  • Jaya V: hi, am having rman backup. i need to restore on it, from test instance. But the test instance name not same...
  • Jaya: hi, am having rman backup. i need to restore on it, from test instance. But the test instance name not same...
  • wissem: SQL Developer 4.0
  • oracleman consulting: great info thanks for sharing
  • Mike: Very nice article!! Thanks for sharing!!
  • yathish: I really appreciate if you can send me, if you have tutorial for 11g (11.2.0.1) RAC & ASM (prefer to be...
  • Farrukh Kamal: Fahad, I’m interesting in pursuing remote employment with Pythian. What tips would you suggest...
  • pavankumar: for the error it need to set env correctly http://orcl11gdba.blogspot.in/ 2014/08/asmcmd-08102-no-con...
  • wissem: Post result off; crsctl check has crsctl check crs

Oracle-Class Forums Latest Activity