OraFAQ Forum: SQL & PL/SQL » Urgent : Errors :- ORA-01034 and ORA-27101

Home » SQL & PL/SQL » SQL & PL/SQL » Urgent : Errors :- ORA-01034 and ORA-27101

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Urgent : Errors :- ORA-01034 and ORA-27101 [message #208340]

Sat, 09 December 2006 11:28

lunate
Messages: 74
Registered: October 2006
Location: Pakistan

Member

hi all.

i have installed oracle 9i data base + form 6i on windows 2000 server.
after installation ,i also create two users and some tables , then restart my p.c.
after comming back, i re-opened my sql*pls prompt and form 6i developer and then enter user name as >SCOTT/TIGER.

But suddenly i got the errors.

Quote:

ORA-01034 > Oracle not available.
ORA-27101 >Shared Memory realm doesnot exit.

can some one help me how i can recover my oracle from these error ,and cause of these errors,is these or due to any virus damages or some othere causes .

please help me.
regards

[Updated on: Sat, 09 December 2006 11:30]

Report message to a moderator

Re: Urgent : Errors :- ORA-01034 and ORA-27101 [message #208341 is a reply to message #208340]

Sat, 09 December 2006 11:38

dba_blr
Messages: 43
Registered: December 2006

Member

Check if your database is open or not. It seems your database is not in open stage.

SQL>connect / as sysdba
SQL>select status from v$instance;

The above query should return "OPEN".

Report message to a moderator

Re: Urgent : Errors :- ORA-01034 and ORA-27101 [message #208342 is a reply to message #208340]

Sat, 09 December 2006 11:40

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Perhaps you just didn't wait long enough; Oracle needs some time to start up, it isn't 1-2-3 and here it is.

Wait a little bit longer and try again.

Report message to a moderator

Re: Urgent : Errors :- ORA-01034 and ORA-27101 [message #208348 is a reply to message #208342]

Sat, 09 December 2006 12:03

lunate
Messages: 74
Registered: October 2006
Location: Pakistan

Member

ya i wait for some minuts (10-15).
but u also know when we open oracle and try to sign-in just after desktop appear,there kind of error is some one else.
i may be unable to intialize the oracle.

but i m here not yet being able to connect as system/manager.

not what do think ,whats problem with my oracle ?

thanx for ur help.
regards,

Report message to a moderator

Re: Urgent : Errors :- ORA-01034 and ORA-27101 [message #208349 is a reply to message #208348]

Sat, 09 December 2006 12:07

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Is it MS Windows operating system? If so, go to Administrative tools - Services and check state of Oracle services. Try to STOP them and then START them again.

Report message to a moderator

Re: Urgent : Errors :- ORA-01034 and ORA-27101 [message #208350 is a reply to message #208348]

Sat, 09 December 2006 12:08

dba_blr
Messages: 43
Registered: December 2006

Member

try to connect as SYS AS SYSDBA instead of SYSTEM and check if your database is OPEN. If not issue the STARTUP command.

Report message to a moderator

Re: Urgent : Errors :- ORA-01034 and ORA-27101 [message #208351 is a reply to message #208350]

Sat, 09 December 2006 12:21

lunate
Messages: 74
Registered: October 2006
Location: Pakistan

Member

ok.i will try it 2morrow bcoz now time is 3:00 am here .
so i will tell u soon about your kind solutions
once again thanx for your sweat help.
regards.

Report message to a moderator

Re: Urgent : Errors :- ORA-01034 and ORA-27101 [message #208369 is a reply to message #208348]

Sat, 09 December 2006 22:47

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
not what do think ,whats problem with my oracle ?

No problem with oracle it is expected problem ( sometime).

for this you have to set Oracle Services "automatically".
Go >>> start ----> run ----> services.msc

and set "manual" to "automatic" >OracleService<sid>

then when ur OS restart it will automatically start oracle services.

hope this helps
Taj

Report message to a moderator

Re: Urgent : Errors :- ORA-01034 and ORA-27101 [message #208508 is a reply to message #208369]

Mon, 11 December 2006 02:39

lunate
Messages: 74
Registered: October 2006
Location: Pakistan

Member

thanx all my oracle is now working fine.
bye.

Report message to a moderator

Previous Topic:	How to write Linefeed Symbol (L above F) via UTL_FILE on VMS?
Next Topic:	create dynamic tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 12:20:38 CST 2024