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]

I will try to cleanup the memory segments manually,

And no I  didnot ran the utlrp.sql etc. scripts after the upgrade . Can I run it now middel on my upgrdae?

Thanks

[Former Member]

Well, I missed one question.. 🙂 Did you upgraded/patched Oracle as part of the SAP upgrade?

If so, you should make sure that these kind of scripts (mentioned in the upgrade guide) are executed correctly.

Sorry for the confusion.

Kind regards,

Mark

[Former Member]

Well I did  mis undrestand your question, I am upgradeing sap installation and not Oracle,

and I did rester server but it did not help,

Thanks

[Former Member]

After restet I did tried to start Oracle:

C:\Users\Administrator>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Oct 15 16:58:20 2012

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

Connected to an idle instance.

SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 1352953856 bytes
Fixed Size                  2254984 bytes
Variable Size             687867768 bytes
Database Buffers          654311424 bytes
Redo Buffers                8519680 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 3772
Session ID: 44 Serial number: 3

SQL> shutdown immediate
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL>

Thanks

[Former Member]

Could you check the database alert log and usertrace logs and upload here please?