Archive for the ‘oracle’ Category

ASM的limits(留看)

星期四, 二月 23rd, 2012

ASM imposes the following limits:

63 disk groups in a storage system

10,000 ASM disks in a storage system

2 terabyte maximum storage for each ASM disk (the Bug 6453944 allowed larger sizes, but that led to problems, see Note 736891.1 “ORA-15196 WITH ASM DISKS LARGER THAN 2TB”)

40 exabyte maximum storage for each storage system

1 million files for each disk group

2.4 terabyte maximum storage for each file

X11TransSocketINETConnect() :can’t get address for localhost

星期一, 十一月 28th, 2011

用XMANAGER XSTART 连接LINUX服务器启用图形界面时,报错X11TransSocketINETConnect() :can’t get address for localhost,最终确认为
/etc/hosts文件缺少127.0.0.1地址,添加上就OK

ora-39095

星期一, 九月 6th, 2010

今天在导出数据文件的时候,倒着倒着就报错了
ORA-39095:Dump file space has been exhausted: Unable to allocate string bytes
Cause: The Export job ran out of dump file space before the job was completed.
Action: Reattach to the job and add additional dump files to the job restarting the job.

从报错的字面意思,一开始以为系统空间问题,但是空闲的空间还是很多的,根据提示增加了个dumpfile但是还是报错,后来查了下METALINK,可能是我的PARALLEL太高了。我从8改为4就好了。或者也可以通过增加DUMPFILE,也能解决问题。 dumpfile=hisdeliverxU%就OK。记录下

4个监听的问题

星期四, 八月 12th, 2010

今天启动一个测试库,发现连接不上客户端,一看4个监听,就想到之前看到过文章,说10.2.0.1上有这个问题,listener.ora加入以下参数解决
SUBSCRIBE_FOR_NODE_DOWN_EVENT_ =OFF 随便记录下,以备查找

impdp and optimizer_mode rule

星期五, 三月 12th, 2010
因为和应用有关,公司的工具一直用imp exp ,最近在客户那是用impdp导入数据的时候,无法导入,报如下错:
Impdp fails with the following errors:
UDI-00008: operation generated ORACLE error 31626
ORA-31626: job does not exist
ORA-06512: at "SYS.KUPC$QUE_INT", line 536
ORA-25254: time-out in LISTEN while waiting for a message
 
一开始怀疑,主表的问题,但是删除重新导入还是不行,最后确认是和数据库的优化模式有关,因为我们的应用,数据库的优化模式为
RULE,改为除RULE其他模式后,导入正常,文档: 577562.1有描述:
In a RAC database a full Data Pump export fails with:
 
ORA-39097: Data Pump job encountered unexpected error -1422
ORA-39065: unexpected master process exception in DISPATCH
ORA-01422: exact fetch returns more than requested number of rows
这个类似的错误也是这个原因引起的