UNIX for Dummies Questions & Answers

Dear Tayyab,
i tried to follow your steps...

"Make it -rw-r--r-- or if you don't want to give read access to every one then make that particular user a member of the same group which oracle_install belongs."

Regards
Faruque

So, I have clearly put an "or" there, you can set permissions to -rw-r--r-- in that case its readable to every one, but if you want a secure thing then make that user a member of oinstall group and in that case you need 640 permissions.

[root@oper-db ~]# userdel rozan
[root@oper-db ~]# useradd -d /home/rozan -s /bin/bash -c "Rozan Ahmed" -g dba rozan
[root@oper-db ~]# ls -ltr /uo01/app/oracle/admin/operdb/bdump/
total 332
-rw-r----- 1 oracle oinstall 808 Jan 31 02:41 operdb_lgwr_7864.trc
-rw-r----- 1 oracle oinstall 616 Jan 31 02:42 operdb_arc1_7946.trc
-rw-r----- 1 oracle oinstall 616 Jan 31 02:42 operdb_arc0_7944.trc
-rw-r----- 1 oracle oinstall 1072 Jan 31 02:42 operdb_lgwr_7924.trc
-rw-r----- 1 oracle oinstall 675 Jan 31 02:47 operdb_arc0_7988.trc
-rw-r----- 1 oracle oinstall 813 Jan 31 02:47 operdb_arc2_7992.trc
-rw-r----- 1 oracle oinstall 1019 Jan 31 02:49 operdb_arc1_7990.trc
-rw-r----- 1 oracle oinstall 815 Jan 31 02:55 operdb_arc2_11996.trc
-rw-r----- 1 oracle oinstall 1385 Jan 31 03:55 operdb_arc1_11994.trc
-rw-r----- 1 oracle oinstall 4612 Jan 31 03:58 operdb_arc0_11992.trc
-rw-r----- 1 oracle oinstall 5635 Jan 31 03:59 operdb_pmon_11964.trc
-rw-r----- 1 oracle oinstall 1077 Jan 31 03:59 operdb_lgwr_11972.trc
-rw-r----- 1 oracle oinstall 801 Jan 31 04:12 operdb_p002_18150.trc
-rw-r----- 1 oracle oinstall 799 Jan 31 04:12 operdb_p001_18148.trc
-rw-r----- 1 oracle oinstall 799 Jan 31 04:12 operdb_p000_18146.trc
-rw-r----- 1 oracle oinstall 3860 Jan 31 04:13 operdb_dbw0_18094.trc
-rw-r----- 1 oracle oinstall 815 Jan 31 04:18 operdb_arc2_18156.trc
-rw-r----- 1 oracle oinstall 955 Jan 31 22:00 operdb_lgwr_18096.trc
-rw-r--r-- 1 oracle oinstall 58428 Jan 31 22:00 alert_operdb.log
-rw-r----- 1 oracle oinstall 16959 Feb 1 03:13 operdb_arc0_18152.trc
-rw-r----- 1 oracle oinstall 79453 Feb 1 03:16 operdb_arc1_18154.trc
[root@oper-db ~]# su - rozan
[rozan@oper-db ~]$ tail /uo01/app/oracle/admin/operdb/bdump/alert_operdb.log
tail: cannot open `/uo01/app/oracle/admin/operdb/bdump/alert_operdb.log' for reading: Permission denied
[rozan@oper-db ~]$

What are the permissions for directory bdump? and please put code tags around any code or output you want to post like "[code]ls -l[/code"] remove quotes.

Code:

[root@oper-db ~]# ls -ltr /uo01/app/oracle/admin/operdb
total 48
drwxr-x---  2 oracle oinstall 4096 Jan 31 02:39 dpdump
drwxr-x---  2 oracle oinstall 4096 Jan 31 02:39 cdump
drwxr-x---  2 oracle oinstall 4096 Jan 31 02:42 pfile
drwxr-x---  2 oracle oinstall 4096 Jan 31 04:12 udump
drwxr-x---  2 oracle oinstall 4096 Jan 31 21:13 adump
drwxrwxrwx  2 oracle oinstall 4096 Feb  1 02:22 bdump
[root@oper-db ~]#

With this permission set on directory:

Code:

drwxrwxrwx 2 oracle oinstall 4096 Feb 1 02:22 bdump

and -rw-r--r-- for the file, user Rozan should be able to read it, I'm blank here, maybe someone else could help you on this topic, again I'll request you to format your posts with code tags, you'll get reply more quickly to a formatted query than the other one. Thanks.

Thank you for your time and support
Best regards
Faruque