ITPub博客

最近某涛oracle 12C RAC 数据库是问题不断，刚刚解决了 ora-07445问题，有的处理新问题，主要报错如下：alert日志报错信息：$ sqlplus / as sysdba EXEC dbms_stats.init_package(); column name format A35set linesize 120select name, ctime, how_created  f...

报错如下：Use ADRCI or Support Workbench to package the incident.See Note 411.1 at My Oracle Support for error and packaging details.2017-11-22 13:56:36.095000 +08:00Exception [type: SIGSEGV, Invalid permissions for mapped object] [ADDR:0x7F358CE5F7E3] [PC:0xAB3E99F, evaudc()+127] [flags: 0x0, c...

Oracle 12C 闪回功能

Oracle12C 发布已经块两个月了，在使用中或多或少的都有一些问题出来，在访问12.2RAC的时候遇到如下问题： ORA-28040 After Upgrade: No Matching Authentication Protocol 上述错误在12.1版本中可如下解决：在sqlnet.ora文件中添加如下参数，设定可用的值，n表示兼容版本，此处可设置为10...

You can create a physical standby of a multitenant container database (CDB) just as you can create a physical standby of a regular primary database. The following are some of the behavioral differences to be aware of when you create and use a physical standby of a CDB:创建一个多租户的CDB环境...

SQL> SELECT NAME,VALUE,DISPLAY_VALUE,ISPDB_MODIFIABLE FROM v$parameter WHERE ISPDB_MODIFIABLE='TRUE';NAMEVALUEDISPLAY_VALUEISPDBsessions472...

Oracle 12C rac DataGuard环境部署。

关于DGbroker的配置网上有太多资料了，此处在不做详细介绍配置，贴一片metalink上的文章共大家参考学习。1. Prerequisits,Start the Dataguard broker DMON process. ----------启动dg_brokerOn Primary and Standby,SQL> alter system set dg_broker_start=true sid='*';  2. Connect to DGMG...

1.1 Creatingan Index Using Advanced Index CompressionCreating anindex using advanced index compression reduces the size of all supported uniqueand non-unique indexes. Advanced index compression improves the compressionratios significantly while still providing efficient access to the index...

今天重启了下DB后在使用EM12C的时候尽然报错无法访问：Backend WLS or EM application seems to be down检查了下数据库，都是ok的，部分日志信息：2015-Feb-04 11:27:13 : Failed to get repository details from credstore : Repository credentials are not available in Credential...

1          Oracle 12C 临时undo在ORACLE 8i中引进了全局临时表,而且把临时表的数据存储在临时表空间以减少资源开销。全局临时表在临时表空间的数据会随着一个事务或者一个会话而结束。一个临时表上执行dml操作自身不产生redo,因为这些数据是存储在临时表空间，但是这...

1   内存数据库测试在pdba下创建一张表： create table inmem_test as select * fromdba_source;SQL> select count(*) from dba_source;  COUNT(*)----------   342744insert into inmem_testselect 'fd'||owner||'sfd'a,'gvj'||na...

在Oracle 12C中，账号分为两种，一种是公用账号，一种是本地账号（亦可理解为私有账号）。共有账号是指在CDB下创建，并在全部PDB中生效的账号，另一种是在PDB中创建的账号。针对这两种账号的测试如下：1.1 在PDB中创建测试账号 SQL> alter session setcontainer=pdb01;&nbsp...

1   PDB数据文件的在线移动和重命名在Oracle 12C之前版本中，数据文件的在线重命名与位置的变动，都需要在数据文件处在offline状态下进行（system表空间除外），在数据文件移动过程中会产生额外的归档日志用于在数据文件移动后恢复。而从Oracle 12C开始，数据文件均可在线进行移动和重命名，包括system数据...

1.1 数据泵新特性测试1.1.1 数据导出工具expdp差异The available keywords and their descriptionsfollow. Default values are listed within square brackets.ABORT_STEPStop the job after it is initialized or atthe indicated object.Valid values are -1 or N where N is zero orgreater....

Rman表恢复之直接导入系统：RMAN> recover table pdb.pdb of pluggable database pdba until time '2014-12-15 09:39:31' auxiliary destination '/soft/auxi' datapump destination '/soft/pdump';------缺少了notableimport参数。 Starting recover at 2014/12/15 10:13:54using channel ORA...

确认在pdb下操作：SQL> show con_name CON_NAME------------------------------PDBA创建一个表：SQL> create table pdb (id number,tdatedate);插入部分数据：SQL> select * from pdb;     IDTDATE---------- ------------------- ...

关于归档日志的备份： RMAN>backup archivelog all; Starting backup at 2014/12/10 10:38:50current log archivedusing channel ORA_DISK_1channel ORA_DISK_1: starting archived logbackup setchannel ORA_DISK_1: specifying archivedlog(s) in backup setinput ar...

[oracle@node02 ~]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.1.0 Production onWed Dec 10 10:34:02 2014 Copyright (c) 1982, 2013, Oracle.  All rights reserved.Connected to:Oracle Database 12c Enterprise EditionRelease 12.1.0.1.0 - 64bit ProductionWith...