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:[EMAIL PROTECTED]] 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:[EMAIL PROTECTED]] 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 || [EMAIL PROTECTED] || <)))>< */ <<Robert D. Yexley (E-mail).vcf>> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Theodoros Demosthenous INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
