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

Description

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.

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)