ORACLE问题汇总--持续更新中。。。

ORA-29807: specified operator does not exist


这是Oracle 的bug , 可以忽略掉，安装完成后，在$ORACLE_HOME/rdbms/admin 目录下运 
行utlrp.sql ，用于修补ORA-29807 错误。 
解释： 
ORA-29807: specified operator does not exist 
This is a known issue (bug 2925665). You can click on the "Ignore" button to continue. 
Once DBCA has completed database creation, remember to run the 'prvtxml.plb' script 
from $ORACLE_HOME/rdbms/admin independently, as the user SYS. It is also advised 
to run the 'utlrp.sql' script to ensure that there are no invalid objects in the database at this time. 
 

$ dbca
Fatal: Stack size too small. Use 'ulimit -s' to increase default stack size.
/u01/oracle/bin/dbca: line 124:  4692 Aborted                 $JRE_DIR/bin/jre -DORACLE_HOME=$OH -DJDBC_PROTOCOL=thin -mx64m -classpath $CLASSPATH oracle.sysman.assistants.dbca.Dbca $ARGUMENTS
解决： vi /u01/oracle/bin/dbca （增加红色字体部分）

123 $JRE_DIR/bin/jre -DORACLE_HOME=$OH -DJDBC_PROTOCOL=thin -mx64m -classpath $CLASSPATH oracle.sysma    n.assistants.dbca.Dbca $ARGUMENTS
124  ulimit -s
125 fi

 

  TNS-12537: TNS:connection closed
TNS-00507: Connection closed
Linux Error: 29: Illegal seek

http://space.itpub.net/35489/viewspace-84958

 

 

解决安装oracle 10g安装过程及isqlplus字体乱码问题：（此解决方法由长沙易剑原创，转载请注明出处）

#mkdir -P /usr/share/fonts/zh-CN/TrueType/

#cd /usr/share/fonts/zh-CN/TrueType/

#cp ../../Chinese/TureType/uming.ttf ./zysong.ttf

 

 

em乱码问题：

http://www.eygle.com/archives/2006/03/oracle10g_em_font_change.html