Oracle9i Database Getting Started Release 1 (9.0.1) for Windows Part Number A90163-01 |
|
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:
The
Note:
ora.hlp
file, which was shipped in previous releases, is no longer available. See this Appendix, Oracle9i Database Error Messages, and Oracle Enterprise Manager Messages Manual for information on 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 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.
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.
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 |
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.
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.
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.
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.
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.
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.
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 |
00036 |
You have entered an invalid option for the |
00037 |
You have entered an invalid option for the |
00038 |
You have entered an invalid option for the |
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
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
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|