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

    Login

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top