-
NID-00100 Cannot open datafile "string"
-
Cause: The specified datafile could not be opened.
-
Action: Ensure that the specified datafile exists and is writable.
NID-00101 LOGFILE (string) not accessible
-
Cause: The specified log file could not be opened.
-
Action: Specify a log file that is writable.
NID-00102 Garbled target string
-
Cause: The supplied connect string could not be parsed. The connect string does not have the correct format.
-
Action: Refer to Oracle9i Database Concepts.
NID-00103 Missing password in connect string "string"
-
Cause: Could not find the password in the supplied connect string. The connect string does not have the correct format.
-
Action: Refer to Oracle9i Database Concepts.
NID-00104 Need to specify TARGET connection parameter in command line
-
Cause: The mandatory parameter
TARGET
was not specified.
-
Action: Specify
TARGET=
username
/
password
when invoking this utility.
NID-00105 Need to specify "LOGFILE=<logfile>" when using APPEND=YES option
-
Cause: The
APPEND
parameter was specified withoutLOGFILE
.
-
Action: Specify
APPEND=YES
only whenLOGFILE
is also specified.
NID-00106 LOGIN to target database failed with Oracle error: string
-
Cause: An Oracle error was reported while attempting to log in to the target database.
-
Action: Follow the actions for the specified Oracle error.
NID-00107 File I/O error on datafile "string" during string operation (number/string)
-
Cause: An operating system error was reported while performing the specified operation in the specified file.
-
Action: Verify the datafile and check for operating system errors.
NID-00109 DBNAME string length number exceeds maximum length of number
-
Cause: The specified new database name exceeded the maximum size.
-
Action: Specify a shorter, valid name.
NID-00110 Cannot use REVERT and specify a database name at the same time
-
Cause: Conflicting options were specified on the command line.
-
Action: Choose only one of the options.
NID-00111 Oracle error reported from target database while executing string string
-
Cause: An Oracle error was reported when executing an OCI operation.
-
Action: Follow the actions for the specified Oracle error.
NID-00113 Error reading answer - aborting
-
Cause: Response caused an error.
-
Action: Retry the operation.
NID-00114 Must specify new database name when SETNAME is used
-
Cause:
SETNAME=YES
was specified but noDBNAME
was provided.
-
Action: Specify
DBNAME
or remove theSETNAME=YES
option.
NID-00115 Database should be mounted
-
Cause: The database was not mounted.
-
Action: Mount the database.
NID-00120 Database should be mounted exclusively
-
Cause: The database was started in parallel mode. To change the DBID, the database must be mounted exclusively.
-
Action: Shut down the database and start it in exclusive mode.
NID-00121 Database should not be open
-
Cause: The database was open. To change the DBID, the database must be mounted exclusively.
-
Action: Shut down the database and mount it in exclusive mode.
NID-00122 Database should have no offline immediate datafiles
-
Cause: The database has one or more datafiles that are in
OFFLINE IMMEDIATE
mode.
-
Action: Drop the datafiles or recover them and bring them online.
NID-00123 Magic number for datafile "string" is incorrect
-
Cause: Block 0 header has an incorrect magic number for the specified datafile.
-
Action: Verify that the datafile is correct and retry the operation.
NID-00124 Mismatched dbid for datafile string, expected number, found number
-
Cause: The dbid of the datafile does not match the old DBID or the new DBID.
-
Action: Verify that this datafile belongs to the database. You may need to restore a backup of the datafile.
NID-00125 Database should have no disabled datafiles
-
Cause: The database has one or more datafiles that are disabled.
-
Action: Drop the datafiles or recover them and bring them online.
NID-00126 Database should have no datafiles in unknown state
-
Cause: The database has one or more datafiles that are in an unknown state.
-
Action: Drop the datafiles or recover them and bring them online.
NID-00127 All online files in the database must have the same checkpoint SCN
-
Cause: The database has one or more datafiles that have a checkpoint SCN that does not match the database checkpoint SCN.
-
Action: Restart the database and shut it down cleanly, then retry the operation.
NID-00128 Cannot revert change of database, change not in progress
-
Cause: The
REVERT
option was used, but the control file does not show that a change of DBID was in progress.
-
Action: Do not use the
REVERT
option, or possibly restore the control file that was in place when the utility was started.
NID-00129 Invalid DBID for datafile "string", expecting number, found number
-
Cause: A datafile header shows a different DBID from the rest of the database files.
-
Action: Ensure that the file belongs to this database.
NID-00130 Mismatched CHECKPOINT_CHANGE# in datafile "string", expecting string, found string
-
Cause: The datafile header does not match information in the control file.
-
Action: Revert the change, open the database, and
verify that all datafiles are consistent. Then, shut down the database
and retry the operation.
NID-00131 Control file is not current
-
Cause: A non-current control file is currently mounted.
-
Action: Perform necessary actions to make the control file current and retry.
NID-00132 CHECKPOINT_CHANGE# in datafile "string": string in the future of controlfile: string
-
Cause: The checkpoint in the datafile header is ahead of the checkpoint in the control file.
-
Action: Make the database consistent and retry.
NID-00133 Database should have only consistent datafiles
-
Cause: The database has one or more datafiles that are marked FUZZY in the control file.
-
Action: Restart the database and shut down consistently, then retry the operation.
NID-00134 Datafile "string" is not consistent
-
Cause: The datafile is marked as fuzzy in its header.
-
Action: Restart the database and shut down cleanly, then retry the operation.
NID-00135 There are number active threads
-
Cause: There are active threads in the database. The most likely cause is that the database crashed the last time it was shut down.
-
Action: Ensure that all threads are closed before
retrying the operation. Start and open the database to perform crash
recovery, then shut down with the
NORMAL
orIMMEDIATE
options to close it cleanly. Finally, try running the utility again.
NID-00137 All datafiles that are not dropped should be readable
-
Cause: The database had one or more files that could not be read.
-
Action: Restore the missing files and retry the operation.
NID-00138 Block verification failed for datafile string (number)
-
Cause: Block header checksum yields a nonzero value for the specified datafile.
-
Action: Verify that the datafile is correct and retry the operation.
NID-00139 Mismatched dbname for datafile string, expected string, found string
-
Cause: The dbname of the datafile does not match the old dbname or the new dbname.
-
Action: Verify that this datafile belongs to the database. You may need to restore a backup of the datafile.
NID-00140 Specified database name string does not match previous name used string
-
Cause: This is a continuation of a failed attempt.
However in the failed attempt, the database name is different than the
one used in the last attempt.
-
Action: Retry the command using the original database name.
NID-00141 No database name specified, previous attempt used string
-
Cause: This is a continuation of a failed attempt. However, in the failed attempt, a database name was provided.
-
Action: Retry the command using the original database name.
NID-00142 Only changing database name, previous attempt changed dbid to number
-
Cause: This is a continuation of a failed attempt. However, in the failed attempt, the database id was also being changed.
-
Action: Retry the command removing
SETNAME=YES
.
NID-00143 Mismatched controlfile string
-
Cause: A controlfile did not have the correct status.
-
Action: Shut down the database, remove the mismatched controlfile, mount the database, and retry the operation.
NID-00144 New name for database string is the same as current name string
-
Cause: The specified name is the same as the current name of the database.
-
Action: Specify a different name or do not use the
DBNAME
option.
NID-00145 nls subsystem initialization failure for product=string, facility=string
-
Cause: The NLS product/facility error message file could not be located or properly initialized.
-
Action: Check that the error message directory and files have been properly installed.
Pages
- Home
- SQL Fundamentals
- SQL Fundamentals II
- SQL PLUS
- PL/SQL
- Forms and Reports
- HTML5
- JavaScript
- PHP
- jQuery
- Java
- NLS_LANG
- SQL SERVER
- PL/SQL Collections and Records
- DBMS_OUTPUT built-in package
- Date and Time
- PL/SQL Transactions
- Ref Cursors
- Bulk Binds
- PL/SQL Analytic Functions
- Problems and solves
- Oracle Indexes
- Oracle Courses
- PHP
- Work Samples
- Record & Collection
- LOOP
- Conditional statements
- Triggers
- Object Oriented
- Contact Me
Wednesday, May 27, 2015
Oracle Errors DBNEWID Messages (NID)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment