waterborn的专栏

数据库RAC NODE 常发生自我重启， 查看日志 /var/log/messages  Apr 12 13:00:39 ordb1 logger: Oracle clsomon failed with fatal status 13.  Apr 12 13:00:40 ordb1 logger: Oracle CRS failure. Rebooting for cluster integr...

JAVA应用层 Spring+iBatis+Proxool 访问ORACLE 11 RAC 每天总会有几个错误 ORA-17410: No more data to read from socket 查不到原因 :roll:

调整SGA , ORACLE 会爆ORA-00845  MEMORY_TARGET not supported on this system 错误   解决： 修改/dev/shm的大小可以通过修改/etc/fstab来实现、 tmpfs /dev/shm tmpfs defaults,size=10240M 0 0...

在 Oracle Enterprise Linux 和 iSCSI 上构建您自己的 Oracle RAC 集群 http://www.oracle.com/technology/global/cn/pub/articles/hunter_rac11gr1_iscsi_2.html   quickly install Oracle Database 11g Release 2 (11.2) o...

1. 查看DATA FILES 文件位置 select  * from dba_data_files   2.启动EM 控制台 emctl start dbconsoleemctl status agent   3.导入导出方案 nohup impdp system/******** DIRECTORY=dmp_dir DUMPFILE=full.dmp FULL=y   n...

1. 创建JOBbegin  sys.dbms_job.submit(job => :job,                      what => 'USER_ABC.PRC_SYNINFO;',                      next_date => to_date('12-02-2009 16:41:00', 'dd-mm-yyyy hh24:mi:ss')...

1. 查询磁盘读写IO比较大的SQL select a.INST_ID,       a.SQL_TEXT,       a.EXECUTIONS,       a.CPU_TIME,       a.ELAPSED_TIME,       trunc(a.ELAPSED_TIME / decode(a.EXECUTIONS, 0, 1, a.EXECUTIONS)),       a.DISK...