Oracle9i Database Getting Started
Release 1 (9.0.1) for Windows

Part Number A90163-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to next page

A
Error Messages

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

This appendix contains these topics:

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 Oracle9i Database 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:\> exp USERNAME/PASSWORD parfile=FILENAME >file1.log 2>file2.err

With this command line, file1.log receives the standard output from the Export utility, while file2.err receives the standard error messages.

ORA-09275: CONNECT INTERNAL No Longer Supported

ORA-09275

Connect internal is no longer supported

Cause: CONNECT INTERNAL is no longer supported.

Action: Connect to the database as CONNECT / AS SYSDBA or an existing user with the appropriate password.

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

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

The 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 

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 backgound 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 

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 (init.ora) 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, then 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 damaged.

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 that 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, then 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 the 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, then 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, then 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, then 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, then 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, then 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 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 Support Services.

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 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: The 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: The target thread is processing an oradebug 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: The datafile ended in the middle of a record. This error occurs when loading files with a fixed record length.

Action: Verify that the datafile 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, load options, or both

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: 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: 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 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 elements

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-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' config.ora 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' init.ora variable not set to TRUE

Cause: For remote operating system logon 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.

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

ORADIM is a command-line utility for starting and stopping database instances that is only available on Oracle 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]. Please refer to the manual. 

00002 

Valid commands are: -DELETE, -EDIT, -NEW, -STARTUP, and -SHUTDOWN 

00003 

An argument is missing for the parameter 

00004 

Either a SID or service name is mandatory. Please enter a valid SID or service name 

00005 

You have entered a SID with more than 64 characters 

00006 

You have entered an empty 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. Please enter a valid SID name 

00010 

SYSTEM\CurrentControlSet\Services\OracleService key does not exist 

00011 

The service does not exist 

00012 

You did not enter a pfile for autostart capability 

00013 

The service start mode could not be set in the registry 

00014 

Cannot open the Windows NT 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 SID is already created. Please enter a different SID name. No action has been taken 

00021 

RegOpenkeyEx failed 

00022 

Please enter one of the following commands 

00023 

Create an instance by specifying the following parameters: 

00024 

-NEW -SID sid | -SRVC service [-INTPWD password] [-MAXUSERS number] [-STARTMODE a|m] [-PFILE file] [-TIMEOUT secs] 

00025 

Edit an instance by specifying the following parameters: 

00026 

-EDIT -SID sid [-NEWSID sid] [-INTPWD passwd] [-STARTMODE a|m] [-PFILE file] [-SHUTMODE a|i|n] [-SHUTTYPE srvc|inst] 

00027 

Delete instances by specifying the following: 

00028 

-DELETE -SID sid | -SRVC service name 

00029 

Startup services and instance by specifying the following parameters: 

00030 

-STARTUP -SID sid [-USRPWD password] [-STARTTYPE srvc|inst|srvc,inst] [-PFILE filename] 

00031 

Shutdown services and instance by specifying the following parameters: 

00032 

-SHUTDOWN -SID sid [-USRPWD password] [-SHUTTYPE srvc|inst|srvc,inst] [-SHUTMODE a | i | n] 

00033 

Query for help by specifying the following parameters: -? | -h | -help 

00034 

You have entered an invalid option for the -NEW command 

00035 

You have entered an invalid option for the -EDIT command 

00036 

You have entered an invalid option for the -DELETE command 

00037 

You have entered an invalid option for the -STARTUP command 

00038 

You have entered an invalid option for the -SHUTDOWN command 

00039 

Internal logic error in ORADIM 

DIM-00000

ORADIM completed with no errors

Cause: ORADIM has completed without any errors.

Action: None.

DIM-00001

ORADIM: <command> [options]. Please refer to the manual.

Cause: Command-line arguments could not be recognized.

Action: Usage: ORADIM <command> [options]

Use the following commands:

To create an instance:

-NEW -SID sid | -SRVC service name [-INTPWD password][-MAXUSERS number]
[-STARTMODE auto [-PFILE filename]| manual]

To edit an instance:

-EDIT -SID sid [-NEWSID sid][-INTPWD password][-STARTMODE auto
[-PFILE filename]| manual]

To delete an instance:

-DELETE -SID sid | -SRVC service name

To startup a service and instance:

-STARTUP -SID sid [-USRPWD password][-STARTTYPE srvc | inst | srvc,inst]
 [-PFILE filename]

To shutdown a service and instance:

-SHUTDOWN -SID sid [-USRPWD password][-SHUTTYPE srvc | inst | srvc,inst]
[-SHUTMODE a | i | n]

To query for help

-? | -h | -help

DIM-00002

Valid commands are: -DELETE, -EDIT, -NEW, -STARTUP, and -SHUTDOWN

Cause: You have not entered one of the referenced commands.

Action: Use the valid commands.

DIM-00003

An argument is missing for the parameter

Cause: You have entered an invalid argument.

Action: Use a valid argument and start the program again.

DIM-00004

Either a SID or service name is mandatory. Please enter a valid SID or service name

Cause: You have not entered the SID following -SID.

Action: Enter a valid SID of 64 characters and try again.

