Oracle
jack2tom
这个作者很懒,什么都没留下…
展开
-
oracle locks query
SELECT b.session_id AS sid,NVL(b.oracle_username, ‘(oracle)’) AS username,a.owner AS object_owner,a.object_name,Decode(b.locked_mode, 0, ‘None’,1, ‘Null (NULL)’,2, ‘Row-S (SS)’,3, ‘Row-X原创 2014-01-05 11:09:49 · 708 阅读 · 0 评论 -
oa数据库rman备份
- newoa服务器: IBM X3650 M4服务器上的oracle备份 –– 由于oa数据库很小, 0级增量备份, 即全备[oracle@newoa ~]# vim /oracle/backup/bin/hot_database_backup#!/bin/env sh## Make Full database backup (incremental level 0)原创 2014-01-05 11:12:06 · 739 阅读 · 0 评论 -
linux下快速删除oracle
-- oracle uninstall ---- ORACLE_BASE is /u01/app/oracle --1. shutdown database2. rm -rf /u01/*3. rm -rf /etc/oratab rm -rf /etc/oraInst.loc rm -rf /usr/local/bin/dbhome rm -rf /u原创 2014-01-05 11:06:23 · 876 阅读 · 0 评论 -
oracle数据库中的一些name的说明
SQL> show parameter nameNAME TYPE VALUE------------------------------------ ----------- ------------------------------db_name原创 2014-01-05 13:47:42 · 653 阅读 · 0 评论 -
oracle database 12.1.0.1 on centos_6.4_x64 silent installation
oracle database 12.1.0.1 on centos_6.4_x64 installation1. /etc/hosts192.168.16.203 hadoop3 2. 检查系统需求物理内存大小: grep MemTotal /proc/meminfo交换分区大小: grep SwapTotal /proc/meminfo/tmp目录大小: df原创 2014-02-15 14:30:20 · 921 阅读 · 0 评论 -
centos 6.5_x64上静默模式安装oracle 11.2.0.1
centos 6.5_x64上静默模式安装oracle 11.2.0.1原创 2014-01-05 10:57:05 · 1954 阅读 · 0 评论 -
告警日志提示FAST_START_MTTR_TARGET过低问题
查看告警日志,发现有提示FAST_START_MTTR_TARGET过低问题如下:Fri Jan 06 09:10:40 2017Archived Log entry 216246 added for thread 1 sequence 108168 ID 0xa33043e3 dest 1:Fri Jan 06 09:10:42 2017LNS: Standby re原创 2017-01-06 10:12:09 · 1379 阅读 · 0 评论