Install 12c database
12.1.0.1.0 - Installation screenshots on win 7 (64-bit)
Download the software from OTN after accepting the
license agreement..
The new features guide can be found here..
This is an installation on windows, probably the most
simple and straightforward installation compared to a database installation on
Unix or a Grid Infrastructure installation.
I always keep an installation on my laptop(runs windows)
.. it comes handy often to test things. Hence this installation and I’m
grabbing screenshots in the process.
Download the zip files from the link above and unzip them.
What’s inside the zip files..
Launch Oracle Universal Installer by double clicking on
setup.exe
Check ‘I wish to receive
security updates via My Oracle Support’ if you would like to do so.
Skipping Software Updates for now..
The database ‘cdborcl’ is created as container database. And, we supply the pluggable database name here - pdborcl
DBCA gets launched for the database creation part..
We get a nice GUI showing the alert log contents ..
Make a note of the URL to use Enterprise Manager..
From EM Database Control to EM Database Express Login 12c..
Database Home Page..
A look at the windows services that gets created..
A look at the schemas and tablespaces that gets created..
C:\Users\SIsaac>C:\app\oracle\product\12.1.0\dbhome_1\bin\sqlplus
SQL*Plus: Release
12.1.0.1.0 Production on Fri Jul 19 15:32:19 2013
Copyright (c) 1982,
2013, Oracle. All rights reserved.
Enter user-name: sys
as sysdba
Enter password:
Connected to:
Oracle Database 12c
Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning,
OLAP, Advanced Analytics and Real Application Testing options
SQL> select
username, account_status, default_tablespace from dba_users order by 1;
USERNAME ACCOUNT_STATUS DEFAULT_TABLESPACE
------------------------------
-------------------------------- ------------------------------
ANONYMOUS EXPIRED & LOCKED SYSAUX
APEX_040200 EXPIRED & LOCKED SYSAUX
APEX_PUBLIC_USER EXPIRED & LOCKED USERS
APPQOSSYS EXPIRED & LOCKED SYSAUX
AUDSYS EXPIRED & LOCKED USERS
CTXSYS EXPIRED &
LOCKED SYSAUX
DBSNMP EXPIRED &
LOCKED SYSAUX
DIP EXPIRED &
LOCKED USERS
DVF EXPIRED &
LOCKED SYSAUX
DVSYS EXPIRED &
LOCKED SYSAUX
FLOWS_FILES EXPIRED & LOCKED SYSAUX
USERNAME ACCOUNT_STATUS DEFAULT_TABLESPACE
------------------------------
-------------------------------- ------------------------------
GSMADMIN_INTERNAL EXPIRED & LOCKED SYSAUX
GSMCATUSER EXPIRED & LOCKED USERS
GSMUSER EXPIRED &
LOCKED USERS
LBACSYS EXPIRED &
LOCKED SYSTEM
MDDATA EXPIRED &
LOCKED USERS
MDSYS EXPIRED & LOCKED SYSAUX
OJVMSYS EXPIRED &
LOCKED USERS
OLAPSYS EXPIRED &
LOCKED SYSAUX
ORACLE_OCM EXPIRED & LOCKED USERS
ORDDATA EXPIRED &
LOCKED SYSAUX
ORDPLUGINS EXPIRED & LOCKED SYSAUX
USERNAME ACCOUNT_STATUS DEFAULT_TABLESPACE
------------------------------
-------------------------------- ------------------------------
ORDSYS EXPIRED &
LOCKED SYSAUX
OUTLN EXPIRED &
LOCKED SYSTEM
SI_INFORMTN_SCHEMA EXPIRED & LOCKED SYSAUX
SPATIAL_CSW_ADMIN_USR EXPIRED & LOCKED USERS
SPATIAL_WFS_ADMIN_USR EXPIRED & LOCKED USERS
SYS OPEN SYSTEM
SYSBACKUP EXPIRED & LOCKED USERS
SYSDG EXPIRED &
LOCKED USERS
SYSKM EXPIRED &
LOCKED USERS
SYSTEM OPEN SYSTEM
WMSYS EXPIRED &
LOCKED SYSAUX
USERNAME ACCOUNT_STATUS DEFAULT_TABLESPACE
------------------------------
-------------------------------- ------------------------------
XDB EXPIRED &
LOCKED SYSAUX
XS$NULL EXPIRED &
LOCKED USERS
35 rows selected.
SQL> col "MAX
SIZE(MB)" format a20
SQL> col
"ALLOCATED(MB)" format a20
SQL> col
"USED(MB)" format a20
SQL> col TABLESPACE
format a30
SQL> col FREE(MB)
format a20
SQL> col PER_FREE
format a20
SQL> set linesize
200
SQL>
SQL> SELECT
F.TABLESPACE_NAME TABLESPACE,
2
TO_CHAR (T.MAX_SPACE, '999,999,999') "MAX SIZE(MB)",
3
TO_CHAR (T.ALLOCATED_SPACE, '999,999,999') "ALLOCATED(MB)",
4
TO_CHAR ((T.ALLOCATED_SPACE - F.FREE_SPACE),'999,999,999')
"USED(MB)",
5
TO_CHAR (F.FREE_SPACE+(T.ALLOCATED_SPACE-T.ALLOCATED_SPACE),
'999,999,999') "FREE(MB)",
6
TO_CHAR ((ROUND ((F.FREE_SPACE/T.ALLOCATED_SPACE)*100)),'999,999')||' %'
PER_FREE
7
FROM (
8
SELECT TABLESPACE_NAME,SUM(BYTES/1024/1024) FREE_SPACE
9
FROM DBA_FREE_SPACE
10
GROUP BY TABLESPACE_NAME
11
) F,
12
(
13
SELECT TABLESPACE_NAME,
14
ROUND (SUM (BYTES/1048576)) ALLOCATED_SPACE,
15
ROUND(SUM(nvl(nullif(MAXBYTES,0),bytes)/1048576)) MAX_SPACE
16
FROM DBA_DATA_FILES
17
GROUP BY TABLESPACE_NAME
18
) T
19
WHERE F.TABLESPACE_NAME = T.TABLESPACE_NAME
20
ORDER BY F.TABLESPACE_NAME;
TABLESPACE MAX SIZE(MB) ALLOCATED(MB) USED(MB) FREE(MB) PER_FREE
------------------------------
-------------------- -------------------- --------------------
-------------------- --------------------
SYSAUX 32,768 760 721 39 5 %
SYSTEM 32,768 780 770 10 1 %
UNDOTBS1 32,768 725 707 18 3 %
USERS 32,768 5 1 4 73 %
SQL>
Steve Karam has compiled a list of articles from all the
oracle experts out there. Now to start studying!
No comments:
Post a Comment