Home » RDBMS Server » Server Administration » ORA-01034: ORACLE not available
ORA-01034: ORACLE not available [message #57098] Tue, 20 May 2003 13:04 Go to next message
Rama
Messages: 17
Registered: October 2001
Junior Member
When I am running the "sqlplus /" the following error is coming... [[Sun OS 5.8, Oracle 9i]]

SQL*Plus: Release 9.2.0.1.0 - Production on Tue May 20 23:57:05 2003

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

ERROR:
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
SVR4 Error: 13: Permission denied

Checked the ORACLE_SID and other env parameters also.

If anyone has some idea, please let me also know how to tackle this error.

thanks in advance.
Re: ORA-01034: ORACLE not available [message #57101 is a reply to message #57098] Tue, 20 May 2003 15:31 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
use sqlplus /nolog
Re: ORA-01034: ORACLE not available [message #57112 is a reply to message #57101] Wed, 21 May 2003 02:55 Go to previous message
pabolu
Messages: 1
Registered: May 2003
Junior Member
Hi Mahesh,

Thanks for the quick reply.

Even after using "sqlplus /" We need to connect to the databse. Still same error is coming.

Looks like some shared meemory permissions related problem for other users. But couldn't able to trace exactly where is the problem.

Do you have any idea, how to provide access to shared memory for other users?

cheers,
Previous Topic: 9i Online Validate index is Taking More time.
Next Topic: Alter tablespace
Goto Forum:
  


Current Time: Fri Sep 20 05:28:59 CDT 2024