ITPub博客

windows + VMWARE +oracle 10G rac +asm1.安装vmware: 创建共享磁盘:scsi1:1 rac.vmx中增加 disk.locking="FALSE" scsi1:sharedBus="VIRTUAL"设置/etc/udev/rules.d/60-raw.rules增加ACTION=="add",KERNEL=="sdc1",RUN+="/bin/raw /dev/raw/raw1 %N"ACTION=="add",KERNEL=="sdc2",RUN+="/bin/raw /dev/raw/raw2 %N"ACTION=="add",KERNEL=="raw[1-2]", OWNER="oracle", GROUP="dba", MODE="660"/

windows + VMWARE +oracle 10G rac +asm1.安装vmware:创建共享磁盘:scsi1:1rac.vmx中增加disk.locking="FALSE"scsi1:sharedBus="VIRTUAL"设置/etc/udev/rules.d/60-raw.rules增加ACTION=="add",KERNEL=="sdc1",RUN+="/bin/raw /dev/raw/raw1 %N"ACTION=="add",KERNEL=="sdc2",RUN+="/bin/raw /dev/raw/raw2 %N"ACTION=="add",KERNEL=="raw[1-2]", OWNER="oracle", GROUP="dba", MODE="660"/etc/sysc

windows + VMWARE +oracle 10G rac +asm1.安装vmware: 创建共享磁盘:scsi1:1 rac.vmx中增加 disk.locking="FALSE" scsi1:sharedBus="VIRTUAL"设置/etc/udev/rules.d/60-raw.rules增加ACTION=="add",KERNEL=="sdc1",RUN+="/bin/raw /dev/raw/raw1 %N"ACTION=="add",KERNEL=="sdc2",RUN+="/bin/raw /dev/raw/raw2 %N"ACTION=="add",KERNEL=="raw[1-2]", OWNER="oracle", GROUP="dba", MODE="660"/

lvcreate -L 8G -nLogVol06 VolGroup00lvcreate -L 8G -nLogVol07 VolGroup00lvcreate -L 8G -nLogVol08 VolGroup00lvcreate -L 8G -nLogVol09 VolGroup00lvcreate -L 8G -nLogVol10 VolGroup00lvcreate -L 8G -nLogVol11 VolGroup00lvcreate -L 8G -nLogVol12 VolGroup00lvcreate -L 8G -nLogVol13 VolGroup00/etc/init.d/oracleasm createdisk VOL1 /dev/mapper/VolGroup00-LogVol06/etc/init.d/oracleasm createdisk VOL2 /dev/mapper/VolGroup00-LogVol07/etc/init.d/oracleasm createdisk VOL3 /dev/mapper/VolGroup00-LogVol08/etc/

oracle中增加全局环境变量配置在oracle的.profile或者.bash_profile中增加SQLPATH=$ORACLE_HOMEexport SQLPATH保存退出后编辑$ORACLE_HOME/login.sqlset lines 160set pages 80set timing onset time offset termout onset trimout ONset trimspool Onset serveroutput on size 100000 format wrappedset long 5000-- define gname=idle-- column global_name new_value gname for a40-- SELECT lower(USER) || '@' ||upper(instance_name)||'('||nvl(UTL_INADDR.GET_HOST_ADDRESS, SYS_CONTEXT('userenv', 'ip_address'))||')' GLOBAL_NA

@?/rdbms/admin/utlxplan create public synonym plan_table for plan_table; grant all on plan_table to public; @?/sqlplus/admin/plustrce.sql grant plustrace to public; #测试过程connect /as sysdba;select username,created from dba_users order by 2;connect USERNAME/PASSWORDset autotrace traceonly;如果出现 SQL> set autotrace traceonly;SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabledSP2-0611: Error enabling STATISTICS report的提示,执行:connect /as sysdba;grant select any

select user_mobile, count(*) from t_query_log where application ='wap' andquery_time >= to_date(to_char(trunc(sysdate-7),'yyyy-mm-dd')||' 18:00:00','yyyy-mm-dd hh24:mi:ss') and query_time <= to_date(to_char(trunc(sysdate),'yyyy-mm-dd')||' 18:00:00','yyyy-mm-dd hh24:mi:ss')[@more@]

reference:http://blog.chinaunix.net/u/11765/showart_471903.html===================1.创建表，通过utlxplan脚本 SQL> @?/rdbms/admin/utlxplanTable created. 2. 创建同义词为了多个用户可以共享一个plan_table 并授权给public SQL> create public synonym plan_table for plan_table;Synonym created.SQL> grant all on plan_table to public;Grant succeeded. 3.创建plustrace 角色 SQL> @?/sqlplus/admin/plustrce.sql 执行这个脚本就可以了。SQL> drop role plustrace;drop role plustrace *ERROR at l

#.profileORACLE_HOME=/home/ora10/product/10.2.0/client;export ORACLE_HOMEORACLE_SID=ECOM;export ORACLE_SIDLD_LIBRARY_PATH=/usr/lib:$ORACLE_HOME/lib;export LD_LIBRARY_PATHLANG=zh_CN.GBK;export LANGNLS_LANG=american_america.ZHS16GBK;export NLS_LANGPATH=$PATH:$ORACLE_HOME/bin;export PATH#response_client.rspRESPONSEFILE_VERSION=2.2.1.0.0UNIX_GROUP_NAME=dbaFROM_LOCATION="../stage/products.xml"NEXT_SESSION_RESPONSE=<Value Unspecified>ORACLE_HOME="/home/ora10/product/10.2.0/client&

create tablespace test datafile '+XXXX' size 3M autoextent on next 50M maxsize 8000M extent management local uniform;alter tablespace test add datafile '+XXX' size 3M autoextent on next 50M maxsize 8000M ;drop tablespace test including contents and datafiles;[@more@]

Linux下的Oracle9i data guard配置过程[@more@]# CONFIGURE STANDBY DATABASEsqlplus /nologset lines 160col PARAMETER for a50col VALUE for a80col name for a40connect / as sysdba;# 启动主库导归档模式startup mount;archive log list;archive log start;alter database Archivelog; alter database force logging; alter database open;# Enable Archiving and Define a Local Archiving Destination ! mkdir -p /export/home/oracle/admin/ECOM/adump/ecom# Create a Control File for the Standby Databasealter database create

select job,last_date,last_sec,next_date,next_sec,broken,failures from user_jobs; 启动:exec dbms_job.run(1);删除:exec dbms_job.remove(1);停止:exec dbms_job.broken(1,false);[@more@]select job,last_date,last_sec,next_date,next_sec,broken,failures from user_jobs; 启动:exec dbms_job.run(1);删除:exec dbms_job.remove(1);停止:exec dbms_job.broken(1,false);

oracle redo 日志删除后的恢复[@more@]startup nomount;alter database mount;/export/home/oracle/9i/dbs/pfileECOM.ora*._ALLOW_RESETLOGS_CORRUPTION='TRUE'*.undo_management='manual'startup mount pfile='/export/home/oracle/9i/dbs/pfileECOM.ora';# 查看实例状态select status from v$instance;alter database open;# 手工切换日志alter system switch logfile; # 查看当前日志select * from v$log; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIV STATUS FIRST_CHANGE# FIRST_TIM---

oracle_redo*log,被移动后的恢复[@more@]startup nomount;alter database mount;or/export/home/oracle/9i/dbs/pfileECOM.ora*._ALLOW_RESETLOGS_CORRUPTION='TRUE'*.undo_management='manual'startup mount pfile='/export/home/oracle/9i/dbs/pfileECOM.ora';# 手工切换日志alter database open;alter system switch logfile; alter database clear unarchived logfile group 3 ;alter database clear unarchived logfile group 2 unrecoverable datafile;recover database using backup controlfile until cancel;alter database open

