RE: 9i R2 not automatically starting up after upgrade

2002-06-14 Thread Yexley Robert D Contr Det 1 AFRL/WSI

That was the problem.  I checked out that registry entry, and then looked in the 
directory that it was pointing to, and there was no init.ora file in that directory.  
I looked at the one that was in my previous ORACLE_HOME, copied and pasted it into the 
directory in the new ORACLE_HOME (the one that the registry entry was pointing to) and 
rebooted, and now it works fine.  Evidently for some reason or other, the 
init.ora file didn't get copied over into the new ORACLE_HOME during the upgrade. 
 Thanks for the advice.

_YEX_
<)))><

-Original Message-
Sent: Friday, June 14, 2002 12:24 PM
To: Multiple recipients of list ORACLE-L


The parameter to look in the registry is

ORA_ORA9I_PFILE

and points to the parameter file.

Make sure that it is located there.

Regards

-Original Message-
Sent: Friday, June 14, 2002 6:16 PM
To: '[EMAIL PROTECTED]'


Check whether the service finds your init.ora file.

The parameter in the registry might point to a different location for the service.

You can find the parameter file and copy paste it to the location that the service is 
looking for it.

I hope that this will help.

Regards
Theodoros

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Friday, June 14, 2002 5:44 PM
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 ---> 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]
|| <)))><
*/

 <> 
-- 
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: 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 sub

Re: 9i R2 not automatically starting up after upgrade

2002-06-14 Thread Igor Neyman

Robert,

Check _AUTORTART key in Windows registry (regedit.exe) under
HKEY_LOCAL_MACHINE\Software\Oracle\Home.
Set this key to TRUE, thus telling Oracle to automatically startup/open the
db, when Oracle service is starting.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, June 14, 2002 10:43 AM


> 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 ---> 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]
> || <)))><
> */
>
>  <>
> --
> 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: Igor Neyman
  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).



RE: 9i R2 not automatically starting up after upgrade

2002-06-14 Thread Theodoros Demosthenous

Check whether the service finds your init.ora file.

The parameter in the registry might point to a different location for the service.

You can find the parameter file and copy paste it to the location that the service is 
looking for it.

I hope that this will help.

Regards
Theodoros

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Friday, June 14, 2002 5:44 PM
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 ---> 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]
|| <)))><
*/

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



RE: 9i R2 not automatically starting up after upgrade

2002-06-14 Thread Seefelt, Beth


The database should start when you start the service if the registry
entry ORA__AUTOSTART is set to TRUE.  When you upgraded the
database, did the ORA__* 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 ---> 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]
|| <)))><
*/

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



RE: 9i R2 not automatically starting up after upgrade

2002-06-14 Thread Theodoros Demosthenous

The parameter to look in the registry is

ORA_ORA9I_PFILE

and points to the parameter file.

Make sure that it is located there.

Regards

-Original Message-
Sent: Friday, June 14, 2002 6:16 PM
To: '[EMAIL PROTECTED]'


Check whether the service finds your init.ora file.

The parameter in the registry might point to a different location for the service.

You can find the parameter file and copy paste it to the location that the service is 
looking for it.

I hope that this will help.

Regards
Theodoros

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Friday, June 14, 2002 5:44 PM
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 ---> 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]
|| <)))><
*/

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



RE: 9i R2 not automatically starting up after upgrade

2002-06-14 Thread Yexley Robert D Contr Det 1 AFRL/WSI

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 ---> 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]
|| <)))><
*/

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



RE: 9i R2 not automatically starting up after upgrade

2002-06-14 Thread Theodoros Demosthenous

Are you using a domain to connect to your PC.

You should go into services and OracleService ---> 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]
|| <)))><
*/

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



9i R2 not automatically starting up after upgrade

2002-06-13 Thread Yexley Robert D Contr Det 1 AFRL/WSI

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
Description: Binary data