viernes, 10 de mayo de 2013

ORA Error . Listado Errores Oracle. ORA-08440 a ORA-09706

ORA-08440: raw buffer is too short to hold converted data
Cause: The output raw buffer passed to a UTL_PG NUMBER_TO_RAW conversion routine was not large enough to contain the results of the conversion based on the picture mask.
Action: Increase the raw buffer size to the size necessary to hold the entire result of the conversion.

ORA-08441: closed parenthesis missing in picture mask
Cause: A closed parenthesis was missing from the picture mask passed to a UTL_PG conversion routine.
Action: Correct the picture mask.

ORA-08443: syntax error in BLANK WHEN ZERO clause in mask options
Cause: A syntax error was found in the BLANK WHEN ZERO clause in the mask options parameter passed to a UTL_PG conversion routine. Valid specifications are: BLANK ZERO BLANK ZEROS BLANK ZEROES BLANK WHEN ZERO BLANK WHEN ZEROS BLANK WHEN ZEROES
Action: Correct the mask options parameter.

ORA-08444: syntax error in JUSTIFIED clause in mask options
Cause: A syntax error was found in the JUSTIFIED clause in the mask options parameter passed to a UTL_PG conversion routine. Valid specifications are: JUST JUST RIGHT JUSTIFIED JUSTIFIED RIGHT
Action: Correct the mask options parameter.

ORA-08445: syntax error in SIGN clause in mask options
Cause: A syntax error was found in the SIGN clause in the mask options parameter passed to a UTL_PG conversion routine. Valid specifications are: SIGN LEADING SIGN LEADING SEPARATE SIGN LEADING SEPARATE CHARACTER SIGN TRAILING SIGN TRAILING SEPARATE SIGN TRAILING SEPARATE CHARACTER SIGN IS LEADING SIGN IS LEADING SEPARATE SIGN IS LEADING SEPARATE CHARACTER SIGN IS TRAILING SIGN IS TRAILING SEPARATE SIGN IS TRAILING SEPARATE CHARACTER
Action: Correct the mask options parameter.

ORA-08446: syntax error in SYNCHRONIZED clause in mask options
Cause: A syntax error was found in the SYNCHRONIZED clause in the mask options parameter passed to a UTL_PG conversion routine. Valid specifications are: SYNC SYNC LEFT SYNC RIGHT SYNCHRONIZED SYNCHRONIZED LEFT SYNCHRONIZED RIGHT
Action: Correct the mask options parameter.

ORA-08447: syntax error in USAGE clause in mask options
Cause: A syntax error was found in the USAGE clause in the mask options parameter passed to a UTL_PG conversion routine. Valid specifications are: USAGE DISPLAY USAGE COMP USAGE COMP-3 USAGE COMP-4 USAGE COMPUTATIONAL USAGE COMPUTATIONAL-3 USAGE COMPUTATIONAL-4 USAGE IS DISPLAY USAGE IS COMP USAGE IS COMP-3 USAGE IS COMP-4 USAGE IS COMPUTATIONAL USAGE IS COMPUTATIONAL-3 USAGE IS COMPUTATIONAL-4
Action: Correct the mask options parameter.

ORA-08448: syntax error in DECIMAL-POINT environment clause
Cause: A syntax error was found in the DECIMAL-POINT environment clause parameter passed to a UTL_PG conversion routine. Valid specifications are: DECIMAL-POINT IS COMMA
Action: Correct the environment clause parameter.

ORA-08449: invalid numeric symbol found in picture mask
Cause: An invalid numeric symbol was found in the picture mask parameter passed to a UTL_PG conversion routine.
Action: Correct the picture mask parameter.

ORA-08450: invalid specification of CR in picture mask
Cause: The CR suffix was incorrectly specified in the picture mask parameter passed to a UTL_PG conversion routine. The CR suffix can only appear at the end of a picture mask.
Action: Correct the picture mask parameter.

ORA-08451: invalid specification of DB in picture mask
Cause: The DB suffix was incorrectly specified in the picture mask parameter passed to a UTL_PG conversion routine. The DB suffix can only appear at the end of a picture mask.
Action: Correct the picture mask parameter.

ORA-08452: specification of E in picture mask is unsupported
Cause: The floating point exponent symbol 'E' was specified in the picture mask parameter passed to a UTL_PG conversion routine. The floating point data type is currently not supported by the UTL_PG conversion routines.
Action: Correct the picture mask parameter, and the data, if necessary.

