Answer

Database Configuration Assistant gets stuck on step 8

I am using Oracle 9.2i on Windows XP. In creating a new database using "Database Configuration Assistant" I get stuck on step 8 of 8 -- after clicking the finish button, nothing happens.

Maria Anderson

Published: 27 Feb 2007

I am using Oracle 9.2i using Windows XP as my operating system. In creating a new database using "Database Configuration Assistant" I get stuck on step 8 of 8 -- after clicking the finish button, nothing happens. I tried the options available naming "generate a script" or "save as template."

First, you can check the DBCA logs which are stored under $ORACLE_HOME/assistants/dbca. If the assistant was experiencing difficulties creating the database, there should be log files in this subdirectory with information.

Second, did the service get created? Without a service, you (or the DBCA) will not be able to create a databas...

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please log in.

You have exceeded the maximum character limit.

Please provide a Corporate Email Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

Finally, is there an alert log? If there is one, it indicates that at least the database was partially created and it may contain specific Oracle errors that will help you troubleshoot the problem. The alert log will be located in the path defined for the background_dump_dest parameter of the database you are attempting to create.

How to create Oracle Multitenant database user accounts

Creating an Oracle Multitenant container database and PDBs

Oracle 18c features give DBAs incremental database capabilities

Oracle RMAN (Oracle Recovery Manager)

Dig Deeper on Oracle database installation, upgrades and patches

How to create Oracle Multitenant database user accounts

Creating an Oracle Multitenant container database and PDBs

Oracle 18c features give DBAs incremental database capabilities

Oracle RMAN (Oracle Recovery Manager)

Related Q&A from Maria Anderson

Error in invoking target install of makefile

Using /var/opt/oracle/oratab

How many database instances can be created?