Removing Your Oracle Database
The task of removing an Oracle database differs based on what OS you are running on. For example, if you are running on UNIX, generally you must remove the related database files (database data files, online redo logs, and control files), files in the admin directories related to the database (database parameter files, trace files, etc.), and entries in ancillary database files such as the oratab, tnsnames.ora, and listener.ora files. If you are running on Windows, you need to make the same changes required on UNIX systems, but you also need to remove the database services for the database that you are removing. This will prevent errors from occurring when you start your Oracle database.
You can also use the DBCA to remove a database. The DBCA can be used to drop a database that you created with the DBCA or one that you manually created.
Oracle Database 10g offers a new command, drop database, that takes care of dropping your database for you. You still need to perform ancillary tasks, such as removing the database service and changing database files such as oratab, tnsnames.ora, and listener.ora.
Removing an Oracle database is quite different than removing the Oracle database software. If removing the software is your quest, you should first remove all Oracle databases on your system, and then use the Oracle Universal Installer to remove the Oracle RDBMS software. To completely remove the Oracle RDBMS software, you will probably have to manually remove files from the old ORACLE_HOME, as the installer is not always perfect in its removal process.
Tuesday, February 23, 2010
ORA-01079 ORACLE database was not properly created, operation aborted
ORA-01079 ORACLE database was not properly created, operation aborted
Possible Causes and Solutions
An error occurred during the creation of the Oracle database. Generally, this is followed by other error messages. Reasons for this error message might include
• Errors in the database initialization file. • Errors in the create database command. • Oracle RDBMS bugs.
Possible Causes and Solutions
An error occurred during the creation of the Oracle database. Generally, this is followed by other error messages. Reasons for this error message might include
• Errors in the database initialization file. • Errors in the create database command. • Oracle RDBMS bugs.
ORA-01078 Failure in processing system parameters
ORA-01078 Failure in processing system parameters
Possible Causes and Solutions
Several possible causes (generally followed by another error message):
• The parameter file could not be opened (followed by an LRM-00109 error message). Check that the parameter file exists, and that it can be opened and read by the database executable. By default, the database expects the parameter file to be in ORACLE_HOME/dbs (this is port-specific, however; for example, Windows expects it to be in $ORACLE_HOME/database by default).
• An unknown parameter may be included in the parameter file (error LRM-00101 also appears). Correct the unknown parameter and restart the database.
Possible Causes and Solutions
Several possible causes (generally followed by another error message):
• The parameter file could not be opened (followed by an LRM-00109 error message). Check that the parameter file exists, and that it can be opened and read by the database executable. By default, the database expects the parameter file to be in ORACLE_HOME/dbs (this is port-specific, however; for example, Windows expects it to be in $ORACLE_HOME/database by default).
• An unknown parameter may be included in the parameter file (error LRM-00101 also appears). Correct the unknown parameter and restart the database.
ORA-01031 Insufficient privileges
ORA-01031 Insufficient privileges
Possible Causes and Solutions
Generally, some security violation has occurred. Check the following: If the remote_login_passwordfile parameter is not set, or is set to none: 1. Make sure you are logged in as the Oracle user (or equivalent) if you are running in UNIX. 2. Make sure you are logged in to a Windows account that is a member of the ORA_DBA group. If the remote_login_passwordfile parameter is set, then make sure you are logging in with the correct password. If you cannot remember the password for your database, you can 1. Use the orapwd utility to create an Oracle database password file. 2. Add the Windows user you are signed in as to the ORA_DBA group.
Possible Causes and Solutions
Generally, some security violation has occurred. Check the following: If the remote_login_passwordfile parameter is not set, or is set to none: 1. Make sure you are logged in as the Oracle user (or equivalent) if you are running in UNIX. 2. Make sure you are logged in to a Windows account that is a member of the ORA_DBA group. If the remote_login_passwordfile parameter is set, then make sure you are logging in with the correct password. If you cannot remember the password for your database, you can 1. Use the orapwd utility to create an Oracle database password file. 2. Add the Windows user you are signed in as to the ORA_DBA group.
ORA-00221 Error on write to controlfile
ORA-00221 Error on write to controlfile
Possible Causes and Solutions
An error has occurred when trying to create the control file, or on subsequent writes to the control file. You should make sure that the file system can be written to by the Oracle database login account. Also make sure that a control file does not already exist.
Possible Causes and Solutions
An error has occurred when trying to create the control file, or on subsequent writes to the control file. You should make sure that the file system can be written to by the Oracle database login account. Also make sure that a control file does not already exist.
ORA-00215 Must be at least one controlfile
ORA-00215 Must be at least one controlfile
Possible Causes and Solutions
You do not have at least one control file listed in your database parameter file, which is required. Correct the parameter file and re-run.
Possible Causes and Solutions
You do not have at least one control file listed in your database parameter file, which is required. Correct the parameter file and re-run.
ORA-00213 Cannot reuse controlfile
ORA-00213 Cannot reuse controlfile
Possible Causes and Solutions
Generally, you are re-creating a database that previously existed, or a previous database creation failed. Remove the control files, and try to create the database again. Exercise caution, and make sure you remove the correct control file. This error may indicate that you are trying to overwrite the control files of another database.
Possible Causes and Solutions
Generally, you are re-creating a database that previously existed, or a previous database creation failed. Remove the control files, and try to create the database again. Exercise caution, and make sure you remove the correct control file. This error may indicate that you are trying to overwrite the control files of another database.
Subscribe to:
Posts (Atom)