 Problem when shutdown improperly [message #383945] |
Sat, 31 January 2009 23:03  |
pardxa
Messages: 11
Registered: January 2009
|
Junior Member |
|
|
hi,
I have installed oracle 10g on my windows OS,and cut the power off accidently.when I reboot the system,the oracle can't bootup automaticly.If I login into Sqlplus,it will be:
C:\>sqlplus system/mypwd
SQL*Plus: Release 10.2.0.1.0 - Production on 星期日 2月 1 12:59:34 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
so every time i had to do this:
c>sqlplus/nolog
SQL>conn sys/mypwd as sysdba
SQL>shutdown abort
SQL>startup
then the database will work properlly.
How can I recover the oracle and make it boot automaticlly just as before?
|
|
|
|
|
|
| Re: Problem when shutdown improperly [message #383953 is a reply to message #383949] |
Sun, 01 February 2009 00:47  |
pardxa
Messages: 11
Registered: January 2009
|
Junior Member |
|
|
thank you for reply.I have :
Checked the Windows service and it is in automtic startup.
and
Check registry in HKLM\Software\Oracle ,the database is set to startup when service starts:
Ora_dboracle_autostart is TRUE
I have changed nothing after problem come.
In fact,the oracle service looks start when system boots up,but the problem is still there.I guess the instance is running but database can't be mounted and openned automaticly.some one told me it is because the log files and the data/control files are not synchronized.and i do nothing (never add/update table/records) after the accident.So How can I make them recovered as synchronized?
|
|
|
|
|
|
| Re: Problem when shutdown improperly [message #383961 is a reply to message #383945] |
Sun, 01 February 2009 01:34 |
pardxa
Messages: 11
Registered: January 2009
|
Junior Member |
|
|
I have done the following:
>restart my PC;
>IN CONCOLE WINDOW:c:>sqlplus system/mypwd
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
>IN CONCOL WINDOW:c:>sqlplus sys/mypwd as sysdba
>SQL>shutdown immediate
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
>SQL>shutdown abort
>SQL>startup
>SQL>select * from tab;
---//IT NOW WORKS WELL WHEN TEST
>restart my PC;
>IN CONCOLE WINDOW:c:>sqlplus system/mypwd
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
---//THE PROBLEM IS STILL THERE!!!!
I have checked the alert file,seems nothing wrong?I attached it.
do I have to startup oracle manully?
|
|
|
|
|
|
|
|
|
|
| Re: Problem when shutdown improperly [message #384001 is a reply to message #383945] |
Sun, 01 February 2009 09:05 |
pardxa
Messages: 11
Registered: January 2009
|
Junior Member |
|
|
Sorry for not explained clearly.
I installed two oracle 10g(same version) on two virtual machines(Virtual Box)(same OS:windows server 2003 EM R2).they both works well before.But there are some bugs in Virtual Box:if to do something,the windows will be shut down on virtual machines.
so 2 oracle have same Error just as I mentioned above.
on one machine SID is DBORACLE,other is MYDB.
there is no wrong operation.
So any other possibility it would be?
|
|
|
|
|
|
| Re: Problem when shutdown improperly [message #384155 is a reply to message #384137] |
Mon, 02 February 2009 06:33 |
pardxa
Messages: 11
Registered: January 2009
|
Junior Member |
|
|
thank you for the reply.but there are two points I should make clear before test your method:
1>my pfile is in "C:\oracle\product\10.2.0\db_1\database\initmydb.ora" and the contents in it is :
SPFILE='C:\oracle\product\10.2.0\db_1/dbs/spfilemydb.ora'
so if I change the spfilemydb.ora's name,the oracle wouldn't bootup!How can I copy the contents from spfile to pfile?and changed the boot parameter file to pfile?
2>How to create another new spfile?give me more details please.
thanks again.
|
|
|
|
| Re: Problem when shutdown improperly [message #384258 is a reply to message #383945] |
Tue, 03 February 2009 00:52 |
pardxa
Messages: 11
Registered: January 2009
|
Junior Member |
|
|
Got an answer to this error,but not a good solution:
1>If you add environment variables:
ORACLE_SID
ORACLE_HOME
2>give a patch of oracle10gR2 10.2.0.2.0.(because my version is 10.2.0.1.0)
the error disapeared!!!
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Problem when shutdown improperly [message #384687 is a reply to message #383945] |
Wed, 04 February 2009 21:03 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
Tell me how to make my scooter go & then I'll solve your problem.
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you
>what I mean is his method doesn't work
claiming "doesn't work" provides NO, NO, NO meaningful or useful information to determine what might be wrong or possible fix.
a gazillion possible causes can be why it "doesn't work".
Since you provide us no useful information, you are free to solve this on your own.
>I installed two oracle 10g(same version) on two virtual machines(Virtual Box)(same OS:windows server 2003 EM R2)
I suspect that the cause is related OS misconfiguration.
[Updated on: Wed, 04 February 2009 21:14] Report message to a moderator |
|
|
|
|
|
|
|
| Re: Problem when shutdown improperly [message #385087 is a reply to message #384689] |
Fri, 06 February 2009 06:40 |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Try looking at the Event Viewer
(Start > Control Panel > Administrative Tools > Event Viewer)
That provides a lot of useful information about what happens during the boot up process.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
