How to install Oracle Database 12.1.0.2 and to create databases in silent mode on Windows 2012

This blog post shows how to install Oracle Database 12.1.0.2 in silent mode and to use DBCA in silent mode to create a 12.1.0.2 database on Windows 2012:

  • for a database using ASM storage and Grid Infrastructure (GI)
  • for a database using only NTFS storage.
  • The configuration used is Windows 2012 and VirtualBox 4.3.16 used in my previous blog article.
    The Windows user account that is used is oracle unless otherwise stated. GI 12.1.0.2 has already been installed on this server.

    Oracle Database 12.1.0.2 installation in silent mode

    On host machine unzip winx64_12102_database_1of2.zip and winx64_12102_database_2of2.zip in same target directory winx64_12102_database. I have not been unable to run F:\winx64_12102_database\database\setup.exe. So I have copied database directory to H:\stage:

    PS H:\> xcopy F:\winx64_12102_database\database stage /s
    

    Launch following script to install Oracle Database 12.1.0.2 into H:\oracle\db12102 directory (note ORACLE_HOSTNAME and oracle.install.db.isRACOneInstall settings) – the actual script has all options and parameters in one single line:

    H:\stage>.\setup.exe -silent 
    ORACLE_BASE="h:\oracle\base" 
    ORACLE_HOME="h:\oracle\db12102"  
    ORACLE_HOSTNAME=w12dc01 
    oracle.install.option=INSTALL_DB_SWONLY 
    SELECTED_LANGUAGES=en 
    oracle.install.IsBuiltInAccount=true 
    oracle.install.db.InstallEdition=EE 
    oracle.install.db.isRACOneInstall=false 
    oracle.install.IsBuiltInAccount=true 
    SECURITY_UPDATES_VIA_MYORACLESUPPORT=false 
    DECLINE_SECURITY_UPDATES=true
    

    Answer Yes to Windows UAC window to allow setup.exe execution; a new window is opened where the following should be displayed:

     Preparing to launch Oracle Universal Installer from C:\Users\oracle\AppData\Local\Temp\OraInstall2014-10-28_10-23-35PM. Please wait ... 
    [WARNING] [INS-35810] You have selected to use Built-in Account for installation and configuration of O
    racle Home. Oracle recommends that you specify a Windows User Account with limited privilege to install and configure a secure Oracle Home.
       ACTION: Specify a Windows User Account.
    [WARNING] [INS-32018] The selected Oracle home is outside of Oracle base.
       ACTION: Oracle recommends installing Oracle software within the Oracle base directory. Adjust the Oracle home or Oracle base accordingly.
    You can find the log of this install session at:
     C:\Program Files\Oracle\Inventory\logs\installActions2014-10-28_10-23-35PM.log
    Dll to load is C:\Users\oracle\AppData\Local\Temp\OraInstall2014-10-28_10-23-35PM\Win64RunProcesses.dll
    Loading psapi.dll from C:\Users\oracle\AppData\Local\Temp\OraInstall2014-10-28_10-23-35PM\psapi.dll
    PersistEnv
    INFO: h:\oracle\db12102\odp.net\managed\common\oracle.manageddataaccess.dll is registered successfully in GAC.
    INFO: h:\oracle\db12102\odp.net\managed\publisherpolicy\4\policy.4.121.oracle.manageddataaccess.dll is registered successfully in GAC.
    INFO: h:\oracle\db12102\odp.net\managed\x64\oracle.manageddataaccessdtc.dll is registered successfully in GAC.
    INFO: h:\oracle\db12102\odp.net\bin\4\oracle.dataaccess.dll is registered successfully in GAC.
    INFO: h:\oracle\db12102\odp.net\publisherpolicy\4\policy.4.112.oracle.dataaccess.dll is registered successfully in GAC.
    INFO: h:\oracle\db12102\odp.net\publisherpolicy\4\policy.4.121.oracle.dataaccess.dll is registered successfully in GAC.
    
    INFO: The following section has been added.
    
    INFO: The following element added under DbProviderFactories. INFO: Counters registered successfully in the system. INFO: The following section has been added.
    INFO: The following element added under DbProviderFactories. INFO: section has been successfully added/modified INFO: Counters registered successfully in the system.INFO: h:\oracle\db12102\asp.net\bin\4\oracle.web.dll is registered successfullyin GAC. INFO: h:\oracle\db12102\asp.net\publisherpolicy\4\policy.4.112.oracle.web.dll is registered successfully in GAC. INFO: h:\oracle\db12102\asp.net\publisherpolicy\4\policy.4.121.oracle.web.dll is registered successfully in GAC. INFO: Following entries added in GroupedProviders.xml file. INFO: Following entry added to machine.config file. INFO: Following entry added to machine.config file. INFO: Following entry added to machine.config file. INFO: Following entry added to machine.config file. INFO: Following entry added to machine.config file. INFO: Following entry added to machine.config file. Connection string name OraAspNetConString is set successfully INFO: h:\oracle\db12102\ode.net\bin\4\oracle.database.extensions.dll is registered successfully in GAC. The installation of Oracle Database 12c was successful. Please check 'C:\Program Files\Oracle\Inventory\logs\silentInstall2014-10-28_10-23-35PM.log' for more details. Successfully Setup Software. Please press Enter to exit...

    Check Oracle Inventory:

    PS C:\Users\oracle> $env:ORACLE_HOME="H:\oracle\db12102"
    PS C:\Users\oracle> cmd.exe
    Microsoft Windows [Version 6.2.9200]
    (c) 2012 Microsoft Corporation. All rights reserved.
    
    C:\Users\oracle>%ORACLE_HOME%\opatch\opatch lsinv
    Oracle Interim Patch Installer version 12.1.0.1.3
    Copyright (c) 2014, Oracle Corporation.  All rights reserved.
    
    
    Oracle Home       : H:\oracle\db12102
    Central Inventory : C:\Program Files\Oracle\Inventory
       from           : n/a
    OPatch version    : 12.1.0.1.3
    OUI version       : 12.1.0.2.0
    Log file location : H:\oracle\db12102\cfgtoollogs\opatch\opatch2014-10-28_22-58-17PM_1.log
    
    Lsinventory Output file location : H:\oracle\db12102\cfgtoollogs\opatch\lsinv\lsinventory2014-10-28_22-58-17PM.txt
    
    --------------------------------------------------------------------------------
    Installed Top-level Products (1):
    
    Oracle Database 12c                                                  12.1.0.2.0
    There are 1 products installed in this Oracle Home.
    
    
    There are no Interim patches installed in this Oracle Home.
    
    
    --------------------------------------------------------------------------------
    
    OPatch succeeded.
    
    C:\Users\oracle>
    

    Check Windows Registry:

    PS C:\Users\oracle> reg query hklm\software\oracle\key_oraDB12Home1
    
    HKEY_LOCAL_MACHINE\software\oracle\key_oraDB12Home1
        ORACLE_HOME    REG_SZ    h:\oracle\db12102
        ORACLE_HOME_NAME    REG_SZ    OraDB12Home1
        ORACLE_GROUP_NAME    REG_SZ    Oracle - OraDB12Home1
        NLS_LANG    REG_SZ    AMERICAN_AMERICA.WE8MSWIN1252
        ORACLE_BUNDLE_NAME    REG_SZ    Enterprise
        OLEDB    REG_SZ    h:\oracle\db12102\oledb\mesg
        ORACLE_HOME_TYPE    REG_SZ    1
        ORACLE_SVCUSER    REG_SZ    NT AUTHORITY\SYSTEM
        ORACLE_SVCUSER_PWDREQ    REG_SZ    0
        ORACLE_BASE    REG_SZ    h:\oracle\base
        MSHELP_TOOLS    REG_SZ    h:\oracle\db12102\MSHELP
        ORACLE_HOME_KEY    REG_SZ    SOFTWARE\ORACLE\KEY_OraDB12Home1
        SQLPATH    REG_SZ    h:\oracle\db12102\dbs
        RDBMS_CONTROL    REG_SZ    h:\oracle\db12102\DATABASE
        RDBMS_ARCHIVE    REG_SZ    h:\oracle\db12102\DATABASE\ARCHIVE
    
    HKEY_LOCAL_MACHINE\software\oracle\key_oraDB12Home1\ODE
    HKEY_LOCAL_MACHINE\software\oracle\key_oraDB12Home1\OLEDB
    PS C:\Users\oracle>
    

    ORA_DBA group has been added to oracle user account:

    PS C:\Users\oracle> net user oracle
    User name                    oracle
    Full Name
    Comment
    User's comment
    Country/region code          000 (System Default)
    Account active               Yes
    Account expires              Never
    
    Password last set            10/22/2014 7:37:36 PM
    Password expires             12/3/2014 7:37:36 PM
    Password changeable          10/22/2014 7:37:36 PM
    Password required            Yes
    User may change password     Yes
    
    Workstations allowed         All
    Logon script
    User profile
    Home directory
    Last logon                   10/28/2014 10:19:53 PM
    
    Logon hours allowed          All
    
    Local Group Memberships      *Administrators       *ORA_ASMADMIN
                                 *ORA_ASMDBA           *ORA_DBA
                                 *ORA_OraDB12Home1_SYSB*ORA_OraDB12Home1_SYSD
                                 *ORA_OraDB12Home1_SYSK*ORA_OraGI12Home1_SYSB
                                 *ORA_OraGI12Home1_SYSD*ORA_OraGI12Home1_SYSK
                                 *Users
    Global Group memberships     *None
    The command completed successfully.
    
    PS C:\Users\oracle>
    

    Fast Recovery Area (FRA) disk group creation

    Run following commands:

    PS C:\Users\oracle> $env:ORACLE_SID="+ASM"
    PS C:\Users\oracle> sqlplus / as sysasm
    
    SQL*Plus: Release 12.1.0.2.0 Production on Wed Oct 29 19:36:14 2014
    
    Copyright (c) 1982, 2014, Oracle.  All rights reserved.
    
    
    Connected to:
    Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
    With the Automatic Storage Management option
    SQL> create diskgroup FRA external redundancy disk '\\.\ORCLDISK2';
    
    Diskgroup created.
    
    SQL> exit
    

    Check that FRA disk group is mounted and registered in Oracle Restart:

    PS C:\Users\oracle> crsctl stat res -t
    --------------------------------------------------------------------------------
    Name           Target  State        Server                   State details
    --------------------------------------------------------------------------------
    Local Resources
    --------------------------------------------------------------------------------
    ora.DATA.dg
                   ONLINE  ONLINE       w12dc01                  STABLE
    ora.FRA.dg
                   ONLINE  ONLINE       w12dc01                  STABLE
    ora.LISTENER.lsnr
                   ONLINE  ONLINE       w12dc01                  STABLE
    ora.asm
                   ONLINE  ONLINE       w12dc01                  Started,STABLE
    ora.ons
                   OFFLINE OFFLINE      w12dc01                  STABLE
    --------------------------------------------------------------------------------
    Cluster Resources
    --------------------------------------------------------------------------------
    ora.cssd
          1        ONLINE  ONLINE       w12dc01                  STABLE
    ora.evmd
          1        ONLINE  ONLINE       w12dc01                  STABLE
    --------------------------------------------------------------------------------
    PS C:\Users\oracle>
    

    DBCA PowerShell session

    I have installed Oracle Database with Oracle home user property set to Windows built-in account. This implies that when using oracle account to use DBCA I get:

    PRCD-1025 : Failed to create database cdb12c
    PRKH-1014 : Current user "oracle" is not the oracle owner user "nt authority\system" of oracle home "h:\oracle\db12102"
    DBCA_PROGRESS : DBCA Operation failed.
    

    If I try to use Administrator account from a Adminstrator Windows session DBCA complains that locations +FRA and +DATA don’t exist.

    I have been able to run DBCA from the oracle account Windows session but from a Powershell “Run as Administrator” (you need to right click the Powershell icon in the Task Bar to start a Powershell Run as Administrator).

    Database creation with ASM storage

    To create a container database with 2 pluggable databases to use DATA and FRA ASM diskgroups I have used following script (actual script has all pararameters on one single line):

    dbca 
    -silent 
    -createDatabase 
    -templateName General_Purpose.dbc 
    -gdbName cdb12c 
    -sid cdb12c 
    -createAsContainerDatabase true 
    -numberOfPdbs 2 
    -pdbName pdb 
    -pdbadminUsername pdba 
    -pdbadminPassword oracle12c 
    -SysPassword oracle12c 
    -SystemPassword oracle12c 
    -emConfiguration NONE 
    -storageType ASM 
    -diskGroupName +DATA 
    -recoveryGroupName +FRA 
    -characterSet  AL32UTF8 
    -memoryPercentage 40
    

    Running this scripts takes about 10 minutes with following output:

    Cleaning up failed steps
    4% complete
    Registering database with Oracle Restart
    8% complete
    Copying database files
    9% complete
    10% complete
    15% complete
    20% complete
    25% complete
    38% complete
    Creating and starting Oracle instance
    40% complete
    43% complete
    44% complete
    45% complete
    48% complete
    51% complete
    52% complete
    55% complete
    Completing Database Creation
    57% complete
    60% complete
    62% complete
    70% complete
    77% complete
    80% complete
    Creating Pluggable Databases
    85% complete
    90% complete
    100% complete
    Look at the log file "h:\oracle\base\cfgtoollogs\dbca\cdb12c\cdb12c0.log" for further details.
    

    Go back to an oracle account Powershell session and check that database has been created as expected:

    PS C:\Users\oracle> sqlplus / as sysdba
    
    SQL*Plus: Release 12.1.0.2.0 Production on Wed Oct 29 20:34:43 2014
    
    Copyright (c) 1982, 2014, Oracle.  All rights reserved.
    
    
    Connected to:
    Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
    With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
    and Real Application Testing options
    SQL> select name, cdb from v$database;
    
    NAME      CDB
    --------- ---
    CDB12C    YES
    
    SQL> show pdbs;
    
        CON_ID CON_NAME                       OPEN MODE  RESTRICTED
    ---------- ------------------------------ ---------- ----------
             2 PDB$SEED                       READ ONLY  NO
             3 PDB1                           READ WRITE NO
             4 PDB2                           READ WRITE NO
    SQL> select name from v$controlfile;
    
    NAME
    --------------------------------------------------------------------------------
    +DATA/CDB12C/CONTROLFILE/current.261.862257941
    +FRA/CDB12C/CONTROLFILE/current.256.862257943
    
    SQL> select member from v$logfile;
    
    MEMBER
    --------------------------------------------------------------------------------
    +DATA/CDB12C/ONLINELOG/group_3.264.862257955
    +FRA/CDB12C/ONLINELOG/group_3.259.862257957
    +DATA/CDB12C/ONLINELOG/group_2.263.862257949
    +FRA/CDB12C/ONLINELOG/group_2.258.862257951
    +DATA/CDB12C/ONLINELOG/group_1.262.862257945
    +FRA/CDB12C/ONLINELOG/group_1.257.862257947
    
    6 rows selected.
    
    SQL> select name from v$datafile;
    
    NAME
    --------------------------------------------------------------------------------
    +DATA/CDB12C/DATAFILE/system.258.862257741
    +DATA/CDB12C/601EBA5E0CEC4A0A9B2C871BFF2E055F/DATAFILE/system.267.862257979
    +DATA/CDB12C/DATAFILE/sysaux.257.862257695
    +DATA/CDB12C/601EBA5E0CEC4A0A9B2C871BFF2E055F/DATAFILE/sysaux.266.862257979
    +DATA/CDB12C/DATAFILE/undotbs1.260.862257787
    +DATA/CDB12C/DATAFILE/users.259.862257787
    +DATA/CDB12C/9C6E701EF01F4FCF9D22FAF33F0638CF/DATAFILE/system.270.862258555
    +DATA/CDB12C/9C6E701EF01F4FCF9D22FAF33F0638CF/DATAFILE/sysaux.271.862258557
    +DATA/CDB12C/9C6E701EF01F4FCF9D22FAF33F0638CF/DATAFILE/users.273.862258625
    +DATA/CDB12C/6A00A4F74168489DA12F9A776035C2DA/DATAFILE/system.274.862258629
    +DATA/CDB12C/6A00A4F74168489DA12F9A776035C2DA/DATAFILE/sysaux.275.862258629
    
    NAME
    --------------------------------------------------------------------------------
    +DATA/CDB12C/6A00A4F74168489DA12F9A776035C2DA/DATAFILE/users.277.862258701
    
    12 rows selected.
    
    SQL> show parameter memory_target
    
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    memory_target                        big integer 1648M
    SQL> show parameter memory_max_target
    
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    memory_max_target                    big integer 1648M
    SQL> select value
      2  from nls_database_parameters
      3  where parameter='NLS_CHARACTERSET';
    
    VALUE
    --------------------------------------------------------------------------------
    AL32UTF8
    
    SQL>
    

    Check that database has been registered in Oracle Restart:

    PS C:\Users\oracle> srvctl config database -d cdb12c
    Database unique name: cdb12c
    Database name: cdb12c
    Oracle home: h:\oracle\db12102
    Oracle user: nt authority\system
    Spfile: +DATA/CDB12C/PARAMETERFILE/spfile.269.862258339
    Password file:
    Domain:
    Start options: open
    Stop options: immediate
    Database role: PRIMARY
    Management policy: AUTOMATIC
    Disk Groups: FRA,DATA
    Services:
    Database instance: cdb12c
    PS C:\Users\oracle> crsctl stat res -t
    --------------------------------------------------------------------------------
    Name           Target  State        Server                   State details
    --------------------------------------------------------------------------------
    Local Resources
    --------------------------------------------------------------------------------
    ora.DATA.dg
                   ONLINE  ONLINE       w12dc01                  STABLE
    ora.FRA.dg
                   ONLINE  ONLINE       w12dc01                  STABLE
    ora.LISTENER.lsnr
                   ONLINE  ONLINE       w12dc01                  STABLE
    ora.asm
                   ONLINE  ONLINE       w12dc01                  Started,STABLE
    ora.ons
                   OFFLINE OFFLINE      w12dc01                  STABLE
    --------------------------------------------------------------------------------
    Cluster Resources
    --------------------------------------------------------------------------------
    ora.cdb12c.db
          1        ONLINE  ONLINE       w12dc01                  Open,STABLE
    ora.cssd
          1        ONLINE  ONLINE       w12dc01                  STABLE
    ora.evmd
          1        ONLINE  ONLINE       w12dc01                  STABLE
    --------------------------------------------------------------------------------
    PS C:\Users\oracle>
    

    Switch to cmd.exe to use sc.exe and to check that DBCA has created one Windows service for database cdb12c:

    C:\Users\oracle>sc query | findstr  Oracle |  findstr cdb12c
    
    C:\Users\oracle>sc query | findstr  Oracle |  findstr CDB12C
    SERVICE_NAME: OracleServiceCDB12C
    DISPLAY_NAME: OracleServiceCDB12C
    
    C:\Users\oracle>sc qc OracleServiceCDB12C
    [SC] QueryServiceConfig SUCCESS
    
    SERVICE_NAME: OracleServiceCDB12C
            TYPE               : 10  WIN32_OWN_PROCESS
            START_TYPE         : 3   DEMAND_START
            ERROR_CONTROL      : 1   NORMAL
            BINARY_PATH_NAME   : h:\oracle\db12102\bin\ORACLE.EXE CDB12C
            LOAD_ORDER_GROUP   :
            TAG                : 0
            DISPLAY_NAME       : OracleServiceCDB12C
            DEPENDENCIES       :
            SERVICE_START_NAME : LocalSystem
    
    C:\Users\oracle>
    

    Database creation with NTFS storage

    To create a non container database using NTFS file system I have used following script (actual script has all pararameters on one single line – and this script has also been run from a Powershell “Run as Administrator”):

    dbca 
    -silent 
    -createDatabase 
    -templateName General_Purpose.dbc 
    -gdbName db12 
    -sid db12 
    -SysPassword oracle12c 
    -SystemPassword oracle12c 
    -emConfiguration NONE 
    -storageType FS 
    -datafileDestination h:\oradata 
    -characterSet  AL32UTF8 
    -memoryPercentage 20
    

    Running this scripts takes about 15 minutes with following output:

    Cleaning up failed steps
    5% complete
    Registering database with Oracle Restart
    11% complete
    Copying database files
    12% complete
    14% complete
    21% complete
    27% complete
    34% complete
    41% complete
    44% complete
    Creating and starting Oracle instance
    46% complete
    51% complete
    55% complete
    60% complete
    61% complete
    64% complete
    66% complete
    Completing Database Creation
    70% complete
    73% complete
    76% complete
    86% complete
    96% complete
    100% complete
    Look at the log file "h:\oracle\base\cfgtoollogs\dbca\db12\db120.log" for further details.
    

    Go back to an oracle account Powershell session and check that database has been created as expected:

    PS C:\Users\oracle> sqlplus / as sysdba
    
    SQL*Plus: Release 12.1.0.2.0 Production on Thu Oct 30 19:56:22 2014
    
    Copyright (c) 1982, 2014, Oracle.  All rights reserved.
    
    
    Connected to:
    Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
    With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
    
    SQL> select name, cdb from v$database;
    
    NAME      CDB
    --------- ---
    DB12      NO
    
    SQL>
    SQL>
    SQL> select name from v$controlfile;
    
    NAME
    --------------------------------------------------------------------------------
    H:\ORADATA\DB12\CONTROL01.CTL
    H:\ORACLE\BASE\FAST_RECOVERY_AREA\DB12\CONTROL02.CTL
    
    SQL> select member from v$logfile;
    
    MEMBER
    --------------------------------------------------------------------------------
    H:\ORADATA\DB12\REDO03.LOG
    H:\ORADATA\DB12\REDO02.LOG
    H:\ORADATA\DB12\REDO01.LOG
    
    SQL> select name from v$datafile;
    
    NAME
    --------------------------------------------------------------------------------
    H:\ORADATA\DB12\SYSTEM01.DBF
    H:\ORADATA\DB12\SYSAUX01.DBF
    H:\ORADATA\DB12\UNDOTBS01.DBF
    H:\ORADATA\DB12\USERS01.DBF
    
    SQL> show parameter memory_target
    
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    memory_target                        big integer 820M
    SQL> show parameter memory_max_target
    
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    memory_max_target                    big integer 820M
    SQL> select value
      2  from nls_database_parameters
      3  where parameter = 'NLS_CHARACTERSET';
    
    VALUE
    --------------------------------------------------------------------------------
    AL32UTF8
    
    SQL> show parameter db_recovery_file_dest
    
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    db_recovery_file_dest                string      h:\oracle\base\fast_recovery_a
                                                     rea
    db_recovery_file_dest_size           big integer 6420M
    

    Note that DBCA has created by default the database files directory H:\oradata and set FRA parameters for database instance. Check that database has been registered in Oracle Restart:

    PS C:\Users\oracle> srvctl config database -d db12
    Database unique name: db12
    Database name: db12
    Oracle home: h:\oracle\db12102
    Oracle user: nt authority\system
    Spfile: h:\oracle\db12102\database\spfiledb12.ora
    Password file:
    Domain:
    Start options: open
    Stop options: immediate
    Database role: PRIMARY
    Management policy: AUTOMATIC
    Disk Groups:
    Services:
    Database instance: db12
    PS C:\Users\oracle> crsctl stat res -t
    --------------------------------------------------------------------------------
    Name           Target  State        Server                   State details
    --------------------------------------------------------------------------------
    Local Resources
    --------------------------------------------------------------------------------
    ora.DATA.dg
                   ONLINE  ONLINE       w12dc01                  STABLE
    ora.FRA.dg
                   ONLINE  ONLINE       w12dc01                  STABLE
    ora.LISTENER.lsnr
                   ONLINE  ONLINE       w12dc01                  STABLE
    ora.asm
                   ONLINE  ONLINE       w12dc01                  Started,STABLE
    ora.ons
                   OFFLINE OFFLINE      w12dc01                  STABLE
    --------------------------------------------------------------------------------
    Cluster Resources
    --------------------------------------------------------------------------------
    ora.cdb12c.db
          1        ONLINE  ONLINE       w12dc01                  Open,STABLE
    ora.cssd
          1        ONLINE  ONLINE       w12dc01                  STABLE
    ora.db12.db
          1        ONLINE  ONLINE       w12dc01                  Open,STABLE
    ora.evmd
          1        ONLINE  ONLINE       w12dc01                  STABLE
    --------------------------------------------------------------------------------
    PS C:\Users\oracle>
    

    Switch to cmd.exe to use sc.exe and to check that DBCA has created 2 Windows service for database DB12:

    PS C:\Users\oracle> cmd.exe
    Microsoft Windows [Version 6.2.9200]
    (c) 2012 Microsoft Corporation. All rights reserved.
    
    C:\Users\oracle>sc query | findstr  Oracle |  findstr DB12
    SERVICE_NAME: OracleServiceCDB12C
    DISPLAY_NAME: OracleServiceCDB12C
    SERVICE_NAME: OracleServiceDB12
    DISPLAY_NAME: OracleServiceDB12
    SERVICE_NAME: OracleVssWriterDB12
    DISPLAY_NAME: OracleVssWriterDB12
    
    C:\Users\oracle>sc qc OracleServiceDB12
    [SC] QueryServiceConfig SUCCESS
    
    SERVICE_NAME: OracleServiceDB12
            TYPE               : 10  WIN32_OWN_PROCESS
            START_TYPE         : 3   DEMAND_START
            ERROR_CONTROL      : 1   NORMAL
            BINARY_PATH_NAME   : h:\oracle\db12102\bin\ORACLE.EXE DB12
            LOAD_ORDER_GROUP   :
            TAG                : 0
            DISPLAY_NAME       : OracleServiceDB12
            DEPENDENCIES       :
            SERVICE_START_NAME : LocalSystem
    
    C:\Users\oracle>sc qc OracleVssWriterDB12
    [SC] QueryServiceConfig SUCCESS
    
    SERVICE_NAME: OracleVssWriterDB12
            TYPE               : 10  WIN32_OWN_PROCESS
            START_TYPE         : 3   DEMAND_START
            ERROR_CONTROL      : 1   NORMAL
            BINARY_PATH_NAME   : h:\oracle\db12102\bin\OraVSSW.exe DB12
            LOAD_ORDER_GROUP   :
            TAG                : 0
            DISPLAY_NAME       : OracleVssWriterDB12
            DEPENDENCIES       :
            SERVICE_START_NAME : LocalSystem
    
    C:\Users\oracle>
    

    Windows Registry entries for new Oracle Home and new Oracle databases

    Following entries have been created:

    PS C:\Users\oracle> reg query hklm\software\oracle\KEY_OraDB12Home1
    
    HKEY_LOCAL_MACHINE\software\oracle\KEY_OraDB12Home1
        ORACLE_HOME    REG_SZ    h:\oracle\db12102
        ORACLE_HOME_NAME    REG_SZ    OraDB12Home1
        ORACLE_GROUP_NAME    REG_SZ    Oracle - OraDB12Home1
        NLS_LANG    REG_SZ    AMERICAN_AMERICA.WE8MSWIN1252
        ORACLE_BUNDLE_NAME    REG_SZ    Enterprise
        OLEDB    REG_SZ    h:\oracle\db12102\oledb\mesg
        ORACLE_HOME_TYPE    REG_SZ    1
        ORACLE_SVCUSER    REG_SZ    NT AUTHORITY\SYSTEM
        ORACLE_SVCUSER_PWDREQ    REG_SZ    0
        ORACLE_BASE    REG_SZ    h:\oracle\base
        MSHELP_TOOLS    REG_SZ    h:\oracle\db12102\MSHELP
        ORACLE_HOME_KEY    REG_SZ    SOFTWARE\ORACLE\KEY_OraDB12Home1
        SQLPATH    REG_SZ    h:\oracle\db12102\dbs
        RDBMS_CONTROL    REG_SZ    h:\oracle\db12102\DATABASE
        RDBMS_ARCHIVE    REG_SZ    h:\oracle\db12102\DATABASE\ARCHIVE
        ORACLE_SID    REG_SZ    db12
        ORA_cdb12c_AUTOSTART    REG_EXPAND_SZ    FALSE
        ORA_cdb12c_SHUTDOWN    REG_EXPAND_SZ    TRUE
        ORA_cdb12c_SHUTDOWNTYPE    REG_EXPAND_SZ    immediate
        ORA_cdb12c_SHUTDOWN_TIMEOUT    REG_EXPAND_SZ    90
        ORA_db12_AUTOSTART    REG_EXPAND_SZ    FALSE
        ORA_db12_SHUTDOWN    REG_EXPAND_SZ    TRUE
        ORA_db12_SHUTDOWNTYPE    REG_EXPAND_SZ    immediate
        ORA_db12_SHUTDOWN_TIMEOUT    REG_EXPAND_SZ    90
    
    HKEY_LOCAL_MACHINE\software\oracle\KEY_OraDB12Home1\ODE
    HKEY_LOCAL_MACHINE\software\oracle\KEY_OraDB12Home1\OLEDB
    PS C:\Users\oracle>
    

    About Oracle Home User

    I have tried to use Oracle Home User but I was not able to make it work: this is why I have used a standard built-in Windows account instead of using a dedicated account.

    Follow

    Get every new post delivered to your Inbox.