oracle记录[@more@]orassh -P -g -f tomcat@61.242.223.36 -L 8080:61.242.223.36:8080 sleep 7200kill -9 `ps -ef|grep "LOCAL=NO" |grep -v grep |awk '{print $2}'` 删除重复的记录delete from heroinfo a where a.rowid!=(select max(rowid) from heroinfo b where a.fxno=b.fxno and b.fxno=a.fxno ); 后台进程的SPIDSELECT s.SID SID, p.spid threadid, p.program processname, bg.NAME NAME FROM v$process p, v$session s, v$bgprocess bg WHERE p.addr = s.paddr AND p.addr = bg.paddr AND bg.paddr <> '00';

#!/usr/bin/sh# ding yi huan jing bian liang DATE=`date +%w`DIR="/export/home/ORA_BAK"BAK_CONF="${DIR}/bin"RBAK_HOME="/manager/oracle/ORA_BAK"export DATE DIR BAK_HOME# export oracle dump file dumpdb(){cd $DIR/DATA$ORACLE_HOME/bin/exp $1/$1@$2 file=$1_$DATE.dmp log=$1_$DATE.log compress=n}zip(){cd $DIR/DATAif [ -f ${DIR}/DATA/$1_$DATE.dmp ] ; then echo "$1 dmp is dump ... now compress ..." rm -rf $DIR/DATA/$1_$DATE.dmp.Z compress $1_$DATE.dmp echo &q

#!/bin/sh# DATE=`date +%w`DIR="/export/home/oracle/ORA_BAK"BAK_CONF="${DIR}/bin"RBAK_HOME="/backup/orabackup"export DATE DIR BAK_HOME# export oracle dump file dumpdb(){cd $DIR/DATA$ORACLE_HOME/bin/exp $1/$2@$3 file=$1_$DATE.dmp log=$1_$DATE.log # compress=n}zip(){cd $DIR/DATAif [ -f ${DIR}/DATA/$1_$DATE.dmp ] ; then echo "$1 dmp is dump ... now compress ..." rm -rf $DIR/DATA/$1_$DATE.dmp.Z compress $1_$DATE.dmp echo "database dmp compress OK..

#!/bin/shsqlplus $1/$2@$3 <<EOFset feed offset lines 130set pagesize 999col TS_name format a13col TS_place format a48spool $4.txtselect b.file_id ID,b.FILE_NAME TS_place,b.tablespace_name TS_name,b.bytes BYTES,b.MAXBYTES,(b.bytes-sum(nvl(a.bytes,0))) USED,sum(nvl(a.bytes,0)) surplus,sum(nvl(a.bytes,0))/(b.bytes)*100 surplus_prefrom dba_free_space a,dba_data_files bwhere a.file_id=b.file_idgroup by b.tablespace_name,b.file_id,b.bytes,b.FILE_NAME,b.MAXBYTES order by b.file_id;spool offexitEO

startup mount ;select name from v$datafile;select tablespace_name from dba_tablespaces; [@more@]startup mount ;select name from v$datafile;select tablespace_name from dba_tablespaces; alter database datafile '/export/home/oracle/oradata/ECOM/undotbs01.dbf' offline drop; alter tablespace UNDOTBS1 add datafile '/export/home/oracle/oradata/ECOM/undotbs02.dbf' size 200M;# create undo tablespace undotbs2 datafile '/export/home/oracle/oradata/ECOM/undotbs02.dbf' size 200m;ALTER SYSTEM SET undo_tablesp

RMAN简单使用目标机A:create tablespace RMAN datafile '$ORACLE_HOME/oradata/FILENAME.DBF' size 20M;[@more@]RMAN简单使用目标机A:create tablespace RMAN datafile '$ORACLE_HOME/oradata/FILENAME.DBF' size 20M;create username RMAN identified by RMAN default tablespace rman temporary tablespace temp quota unlimited on RMAN;grant recovery_catalog_owner to rman ; rman catalog rman/rmancreate catalog tablespace 'RMAN';Rman主机B:rman target /connect catalog rman/rman@$A_SID注册数据库register database;注销数据