look your alert and trace files
Printable View
look your alert and trace files
Thanks a lot,
I have restarted the server,now it is ok.
Nice to hear you resolved that :-)
this doc may help:
Bookmark Fixed font Go to End
Doc ID: Note:136214.1
Subject: Oracle8i: Startup, Shutdown Related Registry Entries on WindowsNT & Windows2000
Type: BULLETIN
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 26-FEB-2001
Last Revision Date: 26-SEP-2001
PURPOSE
To give an overview of the startup and shutdown related registry entries
for Oracle8i on WindowsNT and Windows2000.
SCOPE & APPLICATION
Oracle8i for WindowsNT and Windows2000.
Overview of the startup and shutdown related entries:
=====================================================
Note: there are three bugs associated with this functionality:
Shows that the shutdown options are not working on 8.1.7.0.0.
8.1.5 and 8.1.6 are NOT affected by this bug.
A fix is available in 8.1.7.1.1.
[BUG:724051]:
A WindowsNT shutdown does not perform a clean database shutdown due to
a change in behavior from WindowsNT SP4 and higher versions.
Stopping the service itself is working fine, the fix is placing an
ORAIMR8.dll in the Oracle_home\bin directory of the 8.1.6 database.
The dll itself is included in 8.1.7.0.0 and 8.1.6.3.1.
This bug occurs using SQLNET.AUTHENTICATION_SERVICES= (NTS) in
the sqlnet.ora, the 8.1.7.0.0 service will not open the database, and an
ORA-12640 is reported in the ORACLE_HOME\database\oradim.log.
The fix is available on MetaLink. It is patch 1522966, for
Product:SQL*Net, Platform:MS WindowsNT.
This problem occurs only on Windows2000, not on WindowsNT.
You need to have the following entries in the registry in
HKLM\SOFTWARE\ORACLE\HOMEx (where x = from 0 to ...):
Note: You can check if you are using the correct Oracle home by the variables
ORACLE_HOME (gives the path) and ORACLE_HOME_NAME (gives the oracle home
name) in the HKLM\SOFTWARE\ORACLE\HOMEx key.
Replace the _SID_ in the following entries with the SID of your database.
To Enable the "clean shutdown" of a Database when Stopping the Service:
=======================================================================
ORA_SID_SHUTDOWN:
Possible values: TRUE or FALSE.
Set this to TRUE to enable the proper shutdown of the database.
ORA_SID_SHUTDOWN_TIMEOUT:
Possible values: timeout in seconds (30 for example).
Sets the maximum time (in seconds) to wait for the shutdown to complete
before the service for a particular SID stops.
This timeout should be set high enough to give the database time to complete
the shutdown.
If this is lower then the time needed, you will not have a clean shutdown!
You can check this in the alert log.
ORA_SID_SHUTDOWNTYPE:
Possible Values: i , t , a
where n = shutdown normal
i = shutdown immediate
and a = shutdown abort
If the entries are not set, stopping a service will be WORSE then a shutdown
abort. WindowsNT and Windows2000 will just "clean" the memory. (This could be
compared to a 'kill -9' on a Unix system). This is likely to make any cold
backup useless.
Please also note there is another WindowsNT parameter called:
"WaitToKillServiceTimeout"
found in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control expressed in
microseconds (1000 microseconds make one second). This timeout should ALSO be
set high enough to give the database time to complete the shutdown (the default
is 20000). Contact Microsoft for more information about this parameter.
To enable the automatic opening of the database when you start the service:
===========================================================================
ORA_SID_AUTOSTART:
Possible values: TRUE or FALSE.
Set this to TRUE to enable the automatic startup of the database.
ORA_SID_PFILE:
Possible values: the full path to the init.ora file
(d:\ora8i\admin\pfile)
References:
===========
[BUG:724051] SHUTDOWN IMMEDIATE NOT ISSUED WHEN NT SERVER IS SHUTDOWN
.
--------------------------------------------------------------------------------
Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal Notices and Terms of Use.
good one
[Edited by ybadejo on 11-30-2001 at 11:29 AM]