- 博客(14)
- 收藏
- 关注
RSS订阅原创 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
949
原创 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
17622
原创 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
2379
原创 GoldenGate -2> oracle 12c to mysql 数据同步(1)
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++--oracle+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++.1 开启归档模
2016-11-22 10:56:44
1020
原创 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
1471
原创 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
511
原创 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
413
原创 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
615
原创 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
3915
原创 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
1590
原创 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
3070
原创 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
5114
原创 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
3719
原创 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
3876
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人