FAQ
Forwarded message follows -------

(also see 136214.1 ?
"startup and shutdown related registry entry's
for 8i on windows NT - 2000"
)

Microsoft Servers and Utilities Technical Forum

Displayed below are the messages of the selected thread.

Thread Status: Closed

...

RDBMS Version: 8.1.7
Operating System and Version: Windows 2000 Advanced Server
Error Number (if applicable): ORA-27101

...
From: xxxxx xxxxx 19-Jan-01 14:45
Subject: Re : Database Startup via Windows 2000 Advanced Server
Services

One additional bit of information is that I can open up a DOS prompt
set my ORACLE_SID use and use svrmgrl. I first have
to do a shutdown abort, but can then do a startup and the database
works fine. No problems connecting or anything.
However, if I reboot after that, I return to the same issue. Even
after restarting the database manually, I cannot go into the
services and restart the database. I get the following message from
Microsoft Management Console: Could not start the
OracleServiceSTOEMADM service on Local Computer. Ther service did
not return an error. This could be an internal
Windows error or an internal service error. If the problem persists,
contact your system administrator. (STOEMADM is my
instance name). This definately points to a registry/services
problem. I still cannot find anything wrong in the registry or the
service..... Any ideas?

...

From: Oracle, Gina Thunder 23-Jan-01 21:33
Subject: Re : Database Startup via Windows 2000 Advanced Server
Services

Verify that ORACLE_SID is set and points to a valid 8.1.7 database
which is up and running. Previously when the
ORACLE_HOME or ORACLE_SID was set incorrectly, in the 'oracle' or
client user's environment, only ora-1034 was
reported. ORA-01034 "ORACLE not available" With 8.1.7, the ora-27101
is reporting that the shared memory key
generated by the client doesn't match any currently existing keys.
This is to be expected if the ORACLE_HOME used by the
client isn't the same as the one used to startup the database with
OR the ORACLE_SID is not correctly referencing the right
instance.

If your ORACLE_SID is correctly set, confirm that ORA_SID_AUTOSTART
of registry is set to TRUE. There was an
internal bug (1283305/1317791)logged on the autostart not working
properly, however, the bug was to be fixed in 8.1.7. Let
me know if you are still having problems after checking the above
parameters.

Gina
Oracle Support Services

...

From: xxxxx xxxxx 25-Jan-01 20:33
Subject: Re : Database Startup via Windows 2000 Advanced Server
Services

I found a TNS error that was occuring during service startup. If you
comment out the
SQLNET.AUTHENTICATION_SERVICES= (NTS) in your
$ORACLE_HOME/network/admin/sqlnet.ora file, the problem
goes away....

From: Oracle, Gina Thunder 30-Jan-01 16:34
Subject: Re : Database Startup via Windows 2000 Advanced Server
Services

Thank you for both of your updates to this post. New problems can be
posted by creating a new thread.

...

From: Oracle, Gina Thunder 26-Feb-01 14:48
Subject: Re : Re : Database Startup via Windows 2000 Advanced Server
Services

This issue is docuemented in bug
1522966. The workaround is to comment out the
SQLNET.AUTHENTICATION_SERVICES= (NTS) in your
%ORACLE_HOME%/network/admin/sqlnet.ora as has been
stated. This bug has a fix in patchset: : 8.1.7.0.1.

...

From: Oracle, Gina Thunder 02-May-01 22:21
Subject: Re : Re : Database Startup via Windows 2000 Advanced Server
Services

The latest 8.1.7 patch is 8.1.7.1.2. This patch needs to be applied
to 8.1.7.1.1 (this patch contains the fix). Both of these
patches can be found on MetaLink by using the "NEW! click here for
all product patches" link. The base bug is documented
within the readme as: 1336566. Thank you for this post.

...

Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved.
Legal Notices and Terms of Use.

Content-description: Text from file 'oracle-NT-shut-start-registry.txt'

Doc ID: Note:136214.1

registry entry's for 8i on Creation Date: 26-FEB-2001
windows NT - 2000 Last Revision
Type: BULLETIN Date: 03-APR-2001

Status: REVIEWED

PURPOSE

To give an overview of the startup and shutdown related registry entry's
for 8i on windows NT / 2000.

An overview of the startup and shutdown related entry's

note: there are 3 bugs with this functionality:

bug:1568668 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 foreseen in 8.1.7.1.

bug:724051 is that an NT shutdown does not perform a clean
database shutdown due to a change in behavior from WINNT 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.

bug:1397927 is about when using SQLNET.AUTHENTICATION_SERVICES= (NTS)
in sqlnet.ora the 8.1.7.0.0 service won't open the database with
an ora-12640 in the ORACLE_HOME\database\oradim.log.
the fix is on metalink -> product:sql*Net, Platform:MS Windows NT
patch 1522966.
This problem occures on windows 2000 only, not on windows NT4

...

RELATED DOCUMENTS

[BUG:1568668]
[BUG:724051]
[BUG:1397927]

.

Copyright (c) 1995,2000 Oracle
Corporation. All Rights Reserved. Legal
[Image] Notices and Terms of Use. [Image]

--Message-Boundary-18415--

------- End of forwarded message -------

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eric D. Pierce
INET: PierceED_at_csus.edu

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedMay 8, '01 at 7:27p
activeMay 8, '01 at 7:27p
posts1
users1
websiteoracle.com

1 user in discussion

Eric D. Pierce: 1 post

People

Translate

site design / logo © 2022 Grokbase