Oracle Database not working

Hi Gurus,

I tried to start up the database by issuing the command on my Dev server

c:\>sqlplus/nolog

connect / as sysdba

"startup,"

and I am getting the following error:

ORA-03113 end-of-file on communication channel

And the second time I issued the command, I got the following errors:

ORA-24324 service handle not initialized

ORA-01041 internal error. hostdef extension doesn't exist.

O.S IS WINDOWS 2003.

ORACLE RDBMS Version: 10.2.0.2.0

Pls advice.

Thanks.

SAP Managed Tags:
Oracle Database

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (2)

which options was chosen when running CHKDSK?

was Oracle UP and RUNINNG when CHKDSK ran?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi eric,

When we restarted the server ,it automatically started running chkdsk and we didnt cancelled it.so the oracle database was down when chkdsk was running.

After the chkdsk finished and once windows booted we were unable to start the database.

Regards.

Check that owner of the database are able to write to all the fileareas.

Check that you are using sqlplus.exe located in %ORACLE_HOME\bin and not in e.g. the ooracle_client dir.

Remember the space between 'sqlplus' and '/nolog'

Regards

Audun

HI,

Check Oracle Services should be up.(Run -> Services.msc)

Surendra Jain

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi,

All the services are up.These problem happened after running the chkdsk.Below is the details of alert.log file,pls have a look:

Dump file c:\oracle\dev\102\rdbms\trace\alert_dev.log

Wed Aug 04 20:12:35 2010

ORACLE V10.2.0.2.0 - Production vsnsta=0

vsnsql=14 vsnxtr=3

Windows Server 2003 Version V5.2 Service Pack 1

CPU : 4 - type 586, 2 Physical Cores

Process Affinity : 0x00000000

Memory (Avail/Total): Ph:3169M/3743M, Ph+PgF:23279M/23643M, VA:1930M/2047M

Wed Aug 04 20:12:35 2010

Errors in file c:\oracle\dev\102\rdbms\trace\dev_ora_3396.trc:

ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_kxfpmxdf+7] [PC:0xB14C0F] [ADDR:0xB14C08] [UNABLE_TO_WRITE] []

Dump file c:\oracle\dev\102\rdbms\trace\alert_dev.log

Wed Aug 04 20:22:21 2010

ORACLE V10.2.0.2.0 - Production vsnsta=0

vsnsql=14 vsnxtr=3

Windows Server 2003 Version V5.2 Service Pack 1

CPU : 4 - type 586, 2 Physical Cores

Process Affinity : 0x00000000

Memory (Avail/Total): Ph:3290M/3743M, Ph+PgF:23349M/23643M, VA:1930M/2047M

Wed Aug 04 20:22:21 2010

Errors in file c:\oracle\dev\102\rdbms\trace\dev_ora_2964.trc:

ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_kxfpmxdf+7] [PC:0xB14C0F] [ADDR:0xB14C08] [UNABLE_TO_WRITE] []

Wed Aug 04 20:28:27 2010

Errors in file c:\oracle\dev\102\rdbms\trace\dev_ora_2400.trc:

ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_kxfpmxdf+7] [PC:0xB14C0F] [ADDR:0xB14C08] [UNABLE_TO_WRITE] []

Thu Aug 05 10:45:15 2010

Errors in file c:\oracle\dev\102\rdbms\trace\dev_ora_5716.trc:

ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_kxfpmxdf+7] [PC:0xB14C0F] [ADDR:0xB14C08] [UNABLE_TO_WRITE] []

Thanks.

hi nadeem,

please tell about chkdsk mean it is successfully scanned.

second check permission of that folder.

3rd. did you restart your server.

regards,

Hi majamil,

The chkdsk was successfully done as per system admin.

Do you mean folder permission of oracle Home ??

Yes,the server has been restarted number of times,but same issue.

Thanks.

HI,

Contact to oracle for ORA-07445 or see the MetaLink note Note:208922.1

http://www.dba-oracle.com/t_ora_07445_exception_encountered.htm

Dear Nadeem,

your oracle Database was started with incorrect ORA_NLS10 parameter, so now you have to follow these steps

1. SQL> shutdown

2. Set the parameter NLS to the correct value as per MOS Note ID - 553264.1

3. SQL> Startup

this should be solve your issue....

Regards,

What about the space on your drives, do you have enough space for files to grow?

Also check your permissions on the files specified.

Chris

Hi,

