I have
a unix user id and when I log into that user id and goto sqlplus I
have
problem to login to sqlplus with using my service name.
For example the following login with tnsnames (service name) was
successful and there was no problem using tcp protocol.
SQL> connect myuserid/mypassword@myservicena
me
Connected.
My problem:
When I don't use tnsnames and want to use ipc protocol then I get
the following
error.
SQL> connect myuserid/mypassword
ERROR:
ORA-01034: ORACLE not available
ORA-27121: unable to determine size of shared memory segment
SVR4 Error: 13: Permission denied
Answer to your problem:
=======================
Make sure file 'oracle' has the following permissions:
cd $ORACLE_HOME/bin
6751
If not...
1. Login as oracle user
2. Shutdown (normal) the db
3. Go to $ORACLE_HOME/bin
4. Execute the following
chmod 6751 oracle
5. Check the file permissions on oracle using the following
ls -l oracle
they should be:
-rwsr-s--x
Startup the db and try connecting as
dba or non-oracle user.
if this will not work:
- make sure permisions on oracle filesystems are set correctly (
set to 755)
- filesystem must be mounted with correct setuid