Oracle 12c新特性

Oracle Database 12c架构图

2013/07/05 by admin Leave a Comment

Oracle Database 12c架构图高清包括最新的后台进程及其工作原理

Filed Under: Oracle, Oracle 12c新特性

【Maclean Liu技术分享】12c 12.1.0.1 RAC安装教学视频基于Vbox+Oracle Linux 5.7

2013/07/02 by admin 1 Comment

【Maclean Liu技术分享】12c 12.1.0.1 RAC Real Application Cluster 安装教学视频基于Vbox+Oracle Linux 5.7

安装步骤脚本下载：

Maclean技术分享 12c RAC 安装OEL 5.7 12.1.0.1 RAC VBox安装脚本.txt

视频观看地址:
[Read more…]

Filed Under: Oracle, Oracle 12c新特性, Oracle RAC

oracle database 12c release 1 (12.1.0.1.0) 正式公开发布了

2013/06/26 by admin Leave a Comment

oracle database 12c release 1 正式公开发布了，下载地址：http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

目前提供 Linux x86-64 、Solaris Sparc64、 Solaris (x86-64) 3个平台更多信息可以参考：https://blogs.oracle.com/UPGRADE/entry/finally_oracle_database_12c_is

Oracle Database 12c Release 1 (12.1.0.1.0) Download中：http://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-linux-download-1959253.html

Oracle Database 12c Documentation 12c的官方文档已经Release 地址： http://www.oracle.com/pls/db121/homepage

Maclean Liu关于Database 12c的研究文档分类：

https://www.askmac.cn/archives/category/oracle/oracle-12c

Filed Under: Oracle, Oracle 12c新特性

12c Pluggable Database Container Database权限与角色管理

2013/06/18 by admin Leave a Comment

oracle@localhost:~$ oerr ora 65050
65050, 00000, “Common DDLs only allowed in CDB$ROOT”
// *Cause: An attempt was made to issue a Common DDL in a pluggable database.
// *Action: Switch to CDB$ROOT and issue the Common DDL there.
//
oracle@localhost:~$ oerr ora 65032
65032, 00000, “a Local Role may only be granted or revoked within the current Container”
// *Cause: A user issued a GRANT or REVOKE statement specifying
// CONTAINER=ALL and listing a Local Role among roles
// to be granted or revoked, which is illegal.
// *Action: If trying to revoke a Local Role, remove CONTAINER=ALL from
// the statement. If trying to revoke Common Privileges and/or
// Roles, remove Local Roles from the list of roles being granted
// or revoked.
//

LOCAL ROLE/PRIV 不能 grant to .. CONTAINER=ALL;

SQL> grant c##maclean11 to maclean1 container=ALL;
grant c##macleanll to maclean1 container=ALL
*
ERROR at line 1:
ORA-65030: one may not grant a Common Privilege to a Local User or Role

oracle@localhost:~$ oerr ora 65030
65030, 00000, “one may not grant a Common Privilege to a Local User or Role”
// *Cause: A Common User issued a GRANT statement specifying
// CONTAINER=ALL and naming a Local User or Role as a grantee,
// which is illegal.
// *Action: If trying to grant a Local Privilege, remove CONTAINER=ALL from
// the statement. If trying to grant a Common Privilege, remove
// Local Users and Roles from the list of grantees.
//

不能将COMMON PRIV/ROLE grant to local user/role container=ALL;

Filed Under: Oracle, Oracle 12c新特性

Oracle 12c PGA内存自动管理功能

2013/04/25 by admin Leave a Comment

–内存管理的新功能：引入PGA 的上限尺寸限制

管理program global area (PGA)

传统的 PGA 内存管理

Oracle 9i Database 中，导入了自动 PGA 内存(PGA 自动调整功能)
通过PGA_AGGREGATE_TARGET初始化参数自动导出实例中活跃的工作区域中，可以使用的PGA内存总量

–Oracle可以自动调整分类处理以及哈希结合中所使用的SQL工作区域

自动 PGA 的内存操作与限制

通过PGA_AGGREGATE_TARGET 初始化参数所指定的值就是目标值，但并不一定能残留在指定值以内的内存尺寸之中

–比指定值尺寸更大的案例

大量的进程同时开始分类处理的案例
连接到实例的进程数增加的情况

–如SGA 的 SGA_TARGET初始化参数一样，这并不是无法超过指定值尺寸的结构