There is enough free space and reqd permission on the oracle folder --(

Thanks.

provide contents of file c:\oracle\dev\102\rdbms\trace\dev_ora_3396.trc

Dump file c:\oracle\dev\102\rdbms\trace\dev_ora_3396.trc

Wed Aug 04 20:12:35 2010

ORACLE V10.2.0.2.0 - Production vsnsta=0

vsnsql=14 vsnxtr=3

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production

Process Id: 0x0000098c Thread Id : 0x00000d44 Time : Wed Aug 04 20:12:35

Excp. Code: 0xc0000005 Excp. Type: ACCESS_VIO Flags: 0x00000000

Registers -

eip = 00b14c0f esp = 04bfd3a4 ebp = 04bfd405 edi = 04ac80a0 esi = 04bfd3e0

eax = 00b14c08 ebx = 04c8bb8d ecx = 04bfd35d edx = 04bfd3d4

ecs = 0000001b eds = 00000023 ees = 00000023 ess = 00000023

egs = 00000000 efs = 0000003b

eflags = 00010202

End of Registers -

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production

With the Partitioning, OLAP and Data Mining options

Windows Server 2003 Version V5.2 Service Pack 1

CPU : 4 - type 586, 2 Physical Cores

Process Affinity : 0x00000000

Memory (Avail/Total): Ph:3169M/3743M, Ph+PgF:23279M/23643M, VA:1930M/2047M

Instance name: dev

Redo thread mounted by this instance: 0 <none>

Oracle process number: 0

Windows thread id: 3396, image: ORACLE.EXE (SHAD)

2010-08-04 20:12:35.704

ksedmp: internal or fatal error

ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_kxfpmxdf+7] [PC:0xB14C0F] [ADDR:0xB14C08] [UNABLE_TO_WRITE] []

Current SQL information unavailable - no SGA.

Call Stack Trace -

calling call entry argument values in hex

location type point (? means dubious value)

_kxfpmxdf+7 00000000

A0608A23 CALL??? 00000000

Binary Stack Dump -

========== FRAME [1] (_kxfpmxdf+7 -> 00000000) ==========

Inaccessible memory range: 00000000 -> 00000400

========== FRAME [2] (A0608A23 -> 00000000) ==========

Dump of memory from 0x04BFD405 to 0x04BFD505

4BFD400 04BFD464 608A23C9 04AC80A0 [d....#.`....]

4BFD410 03218A54 04C8004C 04C8BB8C 04ACAD60 [T.!.L.......`...]

4BFD420 00000000 00000000 00000061 000000BB [........a.......]

4BFD430 00000001 04A19B50 04A19B80 00000000 [....P...........]

4BFD440 00000000 04A19B80 04C68080 04C805C4 [................]

4BFD450 04C8004C 03218A54 04ACAD60 031FF3F0 [L...T.!.`.......]

4BFD460 04AC80B0 04BFD48C 608E68C1 04AC80A0 [.........h.`....]

4BFD470 03218A54 04C8004C 04C805C4 00000000 [T.!.L...........]

4BFD480 00194FE0 00194FE0 00000000 04BFDB64 [.O...O......d...]

4BFD490 0044807A 04AC80A0 03218A54 04C8004C [z.D.....T.!.L...]

4BFD4A0 00000000 00000000 00000000 00000000 [................]

Repeat 5 times

4BFD500 00000000 00000000 [........]

Argument/Register Address Dump -

End of Call Stack Trace -

===================================================

PROCESS STATE

Process global information:

process: 00000000, call: 00000000, xact: 00000000, curses: 00000000, usrses: 00000000

No process is allocated.

KSFD PGA DUMPS

Number of completed I/O requests=0 flags=0

END OF PROCESS STATE

PINNED BUFFER HISTORY (oldest pin first)

SGA is not mapped - only buffer DBAs will be dumped

END OF PINNED BUFFER HISTORY

No block in buffer pin history is suitable for redo dump.

No cursors.

Archival Runtime State -

SGA unmapped

End of Archival Runtime State -

Hi eric,

the file dev_ora_3396.trc is too large to paste it here.let me know how should i send it to you:

Thanks for your help.

Hi Gurus,

Just want to share that the problem has been solved,by reinstalling the windows server 2003 O.S using REPAIR option.

Thanks...

Dear All,

In our case after restarting the server solved the issue.

Kind Regards,

Gulam

Ask a Question

Top Q&A Solution Author

User

Count