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]

Hi Reza,

Check the document, below;

Note 328822 - AIX kernel extension for Oracle

Best regards,

Orkun Gedik

[Former Member]

Hi Orkun,

My Oracle run on Windows and not AIX. And I have this problem on middel of upgrade after the shadow instance was createt.

Thanks

[Former Member]

Sorry, I couldn't see the system running on Windows. Ok, did you applied the latest db patches? When did you faced with this error? Was the database able to started, successfully before the upgrade?

Additionally, could you check the alert log?

[Former Member]

Thanks for reply.

No I did not applied the latest db patches. I faced this problem middel on Upgrdae on Pre-processing.  I did used this note  1734716 - ORA-01034: Oracle not available , but did not help.

Thanks

[Former Member]

Hi,

Let's move step by step. Startup the database and get the error. Then, try to shutdown the database and get the second error. So, startup the database again and execute the statement below.

SQL> show parameter background_dump_dest

Then, goto the path referred by the statement and upload "alert_<SID>.log". If it is large to upload, you can zip it.

SQL> show parameter user_dump_dest

Then, goto the path referred by the statement and upload latest .trc file.

Best regards,

Orkun Gedik