脚踏实地、勇往直前!
全部博文(1005)
发布时间:2017-07-03 19:56:45
环境:OS:CentOS 7DB:11.2.0.41.查看当前的asm磁盘[root@host01 bin]# oracleasm listdisksDATA1DATA2DATA3DATA4DATA5OCR1OCR2OCR3REDO1REDO22.查看ocr磁盘组[root@host01 bin]# ./crsctl query css votedisk## STATE File Universal Id .........【阅读全文】
发布时间:2014-06-05 21:42:41
系统内核[root@node3 oracleasm]# uname -aLinux node3 2.6.9-42.0.0.0.1.EL #1 Sun Oct 15 13:58:55 PDT 2006 i686 athlon i386 GNU/Linux安装ASM三个包:[root@node1 asmlib]# rpm -ivh oracleasm-support-2.1.7-1.el4.i386.rpm[root@node1 asmlib]# rpm -ivh oracleasm-2.6.9-42.0.2.EL-2.0.3-1.i686.rpm[ro.........【阅读全文】
发布时间:2014-05-28 11:26:52
场景:节点3的公共ip变更了,由原来的192.168.50.148 改成了192.168.50.167,rac修改配置如下:1. 修改每个节点的hosts文件修改前node1-> more /etc/hosts# Do not remove the following line, or various programs# that require network functionality will fail.127.0..........【阅读全文】
发布时间:2014-05-27 16:10:12
今天在执行一个存储过程的时候报如下的错误:SQlerrm:ORA-02069: global_names parameter must be set to TRUE for this operation存储过程里的代码是这样的INSERT INTO oss_ccm.oss_ai_send_number@oss139_9qi.localdomain t (orderid, usernumber, &nbs.........【阅读全文】