Oracle 12c
文章平均质量分 75
OnOne17
这个作者很懒,什么都没留下…
展开
-
Oracle 12c中使用透明网关(gateways) 12.1数据链接到SQL Server 2012
Installing Oracle Database Gateway for SQL Server 1. 拓扑结构SQL Server-->Gateways-->OracleVersion:2012172.16.28.207:1433Version:12.1172.16.28.41:原创 2016-08-20 16:01:15 · 3911 阅读 · 0 评论 -
ORA-01157,ORA-01110
SQL> select * from dba_temp_files *ERROR at line 1:ORA-01157: cannot identify/lock data file 201 - see DBWR trace fileORA-01110: data file 201:'/home/oracle/app/oracle/oradata原创 2016-12-14 17:31:02 · 978 阅读 · 0 评论 -
ORA-03113: oracle 12c 无法正常启动
--ORA-03113 oracle 12c 无法正常启动[oracle@oracle1 ~]$ sqlplus / as sysdbaSQL*Plus: Release 12.1.0.2.0 Production on Tue Nov 22 10:27:32 2016Copyright (c) 1982, 2014, Oracle. All rights reserve原创 2016-11-22 10:41:50 · 1492 阅读 · 0 评论 -
GoldenGate -2> oracle 12c to mysql 数据同步(1)
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++--oracle+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++.1 开启归档模原创 2016-11-22 10:56:44 · 1033 阅读 · 0 评论 -
ORA-12526: TNS: 监听程序: 所有适用例程都处于受限模式
C:\Users\gaoh>sqlplus sys/orcL#2016@test1 as sysdbaSQL*Plus: Release 12.1.0.2.0 Production on 星期五 12月 2 10:17:50 2016Copyright (c) 1982, 2014, Oracle. All rights reserved.ERROR:ORA-1252原创 2016-12-02 10:24:24 · 17701 阅读 · 0 评论 -
rman异机恢复 Linux _RAC至Win_Single Instance note
mkdir /home/exp_direxport ORACLE_SID=dfhis2rman target /RMAN> run { allocate channel c1 device type disk; backup incremental level 0 format '/home/exp_dir/db_full_%U.bak' ta原创 2016-12-01 22:26:17 · 2406 阅读 · 0 评论 -
oracle 12c AL32UTF8字符集修改为ZHS16GBK
[root@orcl2 12c]# su - oracle上一次登录:六 8月 20 15:31:12 CST 2016pts/2 上[oracle@orcl2 ~]$tnsping t_xshisTNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 21-AUG-2016 12:57:09Co原创 2016-08-21 13:04:40 · 3736 阅读 · 0 评论 -
oracle 12c查询数据库名、实例名等
C:\Users\example>sqlplus / as sysdbaSQL*Plus: Release 12.1.0.2.0 Production on 星期一 8月 22 11:12:14 2016Copyright (c) 1982, 2014, Oracle. All rights reserved.连接到:Oracle Database原创 2016-08-22 11:18:32 · 5164 阅读 · 0 评论 -
Oracle 12c 启用VARCHAR2, NVARCHAR2, and RAW类型支持32K(4,000 to 32,767 bytes)
12c新特性部分 Increased Size Limit for VARCHAR2, NVARCHAR2, and RAW Data Types官方如下介绍:The maximum size of the VARCHAR2, NVARCHAR2, and RAW data types has been increased from 4,000 to 32,767 bytes.Incr原创 2016-08-24 18:28:09 · 3099 阅读 · 0 评论 -
oracle 12c 重建序列SEQUENCE
序列与视图一样,并不占用实际的存储空间,只是在数据字典中保存它的定义信息。创建序列需要使用CREATE SEQUENCE语句,其语法如下:CREATE SEQUENCE [schema]。sequence_name[ START WITH start_number ][ INCREMENT BY increment_number ][ MINVALUE minvalue | NOM原创 2016-08-25 18:58:09 · 1607 阅读 · 0 评论 -
oracle 12c RAC to Single Instance的Active Database Duplicate测试
oracle 12c RAC to Single Instance的Active Database Duplicate测试1.环境概述:++++++++++++++++++++++++++++++++++++++++++++++++++++++++target DB: rac(scanip)db_name:g_xshisinstance_name:auxilia原创 2016-10-10 21:42:41 · 640 阅读 · 0 评论 -
oracle 12c Single Instance to Single Instance的Active Database Duplicate测试
oracle 12c Single Instance to Single Instance的Active Database Duplicate测试--targetSQL> archive log list Database log mode No Archive ModeAutomatic archival DisabledA原创 2016-10-11 17:14:12 · 432 阅读 · 0 评论 -
oracle 12c RMAN异机恢复还原RAC集群(ASM)为单实例库(文件系统)记录
CONFIGURE CONTROLFILE AUTOBACKUP ON备份集准备backup database format '/home/databak/whole_%d_%U';backup spfile format '/home/databak/spfile_%d_%U';切日志alter system switch logfile;backup archi原创 2016-09-27 11:40:28 · 3947 阅读 · 0 评论 -
GoldenGate -1> oracle 12c RAC to Single Instance 数据同步
SQL> select userenv('language') from dual;USERENV('LANGUAGE')----------------------------------------------------AMERICAN_AMERICA.AL32UTF8SQL>--linux:orapwd file=/oracle/app/oracle/p原创 2016-10-20 20:22:53 · 525 阅读 · 0 评论