ITPub博客

http://www.oracledatabase12g.com/archives/oracle-11gr2%E5%8F%91%E5%B8%8311-2-0-3-patchset%E8%A1%A5%E4%B8%81%E9%9B%86-%E5%8F%88%E4%B8%80%E9%87%8D%E9%87%8F%E7%BA%A7%E6%9B%B4%E6%96%B0.htmlOracle 11gR2发布11.2.0.3 Patchset补丁集-又一重量级更新 By admin, on September 24th, 2011 Oracle 11gR2的Patchset 2 即11.2.0.3在美国时间9月23日发布了(23-SEP-2011)，此次的发布包括Linux 86和 Linux x86-64 2种操作系统平台。 11.2.0.3 补丁集的Patch id为10404530，该补丁集包括7个zip包，总容量达到了5 GB (慢慢

EMCA stops with "Hostname should not contain underscore _ in it and it should not be longer than 32 characters" [ID 1265731.1]Applies to: Enterprise Manager Grid Control - Version: 10.2.0.4 to 11.2.0.2 - Release: 10.2 to 11.2Information in this document applies to any platform. Symptoms EMCA or DBCA fails to install EM database console due to a server hostname of over 32 characters. In the $ORACLE_HOME/cfgtoollogs/emca/<SID>/emca_YYYY-MM-DD_HH-MM-SS-AM.log Oct 4, 2010

数据文件offline后，再online时，提示需要介质恢复，也就是需要归档日志。。。而 offline后，并无对涉及该数据文件数据库对象的dml或者ddl操作。。[@more@]

What should the value of LD_ASSUME_KERNEL be set to for Linux? [ID 377217.1] Recommended Settings for Installing Oracle Products Operating System LD_ASSUME_KERNEL setting RHAS 2.1 2.2.5 RHEL3, RHEL4, OEL4 any value from 2.4.1 to 2.4.19 SLES8, SLES9 2.4.21 RHEL5, OEL5, SLES10 Should

Requirements for Installing Oracle 9iR2 64-bit on RHEL 4 x86-64 (AMD64/EM64T) [ID 353529.1]Requirements for Installing Oracle 9iR2 64-bit on RHEL 4 x86-64 (AMD64/EM64T) 1. Install the required OS components This list is based upon a "default-RPMs" installation of RHEL AS/ES 4 update 1. When a newer "update" level is used, the RPM release numbers (such as 2.4-9.1.87) may be slightly higher (such as 2.4-9.1.93 or 2.4-9.2.37). This is fine so long as you are still usi

Requirements for Installing Oracle 9iR2 32-bit on RHEL3 [ID 252217.1]Requirements for Installing Oracle 9iR2 64-bit on RedHat 3 on x86_64 (AMD/EM64T) [ID 308588.1][@more@]

此问题在metalink上有文章记录Error 'su: /Bin/Bash: Too Many Open Files In System' When Switching to Non-root User on Enterprise Linux [ID 1187463.1]Applies to: Linux OS - Version: 4.4 and later [Release: OEL4U4 and later ]Linux x86-64 Symptoms You get the following error when switching to non-root user by 'su': su: /bin/bash: Too many open files in system Cause System-wide resource threshold file-max exceeded. Solution Increase the file-max value, e.g. #echo "6553600&q

How to configure Client Failover after Data Guard Switchover or Failover [ID 316740.1][@more@]

The Impact of the Sqlnet Settings on Database Security (sqlnet.ora Security Parameters and Wallet Location) [ID 1240824.1][@more@]

SQL*Net & Oracle Net Services - Tracing and Logging at a Glance [ID 219968.1][@more@]

How to Configure TAF and Client Load Balancing in a Replicated Environment [ID 210596.1][@more@]

