Question Re: Oracle Database startup issue in Technology Q&A

Oracle Database startup issue

Former Member — Mon, 15 Oct 2012 13:49:18 GMT

I am middel on upgrade SAP BW from 7.0 to 7.3. After shadow instance was create the disp+work it stops for source and shadow instance. Is it some thing to do with shared memory? I am getting following errors when i am starting database

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

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

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

Re: Oracle Database startup issue

Former Member — Mon, 15 Oct 2012 13:56:20 GMT

Hi Reza,

Check the document, below;

Note 328822 - AIX kernel extension for Oracle

Best regards,

Orkun Gedik

Re: Oracle Database startup issue

Former Member — Mon, 15 Oct 2012 14:05:05 GMT

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

Re: Oracle Database startup issue

Former Member — Mon, 15 Oct 2012 14:17:25 GMT

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?

Re: Oracle Database startup issue

Former Member — Mon, 15 Oct 2012 14:27:57 GMT

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

Re: Oracle Database startup issue

Former Member — Mon, 15 Oct 2012 14:28:32 GMT

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

Re: Oracle Database startup issue

Former Member — Mon, 15 Oct 2012 14:33:55 GMT

Hello Mark,

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

Thanks.

Re: Oracle Database startup issue

Former Member — Mon, 15 Oct 2012 14:42:13 GMT

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

Re: Oracle Database startup issue

Former Member — Mon, 15 Oct 2012 14:49:22 GMT

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

Re: Oracle Database startup issue

Former Member — Mon, 15 Oct 2012 14:52:20 GMT

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

Re: Oracle Database startup issue

Former Member — Mon, 15 Oct 2012 14:57:28 GMT

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

Re: Oracle Database startup issue

Former Member — Mon, 15 Oct 2012 15:00:10 GMT

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

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

Re: Oracle Database startup issue

Former Member — Mon, 15 Oct 2012 15:03:05 GMT

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

Re: Oracle Database startup issue

stefan_koehler — Mon, 15 Oct 2012 16:01:46 GMT

Hi Ejersbo,

this has nothing to do with patches or memory. Your local server time does not match the domain server time and as a result the authentication failed.

Just sync your server time with the DC and it will work again.

http://blogs.msdn.com/b/sanket/archive/2006/11/02/synchronizing-machine-time-with-domain-controller.aspx

Regards

Stefan

Re: Oracle Database startup issue

Former Member — Mon, 15 Oct 2012 18:17:19 GMT

Hi Stefan,

I did Synchronizing machine time with domain controller but I have stil the same problem, My problem start during sap BW upgrade after Shadow instance cretet.

Thanks

Re: Oracle Database startup issue

stefan_koehler — Mon, 15 Oct 2012 19:16:41 GMT

Hi Ejersbo,

have you closed your previous SQL*Plus session and restarted the instance afterwards? If not please proceed as the following:

*** New SQL*Plus session ***
SQL> shutdown abort;
SQL> startup

If the issue still persists - please zip the alert.log file and attach it here.

Just out of curiosity. What's that for an ORACLE_HOME path "C:\app\Administrator\product\11.2.0\dbhome_1\"? That does not look like a SAP installation. Maybe there is something wrong with your environment as well.

Regards

Stefan

Re: Oracle Database startup issue

Former Member — Mon, 15 Oct 2012 21:11:34 GMT

Hi Stefan,

I have closed sql*plus session as you mention,

My ORACLE_HOME path is C:\app\Administrator\product\11.2.0\dbhome_1

Thanks

Re: Oracle Database startup issue

Former Member — Tue, 16 Oct 2012 05:13:35 GMT

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

Re: Oracle Database startup issue

Former Member — Tue, 16 Oct 2012 06:17:58 GMT

Hi,

I have this log file:

Trace file C:\ORACLE\BW1\SAPTRACE\diag\rdbms\bw1\bw1\trace\bw1_arc0_1648.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V6.1 Service Pack 1
CPU                 : 4 - type 8664, 4 Physical Cores
Process Affinity    : 0x0x0000000000000000
Memory (Avail/Total): Ph:6347M/8191M, Ph+PgF:33452M/36861M
VM name             : VMWare Version (6)
Instance name: bw1
Redo thread mounted by this instance: 1
Oracle process number: 17
Windows thread id: 1648, image: ORACLE.EXE (ARC0)

*** 2012-10-15 12:35:13.675
*** SESSION ID:(44.3) 2012-10-15 12:35:13.675
*** CLIENT ID:() 2012-10-15 12:35:13.675
*** SERVICE NAME:() 2012-10-15 12:35:13.675
*** MODULE NAME:() 2012-10-15 12:35:13.675
*** ACTION NAME:() 2012-10-15 12:35:13.675

Initial buffer sizes: read 1024K, overflow 832K, change 805K

*** 2012-10-15 12:35:14.737
ORA-19815: WARNING: db_recovery_file_dest_size of 31457280000 bytes is 100.00% used, and has 0 remaining bytes available.
************************************************************************
You have following choices to free up space from recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
   then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
   BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
   reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
   system command was used to delete files, then use RMAN CROSSCHECK and
   DELETE EXPIRED commands.
************************************************************************
*** 2012-10-15 12:35:14.737 4320 krsh.c
ARC0: Error 19809 Creating archive log file to 'E:\ORACLE\BW1\ORAFLASH\BW1\ARCHIVELOG\2012_10_15\O1_MF_1_1824_%U_.ARC'
*** 2012-10-15 12:35:14.737 2932 krsi.c
krsi_dst_fail: dest:1 err:19809 force:0 blast:1
DDE: Problem Key 'ORA 312' was flood controlled (0x1) (no incident)
ORA-00312: online log 4 thread 1: 'E:\ORACLE\BW1\MIRRLOGB\LOG_G14M2.DBF'
DDE: Problem Key 'ORA 312' was flood controlled (0x1) (no incident)
ORA-00312: online log 4 thread 1: 'C:\ORACLE\BW1\ORIGLOGB\LOG_G14M1.DBF'
ORA-00312: online log 4 thread 1: 'E:\ORACLE\BW1\MIRRLOGB\LOG_G14M2.DBF'
*** 2012-10-15 12:35:14.769 4481 kcrr.c

I did tried to increase db_recovery_file_dest_size parameter with but:

SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 8G COPE=BOTH SID='*';

ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 8G COPE=BOTH SID='*'

ERROR at line 1:

ORA-01034: ORACLE not available

Process ID: 0

Session ID: 0 Serial number: 0

Any idea?

Thanks

Re: Oracle Database startup issue

Former Member — Tue, 16 Oct 2012 06:28:22 GMT

Hi,

Please check the below points.

Check archive log drive is full or not ...or any other dirve is full ..?...If full please move older logs to other location.
Please the share the latest log file "alert_BW1.log" probably on the location

C:\ORACLE\BW1\SAPTRACE\diag\rdbms\bw1\bw1\trace\alert_BW1.log

Regards

Sahil