Authorisation failure with CRS

A while back I had the problem that my CRS information was lost.

Now I had found that when I did a crs_start of the component I received the following error:

CRS-0254 authorization failure

Some investigation showed that the problem was related to the fact that the component was not owned by the oracle user.

Using crs_getperm ora.ORCL.db showed the problem.

oracle@myhost:/opt/oracle/crs/bin>./crs_getperm ora.ORCL.db
Name: ora.ORCL.db
owner:root:rwx,pgrp:system:r-x,other::r--,

This can be solved by doing the following:

crs_setperm ora.ORCL.db -o oracle
crs_setperm ora.ORCL.db -g dba

Now it works again.

Oracle listener lsnrctl tips

Here we see the lsnrctl command in action:
$ lsnrctl

LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 30-JAN-2003 11:54:13

(c) Copyright 1998 Oracle Corporation.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> help

The following lsnrctl operations are available

An asterisk (*) denotes a modifier or extended command:

start               stop                status

services            version             reload

save_config         trace               spawn

dbsnmp_start        dbsnmp_stop         dbsnmp_status

change_password     quit                exit

set*                show*

  

The following commands are used to manage the listener: 

·     start – Starts the listener with the name specified, otherwise LISTENER will be used.  For Windows systems, the listener can also be started from the Control Panel.

·     stop – Stops the listener.  For Windows systems, the listener can also be stopped from the Control Panel.

·     status – Provides status information about the listener, including start date, uptime, and trace level.

·     services – Displays each service available, along with the connection history.

·     version – Displays the version information of the listener.

·     reload – Forces a read of the configuration file in order for new settings to take effect without stopping and starting the listener.

·     save_config – Creates a backup of the existing listener.ora file and saves changes to the current version.

·     trace – Sets the trace level to one of the following – OFF, USER, ADMIN, or SUPPORT.

·     spawn – Spawns a program that runs with an alias in the listener.ora file.

·     dbsnmp_start – Starts the DBSNMP subagent. 

 ·     dbsnmp_stop – Stops the DBSNMP subagent.

·     dbsnmp_status – Displays the status of the DBSNMP subagent.

·     change_password – Sets a new password for the listener.

·     quit and exit – Exits the utility.

·     set – Changes the value of any parameter.  Everything that can be shown can be set.

show – Displays current parameter settings.