crr的问题小窝
crrok2002 · 2007-12-15
<< (转)数据库技巧:在Linux9上手动安装DB2
|
首 页
|
zz-linux tar命令 >>
oracle9i for linux2.6.9
2007-12-15
Tag:
数据库
版权声明
:转载时请以超链接形式标明文章原始出处和作者信息及
本声明
http://crrok2002.blogbus.com/logs/12090333.html
问题一:
[oracle@localhost ~]$ dbca
/home/oracle/jre/1.1.8/bin/../lib/i686/green_threads/libzip.so: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference (libzip.so)
Unable to initialize threads: cannot find class java/lang/Thread
Could not create Java VM
解决:linux的kernel版本是2.6,但是oracle9i并不支持,要把版本号改成2.4级别的
用oracle用户
#vi $HOME/.bash_profile
export LD_ASSUME_KERNEL=2.4.11
--------------------------------------------------------
问题二:
运行dbca后,能正常出现图形界面,然后可以选择创建数据库,但是最后一步莫名其妙的界面消失.在命令行出现如下错误:
/oracle/product/9.2.0/bin/dbca: line 124: 16472 Segmentation fault $JRE_DIR/
bin/jre
-DORACLE
_HOME=$OH -DJDBC_PROTOCOL=thin -mx64m -classpath $CLASSPATH
oracle.sysman.assistants.dbca.Dbca $ARGUMENTS
解决:
使用oracle用户,
$ vi $ORACLE_HOME/bin/dbca
将下面列出的除第3 行外的其余行注释掉.
#if [ -f /etc/rac_on ]; then
#Run DBCA
$JRE_DIR/bin/jre -native -DORACLE_HOME=$OH...... //保留这一行
#else
#Run DBCA
#$JRE_DIR/bin/jre -DORACLE_HOME=$OH......
#fi
--------------------------------------------------------
问题三:
在运行了dbca,安装database到13%的时候遇到"ORA-29807:specified operator does not exist"
解决:这是Oracle 的bug , 可以忽略掉,安装完成后,在$ORACLE_HOME/rdbms/admin 目录下运
行utlrp.sql ,用于修补ORA-29807 错误。
解释:
This is a known issue (bug 2925665).
This workaround can be implemented either before invoking the DBCA or after the ORA-29807 has been encountered.
1. Go to the script catxml.sql and comment out the line which will run prvtxml.plb
2a. If the script has been edited before invoking DBCA, it is now safe to proceed with invoking DBCA
OR
2b. If the script has been edited after the ORA-29807 is encountered, go back to your DBCA screen and click 'Ignore'
3. The database creation using DBCA should now proceed without additional errors.
4. Once DBCA has completed database creation, remember to run the 'prvtxml.plb' script independently, as the user SYS.
5. Check whether there are invalid objects:
select * from dba_objects where owner = 'SYS' and status = 'INVALID' ;If so, run the 'utlrp.sql' script to validate those objects.You can click on the "Ignore" button to continue.
--------------------------------------------------------------
问题四:
运行dbca到快一半的时候,出现这个问题 ORA-01430: column being added already exists in table
解决:在网上查了一圈,说是redhat的 可以不予理会,just ignore it!
随机文章:
(转)数据库技巧:在Linux9上手动安装DB2
2007-10-25
转DB2学习笔记
2007-10-23
卸载oracle
2007-10-22
关于约束
2007-08-28
必须要熟悉的V$视图
2007-08-22
收藏到:
Del.icio.us
引用地址:
crrok2002
发表于
14:24:38
|
编辑
|
继续话题
|
转发
|
推荐
发表评论
原始快照:web.archive.org