1 2 Previous Next 18 Replies Latest reply: Jan 17, 2013 11:52 AM by user7904656 RSS

    database configuration assistant hangs at 85%

    Roger25
      I'm trying to install Oracle Database 11gR2. At the Oracle Database configuration step (more exactly Oracle database Configuration assistant step, which is In progress), the progress bar is at 85% for 2 hours, and nothing happens. I looked up in logs, but there are no errors. How much should i wait, and why it hangs at 85%?

      Regards
        • 1. Re: database configuration assistant hangs at 85%
          CKPT
          Roger22 wrote:
          I'm trying to install Oracle Database 11gR2. At the Oracle Database configuration step (more exactly Oracle database Configuration assistant step, which is In progress), the progress bar is at 85% for 2 hours, and nothing happens. I looked up in logs, but there are no errors. How much should i wait, and why it hangs at 85%?

          Regards
          What is OS?
          which logs you have looked? is it installation/configuration log files..?
          • 2. Re: database configuration assistant hangs at 85%
            Roger25
            Windows XP SP3
            logs are at d:\oracle\cfgtools\dbca\orcl, i ordered by date modified desc., and in emConfig.log i don't see any errors.
            Other logs are lockAccount.log, postDBCreation.log, cloneDBCreation.log, trace.log, postScripts.log, etc
            Which log should i consult?
            • 3. Re: database configuration assistant hangs at 85%
              CKPT
              Can you check postDBCreation.log?

              Also change process priority to high from task manager. until it completes.
              • 4. Re: database configuration assistant hangs at 85%
                Roger25
                postDBCreation:

                utl_recomp_begin: 10:14:23
                utl_recomp_end: 10:14:35
                Database closed.
                Database dismounted.
                ORACLE instance shut down.
                ORACLE instance started.
                Total System Global Area 535662592 bytes
                Fixed Size          1375792 bytes
                Variable Size          184549840 bytes
                Database Buffers     343932928 bytes
                Redo Buffers          5804032 bytes
                Database mounted.
                Database opened.
                     1
                     1


                Also, for which process should i set the priority to high?
                • 5. Re: database configuration assistant hangs at 85%
                  CKPT
                  Database mounted.
                  Database opened.
                  Is this information in logfile belongs to recent date & time?
                  If so the database is created and opened too. Just connect from SQL session and check the status of the instance. If it is in READ WRITE mode, You can safely cancel DBCA if there is no process so far.

                  Go to windows task manager --> in applications check your program right click and go to process --> on that process again right click set priority ---> give high.
                  • 6. Re: database configuration assistant hangs at 85%
                    Roger25
                    Yes, it belongs to a recent date&time
                    it seems that i can connect to the instance, and status is:
                    C:\Documents and Settings\Sorin>sqlplus system/radioprofm
                    
                    SQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 12 11:55:59 2011
                    
                    Copyright (c) 1982, 2010, Oracle.  All rights reserved.
                    
                    
                    Connected to:
                    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
                    With the Partitioning, OLAP, Data Mining and Real Application Testing options
                    
                    SQL> select status from v$instance;
                    
                    STATUS
                    ------------
                    OPEN
                    
                    SQL>
                    So can i press Stop, in dbca? at 85%?
                    • 7. Re: database configuration assistant hangs at 85%
                      CKPT
                      So can i press Stop, in dbca? at 85%?
                      No issues if your database is created and opened. :)
                      • 8. Re: database configuration assistant hangs at 85%
                        Roger25
                        This stage of 85% is at "Complete database creation", so i'm curious what more completion can occur, if the database is mounted and opened (that 15% remaining percent what is it for). i hope i will not loose something essential by issuind Stop dbca
                        • 9. Re: database configuration assistant hangs at 85%
                          Aman....
                          If the database is showing the status as Open, see the alert log file and what's the last message recorded in it. Also, try to shut the db down and start it up again. If all works fine, you are good to go IMO.

                          Aman....
                          • 10. Re: database configuration assistant hangs at 85%
                            Roger25
                            Where is the alert log file?
                            "good to go IMO" what means? :)
                            • 11. Re: database configuration assistant hangs at 85%
                              19426
                              Assuming you did not switch it off, last step in postcreation.sql is creating and starting the Enterprise Manager (dbconsole,database control). I guess here occurs a problem.

                              Check

                              emctl status dbconsole

                              Dbconsole is not mandatory, so the database itself may be ok (possibly the EM repository is not created).
                              • 12. Re: database configuration assistant hangs at 85%
                                CKPT
                                Roger22 wrote:
                                This stage of 85% is at "Complete database creation", so i'm curious what more completion can occur, if the database is mounted and opened (that 15% remaining percent what is it for). i hope i will not loose something essential by issuind Stop dbca
                                may be problem from OS or bugs or might problem with RPM's or another. But not sure ;-)
                                Check any event logs found in event viewer and perform some research
                                • 13. Re: database configuration assistant hangs at 85%
                                  Roger25
                                  C:\Documents and Settings\Sorin>emctl status dbconsole
                                  Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to da
                                  tabase unique name.
                                  
                                  C:\Documents and Settings\Sorin>set ORACLE_UNQNAME=orcl
                                  
                                  C:\Documents and Settings\Sorin>emctl status dbconsole
                                  OC4J Configuration issue. D:\oracle\product\11.2.0\dbhome_1/oc4j/j2ee/OC4J_DBCon
                                  sole_10.56.23.29_orcl not found.
                                  
                                  C:\Documents and Settings\Sorin>set ORACLE_HOSTNAME=localhost
                                  
                                  C:\Documents and Settings\Sorin>emctl status dbconsole
                                  OC4J Configuration issue. D:\oracle\product\11.2.0\dbhome_1/oc4j/j2ee/OC4J_DBCon
                                  sole_localhost_orcl not found.
                                  
                                  C:\Documents and Settings\Sorin>
                                  Well, i think i will stop dbca at 85% and i will create manually the EM dbconsole
                                  • 14. Re: database configuration assistant hangs at 85%
                                    CKPT
                                    Yes you can configure OEM again form DBCA or manually.

                                    http://www.akadia.com/services/ora_dbconsole.html
                                    1 2 Previous Next