Oracle8i Client Administrator's Guide
Release 2 (8.1.6) for Windows

Part Number A73017-01

Library

Product

Contents

Index

Go to previous page Go to next page

D
Error Messages

This appendix lists the error messages, causes, and corrective actions that are specific to the operation of Oracle8i Client. This appendix also includes database connection issues.

Specific topics discussed are:

Logging Error Messages

Keep a log of error messages you receive by redirecting the messages to a file. You can record the contents of normal utility messages by using the LOGFILE parameter discussed in Oracle8i Utilities. You can separately record the error message portion by using standard Windows file redirection. For example, use the following syntax to redirect the output from the Export Utility:

C:\> EXP USERNAME/PASSWORD PARFILE=FILENAME >FILE1.LOG 2>FILE2.ERR

In this command line, FILE1.LOG receives the standard output from Export, while FILE2.ERR receives the standard error messages.

Codes 04000-04999: Windows-Specific Oracle Messages

The error messages in this section are Oracle operating system-dependent (OSD) messages issued in response to an error condition in Windows. Each message in this section triggers an Oracle8i database error message.

File I/O Errors: OSD-04000 to OSD-04099

OSD-04000

Logical block size mismatch

Cause: The database block size specified in the initialization parameter file does not match the block size of the actual database files.

Action: Use matching logical block sizes.

OSD-04001

Invalid logical block size

Cause: The logical block size is not a multiple of 512 bytes, or it is too large.

Action: Change the value of DB_BLOCK_SIZE in the initialization parameter file.

OSD-04002

Unable to open file

Cause: The specified path or file name is invalid, or the destination device is full. This error can also be caused by insufficient Windows file handles.

Action: Make sure the path and file exist, and the device has free space. If this fails, increase the number of Windows file handles.

OSD-04003

Unable to read file header block

Cause: The media has been damaged.

Action: Recover the file if necessary, and verify that Windows is functioning correctly.

OSD-04004

Invalid file header

Cause: The file is corrupted.

Action: Recover the file.

OSD-04005

SetFilePointer() failure, unable to read from file

Cause: There was an unexpected return from the Windows system service, SetFilePointer().

Action: Check the operating system error code and consult the Windows documentation.

OSD-04006

ReadFile() failure, unable to read from file

Cause: There was an unexpected return from the Windows system service, ReadFile().

Action: Check the operating system error code and consult the Windows documentation.

OSD-04007

Truncated read

Cause: The system encountered an unexpected end-of-file, which is due to damaged media.

Action: Verify that the file is not damaged.

OSD-04008

WriteFile() failure, unable to write to file

Cause: There was an unexpected return from the Windows system service, WriteFile().

Action: Check the operating system error code and consult the Windows documentation.

OSD-04009

Truncated write

Cause: The destination device is full or the media is damaged.

Action: Verify that the device has free space and the file is not damaged.

OSD-04010

<create> option specified, file already exists

Cause: The file you attempted to create already exists.

Action: Delete the existing file or use the REUSE option in the SQL statement.

OSD-04011

GetFileInformationByHandle() failure, unable to obtain file info

Cause: There was an unexpected return from the Windows system service, GetFileInformationByHandle().

Action: Check the operating system error code and consult the Windows documentation.

OSD-04012

File size mismatch

Cause: The file to be re-used is either too large or too small.

Action: Specify the correct file size or delete the existing file.

OSD-04013

Unable to read line from file

Cause: This error is caused by an operating system error or by damaged media.

Action: Check the operating system error code (if available) and consult the Windows documentation. If no operating system error code is presented, verify that the media is not damaged.

OSD-04014

Unable to close file

Cause: The media has been damaged.

Action: Recover the file, if necessary, and verify that Windows is functioning correctly.

OSD-04015

Asynchronous I/O request returned an error

Cause: There was an unexpected return from the Windows system service.

Action: Check the operating system error code and consult the Windows documentation.

OSD-04016

Error queuing an asynchronous I/O request

Cause: There was an unexpected return from the Windows system service.

