Home » RDBMS Server » Server Administration » ORA-01034 and ORA-27101 (URGENT)
ORA-01034 and ORA-27101 (URGENT) [message #64082] Mon, 13 December 2004 17:19 Go to next message
valiBasha
Messages: 9
Registered: September 2004
Junior Member
Sir . Our system is Windows 2000 server and Database Oracle 9i.It is a district server.I got problem that when i enter username and password in oracle it displays a message

ORA-01034: ORACLE NOT AVAILABLE

ORA-27101:SHARED MEMORY RELM DOES NOT EXIST.

I saw it is mounted but it is not able to open the database.

I stop all oracle services and shutdown the system and restarted again. Then i tried to conncet but it displays 

ORA-01092 ORACLE INSTANCE TERMINATED DISMOUNTED FORCE.

Please help me  any way.

Thank u for giving the valuable suggestions
Re: ORA-01034 and ORA-27101 (URGENT) [message #64085 is a reply to message #64082] Mon, 13 December 2004 19:52 Go to previous messageGo to next message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
Check your ALERT.LOG file (dir /s alert*.log&#124more).
This file will contain more desriptive error
messages.

Best regards.

Frank
Re: ORA-01034 and ORA-27101 (URGENT) [message #64181 is a reply to message #64082] Tue, 28 December 2004 03:05 Go to previous message
Jaymala
Messages: 1
Registered: December 2004
Junior Member
Hi,

This is because the database instance is not started. Try the following.

SQL>connect sys/(password) AS SYSDBA
SQL>STARTUP PFILE=c:oracleadminpfileinit.ora

(password)= password set for sys account
Previous Topic: plz. clarify
Next Topic: Partitioning
Goto Forum:
  


Current Time: Thu Jan 09 22:29:00 CST 2025