ITPub博客

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

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

http://www.sybase.com.cn/detail?id=1094827全球领先的企业级和移动软件公司Sybase，SAP（NYSE：SAP）旗下的公司近日宣布，全新版本的企业数据管理解决方案 Sybase®Adaptive Server Enterprise® (ASE) 15.7正式上市。Sybase ASE 15.7是一款低本高效、能够处理超大数据集的关系型数据库管理系统（RDBMS）。同时，具有全新先进压缩功能的ASE 15.7允许更简洁地存储大数据量，降低了I / O次数，使得当今一流的企业无需增加更多磁盘和硬件成本，即可处理更多的交易和支持更多的并发用户。这则消息是在2011年9月12日至16日在美

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@]

sar -d 2 6[@more@]sar