Oracle Database startup issue

[Former Member]

Hi

I am middel on upgrade SAP BW from 7.0 to 7.3. After shadow instance was create the disp+work it sto...

SQL> startup
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> shutdown immediate
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> show parameter;
ERROR:
ORA-03114: not connected to ORACLE

SQL>

-----------------------------------------------------------------------------------------

C:\app\Administrator\product\11.2.0\dbhome_1\BIN>Lsnrctl start

LSNRCTL for 64-bit Windows: Version 11.2.0.3.0 - Production on 15-OCT-2012 14:42
:50

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

TNS-01106: Listener using listener name LISTENER has already been started

----------------------------------------------------------------------------------------------

C:\app\Administrator\product\11.2.0\dbhome_1\BIN>Lsnrctl status

LSNRCTL for 64-bit Windows: Version 11.2.0.3.0 - Production on 15-OCT-2012 14:43
:26

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=BW1.WORLD))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.3.0 - Produ
ction
Start Date                15-OCT-2012 13:32:59
Uptime                    0 days 1 hr. 10 min. 27 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   C:\app\Administrator\product\11.2.0\dbhome_1\network\a
dmin\listener.ora
Listener Log File         C:\app\Administrator\diag\tnslsnr\BWMNT10\listener\ale
rt\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\BW1.WORLDipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\BW1ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=BWMNT10)(PORT=1527)))
Services Summary...
Service "BW1" has 1 instance(s).
  Instance "BW1", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

C:\app\Administrator\product\11.2.0\dbhome_1\BIN>

Any idea for this problem.

Thanks

[Former Member]

Could be that some shared memory segments are "corrupted".

Can you stop all Oracle processes, cleanup the memory segments used by Oracle (since it's Windows, probably a reboot of the server) and start the database again?

Kind regards,

Mark

[Former Member]

Hello Mark,

Can you guide me, how can I  cleanup the memory segments.

Thanks.

[Former Member]

Good question!

I'm not really Windows minded, but I know from experience that in many cases a reboot of the system is the only way to be sure that memory is cleaned up correctly.

One other option could be to stop the Oracle and SAP processes and check in the task manager if there are still processes active. These should be manually canceled.

One other question; did you ran the utlrp.sql etc. scripts after the upgrade?

Kind regards,

Mark