Use crs_setperm to modify the resource owner and permissions of RAC.

In the Oracle RAC cluster, the management of various resources also has the owner and permission issues. Crs_getperm and crs_setperm are a pair of commands used to view and modify the owner, group, and permissions of resources in the cluster. The following shows how to use crs_getperm.

1. View resources in the current cluster # The following query shows that there are two serviceoracle @ bo2dbp in the current cluster environment: ~> Crs_stat-ls | grep srvora... o4a. SRV Oracle oinstall rwxrwxr -- ora... 0g1. SRV Oracle oinstall rwxrwxr -- # Get the full name of service Oracle @ bo2dbp: ~> Crs_stat-p | grep srvname = ora. gobo4.gobo4 _ srv. gobo4a. srvname = ora. ora10g. hr_ora10g.ora10g1.srvdescription = ora. ora10g. hr_ora10g.ora10g1.srv # The following uses crs_getperm to obtain the resource owner's permission: Oracle @ bo2dbp: ~> Crs_getperm ora. ora10g. hr_ora10g.ora10g1.srvname: ora. ora10g. hr_ora10g.ora10g1.srvowner: oracle: rwx, pgrp: oinstall: rwx, other: r --, # The owner is the owner, pgrp indicates the owner, and other indicates other users, each of the following follows the corresponding permissions 2. crs_getperm and crs_setperm usage Oracle @ bo2dbp: ~> Crs_getperm-husage: crs_getperm resource_name [-u user |-G group] [-q] # crs_getperm is easy to use, followed by the Resource Name. Optional values: user or group Oracle @ bo2dbp: ~> Crs_setperm-h # This command is slightly more complex than crs_getperm usage: crs_setperm resource_name-u aclstring [-q] crs_setperm resource_name-x aclstring [-q] crs_setperm resource_name-O user_name [-q] crs_setperm resource_name-G group_name [-q]-u update ACL string-x Delete the ACL string-o change the owner of the resource-G change the Primary Group of the resource aclstring is one of the following: user: <username>: Rwx group: <groupname>: R-X # note the group usage here. If you directly use the group to modify the permission, you will receive an error message "Other: r -- 3. demonstrate using crs_setpermoracle @ bo2dbp: ~> Supassword: # modify the resource owner and group of the resource hr_ora10g respectively, and change all of them to the roo permission bo2dbp:/users/Oracle # crs_setperm ora. ora10g. hr_ora10g.ora10g1.srv-O rootbo2dbp:/users/Oracle # crs_setperm ora. ora10g. hr_ora10g.ora10g1.srv-g root # After you view the modification, the owner and group of the resource have changed. bo2dbp:/users/Oracle # crs_getperm ora. ora10g. hr_ora10g.ora10g1.srvname: ora. ora10g. hr_ora10g.ora10g1.srvowner: Root: rwx, pgrp: Root: rwx, other: r --, # modify the Group permission, change it to read, and execute bo2dbp:/user S/Oracle # crs_setperm ora. ora10g. hr_ora10g.ora10g1.srv-u pgrp: Root: r-xbo2dbp:/users/Oracle # crs_getperm ora. ora10g. hr_ora10g.ora10g1.srvname: ora. ora10g. hr_ora10g.ora10g1.srvowner: Root: rwx, pgrp: Root: R-X, other: r --, # modify it back in the same way. Bo2dbp:/users/Oracle # crs_setperm ora. ora10g. hr_ora10g.ora10g1.srv-O oraclebo2dbp:/users/Oracle # crs_setperm ora. ora10g. hr_ora10g.ora10g1.srv-G oinstallbo2dbp:/users/Oracle # crs_setperm ora. ora10g. hr_ora10g.ora10g1.srv-u pgrp: oinstall: rwxbo2dbp:/users/Oracle # crs_getperm ora. ora10g. hr_ora10g.ora10g1.srvname: ora. ora10g. hr_ora10g.ora10g1.srvowner: oracle: rwx, pgrp: oinstall: rwx, other: r --, bo2dbp :/Users/Oracle # Su-Oracle # The owner's permissions cannot be modified by Oracle @ bo2dbp: ~> Crs_setperm ora. ora10g. hr_ora10g.ora10g1.srv-u owner: oracle: R-x CRS-0248: ACL operation failedoracle @ bo2dbp: ~> Crs_setperm ora. ora10g. hr_ora10g.ora10g1.srv-u owner: oracle: rw-CRS-0248: ACL operation failedoracle @ bo2dbp: ~> Crs_setperm ora. ora10g. hr_ora10g.ora10g1.srv-u owner: oracle:-wxCRS-0248: ACL operation failed # group permissions can be modified by Oracle @ bo2dbp: ~> Crs_setperm ora. ora10g. hr_ora10g.ora10g1.srv-u pgrp: oinstall: R-x oracle @ bo2dbp: ~> Crs_getperm ora. ora10g. hr_ora10g.ora10g1.srvname: ora. ora10g. hr_ora10g.ora10g1.srvowner: oracle: rwx, pgrp: oinstall: R-X, other: r --, # other can also modify Oracle @ bo2dbp: ~> Crs_setperm ora. ora10g. hr_ora10g.ora10g1.srv-u other: rwx Oracle @ bo2dbp: ~> Crs_getperm ora. ora10g. hr_ora10g.ora10g1.srvname: ora. ora10g. Role: oracle: rwx, pgrp: oinstall: R-X, other: rwx, # Author: Robinson # blog: Author> Crs_stat-ls | grep srvora... o4a. SRV Oracle oinstall rwxrwxr -- ora... 0g1. SRV Oracle oinstall rwxr-xrwx

