- 博客(132)
- 收藏
- 关注
RSS订阅转载 RAC实例名和主机名不对应？
Oracle 11.2版本之前 RAC 使用的是pinned 方式：[oracle@ rac1 ~]$ olsnodes -nrac1 1rac2 2[oracle@ rac1 ~]$ srvctl st...
2017-11-20 16:23:56
371
转载 定期truncate 歷史間隔分區INTERVAL PARTITION
定期truncate 歷史間隔分區INTERVALPARTITION 的SP：CREATE OR REPLACE PROCEDURE GC.DROP_FATP_DIAG_COMM_NOW_PAR ASBEGIN...
2017-11-20 11:39:20
125
转载 WebLogicServer BEA-000211 Connection rejected,..
問題：新部署的WebLogicServer，發現超過5個client鏈接就無法訪問，檢查server log報錯："WebLogicServer <Nov 20, 2017 1:45:00 AM GMT> &...
2017-11-20 10:40:05
362
转载 Oracle cascading standby Parameters
Primary Database DB_UNIQUE_NAME=bostonFAL_SERVER=boston2LOG_ARCHIVE_CONFIG='DG_CONFIG=(boston,bost...
2017-11-17 15:31:01
105
转载 Oracle ROWNUM
ROWNUM和ROWID一樣也是一個偽列，按ORACLE從buffer cache或data file中的順序開始計數的。 ROWNUM=1也就是讀到的第一條，當這條記錄被刪除ROWNUM將變為...
2017-11-15 11:33:29
87
转载 Oracle PL/SQL编译警告PLSQL_WARNINGS
前言：只要符合SQL和PL/SQL的語法語義，ORACLE就會成功的編譯過，不會提示任何信息 警告分類三種 1. SEVERE:檢查可能出現的不可預料結果，例：參數的...
2017-11-15 11:27:10
620
转载 Oracle PL/SQL中EXCEPTION用法
1.自定義EXCEPTION DECLARE past_due EXCEPTION; acct_num NUMBER := 2; BE...
2017-11-15 11:19:03
1574
转载 COMMIT&ROLLBACK时要做哪些工作
COMMIT 提交频繁，花費的時間會上升。提交一千行和提交一行的時間相當 COMMIT前已經完成了99.9%的工作： *已在SGA中產生了回滾段記錄（UNDO） *已在SG...
2017-11-14 15:01:30
106
转载 Oracle自治事务autonomous_transaction用法
自治事務執行某些工作(COMMIT，ROLLBACK)后不影響當前的外面執行的事務。 范例1. 过程中的使用： 非自治事務如下 create or replace pro...
2017-11-14 14:47:34
262
转载 Linux下查找命令对应的RPM安装包
在使用LINUX难免遇到一些命令无法使用，例如：[root@localhost~]# ifconfig-bash: ifconfig: command not found在命令已有安装的server中执行以下，...
2017-11-08 11:47:58
979
转载 [SQL] rollup & cube 分组函数用法及一例
rollup First, itcalculates the standard aggregate values specified in the GROUP BY clause. Then, it c...
2017-11-07 11:10:02
180
转载 Oracle 刪除表中重复记录的DELETE SQL
刪除 table:ZZMSTR.FCT_CAPACITY_MLB 中BU_CODE_ID, FACTORY_CODE_ID欄位重複的行：DELETE FROM ZZMSTR.FCT_CAPACITY_MLBWHER...
2017-11-06 16:43:32
114
转载 Toad生成ASH報錯 ORA-01843: 不是有效的月份 ORA-06512
ORA-01843: 不是有效的月份 ORA-06512: 在 "SYS.DBMS_SWRF_REPORT_INTERNAL",line 11980 ORA-06512: 在 "S...
2017-11-06 16:25:21
804
转载 Linux下禁用IPV6 (Redhat 6.X)
1.vi /etc/sysconfig/network NETWORKING_IPV6=no 必要時/etc/sysconfig/network-scripts/ifcfg-ethx ...
2017-11-06 16:22:25
193
转载 ORA-31693 ORA-00604 and ORA-942 During Data Pump Import
ORA-31693 ORA-00604 and ORA-942 During Data Pump Import (文档 ID 1943390.1) ...
2017-10-27 17:09:08
447
转载 hadoop常用操作命令
dfsadmin命令 report各幾點使用狀態 [hdfs@hd3 ~]$ hadoop dfsadmin-report DEPRECATED: Use of this scri...
2017-10-27 16:43:54
155
转载 RAC Instance Crashes During Startup Due To Error 495
RAC Instance Crashes During Startup Due To Error 495 -GEN0 process terminated with error (文档 ID 1547091.1)...
2017-10-27 16:40:00
227
转载 ORA-00600 [733] WHEN START 9i DATABASE
平臺: Oracle9i Enterprise Edition Release 9.2.0.8.0 -Production Windows 2003(32bit) ...
2017-10-27 16:36:04
179
转载 Flush an Object Out The Library Cache [SGA] Using The DBMS_SHARED_POOL
How To Flush an Object Out The Library Cache [SGA] Using The DBMS_SHARED_POOL Package ...
2017-10-26 17:46:00
98
转载 MSSQL导出所有login账号和密码
http://support.microsoft.com/kb/918992/1> 创建下面两个SP:CREATE PROCEDURE [dbo].[sp_hexadecimal] @binvalue...
2017-10-26 17:36:52
624
转载 Oracle建立dblink MySQL
ODBCconnector: mysql-connector-odbc-5.1.13-1.rhel5 ODBC驅動： unixODBC-2.2.11-7.1...
2017-10-26 17:30:27
168
转载 MySQL Percona XtraBackup
Red Hat Enterprise Linux Server release 6.6(Santiago) [root@mysqlgcopt]# tar -xvfPercona-Xt...
2017-10-26 17:22:35
89
转载 Objects Compiled With 'DEBUG' Option
How to Obtain List of Objects Compiled With 'DEBUG' Option in the Database [ID 231349....
2017-10-26 15:37:00
162
转载 DBMS_JOBS 连续失败16次自动Broken
Broken Jobs and the Job Queue [ID 103349.1] ...
2017-10-26 15:33:57
971
转载 Controlfile和system01數據文件丟失的恢復(通过standby)
問題 巴西時間：FriNov 16 21:00:02 2012,北京時間:週六早上7點 DELL 2950 server + Oracle 9.2.0.7 / ,/u01(ORAC...
2017-10-26 15:16:19
133
转载 LISTAGG 函数
LISTAGG函數 Oracle 11.2之後推出的：字符串聚合 字符串聚合就是按照分组把多行数据串联成一行，以下面的结果集为例： 11.2之前有WMSYS.WM_CONCAT函數，不過是非文檔說明...
2017-10-26 15:09:13
233
转载 Time Drift Detected. Please Check Vktm Trace File For More Details
Time Drift Detected. Please Check Vktm Trace File For Mor...
2017-10-26 15:00:07
833
转载 Bug 10202228 wrong result when _allow_level_without_connect_by set to true
Bug10202228wrong result when _allow_level_without_connect_by set totrue This note gives a brief o...
2017-10-26 14:49:20
557
转载 Data Guard Support for Heterogeneous Primary and Physical Standbys
Data Guard Support for Heterogeneous Primary and Physical Standbys in Same Data Guard ...
2017-10-26 14:47:50
177
转载 tmpfs devshm Oracle 11G
AutomaticMemory Management Startingwith Oracle Database 11g, the Automatic Memory Management feature...
2017-10-26 13:30:54
138
转载 listener start fail TNS-12555 利用trace找到问题
現象： RedHat Enterprise Linux Server release 5.4 (Tikanga) OracleDatabase 11g Enterprise Edition ...
2017-10-26 12:08:34
186
转载 Job: TO_CHAR(CURRENT_TIMESTAMP, 'HH24MISSFF') error
問題： $date-R Fri,10 May 2013 14:51:40 +0800 $date-u FriMay 10 06:51:45 UTC 2013...
2017-10-26 12:04:13
838
转载 Oracle 11G Virtual Columns
Virtual Columns Virtualcolumns are defined by evaluating an expression the results of which become the...
2017-10-26 11:59:06
112
转载 Oracle 11G EM建立
ogg<*dt2*/home/oracle>$emca -repos createSTARTED EMCA at Aug 20, 2013 10:50:25 AMEM Configuration As...
2017-10-26 11:56:11
165
转载 Oracle 11G 统计信息Task
Managing Automated Database Maintenance Tasks Case 1: 在DBCA安裝時如果沒有勾選自動收集統計信息，則oracle不會自動收集...
2017-10-26 11:53:49
214
转载 Interval Partition table 11G
Interval Partitioning Interval partitioning is an extension of range partitioning whichinstructs the da...
2017-10-26 11:45:43
166
转载 db_block_checksum和db_block_checking
物理一致性：硬件故障檢查，不關心內容正確與否。Checksum 邏輯一致性：內容檢查，比checksum複雜的多。如：檢查記錄是否被不存在的事務鎖定、記錄和索引是否對應，檢查內容比物理一致性要多 ...
2017-10-26 11:41:53
155
转载 Oracle active dataguard ORA-01555
Bug 10018789Spin in kgllock / DBhang with high library cache lock waits on ADG This note gi...
2017-10-26 11:38:46
300
转载 Timeout (30000 milliseconds) waiting for the OracleService service to connect.
問題： Services.msc 中Oracle服務啟動時報錯無法開啟 環境： Oracle 11.2.0.3Microsoft Windows 2003(32-b...
2017-10-26 11:36:44
951
转载 Oracle standby ORA-00600:[3020] ORA-10567
現象 Oracle Database 11g Enterprise Edition Release11.2.0.1.0 - 64bit Production Red Hat Ent...
2017-10-26 11:10:48
586
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人