unable to connect to oracle as root user

[Sangeeta Gupta]

hi,

We have migrated our systems from alpha (running tru64 unix) to itanium(hp-ux 11i)
Earlier we could do sqlplus being a root user but now on our new system we are unable to do so.
Example:
$ sqlplus system/manager
ERROR:
ORA-01034: ORACLE not available
ORA-27121: unable to determine size of shared memory segment
HPUX-ia64 Error: 13: Permission denied

When i connect is as "sqlplus system/manager@" it works fine.
it also works fine if i try to connect as oracle user.

I am not sure what setting have been done by system administrators neither am familiar with much of system admin knowledge
I need some pointer/reference as to know more about this error so that i can try to get into the root cause and can fix it.

Thanks in advance
Sangeeta

[Wouter Jagers · Accepted solution]

Check this URL:
http://www.dbforums.com/printthread.php?t=499807

Cheers

[Luk Vandenbussche]

Check your environment variables for oracle when you are root

$ORACLE_HOME
$ORACLE_BASE
$ORACLE_SID

[Yogeeraj_1]

hi sangeeta,

these are the typical entries that are kept in the .profile of the users who will be running Oracle tools.

export DISPLAY=mysrver.domain.mu:0.0
export ORACLE_SID=mydb
export JAVA_HOME=/opt/java1.4
export PERL5LIB=/opt/perl/lib
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/10.2.0
export PATH=/opt/perl/bin:$PATH:/sbin:/usr/sbin:/etc:/usr/ccs/bin:/usr/bin:$ORAC
LE_HOME/bin:$JAVA_HOME/jre
CLASSPATH=/u01/app/oracle/product/10.2.0/jre:/u01/app/oracle/product/10.2.0/jlib
:.
export TMP=/var/tmp
export TMPDIR=/var/tmp
export TMP_DIR=/var/tmp
export TEMP=/var/tmp


can you try something similar and let us know?

kind regards
yogeeraj

[Sangeeta Gupta]

Thanks a lot for all your inputs.
My problem is solved by doing following as suggested in the link referred by Wouter :
cd $ORACLE_HOME/bin
chmod 6751 oracle.

Regards,
Sangeeta