RE: 9i R2 not automatically starting up after upgrade

The database should start when you start the service if the registry entry ORA_<SID>_AUTOSTART is set to TRUE. When you upgraded the database, did the ORA_<SID>_* registry keys get moved into the new HKLM\Software\Oracle\HOMEx key, and removed from the old one? ORA-27101 can indicate its trying to start from the wrong ORACLE_HOME.

Beth

-----Original Message-----
[mailto:Robert.Yexley_at_wpafb.af.mil]
Sent: Friday, June 14, 2002 10:44 AM
To: Multiple recipients of list ORACLE-L

I tried that...didn't fix the problem. The service actually starts without any problems, but for some reason, starting the service doesn't actually start the database. I have to actually login to SQL*Plus in /nolog mode, connect / as sysdba and then do a startup manually to get the database running. Thanks though.

_YEX_
<)))><

-----Original Message-----
Sent: Friday, June 14, 2002 3:38 AM
To: Multiple recipients of list ORACLE-L

Are you using a domain to connect to your PC.

You should go into services and OracleService<SID> ---> Properties. In the Log On tab go and choose log on as this account and choose your username and password that you are connecting to the domain.

Stop and restart the service, and check that the memory is reserved for the instance.

Regards
Theodoros

-----Original Message-----
[mailto:Robert.Yexley_at_wpafb.af.mil]
Sent: Thursday, June 13, 2002 8:22 PM
To: Multiple recipients of list ORACLE-L

I upgraded a database yesterday from 9i R1 (9.0.1) to 9i R2 (9.2.0.1.0), and am now having problems with the database starting up automatically on system reboot. This is on a Windows 2000 Pro machine. The error that I get when I try to connect with SQL*Plus is "ORA-27101: shared memory realm does not exist". If I run SQL*Plus with the /nolog option, connect / as sysdba, and startup manually, everything works fine. Anyone have any idea why it won't startup automatically, or what I could try to get it to? Thanks.

_YEX_ /*
|| Robert D. Yexley
|| Oracle Programmer/Analyst
|| Easylink Services Corporation
|| Professional Services
|| Contractor - Wright Research Site MIS
|| Det-1 AFRL/WSI Bldg. 45 Rm. 062
|| (937) 255-1984
|| robert.yexley_at_wpafb.af.mil
|| <)))><

*/

 <<Robert D. Yexley (E-mail).vcf>>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Theodoros Demosthenous
  INET: theodoros_at_edams.com

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yexley Robert D Contr Det 1 AFRL/WSI
  INET: Robert.Yexley_at_wpafb.af.mil

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seefelt, Beth
  INET: Beth.Seefelt_at_TetleyUSA.com

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).