This discussion is archived
1 2 Previous Next 18 Replies Latest reply: Jan 17, 2013 9:52 AM by user7904656 RSS

database configuration assistant hangs at 85%

Roger25 Explorer
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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.... Oracle ACE
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    Where is the alert log file?
    "good to go IMO" what means? :)
  • 11. Re: database configuration assistant hangs at 85%
    19426 Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    Yes you can configure OEM again form DBCA or manually.

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points