D Error Messages on Windows

This appendix lists error messages, causes, and corrective actions that are specific to operation of Oracle Database for Windows. This appendix also includes database connection issues.

This appendix contains these topics:

ORA-09275: CONNECT INTERNAL No Longer Supported

ORA-09275
Connect internal is not a valid DBA connection
Cause: CONNECT INTERNAL is no longer supported for DBA connections.
Action: If NTS is enabled, you can connect to the database as CONNECT / AS SYSDBA or CONNECT / AS SYSOPER. If NTS is not enabled, you can connect as CONNECT SYS AS SYSDBA. You can also connect as an existing user with the appropriate password.

OSD-04000 to OSD-04599: Windows-Specific Oracle Database Messages

Error messages in this section are Oracle Database operating system-dependent (OSD) messages displayed in response to an error condition in Windows. Each message in this section triggers an Oracle Database error message.

Error messages appear first in summary tables consisting of error numbers and the corresponding error message. Following the tables is a more detailed discussion of errors, including causes and corrective actions.

  • 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
    4000 Logical block size mismatch
    4001 Invalid logical block size
    4002 Unable to open file
    4003 Unable to read file header block
    4004 Invalid file header
    4005 SetFilePointer() failure, unable to read from file
    4006 ReadFile() failure, unable to read from file
    4007 Truncated read
    4008 WriteFile() failure, unable to write to file
    4009 Truncated write
    4010 <create> option specified, file already exists
    4011 GetFileInformationByHandle() failure, unable to obtain file info
    4012 File size mismatch
    4013 Unable to read line from file
    4014 Unable to close file
    4015 An asynchronous I/O request returned an error
    4016 Error queuing an asynchronous I/O request
    4017 Unable to open the specified RAW device
    4018 Unable to access the specified directory or device
    4019 Unable to set file pointer
    4020 Unable to set eof file marker
    4021 Unable to read file
    4022 Unable to write file
    4023 SleepEx() failure, unable to Sleep
    4024 Unable to delete file
    4025 Invalid question asked
    4026 Invalid parameter passed

    Memory Errors: OSD-04100 to OSD-04199
    4100 malloc() failure, unable to allocate memory
    4101 Invalid SGA: SGA not initialized
    4102 Unable to open/create file for shared memory object
    4103 Unable to attach to SGA: SGA does not exist
    4104 Unable to map shared memory (SGA) into the address space
    4105 Shared memory (SGA) mapped to wrong address
    4106 Unable to allocate memory with VirtualAlloc
    4107 Unable to deallocate memory with VirtualFree
    4108 Unable to protect memory with VirtualProtect

    Process Errors: OSD-04200 to OSD-04299
    4200 Unable to begin another thread
    4201 No pid structure supplied to spdcr()
    4202 DosSetPriority() failure, unable to set process priority
    4203 DosKillProcess() failure, unable to kill process
    4204 Invalid pid
    4205 CreateProcess() failure, unable to spawn process
    4207 Invalid priority specified in CONFIG parameter ORACLE_PRIORITY
    4208 OpenProcess() failure, unable to open process handle
    4209 Incorrect or unknown background image name given to spdcr()
    4210 Timeout waiting for thread semaphore
    4211 Thread information not found
    4212 Maximum number of ORACLE threads reached
    4213 ORACLE thread unable to DuplicateHandle()
    4214 ORACLE thread unable to CreateEvent()
    4215 Bad function code supplied to ssthreadop
    4216 Unable to find file handle for that thread
    4217 Unable to retrieve system username for current user
    4218 Cannot post thread
    4219 Bad thread list semaphore
    4221 Target thread is currently busy
    4222 Unable to get the threads context
    4223 Unable to set the threads context
    4224 Unable to suspend the target thread
    4225 Unable to resume the target thread

    Loader Errors: OSD-04300 to OSD-04399
    4300 Unable to read complete record from datafile
    4301 Record size too large
    4302 Invalid record type, load options, or both

    Semaphore Errors: OSD-04400 to OSD-04499
    4400 Unable to acquire internal semaphore for process
    4401 WaitForSingleObject() failure, unable to obtain semaphore

    Miscellaneous Errors: OSD-04500 to OSD-04599
    4500 Illegal option specified
    4501 Internal buffer overflow
    4502 Translations nested too deep
    4503 Text contains no translatable elements
    4505 stdin not responding
    4506 Unable to spawn process through system()
    4510 Operating system roles are not supported
    4511 Unable to get date and time from the operating system
    4512 Unable to translate the 'USERNAME' config.ora variable on server
    4513 'remote_os_authent' init.ora variable not set to true
    4514 The Windows Group name is too long for internal buffer
    4515 This command is not implemented at this time

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

