Oracle9R2

William F. O'Neill wrote:

 > Just upgraded today to Oracle9R2. The upgrade was 'successful.' In
 > attempting to 'start' Oracle thru EM, I received an error msg #ORO-27101 -
 > "shared memory realm does not exist." I looked in the Initialization
 > parameters, and the value there was 0. What should this value be, and will
 > inserting this value allow me to start the DB?
 > PS - not a DB, but a developer, attempting to learn more about Oracle.

The value of "what" was zero?

And the operating system is?

If Windows start the database service ... perhaps use oradim to recreate it.

If *NIX recheck your kernel parameters

In the future ... two things.
1. Exactly what version? 9R2 could be any one of 6 different things
2. Exactly what operating system and hardware platform
--
Daniel A. Morgan
University of Washington
damorgan.DeleteThis@x.washington.edu
(replace 'x' with 'u' to respond)
 >> Stay informed about: Oracle9R2 

William F. O'Neill wrote:
 > I cannot use SQLPlus either, because of this error message. Any
other
 > suggestions?
 >


  > > SQL> startup
  > >

YOu most certainly CAN use SQL*Plus:

start->run->cmd.exe

 >From here typs (the c:\> prompt should be used as an example only):

c:\> set ORACLE_SID=<your database name here>

c:\> sqlplus /nolog

you should see something similar to:

SQL*Plus: Release 9.2.0.1.0 - Production on Sun Mar 13 18:27:51 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL>

At THAT point type:

SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup

And see what transpires. You should see something similar to:

ORACLE instance started.

Total System Global Area 246139296 bytes
Fixed Size 731552 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 10526720 bytes
Database mounted.
Database opened.
SQL>

It's apparent you have not set the service to autostart the instance at
boot; use ORADIM to do this:

c:\> oradim -startup -sid=<your database name here>
-starttype=srvc,inst -pfile=<your parameter file, and path, here>

This SHOULD set the service to start the instance as well at boot.


David Fitzjarrell
 >> Stay informed about: Oracle9R2 

I cannot use SQLPlus either, because of this error message. Any other
suggestions?

wrote in message

 > SQL> startup
 >
 >> Stay informed about: Oracle9R2 

'Shared memory Pool"
Am using Oracle 9.2.0.1.0 on WINXP Pro.
Am using Oracle in a non-network environment (standalone).
Daniel:
Again, am not a DBA....What should the kernel parameters be, and where would
I find them? Thank,
Bill....

"DA Morgan" wrote in message

 > William F. O'Neill wrote:
 >
  >> Just upgraded today to Oracle9R2. The upgrade was 'successful.' In
  >> attempting to 'start' Oracle thru EM, I received an error msg
  >> #ORO-27101 - "shared memory realm does not exist." I looked in the
  >> Initialization parameters, and the value there was 0. What should this
  >> value be, and will inserting this value allow me to start the DB?
  >> PS - not a DB, but a developer, attempting to learn more about Oracle.
 >
 > The value of "what" was zero?
 >
 > And the operating system is?
 >
 > If Windows start the database service ... perhaps use oradim to recreate
 > it.
 >
 > If *NIX recheck your kernel parameters
 >
 > In the future ... two things.
 > 1. Exactly what version? 9R2 could be any one of 6 different things
 > 2. Exactly what operating system and hardware platform
 > --
 > Daniel A. Morgan
 > University of Washington

 > (replace 'x' with 'u' to respond)
 >> Stay informed about: Oracle9R2 

William F. O'Neill wrote:

 > 'Shared memory Pool"
 > Am using Oracle 9.2.0.1.0 on WINXP Pro.
 > Am using Oracle in a non-network environment (standalone).
 > Daniel:
 > Again, am not a DBA....What should the kernel parameters be, and where would
 > I find them? Thank,
 > Bill....

There are no kernel parameters in Windows. Were you working in *NIX you
would have known what they were.

Most likely the problem is that the Windows services didn't start.
Start
Settings
Control Panel
Administrative Tools
Services

Does the OracleService show as started?
If not start it ... if so stop it and restart it
Try again

If that doesn't work.

Start
Run
Cmd
NET STOP OracleService<sid_name_from_control_panel_service>
NET START OracleService<sid_name_from_control_panel_service>

Carefully record any error messages seen in their totality.

--
Daniel A. Morgan
University of Washington
damorgan.DeleteThis@x.washington.edu
(replace 'x' with 'u' to respond)
 >> Stay informed about: Oracle9R2 

On Sun, 13 Mar 2005 18:17:14 -0500, William F. O'Neill wrote:

 > Just upgraded today to Oracle9R2. The upgrade was 'successful.' In
 > attempting to 'start' Oracle thru EM, I received an error msg #ORO-27101 -
 > "shared memory realm does not exist." I looked in the Initialization

This means that the database instance was not started.

Windows - check your services. Otherwise, startup in sqlplus
command line, in sysdba mode
 >> Stay informed about: Oracle9R2 

Hi Daniel:
Thank you for responding. One of the first things I did was to check the
Services, and Settings/Services indicated that oracleservicemisc was
'started.'
However, I did what you suggested with NET STOP, and NET START. No error
message of any type, only a message to say the operation was 'successful.'
At this point, I went into EM, and attempted to open the instance of MISC.
Error Message from EM: Ora-01092 "Oracle instance terminated. Disconnection
forced."
This original instance was created with an earlier version of Oracle, eg.
9.0.1.1 - and I have been attempting to upgrade it to 9.2.0.1, which is
where I got the error on 'shared memory realm does not exist.'
At this point, what is your next suggestion? and I do appreciate the
help....
Bill...

"DA Morgan" wrote in message

 > William F. O'Neill wrote:
 >
  >> 'Shared memory Pool"
  >> Am using Oracle 9.2.0.1.0 on WINXP Pro.
  >> Am using Oracle in a non-network environment (standalone).
  >> Daniel:
  >> Again, am not a DBA....What should the kernel parameters be, and where
  >> would I find them? Thank,
  >> Bill....
 >
 > There are no kernel parameters in Windows. Were you working in *NIX you
 > would have known what they were.
 >
 > Most likely the problem is that the Windows services didn't start.
 > Start
 > Settings
 > Control Panel
 > Administrative Tools
 > Services
 >
 > Does the OracleService show as started?
 > If not start it ... if so stop it and restart it
 > Try again
 >
 > If that doesn't work.
 >
 > Start
 > Run
 > Cmd
 > NET STOP OracleService<sid_name_from_control_panel_service>
 > NET START OracleService<sid_name_from_control_panel_service>
 >
 > Carefully record any error messages seen in their totality.
 >
 > --
 > Daniel A. Morgan
 > University of Washington

 > (replace 'x' with 'u' to respond)
 >> Stay informed about: Oracle9R2 

William F. O'Neill wrote:
 > Hi Daniel:
 > Thank you for responding. One of the first things I did was to check the
 > Services, and Settings/Services indicated that oracleservicemisc was
 > 'started.'
 > However, I did what you suggested with NET STOP, and NET START. No error
 > message of any type, only a message to say the operation was 'successful.'
 > At this point, I went into EM, and attempted to open the instance of MISC.
 > Error Message from EM: Ora-01092 "Oracle instance terminated. Disconnection
 > forced."
 > This original instance was created with an earlier version of Oracle, eg.
 > 9.0.1.1 - and I have been attempting to upgrade it to 9.2.0.1, which is
 > where I got the error on 'shared memory realm does not exist.'
 > At this point, what is your next suggestion? and I do appreciate the
 > help....
 > Bill...

The Oracle service that has started ... is it the one for the database
or the one for the EOM repository? You need to verify that both are
are started. You may be testing the wrong one.
--
Daniel A. Morgan
University of Washington
damorgan RemoveThis @x.washington.edu
(replace 'x' with 'u' to respond)
 >> Stay informed about: Oracle9R2 

Hi Daniel:
These are the Services that are in 'Start' mode:
OracleMTSRecoveryService
OracleOrahome90Agent
OracleOrahomeTNSListener
OracleServiceConsol
OracleServiceMisc

I tested the Consol & Misc Services with Net Stop & Net Start. Misc is the
one I'm having problems with, trying to upgrade it to 9.2.0.1.0. Consol
works fine, and I can connect to to it. MISC - I cannot connect to it thru
OEM or SQLPlus.

Bill....
"DA Morgan" wrote in message

 > William F. O'Neill wrote:
  >> Hi Daniel:
  >> Thank you for responding. One of the first things I did was to check the
  >> Services, and Settings/Services indicated that oracleservicemisc was
  >> 'started.'
  >> However, I did what you suggested with NET STOP, and NET START. No error
  >> message of any type, only a message to say the operation was
  >> 'successful.' At this point, I went into EM, and attempted to open the
  >> instance of MISC. Error Message from EM: Ora-01092 "Oracle instance
  >> terminated. Disconnection forced."
  >> This original instance was created with an earlier version of Oracle, eg.
  >> 9.0.1.1 - and I have been attempting to upgrade it to 9.2.0.1, which is
  >> where I got the error on 'shared memory realm does not exist.'
  >> At this point, what is your next suggestion? and I do appreciate the
  >> help....
  >> Bill...
 >
 > The Oracle service that has started ... is it the one for the database
 > or the one for the EOM repository? You need to verify that both are
 > are started. You may be testing the wrong one.
 > --
 > Daniel A. Morgan
 > University of Washington

 > (replace 'x' with 'u' to respond)
 >> Stay informed about: Oracle9R2 

