ITPub博客

select 自定义类型(  a as b) from dual自定类型中不能使用 as

使用dblink的时候使用returning 不支持

ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes set   serveroutput   on   size   1000000  ;

trim()注意点：这个函数处理字符串的时候，如果字符串是小空，也就是空格的时候会返回 null而不是‘’ 

Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_smon_5686.trc:ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []ORACLE Instance orcl (pid = 8) - Error 600 encountered ...

ORA-00600: internal error code, arguments: [4137], [], [], [], [], [],[], []Oracle Note:47456.1:DESCRIPTION: While backing out an undo record (i.e. at the time ofrollback) we found a transaction id m...

ORA-00704: 引导程序进程失败ORA-00704: 引导程序进程失败ORA-00600: 内部错误代码, 参数: [4000], [12], [], [], [], [], [], []查询了该错误的问题:Oracle Note:47456.1:DESCRIPTION: This has the potential to b...

问题描述客服人员说数据库启动异常，报错说控制文件不一致。心想这个问题好解决只要找一个为基准，复制三个就可以了。但是使用三个控制文件为副本都不能启动数据库。1.控制文件check失败Errors in file /u01/app/o...

Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 10.2.0.4This problem can occur on any platform.SymptomsOn certain Windows client :connection using sqlplus giving the follow...

Martin Zahn, 27.02.2009 Overview Backup and recovery is one of the most important a...

rac环境中ifconfig -a看到 eth0:eth1：从失败节点failover过来的 eth0:0 ：自己vip用的/etc/sysconfig/network-scripts/etc/sysconfig/networking/devices中都没有相关的配置文件。ifconfig eth0...

rac节点删除olsnodes和crs_stat 都看不到被删除节点。但是 addNode.sh 中可以看到。从新执行 runInstaller.sh  + 一些参数成功执行 OK。再次运行 addNode.sh看不到原来的节点了。 ----按照手册执...

情况两个节点的环境。节点1损坏了。从新安装了节点1的操作系统。节点2可以正常使用。目标把节点1从新添加到rac环境中去。摄像做法1.删除残留信息[oracle@node2 bin]$ crs_stat -t名称    &nb...

If your system abruptly loses power, orif a RAID card is beginning to fail, you might see an ominous messagelike this within your logs:EXT3-fs error (device hda3) in start_transaction: Journ...

今天本来头让修改一下数据库的参数。发现不知道哪位大侠把参数文件都给删了。呵呵还好数据库是启动状态。于是create pfile from memory;create spfile from memory;...

sshd 启动失败。报错：sshd/var/empty/sshd not root and not root group *****不太记得了。/var/empty/sshd检查一下这个目录的权限应该是 root：root 如不是chown root：root  -R /var/empty重启sshd...

数据库自动关闭1.日志ORA-00600: internal error code, arguments: [6001], [0], [], [], [], [] , [], [] ORACLE Instance prod (pid = 7) - Error 600 encountered while recovering transaction (...

现象 :alert.log中有下面的警告信息Memory Notification: Library Cache Object loaded into SGAHeap size 2757K exceeds notification threshold (2048K)问题分析:Oracle10.2.0.1的Bug解决方法1:改此隐含参数SQL> a...

问题执行lsnrctl start报错TNS-12537: TNS:connection closed TNS-12560: TNS:protocol adapter error TNS-00507: Connection closed Linux Error: 29: Illegal seek解决办法1.查看/etc/hosts文件和listener.ora...

今天一个客户说crsd.log里报出的信息不知道怎么回事FI[vGA5r_02009-03-17 13:40:27.603: [  OCRUTL][31]u_freem: mem passed is nullITPUB个人空间L\|uU0JkA,X8TD2009-03-18 01:40:27.606: [  OCRUTL][36...