OSD-04000
Logical block size mismatch
Cause: Database block size specified in initialization parameter file does not match block size of actual database files.
Action: Use matching logical block sizes.
OSD-04001
Invalid logical block size
Cause: 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: Specified path or file name is invalid, or destination device is full. This error can also be caused by insufficient Windows file handles.
Action: Make sure path and file exist, and device has free space. If this fails, then increase number of Windows file handles.
OSD-04003
Unable to read file header block
Cause: Media has been damaged.
Action: Recover file, if necessary, and verify that Windows is functioning correctly.
OSD-04004
Invalid file header
Cause: File is damaged.
Action: Recover file.
OSD-04005
SetFilePointer() failure, unable to read from file
Cause: Unexpected return from Windows system service SetFilePointer().
Action: Check operating system error code and operating system documentation.
OSD-04006
ReadFile() failure, unable to read from file
Cause: Unexpected return from Windows system service ReadFile().
Action: Check operating system error code and operating system documentation.
OSD-04007
Truncated read
Cause: System encountered an unexpected end-of-file, which is due to damaged media.
Action: Verify that file is not damaged.
OSD-04008
WriteFile() failure, unable to write to file
Cause: Unexpected return from Windows system service WriteFile().
Action: Check operating system error code and operating system documentation.
OSD-04009
Truncated write
Cause: Destination device is full, or media is damaged.
Action: Verify that device has free space and that file is not damaged.
OSD-04010
<create> option specified, file already exists
Cause: File you attempted to create already exists.
Action: Delete existing file or use REUSE option in SQL statement.
OSD-04011
GetFileInformationByHandle() failure, unable to obtain file info
Cause: Unexpected return from Windows system service GetFileInformationByHandle().
Action: Check operating system error code and operating system documentation.
OSD-04012
File size mismatch
Cause: File to be re-used is either too large or too small.
Action: Specify correct file size or delete 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 operating system error code (if available) and operating system documentation. If no operating system error code is presented, then verify that media is not damaged.
OSD-04014
Unable to close file
Cause: Media has been damaged.
Action: Recover file, if necessary, and verify that Windows is functioning correctly.
OSD-04015
Asynchronous I/O request returned an error
Cause: Unexpected return from Windows system service.
Action: Check operating system error code and operating system documentation.
OSD-04016
Error queuing an asynchronous I/O request
Cause: Unexpected return from Windows system service.
Action: Check operating system error code and operating system documentation.
OSD-04017
Unable to open the specified RAW device
Cause: An invalid path or file name was specified, or device is full.
Action: Make sure file exists and device is not full; verify that 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 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 operating system error code (if available) and operating system documentation. If no operating system error code is presented, then verify that 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 operating system error code (if available) and operating system documentation. If no operating system error code is presented, then verify that 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 operating system error code (if available) and operating system documentation. If no operating system error code is presented, then verify that 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 operating system error code (if available) and operating system documentation. If no operating system error code is presented, then verify that media is not damaged.
OSD-04023
SleepEx() failure, unable to Sleep
Cause: Unexpected return from Windows system service.
Action: Check operating system error code and operating system documentation.
OSD-04024
Unable to delete file
Cause: This error is caused by an operating system error or by damaged media.
Action: Check operating system error code (if available) and operating system documentation. If no operating system error code is presented, then verify that 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: 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: System Global Area (SGA) has been allocated but not initialized.
Action: Wait until STARTUP has completed before attempting to connect.
OSD-04102
Unable to open/create file for shared memory object
Cause: Unexpected return from Windows system service CreateFile().
Action: Check operating system error code and operating system documentation.
OSD-04103
Unable to attach to SGA: SGA does not exist
Cause: SGA does not exist.
Action: Start up an Oracle Database instance.
OSD-04104
Unable to map shared memory (SGA) into the address space
Cause: Unexpected return from Windows system service MapViewOfFileEx().
Action: Check operating system error code and operating system documentation.
OSD-04105
Shared memory (SGA) mapped to wrong address
Cause: Unexpected return from Windows system service MapViewOfFileEx().
Action: Check operating system error code and operating system documentation.
OSD-04106
Unable to allocate memory with VirtualAlloc
Cause: 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: Unexpected return from Windows system service VirtualFree().
Action: Check operating system error code and operating system documentation.
OSD-04108
Unable to protect memory with VirtualProtect
Cause: Unexpected return from Windows system service VirtualProtect().
Action: Check operating system error code and operating system documentation.

Process Errors: OSD-04200 to OSD-04299

OSD-04200
Unable to begin another thread
Cause: 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: Unexpected return from Windows system service DosSetPriority().
Action: Check operating system error code and operating system documentation.
OSD-04203
DosKillProcess() failure, unable to kill process
Cause: Unexpected return from Windows system service DosKillProcess().
Action: Check operating system error code and operating system 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: Unexpected return from Windows system service CreateProcess().
Action: Check operating system error code and operating system documentation.
OSD-04207
Invalid priority specified in CONFIG parameter ORACLE_PRIORITY
Cause: 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: Unexpected return from Windows system service OpenProcess().
Action: Check operating system error code and operating system documentation.
OSD-04209
Incorrect or unknown background image name given to spdcr()
Cause: Unexpected background name given to spdcr().
Action: Contact Oracle Support Services.
OSD-04210
Timeout waiting for thread semaphore
Cause: An Oracle Database thread died holding the semaphore.
Action: Restart Oracle Database instance.
OSD-04211
Thread information not found
Cause: An Oracle Database thread died without deleting its information.
Action: Restart Oracle Database instance.
OSD-04212
Maximum number of Oracle threads reached
Cause: Maximum number of Oracle 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: Target thread is processing an Oracle Database utility command.
Action: Wait and resend command.
OSD-04222
Unable to get the threads context
Cause: Check operating system error code.
Action: Remedy operating system error.
OSD-04223
Unable to set the threads context
Cause: Check operating system error code.
Action: Remedy operating system error.
OSD-04224
Unable to suspend the target thread
Cause: Check operating system error code.
Action: Remedy operating system error.
OSD-04225
Unable to resume the target thread
Cause: Check operating system error code.
Action: Remedy operating system error.

Loader Errors: OSD-04300 to OSD-04399

OSD-04300
Unable to read complete record from datafile
Cause: Datafile ended in the middle of a record. This error occurs when loading files with a fixed record length.
Action: Verify that datafile is of correct length and contains complete records.
OSD-04301
Record size too large
Cause: Specified record size is too large to load.
Action: Reduce record size and reload data.
OSD-04302
Invalid record type, load options, or both
Cause: Control file's Windows file processing options string contains an invalid option or keyword.
Action: Set 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: Oracle Database has exceeded the maximum number of connections.
Action: Delete any unused connections and try again.
OSD-04401
WaitForSingleObject() failure, unable to obtain semaphore
Cause: Unexpected return from Windows system service WaitForSingleObject().
Action: Check operating system error code and operating system 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: Program encountered too many intermediate translations while attempting to translate a configuration variable.
Action: Simplify values of configuration parameters to include fewer intermediate translations.
OSD-04503
Text contains no translatable elements
Cause: Program cannot recognize variables in text to be translated.
Action: Check and, if necessary, correct text to be translated.
OSD-04505
stdin not responding
Cause: System cannot receive input from standard input stream.
Action: Verify that process has access to an input device.
OSD-04506
Unable to spawn process through system()
Cause: System is out of memory or executable is invalid.
Action: Shut down unnecessary processes; install more memory in the computer. Verify name of executable.
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: Unexpected return from GetLocalTime() call.
Action: Verify that system time is correct on the computer.
OSD-04512
Unable to translate the 'USERNAME' config.ora variable on server
Cause: 'USERNAME' configuration parameter variable on host is not properly set.
Action: Verify 'USERNAME' variable is set.
OSD-04513
'remote_os_authent' init.ora variable not set to TRUE
Cause: For remote operating system logon to function, 'REMOTE_OS_AUTHENT' parameter must be set to TRUE.
Action: Shut down and start up instance with 'REMOTE_OS_AUTHENT = TRUE' in initialization parameter file.
OSD-04514
The Windows Group name is too long for internal buffer
Cause: Windows Group name is too long.
Action: Use a shorter Windows group name.

DIM-00000 to DIM-00039: ORADIM Command Syntax Errors

ORADIM is a command-line tool for starting and stopping database instances that is only available on Oracle Database for Windows. It is not available on any other platform.

Oradim Errors DIM-0000 to DIM-0039
00000 ORADIM completed with no errors
00001 ORADIM: <command> [options]. Refer to manual.
00002 The specified command was invalid.
00003 An argument is missing for the parameter
00004 SID or service name was not specified.
00005 SID with more than 64 characters specified.
00006 Missing SID
00007 Missing or invalid -STARTMODE parameter. Valid -STARTMODE parameter is AUTO or MANUAL.
00008 A valid service name is OracleService appended with a SID
00009 SID name is mandatory.
00010 SYSTEM\CurrentControlSet\Services\OracleService key does not exist.
00011 The specified service does not exist.
00012 A PFILE is necessary for AUTOSTART option.
00013 Service start mode could not be set in the registry.
00014 Cannot open the Windows Service Control Manager.
00015 Cannot start already- ORACLE - shut it down first.
00016 Missing or invalid -SHUTTYPE parameter. A valid -SHUTTYPE parameter is SRVC or INST.
00017 Instance shutdown mode must be one of the following: a for abort, i for immediate or n for normal.
00018 Failed to stop Oracle Service.
00019 Create Service Error.
00020 A service for this name exists.
00021 Registry open failed.
00023 Create an instance by specifying the following options:
00024 -NEW -SID sid | -SRVC srvc | -ASMSID sid | -ASMSRVC srvc [-SYSPWD pass]
00025 [-STARTMODE auto | manual] [-SRVCSTART system | demand] [-PFILE file | -SPFILE]
00026 [-SHUTMODE normal | immediate | abort] [-TIMEOUT secs] [-RUNAS osusr/ospass]
00027 Edit an instance by specifying the following options:
00028 -EDIT -SID sid | -ASMSID sid [-SYSPWD pass]
00029 [-STARTMODE auto | manual] [SRVCSTART system | demand] [-PFILE file | -SPFILE]
00030 [-SHUTMODE normal | immediate | abort] [-SHUTTYPE srvc | inst] [-RUNAS osusr/ospass]
00031 Delete instances by specifying the following options:
00032 -DELETE -SID sid | -ASMSID sid | -SRVC srvc | -ASMSRVC srvc
00033 Startup services and instance by specifying the following options:
00034 -STARTUP -SID sid | -ASMSID sid [-SYSPWD pass]
00035 [-STARTTYPE srvc | inst | srvc,inst] [-PFILE filename | -SPFILE]
00036 Shutdown services and instance by specifying the following options:
00037 -SHUTDOWN -SID sid | -ASMSID sid [-SYSPWD pass]
00038 [-SHUTTYPE srvc | inst | srvc,inst] [-SHUTMODE normal | immediate | abort]
00039 Query for help by specifying the following parameters: -? | -h | -help
00040 Invalid option for the -NEW command.
00041 Invalid option for the -EDIT command.
00042 Invalid option for the -DELETE command.
00043 Invalid option for the -STARTUP command.
00044 Invalid option for the -SHUTDOWN command.
00045 Internal error in ORADIM.
00046 Invalid Pfile.
00050 Instance deleted.
00051 Instance created.
00075 Failed to control service.
00076 Failed to delete service.
00077 Failed to change service configuration.
00078 Failed to start service.

