OraFAQ Forum: Server Administration » Problem Re-Starting the database instance

Home » RDBMS Server » Server Administration » Problem Re-Starting the database instance

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

Problem Re-Starting the database instance [message #132764]

Tue, 16 August 2005 01:34

d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta

Senior Member

hi all,
I need some help in detecting the problem on re-starting the database instance.
We are having oracle 9i version:-9.2.0.1
When i want to restrat the database ,i simply go to the services in control panel of my windows server 2003 standard edition.And stop the instance of my data base (orcl).
But the problem is this operation hangs (means a stopping message is shown instaed of stopped message). And also its shows an windows error of unable to stop the service. So to restart the database instance i have to restart the server again. But it should not be the proper way.
I check the alert_orcl.log file and it points me towards a trace file to see the error.
The error in the trace file at udump is as below:-
---------------------------------------------
FATAL ERROR IN TWO-TASK SERVER:error = 12571
ksedmp: internal or fatal error.
ORA-01089: immediate shutdown in progress - no operations are permited.
---------------------------------------------
Is any one have idea reagrding this error.
If i want to restart the instance through enterprise manager,the operation also hangs(means showing the shutdown in progress for a long time).
What may be the cause.
Thanks
regds
Dinesh

Report message to a moderator

Re: Problem Re-Starting the database instance [message #132800 is a reply to message #132764]

Tue, 16 August 2005 04:58

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

Source: http://p204.ezboard.com/farikaplangeneraldiscussionboard.showMessage?topicID=794.topic

fact: Oracle Server - Enterprise Edition
symptom: Errors appear in alert file
symptom: FATAL ERROR IN TWO-TASK SERVER:
symptom: ERROR = 12571
symptom: trace file generated
symptom: Database operations continue successfully
cause: The most common cause for the above error is an ungraceful
disconnection of a session from the oracle db while the db is currently running
a dml statement issued by that session. The error is recorded when oracle
attempts to reply back to the session with the results of the dml and cannot
access the session. Overall database operations are usually not affected.

An ungraceful disconnection could cause by but is not limited to any of the
following:
- the client machine crashed
- the network connection crashed
- the user exited the session improperly (not issuing the 'exit' command)
- the user application allows the user to exit the application without properly
terminating the session.

The above can cause problems with corrupted rollback segments if occurring on a
regular basis and is not addressed. This would require db recovery and
possibly a db rebuild (not a light matter)

PMON will usually rollback most transactions in the rollback segments for a
session if it finds that the session has been ungracefully disconnected, but
there is always a chance that it cannot and this will lead to rollback segment
corruption.

fix:

The dml and the user that issued the dml can be determined from the trace file.
The current dml is in the tracefile header section. The user can be found in
the process state dump of the trace. The process state shows the machine,
o/suser, and user for the session.

The DBA can use this information to determine what the user was doing at the
time and if there was an ungraceful exit from the session the user was
utilizing.

The DBA should then address the cause of the ungraceful exit to reduce the
possibility of reoccurance.

Report message to a moderator

Re: Problem Re-Starting the database instance [message #132812 is a reply to message #132800]

Tue, 16 August 2005 05:51

d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta

Senior Member

Thanks girish,
All these things are related to the restarting the server,but as i am restarting the database instance at that time no one is connected to the data-base.I am the only one doing the activity.

Thanks again
dinesh

Report message to a moderator

Previous Topic:	View all procedures
Next Topic:	high parse to execute ratio

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 26 10:21:08 CST 2025