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
OSD-04000 to OSD-04599: Windows-Specific Oracle Database Messages
DIM-00000 to DIM-00039: ORADIM Command Syntax Errors

Database Connection Issues

Note:

The ora.hlp file, which was shipped in previous releases, is no longer available. See this Appendix, Oracle Database Error Messages, and Oracle Enterprise Manager Messages Manual for information on error messages.

D.1 ORA-09275: CONNECT INTERNAL No Longer Supported

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

D.2 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 via 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

D.2.1 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 filename 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 filename 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.

D.2.2 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.

D.2.3 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.

D.2.4 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.

D.2.5 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.

D.2.6 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 is unable to receive input from standard input stream.; Action: Verify that process has access to an input device.

OSD-04506: Unable to spawn process via 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.

D.3 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-running 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 invoke 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 make sure 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-running 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 filename 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, make sure that user has enough privileges.

DIM-00076: Failed to delete service.; Cause: The request for service deletion failed.; Action: Check additional error, make sure that user has enough privileges.

DIM-00077: Failed to change service configuration.; Cause: An attempt to change configuration failed.; Action: Check additional error, make sure that user has enough privileges.

DIM-00078: Failed to start service.; Cause: The request to start service failed.; Action: Check additional error, make sure that user has enough privileges.

D.4 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 running.; Action: Ensure that both services are started.

ORA-12560: TNS: lost contact; Cause: OracleServiceSID service, OracleHOME_NAMETNSListener service, or both are not running. 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