ITPub博客

Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.1 - Release: 10.2 to 11.2Generic Linux Goal ASMLIB is a support library for the Automatic Storage Management (ASM) feature of the Oracle Database and is available for the Linux operating system. ASMLIB packages are available for Linux kernel 2.4 and 2.6 for the following Linux operating systems: Suse Linux Enterprise Server/United Linux versions 8 - 11Red Hat Advanced Server 2.1, Red Hat Enterprise Linux v

Requirements For Installing Oracle10gR2 On RHEL 5/OEL 5 (x86_64) [ID 421308.1] Requirements For Installing Oracle 10gR2 On RHEL/OEL 5 (x86) [ID 419646.1][@more@]Requirements For Installing Oracle10gR2 On RHEL 5/OEL 5 (x86_64) [ID 421308.1] Requirements For Installing Oracle 10gR2 On RHEL/OEL 5 (x86) [ID 419646.1]

ASM 11.2 Configuration KIT (ASM 11gR2 Installation & Configuration, Deinstallation, Upgrade, ASM Job Role Separation (Standalone Only). [ID 1092213.1][@more@]

ASM 11.2 Configuration KIT (ASM 11gR2 Installation & Configuration, Deinstallation, Upgrade, ASM Job Role Separation (Standalone Only). [ID 1092213.1][@more@]

关闭selinux即可。[@more@]/sqlplus: error on libnnz11.so: cannot restore segment prot after reloc [ID 454196.1]

Defining a "default RPMs" installation of the RHEL OS [ID 376183.1][@more@]Defining a "default RPMs" installation of the RHEL OS [ID 376183.1]

Installing 32-bit RDBMS Client software on x86_64 Linux. [ID 1075717.1][@more@]

在rhel5.3 x86上安装oracle 11.2.0.1 db software的过程参考：Requirements for Installing Oracle 11gR2 RDBMS on RHEL (and OEL) 5 on 32-bit x86 [ID 880936.1]I. Hardware: 主要是内存和硬盘的可用空间大小。这个不用说了。我的虚拟机环境是868m内存的，也可以安装上，只是有个提示说内存小于1g，ignore此提示就行 1. Minimum Hardware Requirements a.) At least 1.0 Gb (1024 MB) of physical RAM b.) Swap disk space proportional to the system's physical memory as follows: RAM

在目的机器上oradim -new -sid lei建立bdump 和udump注册表添加键oracle_sid ,并修改其值为leicopy 源机器的full database 备份/archive备份/archive备份之后的归档日志到目的机器的相同目录下copy 源机器的控制文件自动备份到C:from14下restore spfile from 'C:from14O1_MF_S_764118213_793FY5QG_.BKP'restore controlfile from 'C:from14O1_MF_S_764118213_793FY5QG_.BKP'alter database mount;此时，请保证源机器的full database 备份/archive备份在相同的目录（相同的目录是指与源端的备份时的目录同名）下restore database;recover d

Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONE MicrosoftInternetExplorer4

C:Documents and SettingsAdministrator>sqlplus system/aaaaaaSQL*Plus: Release 11.1.0.6.0 - Production on 星期六 10月 8 22:37:22 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 tablespace_name from dba_tablespaces;TABLESPACE_NAME------------------------------SYSTEMSYSAUXUNDOTBS1TEMPUSERSMYTBS已选择6行。SQL> alter

今天在一个win32下oracle 10.1.0.2的一个库上遇到了oe这个用户。貌似这个用户是安装了示例数据库后的自带的。 先记录一下，有机会找个oracle 10.1.0.2 或者oracle 92的环境确认一下。[@more@]

oracle grant 语句的GRANT privilige TO user IDENTIFIED BY password 语法-user已经存在但是赋予不同密码C:Documents and SettingsAdministrator>sqlplus scott/aaaaaa@leiSQL*Plus: Release 11.1.0.6.0 - Production on 星期六 10月 8 22:01:59 2011Copyright (c) 1982, 2007, Oracle. All rights reserved.连接到:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> exit从 Oracle Database 10g Enterprise Edition

在D:oracleproduct10.2.0db_1RDBMSADMINutlsampl.sql下，有如下的语句：DROP USER SCOTT CASCADE;DROP USER ADAMS CASCADE;DROP USER JONES CASCADE;DROP USER CLARK CASCADE;DROP USER BLAKE CASCADE;GRANT CONNECT,RESOURCE,UNLIMITED TABLESPACE TO SCOTT IDENTIFIED BY TIGER;DROP PUBLIC SYNONYM PARTS;CONNECT SCOTT/TIGERCREATE TABLE DEPT (DEPTNO NUMBER(2) CONSTRAINT PK_DEPT PRIMARY KEY, DNAME VARCHAR2(14) , LOC VARCHAR2(13) ) ;这个GRANT privilige TO user IDENTIFIED BY password 语法，其实是会创建user

Complete Checklist for Manual Upgrades to 10gR2 [ID 316889.1][@more@]

登录oracle10.2.0.4 asmcmd提示ORA-12557: TNS:protocol adapter not loadable (DBD ERROR: OCIServerAttach)环境：windows 2003 32bit , oracle10.2.0.4, asm存储，单实例首先安装的是：oracle10.2.0.4 的home在D:oracleproduct10.2.0db_1其次安装的是：oracle10.2.0.1的client home在I:oracleproduct10.2.0client_1最后安装的是：oracle11.1.0.6 的home在F:appAdministratorproduct11.1.0db_1这样一来，windows 环境变量中的path值 如下：F:appAdministratorproduct11.1.0db_1bin;I:oracleproduct10.2.0client_1bin;D:oracleproduct10.2

归档日志大小 与使用rman 备份后的归档日志产生的备份集大小的关系oracle 10.2.0.4，win 32bit ，asm方式存储，归档路径在asm磁盘组中，单实例备份归档日志前，执行：SELECT SUM(BLOCKS *BLOCK_SIZE )/1024/1024 AS "Size(M)" FROM v$archived_log where deleted ='NO'sql返回：1334.16845703125执行备份（不压缩），备份语句为backup archivelog all format 'E:archivelogxiaoshou_arch_%U_%T' delete input;备份后，看生成的归档备份文件的总大小：1,408,131,072 B=1,408,131,072/1024/1024=1342.8984375 其实生成的归档备

Solution 1- We should increase the server swap space (paging space) . The general rule of thumb is that swap space should be:RAM SWAP1GB to 2GB 1.5 times RAM > 2GB and <= 8GB 1 times RAM > 8GB .75 times RAM So in our case, the recommended swap space should be 28 GB Instead of 17 GB 2- We can also try to increase physical memory, if possible. 3- In Unix Platforms , The user limits for user or

OGG can insert duplicate rows when there is no unique index primary key UI PK defined [ID 1350948.1]Applies to: Oracle GoldenGate - Version: 9.5_EA and later [Release: 9.5.0 and later ]Information in this document applies to any platform. Symptoms Target table with no UI or PK has duplicate rows after initial load. Replicat is (may be) using HANDLECOLLISIONS and KEYCOLS Changes An initial load. Cause It is possible to get duplicate rows because there is no key / index constraint

转自：http://space.itpub.net/70109/viewspace-687845感谢原作者。安装oracle11.1.0后运行sqlplus出现错误：Message file sp1<lang>.msb not found解决办法：1、在~oracle/.bashrc中配置如下参数：export ORACLE_SID=orclexport ORACLE_BASE=/home/oracle/oracle_11g/export ORACLE_HOME=/home/oracle/oracle_11g/product/11.1.0/db_1export NLS_LANG=american_america.ZHS16GBKexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATHexport PATH=$PATH:$ORACLE_HOME/bin:$HOME/bin:.再次运行sqlplus sys/password as sysdba，