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

In Article: 15194 of comp.databases.oracle I wrote:

>I met a "strange" situation, anyone can help me?
>
> Under an end user account, I cannot connect ORACLE, such as
> [sqlplus|sqlforms30|sqlrep] userid/passwd, even sys and system.
> BUT sqldba can connect internal.
>
> Under the user oracle account, I can connect ORACLE, such as
> [sqlplus|sqlforms30|sqlrep] userid/passwd, even the end userid/passwd.
>
> The error message I got from sqlplus under the end user account is:
>
> 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.

Thanks Beverly of Oak Ridge National Laboratory for giving the solution:

1. Login as oracle.
2. cd bin
3. chmod 4751 oracle.

I still do not know why it works by changing the original 755 of $ORACLE_HOME/bin/oracle to new 4751 since it works OK before what is happening. If I find it is interesting, I will post it again here.

Thanks all others giving me suggestions too.

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