Action: Check the operating system error code and consult the Windows documentation.

OSD-04017

Unable to open the specified RAW device

Cause: An invalid path or file name was specified or the device is full.

Action: Make sure the file exists and/or device is not full; verify that the operating system is functioning correctly.

OSD-04018

Unable to access the specified directory or device

Cause: An invalid path name was specified.

Action: Make sure the directory or device exists and is accessible.

OSD-04019

Unable to set file pointer

Cause: This error is caused by an operating system error or by damaged media.

Action: Check the operating system error code (if available) and consult the Windows documentation. If no operating system error code is presented, verify that the media is not damaged.

OSD-04020

Unable to set eof file marker

Cause: This error is caused by an operating system error or by damaged media.

Action: Check the operating system error code (if available) and consult the Windows documentation. If no operating system error code is presented, verify that the media is not damaged.

OSD-04021

Unable to read file

Cause: This error is caused by an operating system error or by damaged media.

Action: Check the operating system error code (if available) and consult the Windows documentation. If no operating system error code is presented, verify that the media is not damaged.

OSD-04022

Unable to write file

Cause: This error is caused by an operating system error or by damaged media.

Action: Check the operating system error code (if available) and consult the Windows documentation. If no operating system error code is presented, verify that the media is not damaged.

OSD-04023

SleepEx() failure, unable to Sleep

Cause: There was an unexpected return from the Windows system service.

Action: Check the operating system error code and consult the Windows documentation.

OSD-04024

Unable to delete file

Cause: This error is caused by an operating system error or by damaged media.

Action: Check the operating system error code (if available) and consult the Windows documentation. If no operating system error code is presented, verify that the media is not damaged.

OSD-04025

Invalid question asked

Cause: This is an internal error, not normally expected to occur.

Action: Contact Oracle Support Services.

OSD-04026

Invalid parameter passed

Cause: This is an internal error, not normally expected to occur.

Action: Contact Oracle Support Services.

Memory Errors: OSD-04100 to OSD-04199

OSD-04100

Malloc() failure, unable to allocate memory

Cause: The program is out of memory.

Action: Shut down all unnecessary processes or install more memory in the computer.

OSD-04101

Invalid SGA: SGA not initialized

Cause: The System Global Area (SGA) has been allocated but not initialized.

Action: Wait until the STARTUP has completed before attempting to connect.

OSD-04102

Unable to open/create file for shared memory object

Cause: There was an unexpected return from the Windows system service, CreateFile().

Action: Check the operating system error code and consult the Windows documentation.

OSD-04103

Unable to attach to SGA: SGA does not exist

Cause: The SGA does not exist.

Action: Start up an Oracle instance.

OSD-04104

Unable to map shared memory (SGA) into the address space

Cause: There was an unexpected return from the Windows system service, MapViewOfFileEx().

Action: Check the operating system error code and consult the Windows documentation.

OSD-04105

Shared memory (SGA) mapped to wrong address

Cause: There was an unexpected return from the Windows system service, MapViewOfFileEx().

Action: Check the operating system error code and consult the Windows documentation.

OSD-04106

Unable to allocate memory with VirtualAlloc

Cause: The program is out of memory.

Action: Shut down all unnecessary processes or install more memory in the computer.

OSD-04107

Unable to deallocate memory with VirtualFree

Cause: There was an unexpected return from the Windows system service, VirtualFree().

Action: Check the operating system error code and consult the Windows documentation.

OSD-04108

Unable to protect memory with VirtualProtect

Cause: There was an unexpected return from the Windows system service, VirtualProtect().

Action: Check the operating system error code and consult the Windows documentation.

Process Errors: OSD-04200 to OSD-04299

OSD-04200

Unable to begin another thread

Cause: The program has run out of system resources.

Action: Shut down all unnecessary processes; install more memory in the computer.

OSD-04201

No pid structure supplied to spdcr()

Cause: This is an internal error, not normally expected to occur.

Action: Contact Oracle Support Services.

OSD-04202

