Customer needs to run the /opt/VRTS/bin/sfua_db_config script to set up the correct group permission in /var/vx/vxdba/logs & /var/vx/vxdba/locks directories after installing Storage Foundation for Database edition

Article:HOWTO58835  |  Created: 2011-08-02  |  Updated: 2011-08-05  |  Article URL http://www.symantec.com/docs/HOWTO58835
Article Type
How To


Environment


After installing Storage Foundation for Database Edition 5.0MP3 or later customer should run sfua_db_config to set up the correct group permission
in /var/vx/vxdba, /var/vx/vxdba/logs & /var/vx/vxdba/locks directories.

If the sfua_db_config script is not run, the above directories will have read/write permissions for all system users.

 

 

 

 

 

 

Example: Changing directory permission manually

1. Details of database user
 
# id oracle
uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba)
 

2. Run /opt/VRTS/bin/sfua_db_config script to change directory permission

# /opt/VRTS/bin/sfua_db_config
Welcome to the SFORA configuration script.
       This script sets the owner and group of various directories
Are you ready to configure SFDB directories (y/n/q) [y]?
Enter login account name for DBA user: oracle
Enter group name for DBA user: oinstall
Owner and group changed for SFDB directories
# ls -ld /var/vx/vxdba/
drwxrwxr-t 4 root oinstall 4096 Jul 18 02:25 /var/vx/vxdba/
# ls -ld /var/vx/vxdba
drwxrwxr-t 4 root oinstall 4096 Jul 18 02:25 /var/vx/vxdba
# ls -ld /var/vx/vxdba/logs/
drwxrwxr-t 2 root oinstall 4096 Jul 18 02:25 /var/vx/vxdba/logs/
# ls -ld /var/vx/vxdba/locks/
drwxrwxr-t 2 root oinstall 4096 Jul 18 02:25 /var/vx/vxdba/locks/
 

3. Verify directory permission using non database user

# su - testuser
[testuser@node1 ~]$ ls
[testuser@node1 ~]$ cd /var/vx/vxdb
cd: /var/vx/vxdb: Permission denied
[testuser@node1 ~]$ cd /var/vx/vxdba
cd: /var/vx/vxdba: Permission denied
[testuser@node1 ~]$ cd /var/vx/
cd: /var/vx/: Permission denied
 

The above steps are not required if customer adds single user access for database user during product installation using the installsfrac or installsf scripts.



Article URL http://www.symantec.com/docs/HOWTO58835


Terms of use for this information are found in Legal Notices