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