Forum Stats

  • 3,838,704 Users
  • 2,262,394 Discussions
  • 7,900,739 Comments

Discussions

Database configuration Asssistant hanging at 44%

RamaniNJ
RamaniNJ Member Posts: 55
edited Nov 16, 2018 3:25AM in Database Installation

Hi:

I installed 12c on a Windows 10 server and when I used the Database Configuration Assistant to create a database, it hangs at 44%. Copying of database files and Creating and Starting of Oracle Instance show as finished. But it has been 44% at the Completing Database Creation task.

Can someone shed light on this issue?

Venki

«1

Answers

  • RamaniNJ
    RamaniNJ Member Posts: 55
    edited Nov 15, 2018 10:17AM

    Even though it is hung, I am able to log onto the instance using SQL Plus and execute a simple query "SELECT * FROM TAB;" successfully. But I am afraid I don't know which steps failed to be executed and what may be missing with this database.

  • top.gun
    top.gun Member Posts: 3,666 Gold Crown
    edited Nov 16, 2018 3:25AM

    So there is no error? How do you know it's hung and not slow?

    If the DB is available, then check the alert log for any errors.

  • janik
    janik Member Posts: 3

    same is happened to me what should i do?

  • amadis
    amadis Member Posts: 25 Red Ribbon

    Please provide last 15 lines from logfiles (you can see paths from DBCA log location and Alert log location on screen)

  • was this error resolved? Facing the same issue. Please help

  • amadis
    amadis Member Posts: 25 Red Ribbon

    Please provide last 15 lines from logfiles (you can see paths from DBCA log location and Alert log location on screen)

  • This is the Last 15 lines from the DBCA Alert Log location:

    INFO: Jan 18, 2021 7:08:25 AM oracle.assistants.common.base.util.AssistantAdvisor logMessage

    INFO: DBCA_PROGRESS : 32%



    [progressPage.flowWorker] [ 2021-01-18 07:08:25.812 EST ] [CloneDBCreationStep.executeImpl:566] Startup ......nomount......

    [progressPage.flowWorker] [ 2021-01-18 07:09:27.489 EST ] [CloneDBCreationStep.executeImpl:680] Enabling restricted session.

    [progressPage.flowWorker] [ 2021-01-18 07:09:32.579 EST ] [CloneDBCreationStep.executeImpl:684] alter database "ora" open resetlogs;

    [progressPage.flowWorker] [ 2021-01-18 07:09:37.152 EST ] [CloneDBCreationStep.executeImpl:712] Removing source db service: seeddataXDB

    [progressPage.flowWorker] [ 2021-01-18 07:09:37.171 EST ] [CloneDBCreationStep.executeImpl:712] Removing source db service: seeddata

    [progressPage.flowWorker] [ 2021-01-18 07:09:37.173 EST ] [CloneDBCreationStep.executeImpl:719] Renaming global_name

    INFO: Jan 18, 2021 7:09:37 AM oracle.assistants.dbca.driver.StepDBCAJob$1 update

    INFO: Percentage Progress got for job:Creating and starting Oracle instance progress:31.0



    INFO: Jan 18, 2021 7:09:37 AM oracle.assistants.common.base.util.AssistantAdvisor logMessage

    INFO: DBCA_PROGRESS : 36%



    [progressPage.flowWorker] [ 2021-01-18 07:09:37.179 EST ] [CloneDBCreationStep.executeImpl:735] Temp file to be added:=C:\app\Kobby\oradata\ORA\TEMP01.DBF

    [progressPage.flowWorker] [ 2021-01-18 07:09:37.179 EST ] [CloneDBCreationStep.executeImpl:736] Temp file size in KB:=20480

    [progressPage.flowWorker] [ 2021-01-18 07:09:37.346 EST ] [CloneDBCreationStep.executeImpl:784] Establish USERS as the default permanent tablespace of the database

    [progressPage.flowWorker] [ 2021-01-18 07:09:37.435 EST ] [CloneDBCreationStep.executeImpl:797] Resetting SYS and SYSTEM passwords

    [progressPage.flowWorker] [ 2021-01-18 07:09:37.563 EST ] [CloneDBCreationStep.executeImpl:802] SYS reset done

    [progressPage.flowWorker] [ 2021-01-18 07:09:37.786 EST ] [CloneDBCreationStep.executeImpl:811] SYSTEM reset done

    [progressPage.flowWorker] [ 2021-01-18 07:09:37.786 EST ] [CloneDBCreationStep.executeImpl:823] executing datapatch C:\Oracle19c\db_home\OPatch\datapatch.bat

    This is from the Database Alert Log Location:


    Global Name changed to ORA

    Starting background process CJQ0

    2021-01-18T07:09:36.722109-05:00

    CJQ0 started with pid=40, OS id=16608 

    Completed: alter database "ora" open resetlogs

    alter database rename global_name to "ora.fel.com"

    Completed: alter database rename global_name to "ora.fel.com"

    ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\app\Kobby\oradata\ORA\TEMP01.DBF' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED

    2021-01-18T07:09:37.292585-05:00

    Completed: ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\app\Kobby\oradata\ORA\TEMP01.DBF' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED

    ALTER DATABASE DEFAULT TABLESPACE "USERS"

    Completed: ALTER DATABASE DEFAULT TABLESPACE "USERS"

    TABLE AUDSYS.AUD$UNIFIED: ADDED INTERVAL PARTITION SYS_P181 (79) VALUES LESS THAN (TIMESTAMP' 2021-02-01 00:00:00')

    2021-01-18T09:51:04.503526-05:00

    Warning: VKTM detected a forward time drift. 

    Time drifts can result in unexpected behavior such as time-outs. 

    Please see the VKTM trace file for more details:

    C:\APP\KOBBY\diag\rdbms\ora\ora\trace\ora_vktm_5736.trc

  • Can someone please explain to me if the log indicates that the database was successfully created even though DBCA was stalled during the process?