William F. O'Neill wrote:
 > Hi Daniel:
 > These are the Services that are in 'Start' mode:
 > OracleMTSRecoveryService
 > OracleOrahome90Agent
 > OracleOrahomeTNSListener
 > OracleServiceConsol
 > OracleServiceMisc
 >
 > I tested the Consol & Misc Services with Net Stop & Net Start. Misc is the
 > one I'm having problems with, trying to upgrade it to 9.2.0.1.0. Consol
 > works fine, and I can connect to to it. MISC - I cannot connect to it thru
 > OEM or SQLPlus.
 >
 > Bill....

What problems... Just the 'Shared memory realm does not exist'?

Did you upgrade your consol instance, or just misc?
What about this (and please, cut/paste the results!)
Open command session (Start -> Run -> cmd)
c:\> set oracle_sid=consol
c:\> sqlplus /nolog
SQL> connect / as sysdba
SQL> startup

--
Regards,
Frank van Bortel
 >> Stay informed about: Oracle9R2 

William F. O'Neill wrote:
 > I cannot use SQLPlus either, because of this error message. Any
other
 > suggestions?
 >


  > > SQL> startup
  > >


You most certainly CAN use SQL*Plus:

start->run->cmd.exe

 >From this point type the following (the c:\> prompt should be used as
an example only):

c:\> set ORACLE_SID=<your database name here>

c:\> sqlplus /nolog

you should see something similar to:

SQL*Plus: Release 9.2.0.1.0 - Production on Sun Mar 13 18:27:51 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL>

At THAT point type:

SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup

And see what transpires. You should see something similar to:

ORACLE instance started.

Total System Global Area 246139296 bytes
Fixed Size 731552 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 10526720 bytes
Database mounted.
Database opened.
SQL>

It's apparent you have not set the service to autostart the instance at
boot; use ORADIM to do this:

c:\> oradim -startup -sid=<your database name here>
-starttype=srvc,inst -pfile=<your parameter file, and path, here>

This SHOULD set the service to start the instance as well at boot.


David Fitzjarrell
 >> Stay informed about: Oracle9R2 

William F. O'Neill wrote:
 > I cannot use SQLPlus either, because of this error message. Any
other
 > suggestions?
 >


  > > SQL> startup
  > >

William F. O'Neill wrote:
 > I cannot use SQLPlus either, because of this error message. Any
other
 > suggestions?
 >


  > > SQL> startup
  > >

YOu most certainly CAN use SQL*Plus:

start->run->cmd.exe

 >From this point type the following (the c:\> prompt should be used as
an example only):

c:\> set ORACLE_SID=<your database name here>

c:\> sqlplus /nolog

you should see something similar to:

SQL*Plus: Release 9.2.0.1.0 - Production on Sun Mar 13 18:27:51 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL>

At THAT point type:

SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup

And see what transpires. You should see something similar to:

ORACLE instance started.

Total System Global Area 246139296 bytes
Fixed Size 731552 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 10526720 bytes
Database mounted.
Database opened.
SQL>

It's apparent you have not set the service to autostart the instance at
boot; use ORADIM to do this:

c:\> oradim -startup -sid=<your database name here>
-starttype=srvc,inst -pfile=<your parameter file, and path, here>

This SHOULD set the service to start the instance as well at boot.



David Fitzjarrell
 >> Stay informed about: Oracle9R2 

William F. O'Neill wrote:

 > Hi Daniel:
 > These are the Services that are in 'Start' mode:
 > OracleMTSRecoveryService
 > OracleOrahome90Agent
 > OracleOrahomeTNSListener
 > OracleServiceConsol
 > OracleServiceMisc
 >
 > I tested the Consol & Misc Services with Net Stop & Net Start. Misc is the
 > one I'm having problems with, trying to upgrade it to 9.2.0.1.0. Consol
 > works fine, and I can connect to to it. MISC - I cannot connect to it thru
 > OEM or SQLPlus.
 >
 > Bill....

The above indicates you have a database whose SID is Misc.
Is that the working database or the OEM repository database?
Either way it is only one database and you have indicated that
you have two. Where is the other one?

The only services, fromthe above, that need to be started are
OracleOrahomeTNSListener and OracleServiceMisc but this is
still only one of what you seem to have indicated is two
databases.
--
Daniel A. Morgan
University of Washington
damorgan.RemoveThis@x.washington.edu
(replace 'x' with 'u' to respond)
 >> Stay informed about: Oracle9R2