Oracle error



ORA-00495: GEN0 process terminated with error
Cause: The generic background processing process died.
Action: Warm start the instance.




See more oracle error here.

oracle error- ORA-00494: enqueue string held for too long (more than string seconds) by 'inst string, osid string'

Oracle error



ORA-00494: enqueue string held for too long (more than string seconds) by 'inst string, osid string'
Cause: The specified process did not release the enqueue within the maximum allowed time.
Action: Reissue any commands that failed and contact Oracle Support Services with the incident information.



See more oracle error here.

ORA-00493: GMON process terminated with error

Oracle error




ORA-00493: GMON process terminated with error
Cause: The ASM disk group monitor process died
Action: Warm start instance






See more oracle error here.

oracle error- ORA-00492: GTX* process terminated with error

Oracle error



ORA-00492: GTX* process terminated with error
Cause: A global transaction background process died.
Action: Warm start instance

See more oracle error here.

oracle error- ORA-00491: RMS0 process terminated with error

Oracle error

ORA-00491: RMS0 process terminated with error


Cause: The RAC Management Process died
Action: None



See more oracle error here.

oracle error- ORA-00490: PSP process terminated with error

Oracle error




ORA-00490: PSP process terminated with error
Cause: The process spawner died
Action: Warm start instance






See more oracle error here.

oracle error- ORA-00489: ARB* process terminated with error

Oracle error



ORA-00489: ARB* process terminated with error
Cause: An ASM rebalance worker process died.
Action: Wait for process to restart.







See more oracle error here.

oracle error- ORA-00488: RBAL process terminated with error

Oracle error




ORA-00488: RBAL process terminated with error
Cause: The ASM rebalance coordinator process died.
Action: Warm start instance.






See more oracle error here.

oracle error- ORA-00487: CTWR process terminated with error

Oracle error



ORA-00487: CTWR process terminated with error
Cause: The change tracking process died
Action: Warm start instance



See more oracle error here.

oracle error- ORA-00486: ASMB process terminated with error

Oracle error

ORA-00486: ASMB process terminated with error


Cause: An ASM background process died.
Action: Warm start instance. Also check that ASM Instance is running.




See more oracle error here.

oracle error- ORA-00485: DIAG process terminated with error string

Oracle error

ORA-00485: DIAG process terminated with error string


Cause: A global diagnostic process died
Action: Wait for process to restart



See more oracle error here.

oracle error- ORA-01049: Bind by name is not spupportted in streamed RPC

Oracle error
oracle, oracle error, oracle blog
ORA-01049: Bind by name is not spupportted in streamed RPC


Cause: A newer version of server is talking with this version requesting an operation not supported in this version.
Action: None

See more oracle error here.

oracle error- ORA-00484: LMS* process terminated with error

Oracle error

ORA-00484: LMS* process terminated with error


Cause: A global cache service process died
Action: Warm start instance



See more oracle error here.

oracle error- ORA-01051: deferred rpc buffer format invalid

Oracle error
oracle, oracle error, oracle blog
ORA-01051: deferred rpc buffer format invalid


Cause: The deferred rpc data in sys.def$_call is corrupted.
Action: Contact your customer support representive.



See more oracle error here.

oracle error- ORA-01048: Couldn't find the specified procedure in the given context

Oracle error
oracle, oracle error, oracle blog


ORA-01048: Couldn't find the specified procedure in the given context
Cause: The procedure user specified in deferred RPC doesn't exist.
Action: Check to make sure that the procedure exists and is visible to the replication process.



See more oracle error here.

oracle error- ORA-01045: user string lacks CREATE SESSION privilege; logon denied

Oracle error
oracle, oracle error, oracle blog
ORA-01045: user string lacks CREATE SESSION privilege; logon denied


Cause: A connect was attempted to a userid which does not have create session privilege.
Action: Grant the user CREATE SESSION privilege.

See more oracle error here.

oracle error- ORA-01044: size string of buffer bound to variable exceeds maximum string

Oracle error
oracle, oracle error, oracle blog
ORA-01044: size string of buffer bound to variable exceeds maximum string


Cause: An attempt was made to bind a buffer whose total size would exceed the maximum size allowed. Total array size for arrays is calculated as: (element_size)*(number of elements)
Action: Reduce buffer size.