DIM-00000
ORADIM completed with no errors.
Cause: The specified operation completed successfully.
Action: None.
DIM-00001
ORADIM: <command> [options]. Refer to manual.
Cause: The specified options were invalid or no arguments were supplied.
Action: Usage: ORADIM <command> [options]
DIM-00002
The specified command was invalid.
Cause: Valid commands are: -DELETE, -EDIT, -NEW, -STARTUP, and -SHUTDOWN.
Action: Use valid command.
DIM-00003
An argument is missing for the parameter.
Cause: Missing or invalid argument.
Action: Use a valid argument and run the program again.
DIM-00004
SID or service name was not specified.
Cause: Either a SID or service name is mandatory.
Action: Enter a valid SID of 64 characters and retry.
DIM-00005
SID with more than 64 characters specified.
Cause: SID with more than 64 characters specified.
Action: Change SID to 64 unique characters and ensure that there is no other service with this name.
DIM-00006
Missing SID.
Cause: SID was not specified in the arguments.
Action: Specify a SID.
DIM-00007
Missing or invalid -STARTMODE parameter. Valid -STARTMODE parameter is AUTO or MANUAL.
Cause: An argument for STARTMODE is missing.
Action: Enter a valid start mode and retry.
DIM-00008
A valid service name is OracleService appended with a SID
Cause: The Oracle service name specified is invalid.
Action: Correct the name of service and retry.
DIM-00009
SID name is mandatory.
Cause: SID was not specified.
Action: Enter the SID and retry.
DIM-00010
SYSTEM\CurrentControlSet\Services\OracleService key does not exist.
Cause: Specified registry key was not found.
Action: Try reinstalling. If the problem persists, contact Oracle Support Services.
DIM-00011
The specified service does not exist.
Cause: An attempt to edit a service failed.
Action: Make sure the service exists or user has enough privileges.
DIM-00012
A PFILE is necessary for AUTOSTART option.
Cause: A parameter file {PFILE} was not specified.
Action: Specify a parameter file.
DIM-00013
Service start mode could not be set in the registry.
Cause: The start mode entry in the registry for the service could not be set.
Action: Check if the user has privileges to modify registry.
DIM-00014
Cannot open the Windows Service Control Manager.
Cause: The Service Control Manager could not be opened.
Action: Check for user privileges.
DIM-00015
Cannot start already- ORACLE - shut it down first.
Cause: The instance is already started.
Action: Stop the database before restarting.
DIM-00016
Missing or invalid -SHUTTYPE parameter. A valid -SHUTTYPE parameter is SRVC or INST.
Cause: An option for SHUTTYPE was missing or invalid.
Action: Enter parameter to shut down the instance or the service and retry.
DIM-00017
Instance shutdown mode must be one of the following: a for abort, i for immediate or n for normal.
Cause: Invalid option to shut down the instance was specified.
Action: Enter the correct mode and retry.
DIM-00018
Failed to stop Oracle Service.
Cause: An attempt to stop the service failed.
Action: Retry, check for user privileges.
DIM-00019
Create service error.
Cause: Service could not be created.
Action: Check for user privileges and retry.
DIM-00020
A service for this name exists.
Cause: An attempt was made to create a service name when it already existed.
Action: Retry with a different service name or SID.
DIM-00021
Registry open failed
Cause: An attempt to open the registry failed.
Action: Check for user privileges and retry the operation.
DIM-00023
Create an instance by specifying the following options:
Cause: n/a
Action: n/a
DIM-00024
-NEW -SID sid | -SRVC srvc | -ASMSID sid | -ASMSRVC srvc [-SYSPWD pass]
Cause: n/a
Action: n/a
DIM-00025
[-STARTMODE auto | manual] [-SRVCSTART system | demand] [-PFILE file | -SPFILE]
Cause: n/a
Action: n/a
DIM-00026
[-SHUTMODE normal | immediate | abort] [-TIMEOUT secs] [-RUNAS osusr/ospass]
Cause: n/a
Action: n/a
DIM00027
Edit an instance by specifying the following options:
Cause: n/a
Action: n/a
DIM-00028
-EDIT -SID sid | -ASMSID sid [-SYSPWD pass]
Cause: n/a
Action: n/a
DIM-00029
[-STARTMODE auto | manual] [-SRVCSTART system | demand] [-PFILE file | -SPFILE]
Cause: n/a
Action: n/a
DIM-00030
[-SHUTMODE normal | immediate | abort] [-SHUTTYPE srvc | inst] [-RUNAS osusr/ospass]
Cause: n/a
Action: n/a
DIM-00031
Delete instances by specifying the following options:
Cause: n/a
Action: n/a
DIM-00032
-DELETE -SID sid | -ASMSID sid | -SRVC srvc | -ASMSRVC srvc
Cause: n/a
Action: n/a
DIM-00033
Start up services and instance by specifying the following options:
Cause: n/a
Action: n/a
DIM-00034
-STARTUP -SID sid | -ASMSID sid [-SYSPWD pass]
Cause: n/a
Action: n/a
DIM-00035
[-STARTTYPE srvc | inst | srvc,inst] [-PFILE filename | -SPFILE]
Cause: n/a
Action: n/a
DIM-00036
Shut down services and instance by specifying the following options:
Cause: n/a
Action: n/a
DIM-00037
-SHUTDOWN -SID sid | -ASMSID sid [-SYSPWD pass]
Cause: n/a
Action: n/a
DIM-00038
[-SHUTTYPE srvc | inst | srvc,inst] [-SHUTMODE normal | immediate | abort]
Cause: n/a
Action: n/a
DIM-00039
Query for help by specifying the following parameters: -? | -h | -help
Cause: n/a
Action: n/a
DIM-00040
Invalid option for the -NEW command.
Cause: One or more arguments for creating new service is invalid.
Action: Specify required option and retry.
DIM-00041
Invalid option for the -EDIT command.
Cause: One or more arguments for editing existing service is invalid.
Action: Specify required option and retry.
DIM-00042
Invalid option for the -DELETE command.
Cause: One or more arguments for deleting service is invalid.
Action: Specify required option and retry.
DIM-00043
Invalid option for the -STARTUP command.
Cause: One or more arguments for starting the instance is invalid.
Action: Specify required option and retry.
DIM-00044
Invalid option for the -SHUTDOWN command.
Cause: One or more arguments for shutting down the instance is invalid.
Action: Specify required option and retry.
DIM-00045
Internal error in ORADIM
Cause: Unknown.
Action: Contact Oracle Support Services.
DIM-00046
Invalid Pfile.
Cause: The parameter file name is invalid.
Action: Check that the path name is correct.
DIM-00050
Instance deleted
Cause: The request for deleting instance was successful.
Action: None.
DIM-00051
Instance created.
Cause: The request for creating new instance was successful.
Action: None.
DIM-00075
Failed to control service.
Cause: An attempt to control the service failed.
Action: Check additional error, ensure that user has enough privileges.
DIM-00076
Failed to delete service.
Cause: The request for service deletion failed.
Action: Check additional error, ensure that user has enough privileges.
DIM-00077
Failed to change service configuration.
Cause: An attempt to change configuration failed.
Action: Check additional error, ensure that user has enough privileges.
DIM-00078
Failed to start service.
Cause: The request to start service failed.
Action: Check additional error, ensure that user has enough privileges.

