Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-01034: ORACLE not available
Are you sure it's sgadef.dbf and not sgadefA.dbf?
If you're on Unix, go to $ORACLE_HOME and look for a directory called
'dbs'. Check the permissions on sgadefA.dbf in that directory. Here is
what they should look like:
-rw-r----- oracle dba ...... sgadefA.dbf
where 'oracle' is the username you set up to run Oracle.
suisum_at_ecn.ab.ca wrote:
> I got the following error. Please help.
>
> ORA-01034: ORACLE not available
> ORA-07318: smsget: open error when opening sgadef.dbf file.
> SVR4 Error: 13: Permission denied
>
> --
> Best regards,
--
![]() |
![]() |