See more oracle error here.

oracle error- ORA-01043: user side memory corruption [string], [string], [string], [string]

Oracle error
oracle, oracle error, oracle blog



ORA-01043: user side memory corruption [string], [string], [string], [string]
Cause: The application code corrupted some of the usr memory used by oracle
Action: Make sure that the application code is not overwriting memory.

See more oracle error here.

oracle error- ORA-01042: detaching a session with open cursors not allowed

Oracle error
oracle, oracle error, oracle blog



ORA-01042: detaching a session with open cursors not allowed
Cause: An attempt was made to detach a seesio n which had open cursors.
Action: Close all the cursors before detaching the session.




See more oracle error here.

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

Oracle error
oracle, oracle error, oracle blog



ORA-01041: internal error. hostdef extension doesn't exist
Cause: Pointer to hstdef extension in hstdef is null.
Action: Report as a bug



See more oracle error here.

oracle error- ORA-01040: invalid character in password; logon denied

Oracle error
oracle, oracle error, oracle blog


ORA-01040: invalid character in password; logon denied
Cause: There are multibyte characters in the password or some characters in the password are not in US7ASCII range.
Action: Resubmit password with valid characters.



See more oracle error here.

oracle error- ORA-01039: insufficient privileges on underlying objects of the view

Oracle error
oracle, oracle error, oracle blog


ORA-01039: insufficient privileges on underlying objects of the view
Cause: Attempting to explain plan on other people's view without the necessary privileges on the underlying objects of the view.
Action: Get necessary privileges or do not perform the offending operation.

See more oracle error here.

oracle error- ORA-00910: specified length too long for its datatype

Oracle error
oracle, oracle error, oracle blog


ORA-00910: specified length too long for its datatype
Cause: for datatypes CHAR and RAW, the length specified was > 2000; otherwise, the length specified was > 4000.
Action: use a shorter length or switch to a datatype permitting a longer length such as a VARCHAR2, LONG CHAR, or LONG RAW

See more oracle error here.

oracle error- ORA-00481: LMON process terminated with error

Oracle error







ORA-00481: LMON process terminated with error

Cause: The global enqueue service monitor process died
Action: Warm start instance


See more oracle error here.

oracle error- ORA-00482: LMD* process terminated with error

Oracle error


ORA-00482: LMD* process terminated with error
Cause: A global enqueue service daemon process died
Action: Warm start instance


See more oracle error here.

oracle error- ORA-00480: LCK* process terminated with error


Oracle error

ORA-00480: LCK* process terminated with error
Cause: A system lock process died
Action: Warm start instance

See more oracle error here.

oracle error- ORA-00479: RVWR process terminated with error string


Oracle error

ORA-00479: RVWR process terminated with error string
Cause: The RVWR process died
Action: Warm start instance

See more oracle error here.

oracle error- ORA-00478: SMON process terminated due to error string


Oracle error

ORA-00478: SMON process terminated due to error string
Cause: SMON was unable to service the requests due to error in cleanup of resources
Action: Warm start instance

See more oracle error here.

oracle error- ORA-00477: SNP* process terminated with error


Oracle error

ORA-00477: SNP* process terminated with error
Cause: A materialized view refresh process died
Action: PMON will restart SNP process shortly. If SNP process does not get started, contact Oracle support.

See more oracle error here.

Oracle error- ORA-00752: recovery detected a lost write of a data block

Oracle error
oracle, oracle error, oracle blog
ORA-00752: recovery detected a lost write of a data block


Cause: A write of a data block to storage was lost during normal database operation on the primary database.
Action: Shutdown the primary database and activate the physical standby database to failover. See the Data Guard Concepts and Administration guide for details.

See more oracle error here.

Oracle error-ORA-00751: could not obtain resilvering status for file

Oracle error
oracle, oracle error, oracle blog
ORA-00751: could not obtain resilvering status for file


Cause: An error occurred while obtaining the mirror resilvering status of a file.
Action: Refer to other error messages shown for additional details of the problem.



See more oracle error here.

oracle error- ORA-00476: RECO process terminated with error


Oracle error

ORA-00476: RECO process terminated with error
Cause: The distributed transaction (two-phase commit) recovery process died.
Action: Warm start instance

See more oracle error here.

oracle error- ORA-00475: TRWR process terminated with error


