Home » SQL & PL/SQL » SQL & PL/SQL » Urgent : Errors :- ORA-01034 and ORA-27101
icon5.gif  Urgent : Errors :- ORA-01034 and ORA-27101 [message #208340] Sat, 09 December 2006 11:28 Go to next message
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 Go to previous messageGo to next message
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".
Re: Urgent : Errors :- ORA-01034 and ORA-27101 [message #208342 is a reply to message #208340] Sat, 09 December 2006 11:40 Go to previous messageGo to next message
Littlefoot
Messages: 20894
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.
Re: Urgent : Errors :- ORA-01034 and ORA-27101 [message #208348 is a reply to message #208342] Sat, 09 December 2006 12:03 Go to previous messageGo to next message
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,
Re: Urgent : Errors :- ORA-01034 and ORA-27101 [message #208349 is a reply to message #208348] Sat, 09 December 2006 12:07 Go to previous messageGo to next message
Littlefoot
Messages: 20894
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.
Re: Urgent : Errors :- ORA-01034 and ORA-27101 [message #208350 is a reply to message #208348] Sat, 09 December 2006 12:08 Go to previous messageGo to next message
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.
Re: Urgent : Errors :- ORA-01034 and ORA-27101 [message #208351 is a reply to message #208350] Sat, 09 December 2006 12:21 Go to previous messageGo to next message
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.
Re: Urgent : Errors :- ORA-01034 and ORA-27101 [message #208369 is a reply to message #208348] Sat, 09 December 2006 22:47 Go to previous messageGo to next message
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
icon14.gif  Re: Urgent : Errors :- ORA-01034 and ORA-27101 [message #208508 is a reply to message #208369] Mon, 11 December 2006 02:39 Go to previous message
lunate
Messages: 74
Registered: October 2006
Location: Pakistan
Member

thanx all my oracle is now working fine.
bye.
Previous Topic: How to write Linefeed Symbol (L above F) via UTL_FILE on VMS?
Next Topic: create dynamic tables
Goto Forum:
  


Current Time: Mon Dec 05 09:10:20 CST 2016

Total time taken to generate the page: 0.06020 seconds