-
编辑 删除
Oracle DBA 日常維護手冊
A. DAILY CHECKLIST1. FREE.SQL/* FORMATTED ON 2012/06/15 11:48 (FORMATTER PLUS V4.8.8) */SELECT TABLESPACE_NAME, SUM (BLOCKS) AS FREE_BLK, TRUNC (SUM (BYTES) / (...
-
编辑 删除
11.2.0.3 RAC 全过程--8.Oracle RAC ssh Configure
$ORACLE_HOME/oui/bin/runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES=RAC02" -local$ORA_CRS_HOME/bin/racgons remove_config RAC03:6200$ORA_CRS_HOME/bin/racgons remove_config...
-
编辑 删除
11.2.0.3 RAC 全过程--7.NTP Server
1.Have a Time server:10.203.94.101server 127.127.1.0preferfudge 127.127.1.0 stratum 11driftfile /var/lib/ntp/driftbroadcastdelay 0.008----ALL Node#vi /etc/ntp.confserver 10.203.94.101 pref...
-
编辑 删除
11.2.0.3 RAC 全过程--6.Configure ASM
1.Install oracleasm packages[root@swhygzhoudb01]#rpm -qa | grep oracleasmoracleasm-support-2.1.7-1.el5.i386.rpmoracleasm-2.6.18-164.el5-2.0.5-1.el5.i686.rpmoracleasmlib...
-
编辑 删除
11.2.0.3 RAC 全过程--5.Configure user equivalence .bash_pfile
grid:# .bash_profile# Get the aliases and functionsif [ -f ~/.bashrc ]; then . ~/.bashrc# User specific environment and startup programsPATH=$PATH:$HO...
-
编辑 删除
11.2.0.3 RAC 全过程--4.Create install directory
4.1:# groupadd oinstall# groupadd asmadmin# groupadd asmdba# groupadd asmoper# groupadd dba# groupadd oper#useradd -g oinstall ?G asmadmin,asmdba,asmoper grid#useradd -g oinstall -G dba, oper,...
-
编辑 删除
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.