For more information, see:

For more information about Oracle RAC, see
Use crs_setperm to modify the resource owner and permissions of RAC.
Use crs_profile to manage RAC resource configuration files
RAC database startup and Shutdown
Oracle RAC services
Services in Oracle Database 10g
Migrate datbase from single instance to Oracle RAC
Connect Oracle RAC to a specified instance
Oracle RAC load balancing test (combined with server and client)
Oracle RAC server connection Load Balance)
Load Balance)
Non-Default port listening configuration in Oracle RAC (listener. ora tnsnames. ora)
Oracle RAC Listener Configuration (listener. ora tnsnames. ora)
Configure RAC load balancing and Failover
CRS-1006, CRS-0215 fault case
Installing Oracle 10g RAC Based on Linux (RHEL 5.5)
Use runcluvfy to verify the Oracle RAC installation environment

For more information about the basics and concepts of Oracle network configuration, see:
Configure dynamic service registration for non-default ports
Configure sqlnet. ora to restrict IP Access to Oracle
Configure and manage Oracle listener logs
Set the Oracle listener password (listener)
Configure the Oracle client to connect to the database

For more information about user-managed backup and recovery, see
Oracle cold backup
Oracle Hot Backup
Concept of Oracle backup recovery
Oracle instance recovery
Oracle recovery based on user management
System tablespace management and Backup Recovery
Sysaux tablespace management and recovery
Oracle backup control file recovery (unsing backup controlfile)

For information on RMAN backup recovery and management, see
RMAN overview and architecture
RMAN configuration, Monitoring and Management
Detailed description of RMAN backup
RMAN restoration and recovery
Create and use RMAN catalog
Create RMAN storage script based on catalog
Catalog-based RMAN backup and recovery
RMAN backup path confusion
Use RMAN for recovery from different machine backups (WIN platform)
Use RMAN to migrate a file system database to ASM
Linux RMAN backup shell script
Use RMAN to migrate the database to a different machine

For the Oracle architecture, see
Oracle tablespace and data files
Oracle Password File
Oracle parameter file
Oracle online redo log file)
Oracle Control File)
Oracle archiving logs
Oracle rollback and undo)
Oracle database instance startup and Shutdown Process
Automated Management of Oracle 10g SGA
Oracle instances and Oracle databases (Oracle Architecture)