ITPub博客

在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

[root@localhost ~]# hostname127.0.0.1 localhost.localdomain ::1 localhost6.localdomain6 localhost6localhost.localdomain[root@localhost ~]# hostname leitest[root@localhost ~]# vi /etc/sysconfig/networkNETWORKING=yesNETWORKING_IPV6=noHOSTNAME=leitest[root@localhost ~]# vi /etc/hosts127.0.0.1 localhost.localdomain ::1 localhost6.localdomain6 localhost6192.168.6.40 leitest[@more@]

在目的机器上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

http://blog.csdn.net/bingzhuan/article/details/2833434非常感谢原作者：5love一　日志作用 1、运行情况 反映系统当前运行情况，系统发生了那些动作等。2、故障预警 预报可能发生的故障或已经发生的故障，便于及时处理。3、故障分析处理 对已发生故障的原因、经过，便于故障分析处理。4、安全、审计 记录系统登录情况、命令执行情况等。二 常用UNIX系统日志文件1、solaris /var/adm/ /var/adm/messages 2、hp unix /var/adm/syslog/syslog.log 3、sco unix /etc/log目录 4、red hat /var/log目录 三 H

sqlserver2000 备份数据库时不检查该数据库是否存在不一致性，这一点比较要命。、sqlserver2000 修复数据库的几个命令：dbcc checkdb ('cwbase1',repair_allow_data_loss | REPAIR_FAST | REPAIR_REBUILD )DBCC CHECKALLOC ('cwbase1',repair_allow_data_loss | REPAIR_FAST | REPAIR_REBUILD )DBCC CHECKDB('cwbase1') with NO_INFOMSGS,PHYSICAL_ONLYDBCC CHECKTABLE ('lc0019999.table_name',repair_allow_data_loss | REPAIR_FAST | REPAIR_REBUILD )DBCC DBREINDEX ('lc0019999.table_name' ,'') --对lc0019999.table_name的所有的

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

http://hi.baidu.com/myssc/blog/item/b050f11f7ef4cc0e314e1523.html@echo offRem 检查命令行参数if {%1}=={} goto :Usagefor %%i in ({ {/ {-) do if {%1}==%%i?} goto :Usage %%iecho.:Rem 在当前目录检查看是否存在该文件for %%i in (%1) do if exist %%~nx%i ( echo %%~Fi goto :EOF):Rem 在Path中检查该文件for %%i in (%1) do ( if exist %%~$PATH:i ( echo %%~$PATH:i ) else ( echo Error: %1 不在路径里！！！ goto :Usage ))goto :EOF:Usageecho.echo WHICH "filename"ec

归档日志大小 与使用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

Applies to: Oracle GoldenGate - Version: 5.0.0 and later [Release: 5.0.0 and later ]Information in this document applies to any platform. Goal To handle / replicate tables with no (without) primary key (PK) or unique index (UI) or UPI Solution By default, all the columns (except LOB, XML, UDT et al) will be used as the key. Supplemental logging of the table is required.For batch updates and deletes, one update/delete statement in source will becomes multiple ones in target. i

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，

orian说：inline log，就是包含在里面，同一个lv里面 outline log就是在外面，单独一个逻辑卷 http://www.loveunix.net/thread-99882-1-1.html[@more@]

看pv和vg的对应关系# lspvhdisk0 00c4e67543faa6cb rootvg activehdisk1 00c4e675ba0ca9f7 rootvg activehdisk2 none None hdisk3 none None hdisk4 none None hdisk5 none None hdisk6 none None