ORA-01034 and ORA-27101 (URGENT) [message #64082] |
Mon, 13 December 2004 17:19 |
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 #64181 is a reply to message #64082] |
Tue, 28 December 2004 03:05 |
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
|
|
|