Oracle error

ORA-00475: TRWR process terminated with error
Cause: The system tracing process died
Action: Warm start instance

See more oracle error here.

oracle error- ORA-00474: SMON process terminated with error


Oracle error

ORA-00474: SMON process terminated with error
Cause: The system cleanup process died
Action: Warm start instance

See more oracle error here.

oracle error- ORA-00473: ARCH process terminated with erro



Oracle error

ORA-00473: ARCH process terminated with erro


Cause: The archive process died
Action: Warm start instance

See more oracle error here.

oracle error- ORA-00472: PMON process terminated with error


Oracle error

ORA-00472: PMON process terminated with error
Cause: The process cleanup process died
Action: Warm start instance

See more oracle error here.

oracle error- ORA-00470: LGWR process terminated with error


Oracle error

ORA-00471: DBWR process terminated with error
Cause: The database writer process died
Action: Warm start instance

See more oracle error here.

oracle error- ORA-00470: LGWR process terminated with error


Oracle error

ORA-00470: LGWR process terminated with error
Cause: The log writer process died
Action: Warm start instance

See more oracle error here.

oracle error- ORA-00469: CKPT process terminated with error


Oracle error

ORA-00469: CKPT process terminated with error
Cause: The checkpoint process died
Action: Warm start instance

See more oracle error here.

oracle error- ORA-00453: backgroud process 'string' is dead


Oracle error

ORA-00453: backgroud process 'string' is dead
Cause: The background process that was being messaged was dead or its incarnation was invalid.
Action: Restart the background process.

See more oracle error here.

oracle error- ORA-00452: foreground process unexpectedly terminated with error string


Oracle error

ORA-00452: foreground process unexpectedly terminated with error string
Cause: The foreground process for the new connection did not start.
Action: Reconnect to Oracle.

See more oracle error here.

oracle error- ORA-00451: foreground process died unexpectedly


Oracle error

ORA-00451: foreground process died unexpectedly
Cause: The foreground process for the new connection did not start.
Action: Reconnect to Oracle.

See more oracle error here.

oracle error- ORA-00450: background process 'string' did not start


Oracle error

ORA-00450: background process 'string' did not start
Cause: The specified process did not start.
Action: Consult the error code, and the trace file for the process.

See more oracle error here.

oracle error- ORA-00449: background process 'string' unexpectedly terminated with error string


Oracle error

ORA-00449: background process 'string' unexpectedly terminated with error string
Cause: A foreground process needing service from a background process has discovered the process died.
Action: Consult the error code, and the trace file for the process.

See more oracle error here.

oracle error- ORA-00446: background process started when not expected


Oracle error

ORA-00446: background process started when not expected
Cause: The background process specified started up AFTER the RDBMS was already running.
Action: If nobody at your site started the process, then this is an internal error.

See more oracle error here.

oracle error- ORA-00448: normal completion of background process


Oracle error

ORA-00448: normal completion of background process
Cause: One of the background processes completed normally (i.e. exited). The background process thinks that somebody asked it to exit.
Action: Warm start the system.

See more oracle error here.

oracle error- ORA-00447: fatal error in background process


Oracle error

ORA-00447: fatal error in background process
Cause: One of the background processes died unexpectedly.
Action: Warm start the system.

See more oracle error here.

oracle error- ORA-00445: background process "string" did not start after string seconds

Oracle error



ORA-00445: background process "string" did not start after string seconds

Cause: The specified process did not start after the specified time.
Action: Ensure that the background did not die and leave a trace file.



See more oracle error here.

oracle error- ORA-00404: Convert file not found: 'string'

Oracle error



ORA-00404:

Convert file not found: 'string'
Cause:The file used for converting the database from V7 to V8 could not be found.
Action:Verify that the migration process has been started on this database and that the convert filename is accessable.

oracle error- ORA-00568: Maximum number of interrupt handlers exceeded

Oracle error




ORA-00568: Maximum number of interrupt handlers exceeded
Cause: User specified too many ^c handlers
Action: Remove some old handlers.






See more oracle error here.

oracle error- ORA-00603: ORACLE server session terminated by fatal error

Oracle error




ORA-00603: ORACLE server session terminated by fatal error




Cause: An ORACLE server session was in an unrecoverable state.
Action: Login to ORACLE again so a new server session will be created