ORA-08453: more than one V symbol specified in picture mask
Cause: The picture mask passed to a UTL_PG conversion routine contained more than one decimal point indicator ('V'). Only one decimal point indicator is allowed in the picture mask.
Action: Correct the picture mask parameter.

ORA-08454: more than one S symbol specified in picture mask
Cause: The picture mask passed to a UTL_PG conversion routine contained more than one operational sign indicator ('S'). Only one operational sign indicator is allowed in the picture mask.
Action: Correct the picture mask parameter.

ORA-08455: syntax error in CURRENCY SIGN environment clause
Cause: A syntax error was found in the CURRENCY SIGN environment clause parameter passed to a UTL_PG conversion routine. Valid specifications are: CURRENCY SIGN IS x where x is a valid currency sign
Action: Correct the environment clause parameter.

ORA-08456: no sign in picture mask but SIGN clause in mask options
Cause: The picture mask parameter passed to a UTL_PG conversion routine contained no sign symbol ('S', '+', or '-'), but the mask options parameter contained a SIGN clause. A sign symbol is required in the picture mask parameter when the mask options parameter contains a SIGN clause.
Action: Correct the picture mask parameter or the mask options parameter.

ORA-08457: syntax error in SEPARATE CHARACTER option of SIGN clause
Cause: A syntax error was found in the SEPARATE CHARACTER option of the SIGN clause in the mask options parameter passed to a UTL_PG conversion routine. Valid specifications are: SEPARATE SEPARATE CHARACTER
Action: Correct the mask options parameter.

ORA-08458: invalid format parameter
Cause: The format parameter passed to a UTL_PG conversion routine was invalid. The format parameter should have been built by a prior call to either MAKE_RAW_TO_NUMBER_FORMAT or MAKE_NUMBER_TO_RAW_FORMAT.
Action: Check to be sure that the format parameter was built by MAKE_RAW_TO_NUMBER_FORMAT or MAKE_NUMBER_TO_RAW_FORMAT, and that it was not accidentally overwritten or modified by the PL/SQL procedure.

ORA-08459: invalid format parameter length
Cause: The format parameter passed to a UTL_PG conversion routine was not the correct length. Format parameters must be 2048 bytes in length.
Action: Check to be sure that the format parameter was built by MAKE_RAW_TO_NUMBER_FORMAT or MAKE_NUMBER_TO_RAW_FORMAT, and that it was not accidentally overwritten or modified by the PL/SQL procedure.

ORA-08460: invalid environment clause in environment parameter
Cause: The environment parameter passed to a UTL_PG conversion routine contained an unsupported or invalid environment clause. Only the CURRENCY SIGN and the DECIMAL-POINT IS COMMA environment clauses are supported.
Action: Correct the environment parameter.

ORA-08462: raw buffer contains invalid decimal data
Cause: The input raw buffer passed to a UTL_PG RAW_TO_NUMBER conversion routine contains invalid decimal data.
Action: Correct the input data.

ORA-08463: overflow converting decimal number to Oracle number
Cause: The output variable passed to a UTL_PG RAW_TO_NUMBER was not large enough to hold the Oracle number resulting from the input decimal number.
Action: Be sure that the input decimal number is valid, and besure that the output variable is large enough to hold the Oracle number value.

ORA-08464: input raw decimal data contains more than 42 digits
Cause: The input raw buffer passed to a UTL_PG RAW_TO_NUMBER conversion routine contained more than 42 digits. This exceeds the maximum size of an Oracle number.
Action: Correct the raw input buffer.

ORA-08465: input mask contains more than 32 characters
Cause: The input mask passed to UTL_PG numeric conversion routine contained more the 32 characters.
Action: Correct the mask input buffer.

ORA-08466: raw buffer length string is too short for string
Cause: The input raw buffer passed to a UTL_PG RAW_TO_NUMBER conversion routine was less than %s bytes long, but the picture mask parameter specified that %s bytes of input data were to be converted.
Action: Either the input data is incorrect, or the picture mask is incorrect. Correct the appropriate item.

ORA-08467: error converting Oracle number to string
Cause: An error occurred when converting an Oracle number to a COBOL <type> of: DISPLAY COMP-3 or character variable. The Oracle number was not in the correct format.
Action: Correct the call to the conversion routine. The input must be a valid Oracle number variable.

ORA-08468: mask option string is not supported
Cause: The mask option <clause> was passed to a UTL_PG conversion routine, but is not supported by UTL_PG. The <clause> can be: USAGE IS POINTER USAGE IS INDEX USAGE IS COMP-1 USAGE IS COMP-2 POINTER
Action: Remove the <clause> from the mask options parameter in the PL/SQL call to UTL_PG.

