D
Messages and Codes

This appendix lists the error messages, causes, and corrective actions that are specific to the installation and operation of Oracle8 for Windows NT.

Specific topics discussed are:

• Logging Error Messages
• Oracle Installer Error Messages
• Codes 09200-09499: Oracle8 Database Messages
• Codes 04000-04999: Windows NT-Specific Oracle Messages

Logging Error Messages

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

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

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

Oracle Installer Error Messages

This section lists potential error messages that can occur while using Oracle Installer. Most Oracle Installer error messages are accompanied with corrective information on the screen; therefore, they are not listed in this appendix. This appendix lists potential error messages in alphabetical order and provides the probable cause and corrective action.

Error	Cause	Action
DISK_FULL	There is not enough disk space on the destination volume to copy the selected program.	Create space on the destination volume.
DRIVE_LOCKED	The device specified in the full error message is in use or locked by another process.	Terminate or release the other process, or wait for it to complete.
FILE_CORRUPTED	The file or directory specified in the full error message is damaged or not readable.	Try to repair or replace the file or repair the directory specified.
FILE_NOT_FOUND	It was not possible to locate a file on the source or destination media.	Run a utility program to locate any problems with the source or destination media; the media could be the CD-ROM drive, a network drive, or a floppy drive.
INVALID_FILE_NAME	The file or directory name or volume label specified in the full message is syntactically incorrect.	Specify the file, directory, or volume using the correct syntax.
LEXICAL_ERROR	An error has been detected in the installation scripts.	Call Oracle Worldwide Customer Support.
LOCKING_ VIOLATION	A portion of the file specified in the full message has been locked by another process.	Release or terminate the other process, or wait for it to complete.
OS_ERROR	There is an unexpected operating system error.	Run a utility program to locate any problems with the source or destination media; the media could be the CD-ROM drive, a network drive, or a floppy drive.
PERMISSION_ DENIED	The network has denied permission to perform the selected action.	Check with the Network Administrator; make sure you have Supervisor privileges and can perform the selected action.
READ_ERROR	A problem has been detected on the source or destination media while executing an I/O operation.	If in a networking environment, verify that you have read permission for the networking file. Run a utility program to locate any problems with the source or destination media; the media could be the CD-ROM drive, a network drive, or a floppy drive.
RECALIBRATION_FAILURE	A hardware problem has been detected on the hard drive to which you are installing.	Run a utility program to diagnose the hard drive.
SHARING_VIOLATION	The file specified in the full message has been locked by another process. (This error is similar to the LOCKING_VIOLATION message, which relates to a portion of a file.)	Release or terminate the other process, or wait until it completes.
TOO_MANY_OPEN_FILES	Too many files are open on Windows NT.	Close some of the open files.
WRITE_ERROR	A problem has been detected on the destination media while executing an input/output (I/O) operation.	If you are in a network environment and installing on to the network, verify that you have permission to write to a network directory. Run a utility program to locate any problems with the source or destination media; the media could be the CD-ROM drive, a network drive, or a floppy drive.
WRITE_PROTECTED	The file or directory specified in the full message (in which Oracle software is to be installed) is write-protected.	Remove the write-protection from the specified file or directory.

Codes 09200-09499: Oracle8 Database Messages

This section lists error messages issued by the Oracle8 database. Each one is triggered by an operating system-dependent (OSD) message specific to Windows NT that specifies the error condition signalled. The OSD messages appear in the next section. When you receive one of these messages, look up the accompanying OSD message number listed in the section, "Codes 04000-04999: Windows NT-Specific Oracle Messages" for an explanation of the error.

Message	Signal
ORA-09200	sfccf: error creating file
ORA-09201	sfcopy: error copying file
ORA-09202	sfifi: error identifying file
ORA-09203	sfofi: error opening file
ORA-09204	sfotf: error opening temporary file
ORA-09205	sfqio: error reading or writing to disk
ORA-09206	sfrfb: error reading from file
ORA-09207	sfsrd: error reading from file
ORA-09208	sftcls: error closing file
ORA-09209	sftget: error reading from file
ORA-09210	sftopn: error opening file
ORA-09211	sfwfb: error writing to file
ORA-09212	sfwfbmt: error writing to file
ORA-09213	slgfn: error fabricating file name
ORA-09214	sfdone: I/O error detected
ORA-09215	sfqio: error detected in I/O completion routine
ORA-09216	sdnfy: bad value '%s' for parameter %s
ORA-09217	sfsfs: failed to resize file
ORA-09218	sfrfs: failed to refresh file size
ORA-09240	smpalo: error allocating PGA memory
ORA-09241	smsalo: error allocating SGA memory
ORA-09242	smscre: error creating SGA
ORA-09243	smsget: error attaching to SGA
ORA-09244	smprset: error setting memory protections
ORA-09245	smcstk: error switching stacks
ORA-09246	sfsmap: unable to map SGA
ORA-09247	smsdes: error destroying the SGA
ORA-09260	sigpidu: error obtaining process id
ORA-09261	spdcr: error creating detached (background) process
ORA-09262	spdde: error terminating detached (background) process
ORA-09263	spini: error initializing process
ORA-09264	sptpa: error flagging process
ORA-09265	spwat: error temporarily suspending process
ORA-09266	spawn: error starting an Oracle process
ORA-09270	szalloc: error allocating memory for security
ORA-09271	szlon: error verifying user name
ORA-09272	remote OS login is not allowed
ORA-09273	szrfc: error verifying role name
ORA-09274	szrfc: insufficient role name buffer space
ORA-09280	sllfcf: error closing file
ORA-09281	sllfop: error opening file
ORA-09282	sllfrb: error reading records
ORA-09283	sllfsk: error skipping records
ORA-09290	sksaalo: error allocating memory for archival
ORA-09291	sksachk: invalid device specification for LOG_ARCHIVE_DEST
ORA-09292	sksabln: unable to build file name
ORA-09293	sksasmo: unable to send message to console
ORA-09300	osncon: unable to connect, DPMI not available
ORA-09301	osncon: local kernel only supported in standard mode
ORA-09310	sclgt: error freeing latch
ORA-09311	slsleep: error temporarily suspending process
ORA-09312	slspool: error spooling file to printer
ORA-09313	slsprom: error prompting user
ORA-09314	sltln: error translating logical name
ORA-09315	sql2tt: two-task error translating ORACLE_EXECUTABLE
ORA-09316	szrpc: unable to verify password for role
ORA-09317	szprv: insufficient privileges
ORA-09318	slkhst: error hosting out to operating system
ORA-09319	slgtd: unable to obtain the current date and time
ORA-09320	szrfc: unable to obtain the list of valid OS roles
ORA-09321	slzdtb: unable to convert zoned decimal to binary
ORA-09322	slpdtb: unable to convert packed decimal to binary
ORA-09330	session terminated internally by Oracle or by an Oracle DBA
ORA-09331	scgcan: unable to process lk_sync_cancel return code
ORA-09332	scgcc: unable to process lk_close return code
ORA-09333	scggc: unable to process lk_open_convert return code
ORA-09334	scggc: unable to process lk_convert return code
ORA-09335	scgcm: unable to process return code in completion procedure
ORA-09340	specified ORACLE_SID is either invalid or too long
ORA-09341	scumnt: unable to mount database
ORA-09342	Detached process terminated by Oracle during SHUTDOWN ABORT