DosSetPriority() failure, unable to set process priority

Cause: There was an unexpected return from the Windows system service, DosSetPriority().

Action: Check the operating system error code and consult the Windows documentation.

OSD-04203

DosKillProcess() failure, unable to kill process

Cause: There was an unexpected return from the Windows system service, DosKillProcess().

Action: Check the operating system error code and consult the Windows documentation.

OSD-04204

Invalid pid

Cause: Process ID not recognized by system, process previously terminated.

Action: Verify that process ID is correct and that process is active.

OSD-04205

CreateProcess() failure, unable to spawn process

Cause: There was an unexpected return from the Windows system service, CreateProcess().

Action: Check the operating system error code and consult the Windows documentation.

OSD-04207

Invalid priority specified in CONFIG parameter ORACLE_PRIORITY

Cause: The priority specified is invalid or out of range.

Action: Specify a valid setting for ORACLE_PRIORITY.

OSD-04208

OpenProcess() failure, unable to open process handle

Cause: There was an unexpected return from the Windows system service, OpenProcess().

Action: Check the operating system error code and consult the Windows documentation.

OSD-04209

Incorrect or unknown background image name given to spdcr()

Cause: There was an unexpected background name given to spdcr().

Action: Contact Oracle Support Services.

OSD-04210

Timeout waiting for thread semaphore

Cause: An Oracle8 database thread died holding the semaphore.

Action: Restart Oracle8 database instance.

OSD-04211

Thread information not found

Cause: An Oracle8 database thread died without deleting its information.

Action: Restart Oracle8 database instance.

OSD-04212

Maximum number of Oracle threads reached

Cause: The maximum number of Oracle8 database threads for the instance is reached.

Action: Wait until some connections exit before trying again.

OSD-04213

Oracle thread unable to DuplicateHandle()

Cause: This is an internal error, not normally expected to occur.

Action: Contact Oracle Support Services.

OSD-04214

Oracle thread unable to CreateEvent()

Cause: This is an internal error, not normally expected to occur.

Action: Contact Oracle Support Services.

OSD-04215

Bad function code supplied to ssthreadop

Cause: This is an internal error, not normally expected to occur.

Action: Contact Oracle Support Services.

OSD-04216

Unable to find file handle for that thread

Cause: This is an internal error, not normally expected to occur.

Action: Contact Oracle Support Services.

OSD-04217

Unable to retrieve system username for current user

Cause: This is an internal error, not normally expected to occur.

Action: Contact Oracle Support Services.

OSD-04218

Cannot post thread

Cause: This is an internal error, not normally expected to occur.

Action: Contact Oracle Support Services.

OSD-04219

Bad thread list semaphore

Cause: This is an internal error, not normally expected to occur.

Action: Contact Oracle Support Services.

OSD-04221

Target thread is currently busy

Cause: The target thread is processing an oradebug command.

Action: Wait and re-issue command.

OSD-04222

Unable to get the threads context

Cause: Check OS error code.

Action: Remedy OS error.

OSD-04223

Unable to set the threads context

Cause: Check OS error code.

Action: Remedy OS error.

OSD-04224

Unable to suspend the target thread

Cause: Check OS error code.

Action: Remedy OS error.

OSD-04225

Unable to resume the target thread

Cause: Check OS error code.

Action: Remedy OS error.

Loader Errors: OSD-04300 to OSD-04399

OSD-04300

Unable to read complete record from data file

Cause: The data file ended in the middle of a record. This error occurs when loading files with a fixed record length.

Action: Verify that the data file is of the correct length and contains complete records.

OSD-04301

Record size too large

Cause: The specified record size is too large to load.

Action: Reduce record size and reload the data.

OSD-04302

Invalid record type and/or load options

Cause: The control file's Windows file processing options string contains an invalid option or keyword.

Action: Set the Windows file processing options string to an acceptable value.

Semaphore Errors: OSD-04400 to OSD-04499

OSD-04400

Unable to acquire internal semaphore for process

