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-03 | | | Updated: 2011-08-05 | | | Article URL http://www.symantec.com/docs/HOWTO58835 |
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
Thank you.