致远

Following error arose, check data tablespace, there's sufficent free space. There's high probability that this error is due to database unix box disk space. We know the nature of oracle temp tablespace that when space added to temp space it does not allocate physical space, take only when required . The temp mount point is of 15Gb and the tempfile created is of 40GB, So as 15GB size usage reached it throws an error of No space left on device . I guess if the temp space is small, oracle will try to overwrite the tempspace, if it's big, it will access the full space allocated initially.

when reach 15 if allocated 40, then oracle try to access more space and fail if no space left, but if alocated 15 and have only 15, then it will rewrite. delete the tempfiles, and recreate the tempfiles, allocating 15G to temp tablespace. Rerun application, it's fine this time.

转：http://www.channel7.cn/2004/10-18/01622.html 查看全文

1、一台IBM P670服务器AIX5.2机器名为lpar01，一台客户端SGI机器名IRIS

　　2、在P670上建nfsvg，大小450G，文件系统/nfsserver为400G；导出lpar01上的/nfsserver目录,导入到SGI客户端/data目录

　　3、权限为：读写

生产环境：
操作系统：RedHat AS3.0
数据库：Oracle 9.2.0.4 RAC
存储：普通阵列 查看全文

一.配置data guard

1.将Primary节点设为归档模式。
2.修改初始化文件,主备两节做相应的修改： 查看全文

花了一周时间在vmware GSX3.2上成功安装了10g rac 查看全文

ORA-00600 [2662]错误解决过程

转自：biti_rainy

http://biti_rainy.itpub.net/post/330/21314

exp和imp的实例供参考(转) 查看全文

通过rman把数据库复制到另一台机器

用test/test登录数据库，先模拟删除一些数据： 查看全文

上一次用带drop后缀的offline把数据文件离线了，提示要恢复。 查看全文

今天试验更改一个数据文件名，以为应该很顺利，谁知道，却颇费了些周折。 查看全文

最近学习RAC，一篇对理解概念很好的文章 查看全文

http://www.51cto.com/html/2005/0928/4007.htm 查看全文

http://oss.oracle.com/projects/ocfs/