ITPub博客

1.vi /etc/sysconfig/network NETWORKING_IPV6=no必要時/etc/sysconfig/network-scripts/ifcfg-ethxIPV6INIT=no2./etc/modprobe.d/ipv6.conf (新建文件) alias net-pf-10 off alias ipv6 off blacklist ipv63.重啟server 并验证lsmod | grep ipv6...

SQL Server 需要支持多国语言的话，Table 字段的数据类型需要设置为 nchar，nvarchar，ntext 等， 加n的時候表示支持Unicode 数据(一般支持多語言的站点建议使用)。   在update 及select 等操作的時候需要...

ORA-31693 ORA-00604 and ORA-942 During Data Pump Import (文档 ID 1943390.1)In this Document...

dfsadmin命令report各幾點使用狀態 [hdfs@hd3 ~]$ hadoop dfsadmin-reportDEPRECATED: Use of this script to execute hdfs command is deprecated.Instead use the hdfs command for it. Configured Capacity: 768761769165 (715.97 GB)Present Capacity: 739275145216 (688.50 GB)...

RAC Instance Crashes During Startup Due To Error 495 -GEN0 process terminated with error (文档 ID 1547091.1) Applies to: Oracle Database -Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]Information in this document applies to any platform.Symptomso GI & ...

平臺: Oracle9i Enterprise Edition Release 9.2.0.8.0 -Production         Windows 2003(32bit) 問題：standby database 斷電后，再啟動時startup nomount;報錯：ORA-00600: internal errorcode, arguments:[733], [1780491312], [pga heap],[],...

 修改时间 29-APR-2011     类型 HOWTO     状态 PUBLISHEDDBMS_SHARED_POOL.PURGE Is Not Working On 10.2.0.4 [ID 751876.1] ...

http://support.microsoft.com/kb/918992/1> 创建下面两个SP:CREATE PROCEDURE [dbo].[sp_hexadecimal]    @binvalue varbinary(256),    @hexvalue varchar (514) OUTPUTASDECLARE @charvalue varchar (514)DECLARE @i intDECLARE @length intDECLARE @hexstring char(16)SELECT @charvalu...

 ODBCconnector:mysql-connector-odbc-5.1.13-1.rhel5 ODBC驅動：unixODBC-2.2.11-7.1unixODBC-devel-2.2.11-7.1 OS版本: Red Hat Enterprise Linux Server release 5.4(Tikanga) Oracle DB server中配置：[root@scmauto opt]# rpm -ivhunixODBC-2.2.11...

Red Hat Enterprise Linux Server release 6.6(Santiago) [root@mysqlgcopt]# tar -xvfPercona-XtraBackup-2.4.6-r8ec05b7-el6-x86_64-bundle.tarpercona-xtrabackup-24-2.4.6-2.el6.x86_64.rpmpercona-xtrabackup-24-debuginfo-2.4.6-2.el6.x86_64.rpmpercona-xtrabackup-test-24-2.4.6-2.e...

How to Obtain List of Objects Compiled With 'DEBUG' Option in the Database [ID 231349.1]

Broken Jobs and the Job Queue [ID 103349.1]***Checked forrelevance on 11-Jul-2012*** NOTE:=====The discussedfunctionality is still available in Oracle 10g and Oracle 11g.However, withOracle 10gR1 the DBMS...

問題巴西時間：FriNov 16 21:00:02 2012,北京時間:週六早上7點DELL 2950 server + Oracle 9.2.0.7 / ,/u01(ORACLE_HOME,ORACLE_BASE)相關一塊硬盤RAID1 (76G) 與磁盤陣列卡 同時壞掉/data(大部份datafile,redo logfile)  RAID5 (146G) 沒有損壞 分析如果備份激活的話，需要變...

LISTAGG函數 Oracle 11.2之後推出的：字符串聚合字符串聚合就是按照分组把多行数据串联成一行，以下面的结果集为例：11.2之前有WMSYS.WM_CONCAT函數，不過是非文檔說明的 舉個列子 為實現，同一類不同行數據 在 一行中顯示出來，可以使用wmsys.wm_concat (a.FAILURE_DESC||'-'|| a...

To BottomComments (0) In this Documen...

Bug10202228  wrong result when _allow_level_without_connect_by set totrue  This note gives a brief overview of bug10202228.  The content was last updated on: 25-OCT-2011 Click here for details of each of the sections below.Affects:...

Data Guard Support for Heterogeneous Primary and Physical Standbys in Same Data Guard Configuration [ID 413484.1]To BottomModified:08-Mar-2013Type:BULLETINStatus:PUBLISHEDPriority:1 PLATFORM_ID...

Automatic Memory ManagementStartingwith Oracle Database 11g, the Automatic Memory Management featurerequires more shared memory (/dev/shm)and file descriptors. The size of the sharedmemory must be at least the greater of the MEMORY_MAX_TARGET and MEMORY_TARGET parametersfor each Oracl...

現象：RedHat Enterprise Linux Server release 5.4 (Tikanga)OracleDatabase 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production開啟listener時報錯 TNS-12555,Linux Errorscmautosty<*scmauto*/home/oracle>$lsnrctlstartLSNRCTL forLinux: Version 11.2.0.3.0 - Production on 03...

問題：$date-RFri,10 May 2013 14:51:40 +0800$date-uFriMay 10 06:51:45 UTC 2013 CREATE TABLEGC.TEST_JOB_TIMESTAMP(  SYST      VARCHAR2(50 BYTE), CURRENT_T  VARCHAR2(50 BYTE),  TIMES &nb...