See more oracle error here.

oracle error- ORA-00567: Requested processor group string is too large (maximum string)

Oracle error



ORA-00567: Requested processor group string is too large (maximum string)
Cause: The process could not be started in the requested processor group.
Action: Start the process in another processor group.







See more oracle error here.

oracle error- ORA-00497: XDMG process terminated with error

Oracle error





ORA-00497: XDMG process terminated with error
Cause: The Cell automation manager process terminated with error.
Action: PMON will restart XDMG process shortly. If XDMG process does not restart, contact Oracle Support Services.







See more oracle error here.

oracle error- ORA-00496: LMHB process terminated with error

Oracle error




ORA-00496: LMHB process terminated with error
Cause: The LM heartbeat monitor process died.
Action: Warm start the instance.





See more oracle error here.

oracle error- ORA-00444: background process "string" failed while starting


Oracle error

ORA-00444: background process "string" failed while starting
Cause: Usually due to a bad (or non-existent) background process image.
Action: Get a good background process image.

See more oracle error here.

oracle error- ORA-00443: background process "string" did not start


Oracle error

ORA-00443: background process "string" did not start
Cause: The specified process did not start.
Action: Ensure that the executable image is in the correct place with the correct protections, and that there is enough memory.

See more oracle error here.

oracle error- ORA-00439: feature not enabled: string


Oracle error

ORA-00439: feature not enabled: string
Cause: The specified feature is not enabled.
Action: Do not attempt to use this feature.

See more oracle error here.

oracle error- ORA-00438: string Option not installed


Oracle error

ORA-00438: string Option not installed
Cause: The specified option is not installed.
Action: Purchase and install the option.

See more oracle error here.

oracle error- ORA-00437: ORACLE feature is not licensed. Contact Oracle Corp. for assistance


Oracle error

ORA-00437: ORACLE feature is not licensed. Contact Oracle Corp. for assistance
Cause: ORACLE feature is not licensed.
Action: Contact ORACLE for assistance.

See more oracle error here.

oracle error- ORA-00407: rolling upgrade from release string.string to string.string is not allowed


Oracle error

ORA-00409: COMPATIBLE needs to be string or higher to use AUTO SEGMENT SPACE MANAGEMENT
Cause: This is due to migrating from an older release of Oracle with tablespaces created using AUTO SEGMENT SPACE MANAGEMENT. To open the database, the COMPATIBLE parameter needs to be set to the specified value.
Action: Shutdown and startup with the specified compatibility setting.

See more oracle error here.

oracle error- ORA-00409: COMPATIBLE needs to be string or higher to use AUTO SEGMENT SPACE MANAGEMENT


Oracle error

ORA-00408: parameter string is set to TRUE
Cause: Reporting the parameter that resulted in the compatibility error.
Action: Shutdown and startup with a higher compatibility setting.

See more oracle error here.

Oracle error- ORA-00407: rolling upgrade from release string.string to string.string is not allowed


Oracle error

ORA-00407: rolling upgrade from release string.string to string.string is not allowed
Cause: Another instance executing software at a different point release already has the database mounted.
Action: Shutdown all instances then startup with the new software.

See more oracle error here.

Oracle error- ORA-00406: COMPATIBLE parameter needs to be string or greater


Oracle error

ORA-00406: COMPATIBLE parameter needs to be string or greater
Cause: The COMPATIBLE initialization parameter is not high enough to allow the operation. Allowing the command would make the database incompatible with the release specified by the current COMPATIBLE parameter.
Action: Shutdown and startup with a higher compatibility setting.

See more oracle error here.

Oracle error- ORA-00405: compatibility type "string"


ORA-00405: compatibility type "string"

Cause: Reporting a type associated with another error.
Action: See accompanying error


See more oracle error here.

oracle error- ORA-00403: %s (string) is not the same as other instances (string)

Oracle error



ORA-00403:

%s (string) is not the same as other instances (string)
Cause:Another instance has set the compatible or compatible no recovery parameters differently than this instance.
Action:Change the parameters of the current instance to match other instances already running.

oracle error- ORA-00402: database changes by release string cannot be used by release string

Oracle error





ORA-00402:

database changes by release string cannot be used by release string
Cause:Changes have been made to the database that require a newer software release or that violate the compatibility parameters.
Action:Use a version of the software that can understand the changes or relax the compatibility requirements in the init file

