ITPub博客

又是为了方便识别自己登录到的是哪个数据库，尤其是一个库多个实例的情况下。会在原本只有 SQL > 提示的提示符设置出显示，是哪个用户登录到哪个实例。编辑：ORACLE_HOME/sqlplus/admin目录下的glogin.sql文件，在最后加如下一行，就可以为所有SQL*Plus会话自动设置SQL提示符.set sqlprompt _user'@'_connect_...

author: zhanglintime   : 2014.11.04环境：    os : redhat 6.1 oracle:10.2.0.1启动数据库实例linke的时候报错：[oracle@zhanglin dbs]$ export ORACLE_SID=linke[oracle@zhanglin dbs]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Tue Nov 4 03:58:33 2...

Oracle 低版本导入高版本按用户方案expdp/impdp

ORA-00001: 违反唯一约束条件 (.)ORA-00017: 请求会话以设置跟踪事件ORA-00018: 超出最大会话数ORA-00019: 超出最大会话许可数ORA-00020: 超出最大进程数 ()ORA-00021: 会话附属于其它某些进程；无法转换会话ORA-00022: 无效的会话 ID；访问被拒绝ORA-00023: 会话引用进程私用内存；无法分离会话ORA-00024: 单一...

IMP/IMPDP导入常见的几个报错ORA-31684、ORA-39111、ORA-39083

RMAN 备份片backup copies 和通道CHANNEL

ORA-06512: at "SYS.KUPV$FT_INT", line 600ORA-04063: package body "SYS.KUPC$QUE_INT" has errorsORA-06508: PL/SQL: could not find program unit being called: "SYS.KUPC$QUE_INT"

SQL> alter database add logfile group 2 ('/u01/app/oracle/oradata/VIPBIEDW/redo02a.log','/u01/app/oracle/oradata/VIPBIEDW/redo02b.log') size 1G*ERROR at line 1:ORA-19502: write error on file "/u01/app/oracle/oradata/VIPBIEDW/redo02a.log", block number 2050049 (block size=512)ORA-27072: File I/O ...

WARNING: Heavy swapping observed on system in last 5 mins.pct of memory swapped in [35.11%] pct of memory swapped out [8.77%].

/dev/shm目录下产生大量的ora_$ORACLE_SID的二进制文件

Oracle ASM磁盘组常用操作命令。ams磁盘查看

expdp 全库导入

SQL优化性能，SQL调优

2014.12.01当oracle在非归档情况运行时，又需要备份数据库，那么exp/expdp作为导出，imp/impdp作为导入时不错的选择。下面是一个简单的全库导出的脚本[oracle@BIDB scripts]$ cat full_bak.sh #!/bin/bash. /home/oracle/.bash_profilecd /orabak/dbbakecho "##############################################...

RMAN-00554: initialization of internal recovery manager package failed

改造DISTINCT物化视图包含DISTINCT的物化视图无法快速刷新，但是有些情况可以转化为可快速刷新的物化视图。一.SELECT语句中的DISTINCT操作。其实这种情况最简单，因为如果只是包含一个DISTINCT操作，那么完全可以转...

Current Oracle Cluster Registry location '+CRS' in '/etc/oracle/ocr.loc' and '/dev/raw/raw1' does not matchUpdate either '/etc/oracle/ocr.loc' to use '/dev/raw/raw1' or variable CRS_OCR_LOCATIONS in rootconfig.sh with '+CRS' then rerun rootconfig.sh

ORA-00020: maximum number of processes (150) exceeded

oracle 10g 安装gc:OPMN Process Manager failed to start和OUI - 25031

ORA-01012: not logged on