DIM-00005

You have entered SID with more than 64 characters

Cause: You have entered a SID with more than 64 characters.

Action: Change it to 64 or fewer characters and make sure that there is no other service with this name.

DIM-00006

You have entered an empty SID

Cause: Enter a SID with 64 characters and make sure that there is no service with this SID on your system.

Action: Fill in the SID and rerun the program.

DIM-00007

Missing or invalid -STARTMODE parameter. Valid -STARTMODE parameter is AUTO or MANUAL

Cause: You have not entered the valid start mode (AUTO or MANUAL).

Action: Enter the valid start mode and try again.

DIM-00008

A valid service name is OracleService appended with a SID

Cause: You have entered a service name other than OracleService(SID).

Action: Correct the name of service and try again.

DIM-00009

SID name is mandatory. Please enter a valid SID name

Cause: You did not enter a SID.

Action: Enter the SID and try again.

DIM-00010

SYSTEM\CurrentControlSet\Services\OracleService key does not exist

Cause: The referenced key is not in the registry.

Action: Try reinstalling. If the problem persists, then contact Oracle Support Services.

DIM-00011

The service does not exist

Cause: You have tried to edit a service which does not exist, or there is an error trying to access the registry.

Action: Verify service/SID name used and try again. Restart if necessary or contact Oracle Support Services.

DIM-00012

You did not enter a pfile for autostart capability

Cause: You did not provide the parameter file for starting the database.

Action: Enter the parameter file used to start the database and retry.

DIM-00013

The 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: Try again later, restart, or call Oracle Support Services.

DIM-00014

Cannot open the Windows NT Service Control Manager

Cause: The Service Control Manager could not be opened.

Action: Restart or call Oracle Support Services.

DIM-00015

Cannot start already-running ORACLE - shut it down first

Cause: The instance is already started; shut it down first.

Action: Stop the database before restarting.

DIM-00016

Missing or invalid -SHUTTYPE parameter. A valid -SHUTTYPE parameter is SRVC or INST

Cause: You did not enter a valid shuttype parameter (Service or Instance).

Action: Enter parameter to shut the instance or the service and try again.

DIM-00017

Instance shutdown mode must be one of the following: a for abort, i for immediate or n for normal

Cause: You did not enter the correct mode for shutting down the database.

Action: Enter the correct mode and try again.

DIM-00018

Failed to stop Oracle Service

Cause: Failed to stop the Oracle Service.

Action: Retry. If the error persists, then look at the system error or call Oracle Support Services.

DIM-00019

Create Service Error

Cause: Service could not be created.

Action: Look at the detail error.

DIM-00020

A service for this SID is already created. Please enter a different SID name. No action has been taken

Cause: Service with this name already exists.

Action: Retry with a different SID.

DIM-00021

RegOpenkeyEx failed

Cause: This is a system error due to the service not existing or Windows error.

Action: Retry, restart, or call Oracle Support Services.

DIM-00022

Please enter one of the following commands:

DIM-00023

Create an instance by specifying the following parameters:

DIM-00024

-NEW -SID sid | -SRVC service [-INTPWD password] [-MAXUSERS number] [-STARTMODE a|m] [-PFILE file] [-TIMEOUT secs]

DIM-00025

Edit an instance by specifying the following parameters:

DIM-00026

-EDIT -SID sid [-NEWSID sid] [-INTPWD passwd] [-STARTMODE a|m] [-PFILE file] [-SHUTMODE a|i|n] [-SHUTTYPE srvc|inst]

DIM00027

Delete instances by specifying the following:

DIM-00028

-DELETE -SID sid | -SRVC service name

DIM-00029

Startup services and instance by specifying the following parameters:

DIM-00030

-STARTUP -SID sid [-USRPWD password] [-STARTTYPE srvc|inst|srvc,inst] [-PFILE filename]

DIM-00031

Shutdown services and instance by specifying the following parameters:

DIM-00032

-SHUTDOWN -SID sid [-USRPWD password] [-SHUTTYPE srvc|inst|srvc,inst] [-SHUTMODE a | i | n]

DIM-00033

Query for help by specifying the following parameters: -? | -h |-help

DIM-00034

You have entered an invalid option for the -NEW command

DIM-00035

You have entered an invalid option for the -EDIT command

DIM-00036

You have entered an invalid option for the -DELETE command

DIM-00037

You have entered an invalid option for the -STARTUP command

DIM-00038

You have entered an invalid option for the -SHUTDOWN command

DIM-00039

Internal logic error in ORADIM

Database Connection Issues

The following are common Oracle9i 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 of the Oracle9i 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 the 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 the 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 the services.

ORA-06512

at line 2

Cause: tnsnames.ora and listener.ora files have not been correctly configured to use external procedures.

Action: Reconfigure the 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 at database startup.

Action: Delete and recreate 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 MS-DOS command prompt, enter: oradim -delete -sid sid where: sid is the name of your database (for example, orcl). Recreate the sid and services by entering: oradim -new -sid sid -intpwd password -startmode auto -pfile full path to init.ora

See Also:

Oracle9i Net Services Administrator's Guide


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

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback