ORA-1034 when connecting from UNIX with account other than oracle 
Author Message
 ORA-1034 when connecting from UNIX with account other than oracle

Here is my configuration:
Host OS:  IBM AIX 4.2.1
Oracle:    7.3.4

If logged into AIX as "oracle" the following command suceeds:

sqlplus scott/tiger

if I "su kcameron" (since there is not a "-" I still have all the
envirnment variable from the oracle account)

sqlplus scott/tiger

I get:  ora 1034  - oracle not available.

Any Ideas?

Thanks,
Kirk



Sat, 16 Jun 2001 03:00:00 GMT
 ORA-1034 when connecting from UNIX with account other than oracle

Quote:

> Here is my configuration:
> Host OS:  IBM AIX 4.2.1
> Oracle:    7.3.4

> If logged into AIX as "oracle" the following command suceeds:

> sqlplus scott/tiger

> if I "su kcameron" (since there is not a "-" I still have all the
> envirnment variable from the oracle account)

> sqlplus scott/tiger

> I get:  ora 1034  - oracle not available.

> Any Ideas?

The problem is that the oracle executable is not setuid to the ID of the
oracle user. Since the shared memory segments are owned by the oracle user,
attaching to them fails, thus causing the ORA-1034 error.

To fix it, do the following:
chown oracle $ORACLE_HOME/bin/oracle
chmod 4755 $ORACLE_HOME/bin/oracle

Sometimes the installer fails to do it.

--
                                        Rick
                                        Rick Wessman
                                        Security and Directory Technologies
                                        Server Technologies
                                        Oracle Corporation



Sun, 17 Jun 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. ORA-1034 (Oracle not Available) It's killing me

2. ORA-1034:ORACLE not available, LRM-00109

3. ORA-1034

4. NT Server Crash -> ORA-1034

5. dbassist fails with ORA-1034

6. Error: OWS-05566 due to ORA-1034

7. ORA-1034 for new SQL-Connections

8. ORA-1034 (not available) when importing from 8 using imp7

9. ORA-12505 Connecting to unix ORACLE 8.0.5

10. GA-Atlanta-45712--C++-UNIX-ORACLE-C++, Unix , Oracle

11. GA-Atlanta-45713--C++-UNIX-ORACLE-C++, Unix, Oracle


 
Powered by phpBB® Forum Software