Database Connection Issues

The following are common Oracle Database connection error codes, their causes, and suggested remedies.

TNS-12203
TNS: unable to connect to destination
Cause: OracleServiceSID service, OracleHOME_NAMETNSListener service, or both are not.
Action: Ensure that both services are started.
ORA-12560
TNS: lost contact
Cause: OracleServiceSID service, OracleHOME_NAMETNSListener service, or both are not. You receive this error if you attempt to use any Oracle Database utilities, such as SQL*Plus. This error is analogous to the following Oracle7 error: ORA-09352: Windows 32-bit Two-Task driver unable to spawn new ORACLE task.
Action: Ensure that both services are started.
ORA-28575
unable to open RPC connection to external procedure agent
Cause: tnsnames.ora and listener.ora files have not been correctly configured to use external procedures.
Action: Reconfigure services.
ORA-06512
at "APPLICATIONS.OSEXEC", line 0
Cause: tnsnames.ora and listener.ora files have not been correctly configured to use external procedures.
Action: Reconfigure services.
ORA-06512
at "APPLICATIONS.TEST", line 4
Cause: tnsnames.ora and listener.ora files have not been correctly configured to use external procedures.
Action: Reconfigure services.
ORA-06512
at line 2
Cause: tnsnames.ora and listener.ora files have not been correctly configured to use external procedures.
Action: Reconfigure services.
ORA-01031 and LCC-00161
Both codes appear at startup
Cause: Parameter file (init.ora) or Windows services are damaged. These errors usually appear when the parameter file cannot be read by Oracle Database at database startup.
Action: Delete and re-create the SID and services. Make sure you are logged on as the user Administrator, or a user within the Windows Administrator's Group with full administrative rights. At the command prompt, enter: oradim -delete -sid sid where sid is the name of your database (for example, orcl). Re-create the SID and services by entering: oradim -new -sid sid -startmode auto -pfile full_path_to_init.ora