Hi,
I have installed Oracle 11g R2 on Red Hat 6. My problem is that I cannot access sqlplus from users other than oracle.
I have set the PATH, ORACLE_HOME and ORACLE_SID to the correct values.
Session1
login as: oracle
oracle@192.168.202.128's password:
Last login: Sun Aug 24 01:24:46 2014 from 192.168.202.1
[oracle@localhost ~]$ echo $PATH
/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/bin:/home/oracle/app/oracle/product/11.2.0/dbhome_1/bin
[oracle@localhost ~]$ echo $ORACLE_HOME
/home/oracle/app/oracle/product/11.2.0/dbhome_1
[oracle@localhost ~]$ echo $ORACLE_SID
orcl
[oracle@localhost ~]$ sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Sun Aug 24 03:17:32 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter user-name:
Session2
login as: prithwish
prithwish@192.168.202.128's password:
Last login: Sun Aug 24 02:31:49 2014 from 192.168.202.1
[prithwish@localhost ~]$ export PATH=$PATH:/home/oracle/app/oracle/product/11.2.0/dbhome_1/bin
[prithwish@localhost ~]$ export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1
[prithwish@localhost ~]$ export ORACLE_SID=orcl
[prithwish@localhost ~]$ echo $ORACLE_HOME
/home/oracle/app/oracle/product/11.2.0/dbhome_1
[prithwish@localhost ~]$ echo $ORACLE_SID
orcl
[prithwish@localhost ~]$ echo $PATH
/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/prithwish/bin:/home/oracle/app/oracle/product/11.2.0/dbhome_1/bin
[prithwish@localhost ~]$ sqlplus
-bash: sqlplus: command not found
I assume that I could not access sqlplus beacuse the user prithwish does not have access to /home/oracle
[prithwish@localhost ~]$ cd ..
[prithwish@localhost home]$ ls -ltr
total 8
drwx------. 30 oracle oinstall 4096 Aug 23 23:51 oracle
drwx------. 27 prithwish prithwish 4096 Aug 24 02:33 prithwish
[prithwish@localhost home]$
My question is ,though quite silly, two fold
1) I will need to change the permission of the oracle directory to 755 for other user to access sqlplus?
2) Why is the user directory under home folder created with permissions 700 even when the umask is set at 002? Will changing the permissions of the oracle directory under /home cause any security concerns?
Apologies for being naive . This is the first time I have installed Oracle on UNIX
Regards,
Prithwsh