Codes 04000-04999: Windows NT-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 NT. Each message in this section triggers an Oracle8 database error message, listed in the previous section, "Codes 09200-09499: Oracle8 Database Messages".

• File I/O Errors: OSD-04000 to OSD-04099
• Memory Errors: OSD-04100 to OSD-04199
• Process Errors: OSD-04200 to OSD-04299
• Loader Errors: OSD-04300 to OSD-04399
• Semaphore Errors: OSD-04400 to OSD-04499
• Miscellaneous Errors: OSD-04500 to OSD-04599

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 filename is invalid, or the destination device is full. This error can also be caused by insufficient Windows NT file handles.

Action: Make sure the path and file exist, and the device has free space. If this fails, increase the number of Windows NT 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 NT 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 NT system service, SetFilePointer().

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

OSD-04006

ReadFile() failure, unable to read from file

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

Action: Check the operating system error code and consult the Windows NT 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 NT system service, WriteFile().

Action: Check the operating system error code and consult the Windows NT 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 NT system service, GetFileInformationByHandle().

Action: Check the operating system error code and consult the Windows NT 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 NT 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 NT is functioning correctly.

OSD-04015

Asynchronous I/O request returned an error

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

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

OSD-04016

Error queuing an asynchronous I/O request

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

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

OSD-04017

Unable to open the specified RAW device

Cause: An invalid path or filename 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 NT 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 NT 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 NT 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 NT 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 NT system service.

Action: Check the operating system error code and consult the Windows NT 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 NT 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 Worldwide Customer Support.

OSD-04026

Invalid parameter passed

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

Action: Contact Oracle Worldwide Customer Support.

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 NT system service, CreateFile().

Action: Check the operating system error code and consult the Windows NT 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 NT system service, MapViewOfFileEx().

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

OSD-04105

Shared memory (SGA) mapped to wrong address

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

Action: Check the operating system error code and consult the Windows NT 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 NT system service,VirtualFree().

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

OSD-04108

Unable to protect memory with VirtualProtect

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

Action: Check the operating system error code and consult the Windows NT 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 Worldwide Customer Support.

OSD-04202

DosSetPriority() failure, unable to set process priority

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

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

OSD-04203

DosKillProcess() failure, unable to kill process

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

Action: Check the operating system error code and consult the Windows NT 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 NT system service, CreateProcess().

Action: Check the operating system error code and consult the Windows NT 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 NT system service, OpenProcess().

Action: Check the operating system error code and consult the Windows NT 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 Worldwide Customer Support.

OSD-04210

Timeout waiting for thread semaphore

Cause: An Oracle8 thread died holding the semaphore.

Action: Restart Oracle8 instance.

OSD-04211

Thread information not found

Cause: An Oracle8 thread died without deleting its information.

Action: Restart Oracle8 instance.

OSD-04212

Maximum number of Oracle threads reached

Cause: The maximum number of Oracle8 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 Worldwide Customer Support.

OSD-04214

Oracle thread unable to CreateEvent()

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

Action: Contact Oracle Worldwide Customer Support.

OSD-04215

Bad function code supplied to ssthreadop

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

Action: Contact Oracle Worldwide Customer Support.

OSD-04216

Unable to find file handle for that thread

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

Action: Contact Oracle Worldwide Customer Support.

OSD-04217

Unable to retrieve system username for current user

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

Action: Contact Oracle Worldwide Customer Support.

OSD-04218

Cannot post thread

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

Action: Contact Oracle Worldwide Customer Support.

OSD-04219

Bad thread list semaphore

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

Action: Contact Oracle Worldwide Customer Support.

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 NT file processing options string contains an invalid option or keyword.

Action: Set the Windows NT 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 for Windows NT 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 NT system service, WaitForSingleObject().

Action: Check the operating system error code and consult the Windows NT 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 Worldwide Customer Support.

OSD-04501

Internal buffer overflow

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

Action: Contact Oracle Worldwide Customer Support.Support.

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 logins 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 NT Group name is too long for internal buffer

Cause: The Windows NT Group name is too long.

Action: Use a shorter Windows NT group name.

---