oracle error- ORA-00401: the value for parameter string is not supported by this release

Oracle error



ORA-00401:

the value for parameter string is not supported by this release
Cause:The value specified cannot be supported by this release of the software.
Action:Choose an appropriate value, or remove the parameter value to use the default value.

oracle error- ORA-00400: invalid release value string for parameter string

Oracle error





ORA-00400:

invalid release value string for parameter string
Cause:The release level given for the specified init parameter is invalid.
Action:Correct the parameter value in the parameter file and retry.

oracle error- ORA-00399: corrupt change description in redo log

Oracle error



ORA-00399:

corrupt change description in redo log
Cause:A change vector in the redo log failed validation checks.
Action:Do recovery with a good version of the log or do time based recovery up to the indicated time

oracle error- ORA-00398: abort thread recovery due to reconfiguration

Oracle error



ORA-00398:

abort thread recovery due to reconfiguration
Cause:Global enqueue service reconfiguration occurred during instance/crash recovery.
Action:This is used internally, no action is required.

ORA-00397: instance recovery process terminated with error

Oracle error





ORA-00397:

instance recovery process terminated with error
Cause:The foreground process doing instance recovery died.
Action:Check the foreground trace file for the cause of recovery failure.

Oracle- Recriando tablespace temp no oracle 11g no linux.

Primeiro vamos acessar o sqlplus e verificarmos onde esta armazenada a tablespace temporária do oracle.

oracle@meuservidor:~ sqlplus /nolog

sql>conn sys@brancoproducao as sysdba

sql>select name from v$tempfile;

/u01/app/oracle/oradata/temp01.dbf

2)Vamos criar uma tablespace intermediária:

sql>CREATE TEMPORARY TABLESPACE TEMP2
TEMPFILE '/u01/app/oracle/oradata/temp02.dbf' SIZE 5M REUSE
AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

3)Definimos essa tablespace temporária como default:

sql>ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP2;

4)Apagaremos  a tablespace TEMP antiga para que possamos recria-la novamente:

sql>DROP TABLESPACE TEMP INCLUDING CONTENTS AND DATAFILES;


5) Recriamos agora  a tablespace TEMP :

sql>CREATE TEMPORARY TABLESPACE TEMP
TEMPFILE '/u01/app/oracle/oradata/temp01.dbf' SIZE 100M REUSE
AUTOEXTEND ON NEXT 25M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

6) Definimos a tablespace temp como padrão novamente:

sql>ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP;

7) E finalizando o nosso  tutorial apagamos a tablespace temp2 já que ela não terá mais uso:

sql>DROP TABLESPACE TEMP2 INCLUDING CONTENTS AND DATAFILES;

oracle error- ORA-00396: error string required fallback to single-pass recovery

Oracle error



ORA-00396:

error string required fallback to single-pass recovery
Cause:The indicated error caused two-pass instance or crash recovery to fail. Recovery was retried with an alternate (slower) method to avoid the error.
Action:Correct the cause of the indicated error (also recorded) so that future instance or crash recovery can succeed with the two-pass algorithm. This usually requires making more main memory available to the recovery process.




oracle error- ORA-00395: online logs for the clone database must be renamed

Oracle error



ORA-00395:

online logs for the clone database must be renamed
Cause:A clone database open forces logfile renaming to avoid overwriting the primary logfiles
Action:Rename the logfiles manually or using the log_file_name_convert initialization parameter

oracle error- ORA-00394: online log reused while attempting to archive it

Oracle error



ORA-00394:

online log reused while attempting to archive it
Cause:It has been detected that an online log that is being archived has been reused
Action:Cannot archive the logfile anymore since it has been overwritten

oracle error- ORA-00393: log string of thread string is needed for recovery of offline datafiles

Oracle error



ORA-00393:

log string of thread string is needed for recovery of offline datafiles
Cause:Log cannot be cleared because the redo in it is needed to recover offline datafiles. It has not been archived so there is no other copy available. If the log is cleared the tablespaces containing the files will have to be dropped.
Action:Archive the log then repeat the clear command. If archiving is not possible, and dropping the tablespaces is acceptible, then add the clause UNRECOVERABLE DATAFILE at the end of the clear command.