How to install Oracle Database 12.1 and create a database in silent mode on Windows

I have installed Oracle 12.1 on my personal PC running Windows 8 using a local account having administrator privilege.

Download installation media

You need to download from OTN:

– winx64_12c_database_1of2.zip

– winx64_12c_database_2of2.zip

Extract both files from the same directory

Using 7-zip executable, run:

c:\stage>c:\"Program Files"\7-Zip\7z.exe x winx64_12c_database_1of2.zip
c:\stage>c:\"Program Files"\7-Zip\7z.exe x winx64_12c_database_2of2.zip

Run Oracle Universal Installer (OUI) in silent mode

Run following script from cmd.exe window in the directory where installation media has been extracted:

database\setup -silent "ORACLE_BASE=c:\oracle\product" "ORACLE_HOME=c:\oracle\product\121" 
"oracle.install.option=INSTAL_DB_SWONLY" "oracle.install.IsBuiltInAccount=true" "DECLINE_SECURITY_UPDATES=true" 
"oracle.install.db.InstallEdition=E" "oracle.install.db.isCustomInstall=false" "oracle.install.db.DBA_GROUP=dba" 
"oracle.install.db.OPER_GROUP=dba" "orace.install.db.BACKUPDBA_GROUP=dba"  "oracle.install.db.DGDBA_GROUP=dba"  
"oracle.install.db.KMDBA_GROUP=dba"

This script starts to display a User Access Control window where you must click Yes. A new cmd.exe window is opened by OUI: you need to wait that the ending messages of this window are:

The installation of Oracle Database 12c was successful.
Please check 'C:\Program Files\Oracle\Inventory\logs\silentInstallYYYY-MM-DD_HH-MI-SSPM.log' for more details.
Successfully Setup Software.

Note that during the installation Windows firewall can ask if you want to allow Java to use public network addresses.

Check that silentinstallXXX.log ends with:

INFO: Exit Status is 0
INFO: Shutdown Oracle Database 12c Release 1 Installer
INFO: Unloading Setup Drive

At this step OUI has:

– created Oracle Inventory in C\:Program Files\Oracle\Inventory

– installed Oracle Database Home in C:\oracle\product\121.

Check that SQL*Plus version has the right version and that Oracle Inventory is OK:

c:\tmp>sqlplus -v

SQL*Plus: Release 12.1.0.1.0 Production

c:\tmp>c:\oracle\product\121\OPatch\opatch lsinv
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

Oracle Home       : c:\oracle\product\121
Central Inventory : C:\Program Files\Oracle\Inventory
from           : n/a
OPatch version    : 12.1.0.1.0
OUI version       : 12.1.0.1.0
Log file location : c:\oracle\product\121\cfgtoollogs\opatch\opatch2013-12-27_18-50-34PM_1.log

Lsinventory Output file location : c:\oracle\product\121\cfgtoollogs\opatch\lsinv\lsinventory2013-12-27_18-50-34PM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Database 12c                                                  12.1.0.1.0
There are 1 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

--------------------------------------------------------------------------------

OPatch succeeded.

c:\tmp>

Create a database

To create a database open a new cmd.exe window with “run as administrator” option. I have used following script to create a container database with 2 pluggable databases (PDBs):

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 -datafileDestination c:\oradata -storageType FS -characterSet  AL32UTF8 -memoryPercentage 10

Here is script execution with DBCA log:

c:\tmp>crdb.bat

c:\tmp>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 -datafileDestination c:\oradata -storageType FS -characterSet  AL32UTF8 -memoryPercentage 10
4% complete
Copying database files
5% complete
6% complete
12% complete
17% complete
22% complete
27% complete
30% complete
Creating and starting Oracle instance
32% complete
35% complete
36% complete
37% complete
41% complete
44% complete
45% complete
48% complete
Completing Database Creation
50% complete
53% complete
55% complete
63% complete
71% complete
74% complete
Creating Pluggable Databases
79% complete
84% complete
100% complete
Look at the log file "c:\oracle\product\cfgtoollogs\dbca\cdb12c\cdb12c0.log" for further details.

c:\tmp>type c:\oracle\product\cfgtoollogs\dbca\cdb12c\cdb12c0.log

Unique database identifier check passed.

C:\ has enough space. Required space is 12004 MB , available space is 157260 MB.
File Validations Successful.
DBCA_PROGRESS : 4%
Copying database files
DBCA_PROGRESS : 5%
DBCA_PROGRESS : 6%
DBCA_PROGRESS : 12%
DBCA_PROGRESS : 17%
DBCA_PROGRESS : 22%
DBCA_PROGRESS : 27%
DBCA_PROGRESS : 30%
Creating and starting Oracle instance
DBCA_PROGRESS : 32%
DBCA_PROGRESS : 35%
DBCA_PROGRESS : 36%
DBCA_PROGRESS : 37%
DBCA_PROGRESS : 41%
DBCA_PROGRESS : 44%
DBCA_PROGRESS : 45%
DBCA_PROGRESS : 48%
Completing Database Creation
DBCA_PROGRESS : 50%
DBCA_PROGRESS : 53%
DBCA_PROGRESS : 55%
DBCA_PROGRESS : 63%
DBCA_PROGRESS : 71%
DBCA_PROGRESS : 74%
Creating Pluggable Databases
DBCA_PROGRESS : 79%
DBCA_PROGRESS : 84%
DBCA_PROGRESS : 100%
Database creation complete. For details check the logfiles at:
c:\oracle\product\cfgtoollogs\dbca\cdb12c.
Database Information:
Global Database Name:cdb12c
System Identifier(SID):cdb12c

Check that the database is a container database with 2 PDBs:

SQL> set linesize 132
SQL> select * from v$version;

BANNER                                                                               CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production              0
PL/SQL Release 12.1.0.1.0 - Production                                                    0
CORE    12.1.0.1.0      Production                                                                0
TNS for 64-bit Windows: Version 12.1.0.1.0 - Production                                   0
NLSRTL Version 12.1.0.1.0 - Production                                                    0

SQL> select name, cdb from v$database;

NAME      CDB
--------- ---
CDB12C    YES

SQL>

SQL> select pdb_name, status from dba_pdbs;

PDB_NAME   STATUS
---------- -------------
PDB1       NORMAL
PDB$SEED   NORMAL
PDB2       NORMAL

Note that I could not install Oracle Database 12.1 on Windows 7 Pro due to fatal error INS-30131 for unknown reason (error occured with OUI graphical user interface and with OUI silent mode).

Advertisements
Post a comment or leave a trackback: Trackback URL.

Trackbacks

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: