-
编辑 删除
EM Grid Control Agent Target Discovery
[oracle@hzsdb2 bin]$ ./agentca -helpUsage: agentca -d/-f [-nctis] -d option for rediscovery. -f opti...
-
编辑 删除
Clone ORACLE_HOME
1, Clean up OraHome1 for OraHome1.tar.gz $ORACLE_HOME/<Hostname>_<SID>$ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_<Hostname>_<SID>$ORACLE_HOME/network/log/$ORACLE_HOME/network/a...
-
编辑 删除
ncompress-4.2.4-44.rhel4.x86_64
Cloning of an Oracle Home via Grid Control fails with "/usr/bin/compress: Command not found." [ID 566370.1]
-
编辑 删除
EMGC Bug 5899294
Problem: OMS Cannot Communicate with Agent if IP Address of the Grid Agent Machine is Changed [ID 605009.1] http://forums.oracle.com/forums/thread.jspa?threadID=924925&tstart=15
-
编辑 删除
COMMIT OPTION
COMMIT WAIT: The commit does not return as successful until the redo corresponding to the commit is persisted in the online redo logs (default).COMMIT NOWAIT: The commit should return to the applica...
-
编辑 删除
reinstate database
DGMGRL> show configuration Configuration Name: DRMulti Enabled: &nbs...
-
编辑 删除
PSU 10.2.0.4.2
[oracle@hzshcnc OPatch]$ ./opatch -helpInvoking OPatch 10.2.0.4.2 [oracle@hzshcnc OPatch]$ unzip p6880880_102000_Linux-x86-64.zip [oracle@hzshcnc OPatch]$ ./opatch -helpInvoking OPatc...
-
编辑 删除
oracle patch category
Oracle Interim patches: A patch that is applied in between patchset releases with the Opatch utility. Interim patches are sometimes also referred to as patchset exceptions. Oracle Merge ...
-
编辑 删除
convert database
SQL> set serveroutput onSQL> declare 2 retcode boolean; 3 begin 4 &n...
-
编辑 删除
DG- log type and database role
Pri WEB> SELECT DEST_ID,VALID_TYPE,VALID_ROLE,VALID_NOW FROM V$ARCHIVE_DEST; DEST_ID VALID_TYPE VALID_ROLE VALID_NOW---------- ---------...
-
编辑 删除
flashback drop
SQL> CREATE TABLE CORUSER 2 ( &...
-
编辑 删除
RAC Parallel Compute Parameter
INSTANCE_GROUPS is a Real Application Clusters parameter that you can specify only in parallel mode. Used in conjunction with the PARALLEL_INSTANCE_GROUP parameter, it lets you restrict parallel quer...
-
编辑 删除
Orion
# ./orion_linux_x86 -run simpleORION: ORacle IO Numbers -- Version 11.1.0.7.0Test will take approximately 9 minutesLarger caches may take longer # vi orion_20091022_0316_summary.txtORION V...
-
编辑 删除
Standby is performing log apply
Performing Redo Apply SQL> SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY; PROCESS STATUS--------- ------------ARCH CLOSINGARCH &...
-
编辑 删除
Oracle_Architecture
-
编辑 删除
10g sga_target ? < sga_max
在11g 中，这个SGA_TARGET 只能设置是等于SGA_MAX_SIZE 的大小了，设置比它小，oracle 会自动帮你调整，设置比它大，那还是出错。现在可以自己想想，oracle 对SGA_TARGET 的大小处理在往正确的简单的方向前进中。...
-
编辑 删除
HA parameters
DB_BLOCK_CHECKING Oracle checks a block by going through the data in the block, making sure it is logically self-consistent. Block checking can often prevent memory and data corruption. Block c...
-
编辑 删除
Is there a server running on localhost:3306?
set password for <username>@<servername> = old_password('<password>');
-
编辑 删除
RAC Tips
# oifcfg getifeth0 10.224.188.0 global publiceth2 192.168.0.0 global cluster_interconnect # ocrdump -h ocrdump [<filename...
-
编辑 删除
srvctl -h
srvctl [-V]srvctl add database -d <name> -o <oracle_home> [-m <domain_name>] [-p <spfile>] [-A <name|ip>/netmask] [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY}] [-s <start_options>] [-n <db_name...
