It's All About ORACLE

Oracle - The number one Database Management System. Hope this Blog will teach a lot about oracle.

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

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 - Production on 30-JAN-2003 11:54:13
(c) Copyright 1998 Oracle Corporation.  All rights reserved.
Welcome to LSNRCTL, type "help" for information.

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.


You Might Also Like

Related Posts with Thumbnails