Ask the Expert

Database Configuration Assistant gets stuck on step 8

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."

    Requires Free Membership to View

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 database.

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.

This was first published in February 2007

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: