-
编辑 删除
低调低调
不要观衣识人，一个人怎么对待别人，才是我们判断那个人的标准！ 任何时候，不要太张扬，要保持低调！事实证明，每当我太张扬的时候，总会有后悔的时候！ ...
-
编辑 删除
[转]emca 和emctl 的用法
Oracle10G的EM采用了web方式，并且分成了2个产品，database control和grid control。这里主要介绍如何创建单数据的dbcontrol。Grid control需要下载单独的光盘安装。在用DBCA建库的时候，可以选择是否启用dbcontrol...
-
编辑 删除
how to stop listener in remote machine
http://www.itpub.net/viewthread.php?tid=487253&extra=&page=1through this website,we can see that in oracle9i,if you know the iP/port/sid,you can be stop the remote listener.But ,you cann't do this in ...
-
编辑 删除
觉得无聊，写写东西
最近似乎总在挣扎，继续待在这里似乎只是在浪费时间，又要忍受很多的折磨，可是又不能轻易离开。要么改变，要么离开！改变的决定权不在我这，离开的筹码我会有多少？试着去看淡这一切，可以当想...
-
编辑 删除
[from metalink]How to find the offending SQL from a trace file
How to find the offending SQL from a trace file [ID 154170.1] Modified 21-APR-2010 Type BULLETIN Status PUB...
-
编辑 删除
take care of the default listener definition
take care of the default listener definitionwhen you use the “listener.ora” to start the tnslsnr process,you must take care of the default listener definition.If there is no content in listener.or...
-
编辑 删除
[from metalink]Workaround for ORA-22992
Workaround for ORA-22992 [ID 796282.1] Modified 21-OCT-2010 Type PROBLEM Status PUBLISHED In t...
-
编辑 删除
How does the “change_password” command change
Before the oracle10g,you must execute “set password” after you execute the command “change_password”.for example:LSNRCTL> statConnecting to (DESCRIPTION=(ADDRESS=(PROTOC...
-
编辑 删除
the parameter "lock_sga " and "_use_ism"
In 《DSI401_dump_crashes_corrupt.pdf》,you can find how to use the parameter of “lock_sga” and “_use_ism” and what is the definition of these two parameters.The initialization...
-
编辑 删除
congratulate myself
I have pass all the exam of OCP today.Just congratulate myself on that!Thanks my wife!
-
编辑 删除
[from metalink]PROGRAMS TIME OUT WAITING FOR LIBRARY CACHE PIN
os:window 2003 serveroracle:9204when I recompile the procedure,it takes a long time and makes an "ORA-4021" error at the end.After I restart the os,it does well.maybe,it's a bug.PROGRAMS TIME OUT...
-
编辑 删除
the supplement records of ocp
You want an ASM instance to manage the files of your database. To achieve this objective, you specify the following parameters in the parameter file of the database:INSTANCE_TYPE = RDBMSDB_NAME = PR...
-
编辑 删除
[转]an example of recreating controlfile with offline and read only datafile
假如数据库中存在offline 的datafile，read only 的Tablespace，这时重建控制文件，控制文件中是否会有关于offline datafile, read only tablespace的信息呢？要如何恢复呢？ SQL> alter database datafile...
-
编辑 删除
An experiment of recovering read-only tablespace using backup controlfile
An experiment of recovering read-only tablespace using backup controlfileWhen the tablespace users was read write ,I backup the database with autobackup on.Rman> backup database plus archivelog delete...
-
编辑 删除
1Z0-007
24: In which three cases would you use the USING clause? (Choose three.)A.You want to create a nonequijoin.B.The tables to be joined have multiple NULLcolumns.C.The tables to be joined have columns o...
-
编辑 删除
[from metalink]OCR、Vote disk Maintenance Operations
OCR / Vote disk Maintenance Operations: (ADD/REMOVE/REPLACE/MOVE), including moving from RAW Devices to Block Devices. [ID 428681.1] Modified 16-NOV-2009 ...
-
编辑 删除
the record of learning asm
1、 create a diskgroup for asm(no failure groups)when you create a external diskgroup,the initial state of the diskgroup is dismount,you can query the view v$asm_diskgroup to see it.Sql>CREATE DISKG...
-
编辑 删除
1Z0-043记录(四)
43、You want an ASM instance to manage the files of your database. To achieve this objective, you specify the following parameters in the parameter file of the database:INSTANCE_TYPE = RDBMSDB_NAME ...
-
编辑 删除
1Z0-043记录(三)
29、You have a disk group, DGROUP1, with three disk and NORMAL redundancy. You execute the following command to create a template for the disk group:ALTER DISKGROUP dgroup1ADD TEMPLATE my_tempATTRI...
-
编辑 删除
1Z0-043记录(二)
18、You are working on an Oracle Database 10g database. Because of data loss, you decided to perform. a Flashback Database operation using the following command:SQL> FLASHBACK DATABASE TO TIMESTAMP(S...