ORA-08469: must use the SIGN IS SEPARATE clause in mask options
Cause: A signed numeric entry with DISPLAY usage was converted using a non-defaulted character set and its PICTURE character-string contains an S. In these circumstances, a SIGN IS SEPARATE clause must be specified in the mask options.
Action: Either specify a valid SIGN IS SEPARATE clause in the mask options, use the defaulted character set, or don't specify an S in the PICTURE character-string.

ORA-08498: Warning: picture mask 'string' overrides picture mask option 'USAGE IS string' to 'USAGE IS DISPLAY'
Cause: Picture mask USAGE option was overridden by the picture mask.
Action: This is an informational message only. The message may be eliminated by changing the USAGE option to match the picture mask.

ORA-08499: Warning: picture mask options 'string' ignored by UTL_PG
Cause: Picture mask options such as OCCUR, SYNC and others are not processed by the UTL_PG numeric conversion routines.
Action: This is an informational message only. The message may be eliminated by removing the unnecessary picture mask options from the parameter list passed to the UTL_PG routine.

ORA-09200: sfccf: error creating file
Cause: Could be out of disk space
Action: See OSD error accompanying this message

ORA-09201: sfcopy: error copying file
Cause: Block sizes may not match
Action: See OSD error accompanying this message

ORA-09202: sfifi: error identifying file
Cause: db_block_size specified in init.ora could be incorrect
Action: See OSD error accompanying this message

ORA-09203: sfofi: error opening file
Cause: File attributes may have changed
Action: See OSD error accompanying this message

ORA-09204: sfotf: error opening temporary file
Cause: Incorrect path may have been specified for the file
Action: See OSD error accompanying this message

ORA-09205: sfqio: error reading or writing to disk
Cause: File may have been truncated or corrupted
Action: See OSD error accompanying this message

ORA-09206: sfrfb: error reading from file
Cause: File may have been truncated or corrupted
Action: See OSD error accompanying this message

ORA-09207: sfsrd: error reading from file
Cause: File may have been truncated or corrupted
Action: See OSD error accompanying this message

ORA-09208: sftcls: error closing file
Cause: File may have been corrupted
Action: See OSD error accompanying this message

ORA-09209: sftget: error reading from file
Cause: File may have been truncated or corrupted
Action: See OSD error accompanying this message

ORA-09210: sftopn: error opening file
Cause: Incorrect path may have been specified for the file
Action: See OSD error accompanying this message

ORA-09211: sfwfb: error writing to file
Cause: File may have been truncated or corrupted
Action: See OSD error accompanying this message

ORA-09212: sfwfbmt: error writing to file
Cause: File may have been truncated or corrupted
Action: See OSD error accompanying this message

ORA-09213: slgfn: error fabricating file name
Cause: Filename may be too long
Action: See OSD error accompanying this message

ORA-09214: sfdone: I/O error detected
Cause: File may have been truncated or corrupted
Action: See OSD error accompanying this message

ORA-09215: sfqio: error detected in IOCompletionRoutine
Cause: File may have been truncated or corrupted
Action: See OSD error accompanying this message

ORA-09216: sdnfy: bad value 'string' for parameter string
Cause: The directory specified as the value for the stated parameter could not be used.
Action: Make sure the directory you have specified is a valid directory/file specification.

ORA-09217: sfsfs: failed to resize file
Cause: Could be out of disk space
Action: See OSD error accompanying this message

ORA-09218: sfrfs: failed to refresh file size
Cause: File may be corrupted or truncated
Action: See OSD error accompanying this message

ORA-09240: smpalo: error allocating PGA memory
Cause: Could be out of memory
Action: See OSD error accompanying this message

ORA-09241: smsalo: error allocating SGA memory
Cause: Could be out of memory
Action: See OSD error accompanying this message

ORA-09243: smsget: error attaching to SGA
Cause: SGA may not have been created (database not started)
Action: See OSD error accompanying this message

ORA-09260: sigpidu: error obtaining process id
Cause: May be out of resources
Action: See OSD error accompanying this message

ORA-09261: spdcr: error creating detached (background) process
Cause: Could be out of resources
Action: See OSD error accompanying this message

ORA-09262: spdde: error terminating detached (background) process
Cause: Could be out of resources
Action: See OSD error accompanying this message

ORA-09263: spini: error initializing process
Cause: Could be out of memory
Action: See OSD error accompanying this message

ORA-09264: sptpa: error flagging process
Cause: Could be out of resources
Action: See OSD error accompanying this message

