Re: Cannot connect DB under end user act, but can under oracle!

In <CrGwsv.1woH_at_yuma.ACNS.ColoState.EDU> litao_at_CS.ColoState.EDU (wu litao) writes:
> Enter user-name: system
> Enter password:
> ERROR: ORA-01034: ORACLE not available
> ORA-07320: smsget: shmat error when trying to attach sga.
> SVR4 Error: 13: Permission denied
 

>Oh, I should mention that oracle and the end user have same
>environment.

Too much of the same environment. Check out the permissions on the $ORACLE_HOME/bin/oracle binary. It should be -rws--x--x, if the 's' is missing there is a problem. To correct it, as root type   # chmod 4711 $ORACLE_HOME/bin/oracle

>Thanks in advance!
 

>--
>Litao Wu
>Computer Science Department Phone: (303)491-8119(H) (303)440-3300(O)
>Colorado State University Email: litao_at_cs.colostate.edu
>Fort Collins, CO 80523
>--
>Litao Wu
>Computer Science Department Phone: (303)491-8119
>Colorado State University Email: litao_at_cs.colostate.edu
>Fort Collins, CO 80523

-- 
andy_at_genie.geis.com |  Andy Finkenstadt, GEnie Sysop, GEnie Postmaster
andy_at_tml.com        |  Systems Engineer, TML Information Services, Inc.
genie_at_panix.com     |  +1 718-793-9099