Archive for ‘Oracle’ Category
问题:一客户出现 oracle undo tablespace不断增长并无法回缩
解决方法:
1.新建一新的undo tablespace,如:undotbs2
2.alter system set undo_tablespace=undotbs2 scope=both;
3.drop tablespace undotbs1 including contents and datafiles;
但这是事后的解决方法,如何让 oracle 自动管理的undo tablespace自动收缩,如何合理的设置undo tablespace的大小,正在寻找答案中……
今天有一客户在编译一proc*c application时发生如下错误:
“libclntsh.so is up to date”
在metalink上查找该内容,解决方法如下:(Note:153677.1)
fact: Precompilers 8
fact: PRO*C
fact: Solaris Operating System (SPARC)
symptom: Building Pro*C application fails
symptom: ‘libclntsh.so’ is up to date
cause: You are missing the “build” target in the make command.
fix:Build your Pro*C application using the “build” target as
follows:
make -f demo_proc.mk build OBJS=progname.o EXE=progname(For c++ use the “cppbuild” target)
今天在自己电脑上手工启动listener时出现如下错误:
监听该对象时出错: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bright)(PORT=1521)))
TNS-12546: TNS: 拒绝许可
TNS-12560: TNS: 协议适配器错误
TNS-00516: 拒绝许可
32-bit Windows Error: 13: Permission denied
奇怪!以前都好好的,怎么会报这种错误?难道是权限不够?查看一下当前的用户,没问题呀,是管理员权限,而且也是ORA_DBA群组成员!难道是目录权限不够?一查看也没问题呀!那就奇怪了….难道是端口有冲突?赶紧执行:
C:\>netstatActive Connections Proto Local Address Foreign Address State
TCP bright:912 bright:1323 ESTABLISHED
TCP bright:912 bright:1331 ESTABLISHED
TCP bright:912 bright:1332 ESTABLISHED
TCP bright:1323 bright:912 ESTABLISHED
TCP bright:1331 bright:912 ESTABLISHED
TCP bright:1332 bright:912 ESTABLISHED
TCP bright:1521 baym-cs331.msgr.hotmail.com:1863 ESTABLISHED
TCP bright:2202 ip-32-1-168-192.rev.dyxnet.com:ftp CLOSE_WAIT
TCP bright:2207 ip-32-1-168-192.rev.dyxnet.com:ftp CLOSE_WAIT
TCP bright:2360 ip-32-1-168-192.rev.dyxnet.com:ftp CLOSE_WAIT
[...]