Cause: Oracle8 database has exceeded the maximum number of connections.

Action: Delete any unused connections and try again.

OSD-04401

WaitForSingleObject() failure, unable to obtain semaphorex

Cause: There was an unexpected return from the Windows system service, WaitForSingleObject().

Action: Check the operating system error code and consult the Windows documentation.

Miscellaneous Errors: OSD-04500 to OSD-04599

OSD-04500

Illegal option specified

Cause: This is an internal error, not normally expected to occur.

Action: Contact Oracle Support Services.

OSD-04501

Internal buffer overflow

Cause: This is an internal error, not normally expected to occur.

Action: Contact Oracle Support Services.

OSD-04502

Translations nested too deep

Cause: The program encountered too many intermediate translations while attempting to translate a configuration variable.

Action: Simplify the values of configuration parameters to include fewer intermediate translations.

OSD-04503

Text contains no translatable elementsx

Cause: The program cannot recognize variables in the text to be translated.

Action: Check and, if necessary, correct the text to be translated.

OSD-04505

Stdin not responding

Cause: The system is unable to receive input from the standard input stream.

Action: Verify that the process has access to an input device.

OSD-04506

Unable to spawn process via system()

Cause: The system is out of memory or the executable is invalid.

Action: Shut down unnecessary processes; install more memory in the computer. Verify the name of the executable.

OSD-04507

Password for 'internal' is incorrect

Cause: An attempt was made to connect as 'internal' with an invalid password.

Action: Verify that the password is correct and try again.

OSD-04508

No password given

Cause: An attempt was made to connect as 'internal' without a password.

Action: Enter a valid password when connecting as internal.

OSD-04509

No password found

Cause: Oracle was unable to locate and retrieve the password for 'internal'.

Action: Verify that Oracle is installed and configured correctly.

OSD-04510

Operating system roles are not supported

Cause: An attempt was made to use an operating system role.

Action: Only use roles that were created 'IDENTIFIED BY PASSWORD' as opposed to 'IDENTIFIED EXTERNALLY'.

OSD-04511

Unable to get date and time from the operating system

Cause: There was an unexpected return from GetLocalTime() call.

Action: Verify that the system time is correct on the computer.

OSD-04512

Unable to translate the 'USERNAME' configuration variable on server

Cause: The 'USERNAME' configuration parameter variable on the host is not properly set.

Action: Verify the 'USERNAME' variable is set.

OSD-04513

'REMOTE_OS_AUTHENT' variable not set to TRUE'

Cause: For remote operating system log on to function, the 'REMOTE_OS_AUTHENT' parameter must be set to TRUE.

Action: Shut down and start up the instance with 'REMOTE_OS_AUTHENT = TRUE' in the initialization parameter file.

OSD-04514

The Windows Group name is too long for internal buffer

Cause: The Windows Group name is too long.

Action: Use a shorter Windows group name.

Database Connection Issues

This table lists and provides answers to common Oracle8i database connection issues:

If You Receive This Error...  Ensure Your... 

TNS-12203 TNS: unable to connect to destination 

OracleServiceSID and OracleHome_NameTNSListener1 services are started. See the Net8 Administrator's Guide

ORA-12547 TNS: lost contact

 

OracleServiceSID and OracleHome_NameTNSListener1 services are started. You receive this error if you attempt to use any of the Oracle8i Utilities, such as SQL*Plus.

Note: This error is analogous to the following Oracle7 error:

ORA-09352: Windows 32-bit Two-Task driver unable to spawn new ORACLE task 

ORA-28575: unable to open RPC connection to external procedure agent

ORA-06512: at "APPLICATIONS.OSEXEC", line 0

ORA-06512: at "APPLICATIONS.TEST", line 4

ORA-06512: at line 2

 

TNSNAMES.ORA and LISTENER.ORA files have been correctly configured to use external routines. See Chapter 8 of Net8 Administrator's Guide

1 Ensure that OracleHOME_NAMETNSListener is started if you are using an Oracle8i database that has a home name.


Go to previous page Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index