Home » RDBMS Server » Server Utilities » Error starting Oracle Database
Error starting Oracle Database [message #73368] Fri, 02 April 2004 07:02 Go to next message
denny
Messages: 9
Registered: August 2002
Junior Member
ORA-16038: log 4 sequence# 3812 cannot be archived

ORA-19502: write error on file "", blockno (blocksize=)

ORA-00312: online log 4 thread 1: 'D:oracleoradatauhtdredo04_01.log'

 

I get this when I try to start the database at the SQL prompt after logging in internal

Report message to a moderator

Re: Error starting Oracle Database [message #73377 is a reply to message #73368] Tue, 06 April 2004 01:58 Go to previous messageGo to next message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Hi,

Some suggestions:

1. Ensure your archive log directory is writeable (by oracle) and has sufficient free space for new archives.

2. Verify your archive related INIT.ORA parameters (log_archive_dest or log_archive_dest_1 is set to a valid directory; log_archive_format is valid; log_archive_dest_state_* is enabled; etc.).

3. Disable ARCHIVELOGMODE for the entire database (not a good idea, but will solve your problem).

Best regards.

Frank

Report message to a moderator

Re: Error starting Oracle Database [message #73396 is a reply to message #73368] Wed, 14 April 2004 06:35 Go to previous messageGo to next message
carlos llerena
Messages: 1
Registered: April 2004
Junior Member
error ora-01000 número maximo de cursores abiertos excedidos.
Que debo hacer?

Report message to a moderator

Re: Error starting Oracle Database [message #73404 is a reply to message #73396] Sat, 17 April 2004 00:31 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9097
Registered: November 2002
Location: California, USA
Senior Member
Ensure that your program closes the cursors.
(Asegure que su programa cierre los cursores.)

Modify your program to use fewer cursors.
(Modifica su programa para utilizar menos cursores.)

Change the value of the parmater OPEN_CURSORS in INIT.ORA, then restart Oracle.
(Cambie el valor del parámetro OPEN_CURSORS en INIT.ORA, entonces empieza el Oráculo otra vez.)

Report message to a moderator

Re: Error starting Oracle Database [message #73523 is a reply to message #73396] Sat, 15 May 2004 04:43 Go to previous message
Mukesh
Messages: 8
Registered: March 2002
Junior Member
sir,
i my problum is sql is not login to any user or database his error is initalization or shut down progress. plz help me.

Report message to a moderator

Previous Topic: snapshot not get exported
Next Topic: EXP-00032 Error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 16:09:32 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.