OraFAQ Forum: Server Administration » Question on ORA-XXXXX

Home » RDBMS Server » Server Administration » Question on ORA-XXXXX

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Question on ORA-XXXXX [message #118862]

Mon, 09 May 2005 07:35

Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland

Senior Member

We've a question raised by our application-supplier if all those ORA-Messages will be inserted into the alert.log.
If not they need to provide them from application-side.

ORA-00001: unique constraint violated
ORA-00020: maximum number of processes exceeded
ORA-00060: deadlock detected while waiting for resource
ORA-00372: file cannot be modified
ORA-00904: invalid identifier
ORA-00911: invalid character
ORA-00920: invalid relational operator
ORA-00933: SQL command not properly ended
ORA-00942: table or view does not exist
ORA-00955: name is already in use by excisting object
ORA-01033: Oracle initialization or in shutdown process
ORA-01036: illegal variable name/number
ORA-01110: data file ' '
ORA-01413: illegal value in packed decimal number buffer
ORA-01488: invalid nibble or byte in input data
ORA-01502: index ' ' or partition of such index is in unsuable state
ORA-01653: unable to extend tablespace
ORA-01654: unable to extend index
ORA-01722: invalid number
ORA-01756: quoted string not properly terminated
ORA-03113: end-of-file in communication channel
ORA-03114: not connected to ORACLE
ORA-04031: unable to allocate bytes of shared memory
ORA-04088: error during execution of trigger
ORA-06512: at ' ' line ' '
ORA-08103: object no longer exists
ORA-12541: no listener

Hope you can help me which messages will be written to alert.log. I know about -1653, -1654, -4031.

Thanks
Uwe
Cool

Report message to a moderator

Re: Question on ORA-XXXXX [message #118966 is a reply to message #118862]

Tue, 10 May 2005 01:15

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

Hi

The ones in Bold will be written in Alert log.

ORA-00001: unique constraint violated
ORA-00020: maximum number of processes exceeded
ORA-00060: deadlock detected while waiting for resource
ORA-00372: file cannot be modified
ORA-00904: invalid identifier
ORA-00911: invalid character
ORA-00920: invalid relational operator
ORA-00933: SQL command not properly ended
ORA-00942: table or view does not exist
ORA-00955: name is already in use by excisting object
ORA-01033: Oracle initialization or in shutdown process ORA-01036: illegal variable name/number
ORA-01110: data file ' '
ORA-01413: illegal value in packed decimal number buffer
ORA-01488: invalid nibble or byte in input data
ORA-01502: index ' ' or partition of such index is in unsuable state
ORA-01653: unable to extend tablespace
ORA-01654: unable to extend index
ORA-01722: invalid number
ORA-01756: quoted string not properly terminated
ORA-03113: end-of-file in communication channel
ORA-03114: not connected to ORACLE
ORA-04031: unable to allocate bytes of shared memory
ORA-04088: error during execution of trigger
ORA-06512: at ' ' line ' '
ORA-08103: object no longer exists
ORA-12541: no listener

Regds
Girish

Report message to a moderator

Re: Question on ORA-XXXXX [message #118967 is a reply to message #118862]

Tue, 10 May 2005 01:40

Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland

Senior Member

Thanks Grish,

I hope that our application programmers could give us the others to react on them.

regs
Uwe

Report message to a moderator

Previous Topic:	OEM
Next Topic:	ORA-00604 in connection with ORA-04021

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 04:18:44 CST 2025