Manual Installation of Oracle 12c (12.1.0.2) Sample Schemas－DanBrother的部落格

Manual Installation of Oracle 12c (12.1.0.2) Sample Schemas

Download linuxamd64_12c_examples.zip from:
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-linux-download-2240591.html

Oracle Database 12c Release 1 Examples (12.1.0.2.0) for Linux x86-64
Download linuxamd64_12c_examples.zip (499,228,127 bytes) (cksum - 41327639)

[oracle@testsvr 12.1.0.2]$ unzip linuxamd64_12102_examples.zip

[oracle@testsvr 12.1.0.2]$ cd examples
[oracle@testsvr examples]$ ./runInstaller

[oracle@testsvr examples]$ cd $ORACLE_HOME/demo/schema

[oracle@testsvr schema]$ . oraenv
ORACLE_SID = [my12c] ?
The Oracle base remains unchanged with value /oracle/orabase

[oracle@testsvr schema]$ export TWO_TASK=mypdb
[oracle@testsvr schema]$ sqlplus sys as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Jan 27 14:48:44 2016

Enter password:

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

MYPDB@MY12C> sho con_name

CON_NAME
------------------------------
MYPDB

MYPDB@MY12C> @mksample.sql
...
...
...
...
...
...
...
...
...

col username format a20
col account_status format a20
col oracle_maintained format a20

MYPDB@MY12C> select username,account_status,authentication_type,oracle_maintained
2 from dba_users
3 where created>sysdate-1/2;

USERNAME ACCOUNT_STAUS AUTHENTICATION_TYPE ORACLE_MAINTAINED
-------------------- --------------------- ------------------------ --------------------
PM OPEN PASSWORD N
SH OPEN PASSWORD N
IX OPEN PASSWORD N
HR OPEN PASSWORD N
OE OPEN PASSWORD N
BI OPEN PASSWORD N

MYPDB@MY12C> conn hr
Enter password:
Connected.
MYPDB@MY12C> sho con_name

CON_NAME
------------------------------
MYPDB

MYPDB@MY12C> sho user
USER is "HR"