ORA-09265: spwat: error temporarily suspending process
Cause: Could be out of resources
Action: See OSD error accompanying this message

ORA-09266: spawn: error starting an Oracle process
Cause: Could be out memory
Action: See OSD error accompanying this message

ORA-09270: szalloc: error allocating memory for security
Cause: Could be out of memory
Action: See OSD error accompanying this message

ORA-09271: szlon: error verifying user name
Cause: Username may be too long
Action: See OSD error accompanying this message

ORA-09272: remote os logon is not allowed
Cause: Remote os login attempted when not allowed.
Action: See OSD error accompanying this message

ORA-09273: szrfc: error verifying role name
Cause: An OS error was returned when verifying the role name.
Action: See OSD error accompanying this message

ORA-09274: szrfc: insufficient role name buffer space
Cause: An OS role name was too long.
Action: See OSD error accompanying this message

ORA-09275: CONNECT INTERNAL is not a valid DBA connection
Cause: CONNECT INTERNAL is no longer supported for DBA connections.
Action: Please try to connect AS SYSDBA or AS SYSOPER.

ORA-09276: All bequeath database links must be loopback database links
Cause: A non-loopback bequeath connect string was supplied for a database link.
Action: Please use a connect string with a different transport protocol, or specify a loopback connect string (one that points to the instance for the current session) using "(PROGRAM=<this instance's ORACLE_HOME>/bin/oracle)" and, optionally, "(ENVS=''ORACLE_SID=<this instance's ORACLE_SID>'')".

ORA-09280: sllfcf: error closing file
Cause: File may be corrupted
Action: See OSD error accompanying this message

ORA-09281: sllfop: error opening file
Cause: Possibly incorrect path specified to the file
Action: See OSD error accompanying this message

ORA-09282: sllfrb: error reading records
Cause: File could be corrupted
Action: See OSD error accompanying this message

ORA-09283: sllfsk: error skipping records
Cause: File could be corrupted
Action: See OSD error accompanying this message

ORA-09284: sllfop: cannot allocate read buffer
Cause: malloc() system call returned an error. The system might have run out of heap space
Action: Check additional information for the OS error.

ORA-09285: sllfop: unrecognizable processing option, incorrect format
Cause: Processing option passed is of incorrect format
Action: Consult your IUG for permissible formats

ORA-09290: sksaalo: error allocating memory for archival
Cause: Could be out of memory
Action: See OSD error accompanying this message

ORA-09291: sksachk: invalid device specified for archive destination
Cause: Unable to access directory
Action: Specify a valid device in ARCHIVE control string

ORA-09292: sksabln: unable to build archive file name
Cause: Bad directory or format specified
Action: Specify a valid directory in 'log_archive_format' and a valid format string in 'log_archive_format' in init.ora

ORA-09293: sksasmo: unable to send message to console
Cause: An error was returned while attempting to send a message to the console operator
Action: See OSD error accompanying this message

ORA-09300: osncon: unable to connect, DPMI not available
Cause: Unable to detect the presence of DPMI
Action: Restart Windows and retry

ORA-09301: osncon: local kernel only supported in standard mode
Cause: An attempt was made to connect to S: while in enhanced mode
Action: Restart Windows in standard mode

ORA-09310: sclgt: error freeing latch
Cause: Internal error
Action: See OSD error accompanying this message

ORA-09311: slsleep: error temporarily suspending process
Cause: May be out of resources
Action: See OSD error accompanying this message

ORA-09312: slspool: error spooling file to printer
Cause: Could be out of resources
Action: See OSD error accompanying this message

ORA-09313: slsprom: error prompting user
Cause: May be out of resources
Action: See OSD error accompanying this message

ORA-09314: sltln: error translating logical name
Cause: Internal buffer may have overflowed
Action: See OSD error accompanying this message

ORA-09315: sql2tt: two-task error translating ORACLE_EXECUTABLE
Cause: Internal error
Action: See OSD error accompanying this message

ORA-09316: szrpc: unable to verify password for role
Cause: OS roles may not be supported for this platform
Action: See OSD error accompanying this message

ORA-09317: szprv: insufficient privileges
Cause: The password specified is invalid
Action: See OSD error accompanying this message

ORA-09318: slkhst: unable to host out to operating system
Cause: There might not be enough memory for the command or hosting out may not be supported on this platform
Action: See OSD error accompanying this message

ORA-09319: slgtd: unable to obtain the current date and time
Cause: The system time might be set incorrectly
Action: See OSD error accompanying this message

ORA-09320: szrfc: unable to obtain the list of valid OS roles
Cause: OS roles may not be supported on this platform
Action: See OSD error accompanying this message

ORA-09321: slzdtb: unable to convert zoned decimal to binary
Cause: internal error
Action: See OSD error accompanying this message

ORA-09322: slpdtb: unable to convert packed decimal to binary
Cause: internal error
Action: See OSD error accompanying this message

ORA-09330: Session terminated internally by Oracle or by an Oracle DBA
Cause: Oracle to terminate that session after about a minute. This message also appears in the trace file if a shutdown abort is performed.
Action: None

ORA-09340: Specified ORACLE_SID is either invalid or too long
Cause: ORACLE_SID must be at the most 4 alphanumeric characters.
Action: None

ORA-09341: scumnt: unable to mount database
Cause: Another instance is currently mounting the database
Action: None

ORA-09342: Detached process terminated by Oracle during shutdown abort
Cause: The user performed a shutdown abort.
Action: None

ORA-09344: spsig: error signalling thread
Cause: This function may not be implemented.
Action: None

ORA-09350: Windows 32-bit Two-Task driver unable to allocate context area
Cause: See OSD error accompanying this message
Action: None

ORA-09351: Windows 32-bit Two-Task driver unable to allocate shared memory
Cause: See OSD error accompanying this message
Action: None

ORA-09352: Windows 32-bit Two-Task driver unable to spawn new ORACLE task
Cause: See OSD error accompanying this message
Action: None

ORA-09353: Windows 32-bit Two-Task driver unable to open event semaphore
Cause: See OSD error accompanying this message
Action: None

ORA-09354: Windows 32-bit Two-Task driver: ORACLE task unexpectedly died
Cause: See OSD error accompanying this message
Action: None

ORA-09360: Windows 3.1 Two-Task driver unable to allocate context area
Cause: See OSD error accompanying this message
Action: None

ORA-09361: Windows 3.1 Two-Task driver unable to lock context area
Cause: See OSD error accompanying this message
Action: None

ORA-09362: Windows 3.1 Two-Task driver unable to deallocate context area
Cause: See OSD error accompanying this message
Action: None

ORA-09363: Windows 3.1 Two-Task driver invalid context area
Cause: See OSD error accompanying this message
Action: None

ORA-09364: Windows 3.1 Two-Task driver unable to create hidden window
Cause: See OSD error accompanying this message
Action: None

ORA-09365: Windows 3.1 Two-Task driver unable to destroy hidden window
Cause: See OSD error accompanying this message
Action: None

ORA-09366: Windows 3.1 Two-Task driver unable to allocate shared memory
Cause: See OSD error accompanying this message
Action: None

ORA-09367: Windows 3.1 Two-Task driver unable to deallocate shared memory
Cause: See OSD error accompanying this message
Action: None

ORA-09368: Windows 3.1 Two-Task driver unable to spawn ORACLE
Cause: See OSD error accompanying this message
Action: None

ORA-09369: Windows 3.1 Two-Task driver bad instance handle
Cause: See OSD error accompanying this message
Action: None

ORA-09370: Windows 3.1 Two-Task driver ORACLE task timed out
Cause: See OSD error accompanying this message
Action: None

ORA-09700: sclin: maximum number of latches exceeded
Cause: ORACLE wants to use more latches then available.
Action: increase INIT.ORA parameter latch_pages or decrease the amount of shared memory you are using.

ORA-09701: scnfy: maximum number of processes exceeded
Cause: PROCESSES INIT.ORA parameter exceeded.
Action: Decrease the PROCESSES parameter and restart.

ORA-09702: sem_acquire: cannot acquire latch semaphore
Cause: The semaphore used for accessing latches could not be seized
Action: Send trace file to your customer support representative, along with information on reproducing the error.

ORA-09703: sem_release: cannot release latch semaphore
Cause: The semaphore used for accessing latches could not be released
Action: Send trace file to your customer support representative, along with information on reproducing the error.

ORA-09704: sstascre: ftok error in creating test and set pages.
Cause: the ftok() library call failed in sstastcre().
Action: Verify that tasdef@.dbf file exists. If it does then this is a possible system failure. Perhaps System V compatibility is not enabled.

ORA-09705: spcre: cannot initialize latch semaphore
Cause: The semaphore used for accessing latches could not be initialized
Action: Send trace file to your customer support representative, along with information on reproducing the error.

ORA-09706: slsget: get_process_stats error.
Cause: get_process_stats system call returned an error. Possible OS error.
Action: Check additional information returned. Look for information in OS reference. Contact customer support.

No hay comentarios:

Publicar un comentario