Oracle 12c new Feature: JSON Support in the Oracle 12c Database RDBMS(从此oracle rdbms支持JSON)

很久前在国外的一个blog就看到说是oracle RDBMS(not NOSQL)要支持JSON, 当时说是XMLDB 开发组在做这个事情,随着oracle 12.1.0.2 release 得到确认,的确引入这一特性,JSON, JavaScript Ojbect Notation 在结构上和XML有很多相似之处, 而且这种Schema less data management的数据模型在NOSQL 中广泛应用,数据的存储相对更加紧凑,避免有时空列致ORACLE RDBMS中表一些数据”洞”…

oracle 12c new feature: RESOURCE role without unlimited tablespace

If you are grant privilege to new account like this “grant connect, resource to username”, as you know from 11g the role “Connect” only have “create session” privilege , but now in 12c ,the role “Resource” privilege had changed too.

Install Oracle 12c on Windows [INS-30131] Failed to access the temporary location(无法访问临时位置)

A Question in QQ group get ins-30131 error when install oracle database 12c today, following error

[INS-30131] Initial setup required for the execution of installer validations failed

oracle 12c new feature 隐藏列(invisible columns)

oracle 12c release 1版本引入新功能可隐藏列(invisible columns),这个特性有很多的争议,不明白为什么ORACLE会推出这个特性,因为这个特性可能会带来很多麻烦..

Oracle 12c new feature:OFFSET n FETCH n row-limit

在分页查询或top n中在oracle 之间的版本使用rownum,row_number..,从12c 提供了offset fetch 的语法,其实这个语法不是什么新鲜玩意,在DB2,MSSQL,MYSQL,PostgreSQL之前也都提供的语法。

oracle 12c new feature: moving online datafiles(在线移动数据文件)

在12c以前如果想移动表空间的数据文件首先要offline.再OS mv命令移动离线的数据文件到新路径,Recover datafile[ or tablespace or database] 再Online.从12c 开始可以移动Online 的数据文件了。

oracle 12c Database Architecture (CDB、PDB)

Database Architecture consists of
1) Container Database (CDB)
2) Pluggable Database (PDB)

Installing Enterprise Manager Cloud Control 12c r2 Agent on Linux(安装em12c agent)

Oracle Management Agent 12c communicates only with Oracle Management Service 12c and not with any earlier release of Enterprise Manager

Installing Enterprise Manager Cloud Control 12c release2 on Linux(安装em12c)

EM 12c在安装时和11EM相似,只是增加了Plug-ins 的选择,Plug-ins 和 Connectors做为GRID CONTROLE的扩展并增加了一些非oracle的产品整合为”Cloud”云管理包含DATABASE,Middleware,VM server