直到OS的空白区域中，虚拟内存不足，或者进程到底可以使用的内存上限时，就会发生ORA-4030错误

–OS 整体内存枯竭，可能使得系统整体面临危险

Oracle 12c引入了PGA 的上限尺寸限制

PGA_AGGREGATE_LIMIT 参数

设定实例全体中可以获得的PGA的上限值

–超过上限执行获得时就会发生ORA-4036

–SYS 用户，后台进程不属于这种情况

默认值：较大值

–2048 MB or PGA_AGGREGATE_TARGET × 2 or PROCESSES × 3MB

–默认值在警报日志中的输出例

Using default pga_aggregate_limit of 2048 MB

可以动态变更 (alter system)

–可以设定的值的范围为0，或者比默认值更大的值

Oracle 12c引入了PGA 的上限尺寸限制

PGA_AGGREGATE_LIMIT 的操作图

超过总计值时就会报错(ORA-4036)

※ SYS 用户不在错误范围内

Filed Under: Oracle, Oracle 12c新特性

【Oracle Database 12cR1新特性】SQL Translation Framework SQL 翻译框架

2013/04/12 by admin Leave a Comment

SQL Translation Framework SQL 翻译框架是12cR1中跨RDBMS SQL标准的特性，具体详见如下文档：

[gview file=”https://www.askmac.cn/wp-content/uploads/2013/08/SQL-Translation-OBE.pdf”]

Filed Under: Oracle, Oracle 12c新特性

Oracle数据库新版本12c信息汇总

2013/02/26 by admin Leave a Comment

Oracle甲骨文公司的旗舰产品Oracle Database 12c进入release发布的倒计时，可能在今年7月在上海举行的OOW之前发布。

Oracle Database 12c是甲骨文公司上千名软件工程师耗时7~8年研发的超重量级RDBMS管理型数据库管理系统，可以说是目前世界上技术最为领先的DB产品，业界分析Oracle DB在技术上领先对手5年左右(一家之言)。

在这里我们来汇总了解12c的一些新知识！

【12c新特性】安装12c Standalone Grid Infrastructure

【12c新特性】EM Database Express

将在版本11.2之后废弃或不再支持的特性

解读Tom介绍的Oracle Database 12c的12个新特性

解读Oracle Database 12.1新特性Pluggable Databases

12c分页查询特性FETCH FIRST ROWS,OFFSET ROWS FETCH NEXT ROW LIMIT Clause子句

【12c新特性】dbms_stats report_gather_auto_stats统计信息报告特性

12c新特性:Recover Table

Oracle Database 12c(12.1) Beta已经开始内部测试

Filed Under: Oracle, Oracle 12c新特性

【Database 12c】手动创建CDB Container Database容器数据库

2013/02/08 by admin Leave a Comment

手动建库几乎是每个DBA都需要掌握的技能，而Database 12c中手动创建Container Database容器数据库的过程是如何的呢？

目前12c创建容器数据库Container Database和普通Database存在一点点小的区别，需要指定enable pluggable database，已创建的数据库目前无法转换为容器数据库。

创建必要的目录

mkdir -p /stage/oradata
mkdir -p /stage/fr
mkdir -p /u01/app/oracle/admin/MACLEANCDB/adump

我们创建实例初始化文件，并创建DB:

1、 INIT.ORA

##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
##############################################################################

###########################################
# 
###########################################
_enable_pluggable_database=true

###########################################
# Cache and I/O
###########################################
db_block_size=8192

###########################################
# Cursors and Library Cache
###########################################
open_cursors=300

###########################################
# Database Identification
###########################################
db_domain=""
db_name="MACLEANC"

###########################################
# File Configuration
###########################################
db_create_file_dest="/stage/oradata"
db_recovery_file_dest="/stage/fr"
db_recovery_file_dest_size=5061476352

###########################################
# Miscellaneous
###########################################
compatible=12.0.0.0.0
db_unique_name="MACLEANCDB"
diagnostic_dest=/u01/app/oracle

###########################################
# Network Registration
###########################################
#local_listener=LISTENER_MACLEANCDB

###########################################
# Processes and Sessions
###########################################
processes=300

###########################################
# SGA Memory
###########################################
sga_target=1022361600

###########################################
# Security and Auditing
###########################################
audit_file_dest="/u01/app/oracle/admin/MACLEANCDB/adump"
audit_trail=db
remote_login_passwordfile=EXCLUSIVE

###########################################
# Shared Server
###########################################
dispatchers="(PROTOCOL=TCP) (SERVICE=MACLEANCDBXDB)"

###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
pga_aggregate_target=340787200

###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_tablespace=UNDOTBS1

2、创建密码文件

oracle@localhost:~$ /u01/app/oracle/product/12.1.0/dbhome_1/bin/orapwd file=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/orapwMACLEANCDB force=y extended=y

Enter password for SYS:

3、正式创建DB

oracle@localhost:~$ export ORACLE_SID=MACLEANCDB
oracle@localhost:~$ sqlplus / as sysdba

SQL> startup nomount pfile='init.ora';
ORACLE instance started.

Total System Global Area 1018830848 bytes
Fixed Size                  2268040 bytes
Variable Size             268436600 bytes
Database Buffers          742391808 bytes
Redo Buffers                5734400 bytes

CREATE DATABASE "MACLEANC"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 1024
DATAFILE SIZE 700M AUTOEXTEND ON NEXT  10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE SIZE 550M AUTOEXTEND ON NEXT  10240K MAXSIZE UNLIMITED
SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE SIZE 20M AUTOEXTEND ON NEXT  640K MAXSIZE UNLIMITED
SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE  SIZE 200M AUTOEXTEND ON NEXT  5120K MAXSIZE UNLIMITED
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET UTF8
LOGFILE GROUP 1  SIZE 51200K,
GROUP 2  SIZE 51200K,
GROUP 3  SIZE 51200K
USER SYS IDENTIFIED BY "oracle" USER SYSTEM IDENTIFIED BY "oracle"
enable pluggable database;

Database created.

set linesize 2048;
column ctl_files NEW_VALUE ctl_files;
select concat('control_files=''', concat(replace(value, ', ', ''','''), '''')) ctl_files from v$parameter where name ='control_files';
host echo &ctl_files >> /u01/app/oracle/admin/MACLEANCDB/scripts/init.ora;
spool off

将控制文件信息写入到中==》 echo &ctl_files >> /u01/app/oracle/admin/MACLEANCDB/scripts/init.ora;

4、创建默认使用的USERS表空间

SQL> CREATE SMALLFILE TABLESPACE "USERS" LOGGING  DATAFILE  SIZE 5M AUTOEXTEND ON NEXT  1280K MAXSIZE UNLIMITED  EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO;

Tablespace created.

SQL> ALTER DATABASE DEFAULT TABLESPACE "USERS";

Database altered.

5、执行必要的数据字典创建脚本

alter session set "_oracle_script"=true;
alter pluggable database pdb$seed close;
alter pluggable database pdb$seed open;
host perl /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catcon.pl -l /u01/app/oracle/admin/MACLEANCDB/scripts -b catalog /u01/ap
p/oracle/product/12.1.0/dbhome_1/rdbms/admin/catalog.sql;
host perl /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catcon.pl -l /u01/app/oracle/admin/MACLEANCDB/scripts -b catblock /u01/a
pp/oracle/product/12.1.0/dbhome_1/rdbms/admin/catblock.sql;
host perl /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catcon.pl -l /u01/app/oracle/admin/MACLEANCDB/scripts -b catproc /u01/ap
p/oracle/product/12.1.0/dbhome_1/rdbms/admin/catproc.sql;
host perl /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catcon.pl -l /u01/app/oracle/admin/MACLEANCDB/scripts -b catoctk /u01/ap
p/oracle/product/12.1.0/dbhome_1/rdbms/admin/catoctk.sql;
host perl /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catcon.pl -l /u01/app/oracle/admin/MACLEANCDB/scripts -b owminst /u01/ap
p/oracle/product/12.1.0/dbhome_1/rdbms/admin/owminst.plb;
host perl /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catcon.pl -l /u01/app/oracle/admin/MACLEANCDB/scripts -b pupbld -u SYSTE
M/&&systemPassword /u01/app/oracle/product/12.1.0/dbhome_1/sqlplus/admin/pupbld.sql;
connect "SYSTEM"/"&&systemPassword"
set echo on
spool /u01/app/oracle/admin/MACLEANCDB/scripts/sqlPlusHelp.log append
host perl /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catcon.pl -l /u01/app/oracle/admin/MACLEANCDB/scripts -b hlpbld -u SYSTE
M/&&systemPassword -a 1  /u01/app/oracle/product/12.1.0/dbhome_1/sqlplus/admin/help/hlpbld.sql 1helpus.sql;
@/u01/app/oracle/product/12.1.0/dbhome_1/sqlplus/admin/help/hlpbld.sql helpus.sql;

6、创建一个PDB

cp init.ora  /u01/app/oracle/product/12.1.0/dbhome_1/dbs/initMACLEANCDB.ora 

startup force;

CREATE PLUGGABLE DATABASE MACLEANCDB ADMIN USER MACadmin IDENTIFIED BY oracle
 FILE_NAME_CONVERT=(
  '/stage/oradata/MACLEANCDB/DC36ED41771D435CE0430100007FA00B/datafile/o1_mf_system_8rns0lxf_.dbf', '/stage/oradata/PDB1/datafile/system01.clone',
  '/stage/oradata/MACLEANCDB/DC36ED41771D435CE0430100007FA00B/datafile/o1_mf_sysaux_8rns13dk_.dbf', '/stage/oradata/PDB1/datafile/sysaux1.dbf.clone',
  '/stage/oradata/MACLEANCDB/DC36ED41771D435CE0430100007FA00B/datafile/o1_mf_temp_8rns1d89_.tmp', '/stage/oradata/PDB1/datafile/temp1.tmp.clone'
  )
 STORAGE UNLIMITED;

Filed Under: Oracle, Oracle 12c新特性 Tagged With: 12c, CDB, PDB

【Oracle Database 12c新特性】 12c DataPump Expdp/Impdp新特性

2013/01/28 by admin Leave a Comment

在Oracle Database 12c中加入了一些DataPump Expdp/Impdp的新特性，当然包括对CDB的支持，此外还有部分特性。

例如DISABLE_ARCHIVE_LOGGING/RECOVERY_LOGGING 减少impdp导入时 TABLE/INDEX产生的redo，注意这仅仅是减少不是禁绝。

基本语法如下：

$ impdp hr/hr DIRECTORY=dpump_dir1 DUMPFILE=hr.dmp SCHEMAS=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y
$ impdp hr/hr DIRECTORY=dpump_dir1 DUMPFILE=hr.dmp SCHEMAS=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y:TABLE
$ impdp hr/hr DIRECTORY=dpump_dir1 DUMPFILE=hr.dmp SCHEMAS=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y TRANSFORM=DISABLE_ARCHIVE_LOGGING:N:INDEX

注意即便你用DISABLE_ARCHIVE_LOGGING:Y 也不代表能完全不产生redo
对于 FORCE LOGGING的数据库 DISABLE_ARCHIVE_LOGGING:Y无效

具体使用：

Oracle Database 12c Enterprise Edition Release 12.1.0.0.2 – 64bit Beta
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 17
Current log sequence 19

oracle@localhost:~$ expdp system/oracle dumpfile=temp:ogg_maclean.dmp schemas=ogg_maclean

Export: Release 12.1.0.0.2 – Beta on Sun Apr 28 05:14:00 2013

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.0.2 – 64bit Beta
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting “SYSTEM”.”SYS_EXPORT_SCHEMA_02″: system/******** dumpfile=temp:ogg_maclean.dmp schemas=ogg_maclean
Estimate in progress using BLOCKS method…
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 30 MB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
. . exported “OGG_MACLEAN”.”MACLEAN_PRESS1″ 2.298 MB 84000 rows
. . exported “OGG_MACLEAN”.”MACLEAN_PRESS10″ 2.298 MB 84000 rows
. . exported “OGG_MACLEAN”.”MACLEAN_PRESS2″ 2.298 MB 84000 rows
. . exported “OGG_MACLEAN”.”MACLEAN_PRESS3″ 2.298 MB 84000 rows
. . exported “OGG_MACLEAN”.”MACLEAN_PRESS4″ 2.298 MB 84000 rows
. . exported “OGG_MACLEAN”.”MACLEAN_PRESS5″ 2.298 MB 84000 rows
. . exported “OGG_MACLEAN”.”MACLEAN_PRESS6″ 2.298 MB 84000 rows
. . exported “OGG_MACLEAN”.”MACLEAN_PRESS7″ 2.298 MB 84000 rows
. . exported “OGG_MACLEAN”.”MACLEAN_PRESS8″ 2.298 MB 84000 rows
. . exported “OGG_MACLEAN”.”MACLEAN_PRESS9″ 2.298 MB 84000 rows
Master table “SYSTEM”.”SYS_EXPORT_SCHEMA_02″ successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_02 is:
/tmp/ogg_maclean.dmp
Job “SYSTEM”.”SYS_EXPORT_SCHEMA_02″ successfully completed at Sun Apr 28 05:15:01 2013 elapsed 0 00:00:57

oracle@localhost:~$ ls -lh /tmp/ogg_maclean.dmp
-rw-r—– 1 oracle oinstall 24M Apr 28 05:15 /tmp/ogg_maclean.dmp

oracle@localhost:~$ impdp system/oracle dumpfile=temp:ogg_maclean.dmp remap_schema=ogg_maclean:ogg_maclean1

Import: Release 12.1.0.0.2 – Beta on Sun Apr 28 05:18:18 2013

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.0.2 – 64bit Beta
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table “SYSTEM”.”SYS_IMPORT_FULL_01″ successfully loaded/unloaded
Starting “SYSTEM”.”SYS_IMPORT_FULL_01″: system/******** dumpfile=temp:ogg_maclean.dmp remap_schema=ogg_maclean:ogg_maclean1
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported “OGG_MACLEAN1”.”MACLEAN_PRESS1″ 2.298 MB 84000 rows
. . imported “OGG_MACLEAN1”.”MACLEAN_PRESS10″ 2.298 MB 84000 rows
. . imported “OGG_MACLEAN1”.”MACLEAN_PRESS2″ 2.298 MB 84000 rows
. . imported “OGG_MACLEAN1”.”MACLEAN_PRESS3″ 2.298 MB 84000 rows
. . imported “OGG_MACLEAN1”.”MACLEAN_PRESS4″ 2.298 MB 84000 rows
. . imported “OGG_MACLEAN1”.”MACLEAN_PRESS5″ 2.298 MB 84000 rows
. . imported “OGG_MACLEAN1”.”MACLEAN_PRESS6″ 2.298 MB 84000 rows
. . imported “OGG_MACLEAN1”.”MACLEAN_PRESS7″ 2.298 MB 84000 rows
. . imported “OGG_MACLEAN1”.”MACLEAN_PRESS8″ 2.298 MB 84000 rows
. . imported “OGG_MACLEAN1”.”MACLEAN_PRESS9″ 2.298 MB 84000 rows
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
Job “SYSTEM”.”SYS_IMPORT_FULL_01″ successfully completed at Sun Apr 28 05:18:31 2013 elapsed 0 00:00:10

DISABLE_ARCHIVE_LOGGING
oracle@localhost:~$ impdp system/oracle dumpfile=temp:ogg_maclean.dmp remap_schema=ogg_maclean:ogg_maclean2 TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y

Import: Release 12.1.0.0.2 – Beta on Sun Apr 28 05:21:45 2013

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.0.2 – 64bit Beta
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table “SYSTEM”.”SYS_IMPORT_FULL_01″ successfully loaded/unloaded
Starting “SYSTEM”.”SYS_IMPORT_FULL_01″: system/******** dumpfile=temp:ogg_maclean.dmp remap_schema=ogg_maclean:ogg_maclean2 TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported “OGG_MACLEAN2”.”MACLEAN_PRESS1″ 2.298 MB 84000 rows
. . imported “OGG_MACLEAN2”.”MACLEAN_PRESS10″ 2.298 MB 84000 rows
. . imported “OGG_MACLEAN2”.”MACLEAN_PRESS2″ 2.298 MB 84000 rows
. . imported “OGG_MACLEAN2”.”MACLEAN_PRESS3″ 2.298 MB 84000 rows
. . imported “OGG_MACLEAN2”.”MACLEAN_PRESS4″ 2.298 MB 84000 rows
. . imported “OGG_MACLEAN2”.”MACLEAN_PRESS5″ 2.298 MB 84000 rows
. . imported “OGG_MACLEAN2”.”MACLEAN_PRESS6″ 2.298 MB 84000 rows
. . imported “OGG_MACLEAN2”.”MACLEAN_PRESS7″ 2.298 MB 84000 rows
. . imported “OGG_MACLEAN2”.”MACLEAN_PRESS8″ 2.298 MB 84000 rows
. . imported “OGG_MACLEAN2”.”MACLEAN_PRESS9″ 2.298 MB 84000 rows
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
Job “SYSTEM”.”SYS_IMPORT_FULL_01″ successfully completed at Sun Apr 28 05:21:56 2013 elapsed 0 00:00:09

如同导出表那样导出视图数据

Exporting Views as Tables会导出表的定义和视图数据，而不仅仅是视图定义。以及其依赖的对象，例如约束和授权

SQL> create view cnt as select count(*) c1 from MACLEAN_PRESS1;

View created.

oracle@localhost:~$ expdp system/oracle dumpfile=temp:view.dmp views_as_tables=ogg_maclean.cnt

Export: Release 12.1.0.0.2 – Beta on Sun Apr 28 05:52:49 2013

Filed Under: Oracle, Oracle 12c新特性

【12c新特性】安装12c Standalone Grid Infrastructure

2013/01/22 by admin 1 Comment

【12c新特性】安装12c Standalone Grid Infrastructure

[grid@localhost stage]$ unzip grid_12.1BETA2.zip
[root@localhost ~]# /g01/app/grid/product/12.1.0/grid/rootupgrade.sh
[root@localhost ~]# /g01/app/grid/product/12.1.0/grid/rootupgrade.sh
Performing root user operation for Oracle 12c

The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /g01/app/grid/product/12.1.0/grid
Copying dbhome to /usr/local/bin …
Copying oraenv to /usr/local/bin …
Copying coraenv to /usr/local/bin …

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /g01/app/grid/product/12.1.0/grid/crs/install/crsconfig_params

Error while detecting Oracle Grid Infrastructure. ASMCA needs Oracle Grid Infrastructure to configure ASM.

2013/03/31 02:52:34 CLSRSC-164: ASM upgrade failed

2013/03/31 02:52:34 CLSRSC-304: Failed to upgrade ASM for Oracle Restart configuration

Died at /g01/app/grid/product/12.1.0/grid/crs/install/crsupgrade.pm line 2423.
The command ‘/g01/app/grid/product/12.1.0/grid/perl/bin/perl -I/g01/app/grid/product/12.1.0/grid/perl/lib -I/g01/app/grid/product/12.1.0/grid/crs/install /g01/app/grid/product/12.1.0/grid/crs/install/roothas.pl -upgrade’ execution failed
[root@localhost ~]# /g01/app/grid/product/12.1.0/grid/root.sh
Performing root user operation for Oracle 12c

2013/03/31 02:52:49 CLSRSC-352: CRS is already configured on this node for crshome=/g01/app/grid/product/11.2.0/grid

The command ‘/g01/app/grid/product/12.1.0/grid/perl/bin/perl -I/g01/app/grid/product/12.1.0/grid/perl/lib -I/g01/app/grid/product/12.1.0/grid/crs/install /g01/app/grid/product/12.1.0/grid/crs/install/roothas.pl ‘ execution failed
[root@localhost ~]# /g01/app/grid/product/12.1.0/grid/rootupgrade.sh
Performing root user operation for Oracle 12c

Error while detecting Oracle Grid Infrastructure. ASMCA needs Oracle Grid Infrastructure to configure ASM.

2013/03/31 02:53:06 CLSRSC-164: ASM upgrade failed

2013/03/31 02:53:06 CLSRSC-304: Failed to upgrade ASM for Oracle Restart configuration

ASM Configuration upgraded successfully.

Creating OCR keys for user ‘grid’, privgrp ‘oinstall’..
Operation successful.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user ‘root’, privgrp ‘root’..
Operation successful.
CRS-4664: Node localhost successfully pinned.
2013/03/31 02:56:41 CLSRSC-329: Replacing Clusterware entries in file ‘/etc/inittab’
2013/03/31 03:00:26 CLSRSC-329: Replacing Clusterware entries in file ‘/etc/inittab’
localhost 2013/03/31 03:04:28 /g01/app/grid/product/12.1.0/grid/cdata/localhost/backup_20130331_030428.olr

localhost 2013/01/29 14:56:43 /g01/app/grid/product/11.2.0/grid/cdata/localhost/backup_20130129_145643.olr
2013/03/31 03:04:28 CLSRSC-327: Successfully configured Oracle Grid Infrastructure for a Standalone Server

[grid@localhost ~]$ pstree -a
init
├─VBoxService
│ ├─{VBoxService}
│ ├─{VBoxService}
│ ├─{VBoxService}
│ ├─{VBoxService}
│ ├─{VBoxService}
│ ├─{VBoxService}
│ └─{VBoxService}
├─acpid
├─anacron -s
├─atd
├─auditd
│ ├─audispd
│ │ └─{audispd}
│ └─{auditd}
├─automount
│ ├─{automount}
│ ├─{automount}
│ ├─{automount}
│ └─{automount}
├─avahi-daemon
│ └─avahi-daemon
├─crond
├─cssdagent
│ ├─{cssdagent}
│ ├─{cssdagent}
│ ├─{cssdagent}
│ ├─{cssdagent}
│ ├─{cssdagent}
│ ├─{cssdagent}
│ ├─{cssdagent}
│ ├─{cssdagent}
│ ├─{cssdagent}
│ └─{cssdagent}
├─cupsd
├─dbus-daemon –system
├─dhclient -1 -q -lf /var/lib/dhclient/dhclient-eth0.leases -pf /var/run/dhclient-eth0.pid eth0
├─evmd.bin
│ ├─evmlogger.bin -o /g01/app/grid/product/12.1.0/grid/log/[HOSTNAME]/evmd/evmlogger.info -l/g01/app/grid/product/12.1.0/grid/log/[H
│ ├─{evmd.bin}
│ ├─{evmd.bin}
│ ├─{evmd.bin}
│ ├─{evmd.bin}
│ ├─{evmd.bin}
│ ├─{evmd.bin}
│ ├─{evmd.bin}
│ ├─{evmd.bin}
│ ├─{evmd.bin}
│ ├─{evmd.bin}
│ └─{evmd.bin}
├─gam_server
├─gdm-binary -nodaemon
│ └─gdm-binary -nodaemon
│ ├─Xorg :0 -br -audit 0 -auth /var/gdm/:0.Xauth -nolisten tcp vt7
│ └─gdmgreeter
├─gdm-rh-security
│ └─{gdm-rh-security}
├─gpm -m /dev/input/mice -t exps2
├─hald
│ └─hald-runner
│ ├─hald-addon-keyb
│ ├─hald-addon-keyb
│ ├─hald-addon-keyb
│ └─hald-addon-stor
├─hcid
├─hidd –server
├─hpiod
├─hpssd.py ./hpssd.py
├─init.ohasd /etc/init.d/init.ohasd run
├─iscsid
├─iscsid
├─iscsiuio
│ ├─{iscsiuio}
│ ├─{iscsiuio}
│ └─{iscsiuio}
├─klogd -x
├─mingetty tty1
├─mingetty tty2
├─mingetty tty3
├─mingetty tty4
├─mingetty tty5
├─mingetty tty6
├─ocssd.bin
│ ├─{ocssd.bin}
│ ├─{ocssd.bin}
│ ├─{ocssd.bin}
│ ├─{ocssd.bin}
│ ├─{ocssd.bin}
│ ├─{ocssd.bin}
│ ├─{ocssd.bin}
│ ├─{ocssd.bin}
│ ├─{ocssd.bin}
│ ├─{ocssd.bin}
│ ├─{ocssd.bin}
│ ├─{ocssd.bin}
│ ├─{ocssd.bin}
│ ├─{ocssd.bin}
│ ├─{ocssd.bin}
│ ├─{ocssd.bin}
│ ├─{ocssd.bin}
│ └─{ocssd.bin}
├─ohasd.bin reboot
│ ├─{ohasd.bin}
│ ├─{ohasd.bin}
│ ├─{ohasd.bin}
│ ├─{ohasd.bin}
│ ├─{ohasd.bin}
│ ├─{ohasd.bin}
│ ├─{ohasd.bin}
│ ├─{ohasd.bin}
│ ├─{ohasd.bin}
│ ├─{ohasd.bin}
│ ├─{ohasd.bin}
│ ├─{ohasd.bin}
│ ├─{ohasd.bin}
│ ├─{ohasd.bin}
│ ├─{ohasd.bin}
│ ├─{ohasd.bin}
│ ├─{ohasd.bin}
│ ├─{ohasd.bin}
│ ├─{ohasd.bin}
│ ├─{ohasd.bin}
│ ├─{ohasd.bin}
│ ├─{ohasd.bin}
│ ├─{ohasd.bin}
│ ├─{ohasd.bin}
│ └─{ohasd.bin}
├─ora_aqpc_cdb1
├─ora_arc0_cdb1
├─ora_arc1_cdb1
├─ora_arc2_cdb1
├─ora_arc3_cdb1
├─ora_cjq0_cdb1
├─ora_ckpt_cdb1
├─ora_d000_cdb1
├─ora_dbrm_cdb1
├─ora_dbw0_cdb1
├─ora_dia0_cdb1
├─ora_diag_cdb1
├─ora_fbda_cdb1
├─ora_gen0_cdb1
├─ora_lgwr_cdb1
├─ora_lreg_cdb1
├─ora_mman_cdb1
├─ora_mmnl_cdb1
├─ora_mmon_cdb1
├─ora_ofsd_cdb1
├─ora_p000_cdb1
├─ora_p001_cdb1
├─ora_p002_cdb1
├─ora_p003_cdb1
├─ora_pmon_cdb1
├─ora_psp0_cdb1
├─ora_q001_cdb1
├─ora_q002_cdb1
├─ora_qm01_cdb1
├─ora_reco_cdb1
├─ora_s000_cdb1
├─ora_smco_cdb1
├─ora_smon_cdb1
├─ora_tmon_cdb1
├─ora_tt00_cdb1
├─ora_vktm_cdb1
├─ora_w000_cdb1
├─oraagent.bin
│ ├─{oraagent.bin}
│ ├─{oraagent.bin}
│ ├─{oraagent.bin}
│ ├─{oraagent.bin}
│ ├─{oraagent.bin}
│ ├─{oraagent.bin}
│ ├─{oraagent.bin}
│ ├─{oraagent.bin}
│ ├─{oraagent.bin}
│ ├─{oraagent.bin}
│ ├─{oraagent.bin}
│ ├─{oraagent.bin}
│ ├─{oraagent.bin}
│ ├─{oraagent.bin}
│ ├─{oraagent.bin}
│ ├─{oraagent.bin}
│ └─{oraagent.bin}
├─pcscd
│ ├─{pcscd}
│ └─{pcscd}
├─portmap
├─rpc.idmapd
├─rpc.statd
├─sdpd
├─sendmail
├─sendmail
├─smartd -q never
├─sshd
│ ├─sshd
│ │ ├─bash
│ │ │ └─su – grid
│ │ │ └─bash
│ │ ├─bash
│ │ │ └─su – grid
│ │ │ └─bash
│ │ │ └─pstree -a
│ │ ├─bash
│ │ │ └─su – grid
│ │ │ └─bash
│ │ │ └─tail -f ohasd.log
│ │ └─sftp-server
│ └─sshd
│ └─sshd
│ └─xterm -ls -display localhost:10.0
│ └─bash
├─syslogd -m 0
├─tnslsnr LISTENER -inherit
├─tnslsnr LISTENER -inherit
├─udevd -d
├─xfs -droppriv -daemon
├─xinetd -stayalive -pidfile /var/run/xinetd.pid
└─yum-updatesd -tt /usr/sbin/yum-updatesd

[grid@localhost ~]$ cat .bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs

# export GRID_HOME=/g01/app/grid/product/11.2.0/grid
export GRID_HOME=/g01/app/grid/product/12.1.0/grid
export PATH=$GRID_HOME/bin:$GRID_HOME/OPatch:/usr/bin:/usr/sbin:/bin:/sbin
export ORACLE_SID=+ASM
# export ORACLE_HOME=/g01/app/grid/product/11.2.0/grid
export ORACLE_HOME=/g01/app/grid/product/12.1.0/grid
export ORACLE_BASE=/g01/app/grid

asmca

[grid@localhost tmp]$ crsctl stat res -t
——————————————————————————–
Name Target State Server State details
——————————————————————————–
Local Resources
——————————————————————————–
ora.EXTDG.dg
ONLINE OFFLINE localhost STABLE
ora.LISTENER.lsnr
ONLINE ONLINE localhost STABLE
ora.NORDG.dg
OFFLINE OFFLINE localhost STABLE
ora.SYSTEMDG.dg
ONLINE OFFLINE localhost STABLE
ora.asm
ONLINE OFFLINE localhost STABLE
ora.ons
OFFLINE OFFLINE localhost STABLE
——————————————————————————–
Cluster Resources
——————————————————————————–
ora.cssd
1 ONLINE ONLINE localhost STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE localhost STABLE
——————————————————————————–

Filed Under: Oracle, Oracle 12c新特性