假设如下的环境1号机主机名为hosta，物理ip地址为192.168.0.12号机主机名为hostb，物理ip地址为192.168.0.2active ip(ha软件虚拟出来的ip) 地址为192.168.0.101. /etc/hosts文件中，可以有127.0.0.1这一行，但是127.0.0.1之后，不能有主机名。可以是127.0.0.1 localhost 等等2.1号主机的/etc/hosts文件，应该有如下的行：192.168.0.1 hosta192.168.0.2 hostb 192.168.0.10 cluster 3.2号主机的/etc/hosts文件，应该有如下的行： 192.168.0.1 hosta 192.168.0.2 hostb 192.168.0.10 cluster 4.1号主机中oracle_home

Applies to: Oracle Net Services - Version: 7 to 8.0 Information in this document applies to any platform. Purpose This article describes configuration of sqlnet.ora, tnsnames.ora and listener.ora. This article has been written focusing versions 7 to 8.0. Scope and Application This article is intended for database administrators who would like to configure Net8 Configuring TNSNAMES.ORA, SQLNET.ORA,and LISTENER.ORA in Net8 The LISTENER.ORA File: ===================Database listeners

http://www.cnblogs.com/NickyYe/archive/2011/06/21/2086135.html原文请建如上的的链接。[@more@][]

HP-UX系统日志文件 2008/11/28 19:38 文件名－－－－－－－－－文件内容－－－－－－－－－－－－－－监测方法 /etc/rc.log －－－－－－启动日志－－－－－－－－－－－－－－用读取文本文件的方法， /var/adm/syslog/syslog.log 一般系统日志（包括客户端的访问记录）－－－－－－ /var/adm/sw/*.log －－－－软件安装日志－－－－－－－－－－分析发生的相关问题。 /var/adm/wtmp（wtmps）－用户登录信息－－－－－－－－－－用last 命令查看（清空：>wtmp） /var/adm/btmp（btmps）－－用户登录失败信息－－

you are trying to manipulate a job in the job queue (DBA_JOBS/USER_JOBS) and you receive: ORA-08102: index key not found, object... Cause: Internal error: possible inconsistency in index Action: Send trace file to your customer support representative, along with information on reproducing the error Example: SQL> execute dbms_job.remove(1); ORA-08102: index key not found, object #124 ->>> SYS.I_JOB_NEXT where object #124 is the object# in DBA_OB

Checked for relevance on 14-May-2009" PURPOSE ------- To further document a known DataPump restriction. SCOPE & APPLICATION ------------------- This applies to Database Administrators who have traditionally used UNIX named pipes with the original Export and Import to 'compress', 'gzip' or 'split' Export dump files. DATAPUMP EXPORT/IMPORT DOES NOT WORK WITH UNIX NAMED PIPES ---------------------------------------------------------- EXPLANATION -----------

修改时间 20-JUL-2010 类型 HOWTO 状态 PUBLISHED In this Document Goal Solution References Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.4 - Release: 10.1 to 10.2Information in this document applies to any platform. Goal With the old EXPORT utility you can execute the export using exp command with gzip program as below: mknod /u01/backup/exp/export_pipe p nohup /usr/bin/gzip < /u01/backup/exp/export_pipe

修改时间 17-APR-2009 类型 BULLETIN 状态 PUBLISHED PURPOSE The basic function of the export utility is to extract the objects of a database and locate them in a flat file that is usually on tape or on disk. The process for exporting to tape is explained in this bulletin. SCOPE & APPLICATION Informative SEARCH WORDS 2 gig limit This bulletin examines several considerations and steps for exporting data to tape on unix platforms eith

C:Documents and SettingsAdministrator>sqlplus / as sysdbaSQL*Plus: Release 11.1.0.6.0 - Production on 星期二 9月 13 22:55:50 2011Copyright (c) 1982, 2007, Oracle. All rights reserved.连接到:Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> select supplemental_log_data_min from v$database;SUPPLEME--------NO注意：是no的话，会导致logminer工具无法捕捉dml操作。。。[@more@]