- 博客(14)
- 收藏
- 关注
原创 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
969
原创 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
17676
原创 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
2391
原创 GoldenGate -2> oracle 12c to mysql 数据同步(1)
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++--oracle+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++.1 开启归档模
2016-11-22 10:56:44
1028
原创 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
1481
原创 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
518
原创 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
425
原创 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
628
原创 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
3934
原创 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
1597
原创 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
3084
原创 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
5144
原创 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
3727
原创 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
3894
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人