-
编辑 删除
11.2.0.3 RAC 全过程--3.Kernel Configure
# Edit all Node[root@ swhygzhoudb01 etc]# vi sysctl.conf fs.aio-max-nr=1048576fs.file-max=6815744kernel.shmall=2097152kernel.shmmax=1073741824kernel.shmmni=4096kern...
-
编辑 删除
11.2.0.3 RAC 全过程--2.Check rpm packages
rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' binutils compat-libstdc++ elfutils-libelf elfutils-libelf-devel elfutils-libelf-devel-static gcc gcc-c++ glibc glibc-common glibc-de...
-
编辑 删除
11.2.0.3 RAC 全过程--1.Redhat configure
1.1:[root@swhygzhoudb01 ~]# strings /etc/sysconfig/networkNETWORKING=yesNETWORKING_IPV6=noHOSTNAME=swhygzhoudb011.2:[root@swhygzhoudb01 ~]# strings /etc/sysconfig/network-scripts...
-
编辑 删除
Oracle Files
1、与实例相关的文件只有3種：Ø 参数文件（parameter file）：这些文件告诉Oracle实例在哪里可以找到控制文件，并且指定某些初始化参数，这些参数定义了...
-
编辑 删除
DBMS_STATS.PLAN
Thread 1 cannot allocate new log, sequence 4097Checkpoint not complete Current log# 1 seq# 4096 mem# 0: /data1/stream/ygzhou01/datafile/redofile/redo01.logThread 1 advanced to log sequence 4097 ...
-
编辑 删除
DBMS_STATS
–-收集資料庫資訊EXEC DBMS_STATS.GATHER_DATABASE_STATS;EXEC DBMS_STATS.GATHER_DATABASE_STATS(ESTIMATE_PERCENT => 15);–-收集SCHEMA資訊EXEC DBMS_STATS.GATHER_SCHEMA_STATS('SCOTT');EXEC DBMS_STATS.GATHE...
-
编辑 删除
archived_sp
/* FORMATTED ON 2012/04/27 15:09 (FORMATTER PLUS V4.8.8) */ --STEP1:CREATE TABLE HMD.R_WIP_TRACKING_T_TEMPCREATE TABLE hmd.r_wip_tracking_t_temp AS SELECT * FROM sfi...
-
编辑 删除
Heavy swapping
Thu Apr 19 00:00:00 2012Time drift detected. Please check VKTM trace file for more details.Time drift detected. Please check VKTM trace file for more details.Thu Apr 19 16:30:14 2012Closing scheduler ...
-
编辑 删除
Enabling Database Resident Connection Pooling
Oracle Database includes a default connection pool called SYS_DEFAULT_CONNECTION_POOL. By default, this pool is created, but not started. To enable database resident connection pooling, you must ex...
-
编辑 删除
Shutdown Timeout
Shutdown TimeoutShutdown modes that wait for users to disconnect or for transactions to complete have a limit on the amount of time that they wait. If all events blocking the shutdown do not occu...
-
编辑 删除
PasswordFile
For example, for a database instance with the SID orcldw, the password file must be named orapworcldw on Linux and PWDorcldw.ora on Windows.In an Oracle Real Application Clusters env...
-
编辑 删除
External Tables: Querying Data From Flat Files in Oracle
mkdir -p /data1/stream/ygzhou_dir 1.1、strings inputScripts.sql CREAT OR EREPLACE DIRECTORY dir_dump as '/data1/stream/ygzhou_dir';CREATE TABLE input( id INT, name V...
-
编辑 删除
Automatic Memory Management
AutomaticMemory Management Oracle's Automated MemoryManagement (AMM) features were significantly enhanced in Oracle 11g. With AMM adatabase can automatically manage both the system global are...
-
编辑 删除
MSSQLSERVER2008
Msg 468, Level 16, State 9, Line 1Cannot resolve the collation conflict between "Chinese_PRC_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
-
编辑 删除
RM 刪除數據文件恢復操作
[oracle@ygzhou01 ygzhou01]$ rm -rf ygzhou01.dbf[oracle@ygzhou01 ygzhou01]$ ps -ef|grep dbw|grep -vgreporacle 6081 1 0Mar14 ? &nbs...
-
编辑 删除
CMMSG WHHMD DB PLAN
類別用途設備規格OS版本DB版本RAID需求可用空間邏輯磁盤數據文件分布HMD借用AGRA主DL580G5 /E7450 *4/4GB*8/72G SAS 10K*2+300G SAS 10K *5 /P400i 512MB/RPS/NC360Tlinux RedHat 5.5Ora...
-
编辑 删除
DB存儲規劃
DB 安裝需求類別用途設備規格OS版本DB版本RAID需求可用空間邏輯磁盤數據文件分布L6 SFC主DL580 G5 /Intel® Xeon® CPU E7450 @2.40GHz*24/4GB*8/72G SAS 15K*3+146G SAS 10...
-
编辑 删除
10g Release 2 Tablespace Point In Time Recovery – recover
RMAN> recover tablespace ygzhou until scn 2420448 auxiliary destination '/home/oracle/backup'; Starting recover at 15-MAR-12using channel ORA_DISK_1RMAN-05026: WARNING: presuming following set of...
-
编辑 删除
Create a trigger TO monitoring DDL
--1、CREATE TABLESPACE、USER AND GRANT ROLE TO USER-----------DROP TABLESPACE YGZHOU INCLUDING CONTENTS AND DATAFILES;CREATE TABLESPACE YGZHOU DATAFILE '/data1/stream/ygzhou01/datafile/ygzhou01.dbf' S...
-
编辑 删除
dbverify Utility
1、check datafile: https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=35512.1(1) SQL> show parameter db_block_size NAME &n...
