-
编辑 删除
rman恢复部分表空间
SQL> conn / as sysdbaConnected.SQL> select name from v$datafile;NAME--------------------------------------------------------------------------------/u01/oracle/oradata/orcl/system01.dbf/u01/oracle/oradata/orcl/sysaux01.dbf/u01/oracle/oradata/orcl/undotbs01.dbf/u...
-
编辑 删除
ORA-07445处理分析 关闭自动化任务
1 告警日志内容：[oracle@CnXzBus01POraclL01 ~]$ tail -1000f /opt/app/oracle/diag/rdbms/kcpt/kcpt/trace/alert_kcpt.log | grep -A 2 -B 2 "07445"Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x8] [PC:0x21607D1, apaneg()+227] [flags: 0x0, ...
-
编辑 删除
ORA-12514: TNS:listener does not currently know of service requested in connect
[oracle@kcpttest ~]$ sqlplus scott/tiger@192.168.2.227:1521/kcptdg1SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 6 15:52:48 2016Copyright (c) 1982, 2013, Oracle. All rights reserved.ERROR:ORA-12514: TNS:listener does not currently know of service reques...
-
编辑 删除
表数据被误操作的恢复
SQL> conn scott/tigerConnected.SQL> SQL> SQL> SQL> select * from tab;TNAME TABTYPE CLUSTERID------------------------------ ------- ----------BONUS ...
-
编辑 删除
ldap安装
ldap master server192.168.56.99ldap master slave192.168.56.97ldap client192.168.56.98####server端配置###添加域名[root@localhost ~]# vi /etc/hosts# Do not remove the following line, or various programs# that require network functionality will fail...
-
编辑 删除
查询当前执行的sql及相关内容
10G--10g及以后版本select distinct b.SID,b.SERIAL#,p.SPID,b.LAST_CALL_ET,a.sql_id, a.sql_text,b.status,b.event,b.MODULE, b.OSUSER,b.MACHINE from v$sql a,v$session b,v$process p where a.SQL_ID=b.SQL_ID and b.PADDR=p.ADDR and b.STATUS='ACTIVE' order by B.LAST_CALL_ET desc;--9i及以后版本s...
-
编辑 删除
windows 常用命令行命令
CMD命令：开始－>运行－>键入cmd或command（在命令行里可以看到系统版本、文件系统版本）chcp 修改默认字符集chcp 936默认中文chcp 650011. appwiz.cpl：程序和功能 2. calc：启动计算器 5. chkdsk.exe：Chkdsk磁盘检查（管理员身份运行命令提示符） 6. cleanmgr: ...
-
编辑 删除
oracle表空间查询
set linesize 300set pagesize 10000col TABLESPACE_NAME for a30;col PCT_FREE for a20;col PCT_USED for a20;col USED_MAX% for a20select a.tablespace_name, round(a.bytes_alloc / 1024 / 1024, 2) megs_alloc, ...
-
编辑 删除
oracle单机静默安装脚本oracleAutoInstall.sh
注：脚本只在redhat和CentOS上面验证过，其他系统没有验证，安装包为11.0.2.0.4，其他安装包需要修改脚本。#!/bin/bash#by ray suen#v0.7##################################################################################before the bash you must install necessary rpm for oracle and edit hos...
-
编辑 删除
添加监听密码
LSNRCTL> change_password Old password: New password: Reenter new password: Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test)(PORT=1521)))Password changed for LISTENERThe command completed successfullyLSNRCTL> set passwordPassword:&nb...
-
编辑 删除
DG 添加修改redo日志组大小
注意：log_file_name_convert如果不配置,将导致备库redo 文件不能被删除检查主备库状态主库：select SEQUENCE#,first_time,next_time,APPLIED, THREAD# from v$archived_log order by SEQUENCE#,THREAD#; 49 31-MAR-16 &n...
-
编辑 删除
更改字符集
1.更改数据库字符集为GBKSHUTDOWN IMMEDIATE; STARTUP MOUNT EXCLUSIVE; ALTER SYSTEM ENABLE RESTRICTED SESSION; ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; ALTER SYSTEM SET AQ_TM_PROCESSES=0; ALTER DATABASE OPEN; ALTER DATABASE NATIONAL CHARACTER...
-
编辑 删除
dg搭建 单点-单点
SQL> select log_mode from v$database;LOG_MODE------------ARCHIVELOGSQL> select force_logging from v$database;FOR---NOSQL> alter database force logging;Database altered.SQL> select force_logging,log_mode from v$database;FOR LOG_MOD...
-
编辑 删除
multipath多路径配置
[root@localhost ~]# rpm -qa | grep device-mapperdevice-mapper-1.02.95-3.el6_7.3.x86_64device-mapper-multipath-0.4.9-87.el6.x86_64[root@localhost ~]# vi /etc/multipath.confdefaults {user_friendly_names yesudev_dir /devpath_grouping_policy...
-
编辑 删除
oracle 11G RAC 安装前准备和注意事项
VBoxManage createhd --filename /Volumes/mechine/VMware/virtualBox/11gsharestorage/asm1.vdi --size 2048 --format VDI --variant Fixed VBoxManage createhd --filename /Volumes/mechine/VMware/virtualBox/11gsharestorage/data1.vdi --size 40960 --format VDI --variant Fixed ...
-
编辑 删除
rman备份脚本 发送邮件通知
脚本大部分内容载录网上，本人仅添加邮件发送内容。邮件使用sendEmail包实现，需要自己单独安装。然后再次封装。#!/bin/bash#use Oracle Env.source ~/.bash_profile#Def backupdirdirname=`date "+%Y-%U"`lastweek=`date -d "-3 week" +%Y-%U`backup...
-
编辑 删除
数据库的常规检查脚本
SET MARKUP HTML ON SPOOL ON pre off entmap off;set feedback off;set termout off;set echo off;set verify off;set wrap on;set trimspool ...
-
编辑 删除
oracle获取ddl脚本
#!/bin/bash# author by ray# v6source ~/.bash_profileexport NLS_LANG=AMERICAN_AMERICA.ZHS16GBKoraname=****#定义获取ddl的函数getOracleTableDDL(){ userpass=$1 tname=$2 sqlplus...
-
编辑 删除
自动备份、截断分区表分区数据
#!/bin/bash# by ray# 2016-06-08. ~/.bash_profileexport NLS_LANG="AMERICAN_AMERICA.ZHS16GBK"todayUtc=`date +%s000` #获取毫秒的utc时间tdate=`date +%F-%H%M%S` #获取当前时间days=185 #指定向前的天数，以获取保留的分区数truncdir=/tm...
-
编辑 删除
kill执行时间较长的会话
#!/bin/bash# by ray# 2016-06-16ksfile=/tmp/.kill_session.tmp #kill session 的文件路径killSqlFile=/tmp/.kill_session_temptablespace_highparallel.sql #kill脚本的路径 killSqlHisFile=/home/oracle/shell/killSqlHisInfo.txt #被kill的会话信息oraUser=****** #oracle的用户名...
