- 浏览: 981775 次
- 性别:
- 来自: 杭州
文章分类
最新评论
-
孤星119:
好熟悉的数据库字段啊, 上家公司做的项目每天都跟这些字段打招呼 ...
Oracle exp compress参数引起的空间浪费 -
itspace:
quxiaoyong 写道遇到个问题,网上一搜,全他妈这篇文章 ...
数据库连接错误ORA-28547 -
quxiaoyong:
遇到个问题,网上一搜,全他妈这篇文章。你转来转去的有意思吗?
数据库连接错误ORA-28547 -
hctech:
关于version count过高的问题,不知博主是否看过ey ...
某客户数据库性能诊断报告 -
itspace:
invalid 写道写的不错,我根据这个来安装,有点理解错误了 ...
AIX 配置vncserver
操作系统版本为
在Oracle 9.2.0.4升级至9.2.0.6时报如下错误:
但升级至9.2.0.8没有任何问题,估计是Oracle patch一bug,在9.2.0.8上解决了。
引用
[oracle@zhoul oracle]$ uname -a
Linux zhoul 2.6.18-164.el5 #1 SMP Tue Aug 18 15:51:54 EDT 2009 i686 i686 i386 GNU/Linux
Linux zhoul 2.6.18-164.el5 #1 SMP Tue Aug 18 15:51:54 EDT 2009 i686 i686 i386 GNU/Linux
在Oracle 9.2.0.4升级至9.2.0.6时报如下错误:
引用
- Linking Oracle
rm -f /oracle/app/product/9.2/db_1/rdbms/lib/oracle
gcc -o /oracle/app/product/9.2/db_1/rdbms/lib/oracle -L/oracle/app/product/9.2/db_1/rdbms/lib/ -L/oracle/app/product/9.2/db_1/lib/ -L/oracle/app/product/9.2/db_1/lib/stubs/ -Wl,-E `test -f /oracle/app/product/9.2/db_1/rdbms/lib/skgaioi.o && echo /oracle/app/product/9.2/db_1/rdbms/lib/skgaioi.o` /oracle/app/product/9.2/db_1/rdbms/lib/opimai.o /oracle/app/product/9.2/db_1/rdbms/lib/ssoraed.o /oracle/app/product/9.2/db_1/rdbms/lib/ttcsoi.o /oracle/app/product/9.2/db_1/lib/nautab.o /oracle/app/product/9.2/db_1/lib/naeet.o /oracle/app/product/9.2/db_1/lib/naect.o /oracle/app/product/9.2/db_1/lib/naedhs.o /oracle/app/product/9.2/db_1/rdbms/lib/config.o -lserver9 -lodm9 -lskgxp9 -lskgxn9 -lclient9 -lvsn9 -lwtcserver9 -lcommon9 -lgeneric9 /oracle/app/product/9.2/db_1/rdbms/lib/defopt.o -lknlopt `if /usr/bin/ar tv /oracle/app/product/9.2/db_1/rdbms/lib/libknlopt.a | grep xsyeolap.o > /dev/null 2>&1 ; then echo "-loraolap9" ; fi` -lslax9 -lpls9 -lplp9 -lserver9 -lclient9 -lvsn9 -lwtcserver9 -lcommon9 -lgeneric9 -lknlopt -lslax9 -lpls9 -lplp9 -ljox9 -lserver9 -locijdbcst9 -lwwg9 `cat /oracle/app/product/9.2/db_1/lib/ldflags` -lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lnro9 `cat /oracle/app/product/9.2/db_1/lib/ldflags` -lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lmm -lnls9 -lcore9 -lnls9 -lcore9 -lnls9 -lxml9 -lcore9 -lunls9 -lnls9 `cat /oracle/app/product/9.2/db_1/lib/ldflags` -lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lnro9 `cat /oracle/app/product/9.2/db_1/lib/ldflags` -lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -ltrace9 -lnls9 -lcore9 -lnls9 -lcore9 -lnls9 -lxml9 -lcore9 -lunls9 -lnls9 `if /usr/bin/ar tv /oracle/app/product/9.2/db_1/rdbms/lib/libknlopt.a | grep "kxmnsd.o" > /dev/null 2>&1 ; then echo " " ; else echo "-lordsdo9"; fi` -lctxc9 -lctx9 -lzx9 -lgx9 -lctx9 -lzx9 -lgx9 -lordimt9 -lnls9 -lcore9 -lnls9 -lcore9 -lnls9 -lxml9 -lcore9 -lunls9 -lnls9 -lsnls9 -lunls9 -lxsd9 -lnls9 -lcore9 -lnls9 -lcore9 -lnls9 -lxml9 -lcore9 -lunls9 -lnls9 `cat /oracle/app/product/9.2/db_1/lib/sysliblist` -Wl,-rpath,/oracle/app/product/9.2/db_1/lib:/lib:/usr/lib -lm `cat /oracle/app/product/9.2/db_1/lib/sysliblist` -ldl -lm `test -f /oracle/app/product/9.2/db_1/rdbms/lib/skgaioi.o && echo -laio`
/oracle/app/product/9.2/db_1/lib//libserver9.a(krd.o): In function `krda1fbuf':
krd.c:(.text+0xcc92): undefined reference to `skgmmap_ro'
/oracle/app/product/9.2/db_1/lib//libserver9.a(kse.o): In function `ksepop':
kse.c:(.text+0x498): undefined reference to `kgeclrsta'
kse.c:(.text+0x4a3): undefined reference to `kgechksta'
kse.c:(.text+0x4b6): undefined reference to `kgesetsta'
kse.c:(.text+0x4c7): undefined reference to `kgeclrsta'
/oracle/app/product/9.2/db_1/lib//libserver9.a(ksm.o): In function `ksmdmp_tpga':
ksm.c:(.text+0x1858): undefined reference to `kghdmp_new'
ksm.c:(.text+0x187e): undefined reference to `kghdmp_new'
ksm.c:(.text+0x1898): undefined reference to `kghdmp_new'
/oracle/app/product/9.2/db_1/lib//libserver9.a(ksm.o): In function `ksm_dump_sga_heap':
ksm.c:(.text+0x4998): undefined reference to `kghdmp_new'
/oracle/app/product/9.2/db_1/lib//libserver9.a(ksm.o): In function `ksm_4031_dump':
ksm.c:(.text+0x4b9f): undefined reference to `kghdsdump'
ksm.c:(.text+0x4bdb): undefined reference to `kghdsdump'
ksm.c:(.text+0x5168): undefined reference to `kghdsdump'
/oracle/app/product/9.2/db_1/lib//libserver9.a(ksm.o): In function `ksmhdm':
ksm.c:(.text+0x8769): undefined reference to `kghdmp_new'
ksm.c:(.text+0x87ac): undefined reference to `kghdmp_new'
ksm.c:(.text+0x8809): undefined reference to `kghdmp_new'
ksm.c:(.text+0x884d): undefined reference to `kghdmp_new'
ksm.c:(.text+0x8888): undefined reference to `kghdmp_new'
/oracle/app/product/9.2/db_1/lib//libserver9.a(qm.o): In function `qm_initDirs':
qm.c:(.text+0x1a40): undefined reference to `qmxSetData0'
qm.c:(.text+0x1ad1): undefined reference to `qmxSetData0'
qm.c:(.text+0x1b62): undefined reference to `qmxSetData0'
qm.c:(.text+0x1bf3): undefined reference to `qmxSetData0'
qm.c:(.text+0x1c7f): undefined reference to `qmxSetData0'
/oracle/app/product/9.2/db_1/lib//libserver9.a(qm.o):qm.c:(.text+0x1d1f): more undefined references to `qmxSetData0' follow
/oracle/app/product/9.2/db_1/lib//libserver9.a(kcl.o): In function `kclpto':
kcl.c:(.text+0x17a7): undefined reference to `skgmmap_ro'
/oracle/app/product/9.2/db_1/lib//libserver9.a(kcl.o): In function `kclbr':
kcl.c:(.text+0xa737): undefined reference to `skgmmap_ro'
/oracle/app/product/9.2/db_1/lib//libserver9.a(kcl.o): In function `kclswrite':
kcl.c:(.text+0xaf6c): undefined reference to `skgmmap_ro'
/oracle/app/product/9.2/db_1/lib//libserver9.a(kcl.o): In function `kcllwr':
kcl.c:(.text+0xb8f9): undefined reference to `skgmmap_ro'
/oracle/app/product/9.2/db_1/lib//libserver9.a(kcl.o): In function `kclsplit':
kcl.c:(.text+0x157ee): undefined reference to `skgmmap_ro'
/oracle/app/product/9.2/db_1/lib//libserver9.a(kcl.o):kcl.c:(.text+0x16156): more undefined references to `skgmmap_ro' follow
/oracle/app/product/9.2/db_1/lib//libserver9.a(kks.o): In function `kkslod':
kks.c:(.text+0x1777): undefined reference to `kglatclr'
/oracle/app/product/9.2/db_1/lib//libserver9.a(kokc.o): In function `kokcsodl':
kokc.c:(.text+0xd47): undefined reference to `kocdsfr'
/oracle/app/product/9.2/db_1/lib//libserver9.a(koka.o): In function `kokaclc':
koka.c:(.text+0x6330): undefined reference to `kgiCloseCursors'
/oracle/app/product/9.2/db_1/lib//libserver9.a(opifcs.o): In function `opifcs':
opifcs.c:(.text+0x57): undefined reference to `kgi_mark_csc'
opifcs.c:(.text+0xf5): undefined reference to `kgi_clear_csc'
/oracle/app/product/9.2/db_1/lib//libserver9.a(kkxm.o): In function `kkxmindl':
kkxm.c:(.text+0x259): undefined reference to `kgmindl'
/oracle/app/product/9.2/db_1/lib//libserver9.a(psdicd.o): In function `psdres1':
psdicd.c:(.text+0x34c4): undefined reference to `kglgbo92'
/oracle/app/product/9.2/db_1/lib//libserver9.a(kaf9ir2.o): In function `kafger9ir2_srp':
kaf9ir2.c:(.text+0x28c): undefined reference to `kdr9ir2_pop'
/oracle/app/product/9.2/db_1/lib//libserver9.a(qmts.o): In function `qmtsSetBoolean':
qmts.c:(.text+0x5bd0): undefined reference to `qmxSetData0'
qmts.c:(.text+0x5bee): undefined reference to `qmxSetData0'
/oracle/app/product/9.2/db_1/lib//libserver9.a(qmts.o): In function `qmtsSetNumber':
qmts.c:(.text+0x5cc7): undefined reference to `qmxSetData0'
/oracle/app/product/9.2/db_1/lib//libserver9.a(qmts.o): In function `qmtsSetNumber2':
qmts.c:(.text+0x5d8d): undefined reference to `qmxSetData0'
/oracle/app/product/9.2/db_1/lib//libserver9.a(qmts.o): In function `qmtsSetVarchar':
qmts.c:(.text+0x5e3f): undefined reference to `qmxSetData0'
/oracle/app/product/9.2/db_1/lib//libserver9.a(qmts.o):qmts.c:(.text+0x5ed5): more undefined references to `qmxSetData0' follow
collect2: ld returned 1 exit status
make: *** [/oracle/app/product/9.2/db_1/rdbms/lib/oracle] Error 1
End output from spawned process.
----------------------------------
Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target 'ioracle' of makefile '/oracle/app/product/9.2/db_1/rdbms/lib/ins_rdbms.mk'. See '/oracle/app/oraInventory/logs/installActions2010-10-18_12-15-10PM.log' for details.
Exception Severity: 1
Calling Action unixActions10.1.0.3.0 make
registerOnly = false
installMakePath = /usr/bin/make
installMakeFileName = /oracle/app/product/9.2/db_1/network/lib/ins_net_client.mk
installTarget = client_sharedlib
undoMakeFileName =
installArguments = ORACLE_HOME=/oracle/app/product/9.2/db_1,
logFile = /oracle/app/product/9.2/db_1/install/make.log
undoTarget =
progMsg = Building client shared libraries
The output of this make operation is also available at: '/oracle/app/product/9.2/db_1/install/make.log'
rm -f /oracle/app/product/9.2/db_1/rdbms/lib/oracle
gcc -o /oracle/app/product/9.2/db_1/rdbms/lib/oracle -L/oracle/app/product/9.2/db_1/rdbms/lib/ -L/oracle/app/product/9.2/db_1/lib/ -L/oracle/app/product/9.2/db_1/lib/stubs/ -Wl,-E `test -f /oracle/app/product/9.2/db_1/rdbms/lib/skgaioi.o && echo /oracle/app/product/9.2/db_1/rdbms/lib/skgaioi.o` /oracle/app/product/9.2/db_1/rdbms/lib/opimai.o /oracle/app/product/9.2/db_1/rdbms/lib/ssoraed.o /oracle/app/product/9.2/db_1/rdbms/lib/ttcsoi.o /oracle/app/product/9.2/db_1/lib/nautab.o /oracle/app/product/9.2/db_1/lib/naeet.o /oracle/app/product/9.2/db_1/lib/naect.o /oracle/app/product/9.2/db_1/lib/naedhs.o /oracle/app/product/9.2/db_1/rdbms/lib/config.o -lserver9 -lodm9 -lskgxp9 -lskgxn9 -lclient9 -lvsn9 -lwtcserver9 -lcommon9 -lgeneric9 /oracle/app/product/9.2/db_1/rdbms/lib/defopt.o -lknlopt `if /usr/bin/ar tv /oracle/app/product/9.2/db_1/rdbms/lib/libknlopt.a | grep xsyeolap.o > /dev/null 2>&1 ; then echo "-loraolap9" ; fi` -lslax9 -lpls9 -lplp9 -lserver9 -lclient9 -lvsn9 -lwtcserver9 -lcommon9 -lgeneric9 -lknlopt -lslax9 -lpls9 -lplp9 -ljox9 -lserver9 -locijdbcst9 -lwwg9 `cat /oracle/app/product/9.2/db_1/lib/ldflags` -lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lnro9 `cat /oracle/app/product/9.2/db_1/lib/ldflags` -lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lmm -lnls9 -lcore9 -lnls9 -lcore9 -lnls9 -lxml9 -lcore9 -lunls9 -lnls9 `cat /oracle/app/product/9.2/db_1/lib/ldflags` -lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -lnro9 `cat /oracle/app/product/9.2/db_1/lib/ldflags` -lnsslb9 -lncrypt9 -lnsgr9 -lnzjs9 -ln9 -lnl9 -ltrace9 -lnls9 -lcore9 -lnls9 -lcore9 -lnls9 -lxml9 -lcore9 -lunls9 -lnls9 `if /usr/bin/ar tv /oracle/app/product/9.2/db_1/rdbms/lib/libknlopt.a | grep "kxmnsd.o" > /dev/null 2>&1 ; then echo " " ; else echo "-lordsdo9"; fi` -lctxc9 -lctx9 -lzx9 -lgx9 -lctx9 -lzx9 -lgx9 -lordimt9 -lnls9 -lcore9 -lnls9 -lcore9 -lnls9 -lxml9 -lcore9 -lunls9 -lnls9 -lsnls9 -lunls9 -lxsd9 -lnls9 -lcore9 -lnls9 -lcore9 -lnls9 -lxml9 -lcore9 -lunls9 -lnls9 `cat /oracle/app/product/9.2/db_1/lib/sysliblist` -Wl,-rpath,/oracle/app/product/9.2/db_1/lib:/lib:/usr/lib -lm `cat /oracle/app/product/9.2/db_1/lib/sysliblist` -ldl -lm `test -f /oracle/app/product/9.2/db_1/rdbms/lib/skgaioi.o && echo -laio`
/oracle/app/product/9.2/db_1/lib//libserver9.a(krd.o): In function `krda1fbuf':
krd.c:(.text+0xcc92): undefined reference to `skgmmap_ro'
/oracle/app/product/9.2/db_1/lib//libserver9.a(kse.o): In function `ksepop':
kse.c:(.text+0x498): undefined reference to `kgeclrsta'
kse.c:(.text+0x4a3): undefined reference to `kgechksta'
kse.c:(.text+0x4b6): undefined reference to `kgesetsta'
kse.c:(.text+0x4c7): undefined reference to `kgeclrsta'
/oracle/app/product/9.2/db_1/lib//libserver9.a(ksm.o): In function `ksmdmp_tpga':
ksm.c:(.text+0x1858): undefined reference to `kghdmp_new'
ksm.c:(.text+0x187e): undefined reference to `kghdmp_new'
ksm.c:(.text+0x1898): undefined reference to `kghdmp_new'
/oracle/app/product/9.2/db_1/lib//libserver9.a(ksm.o): In function `ksm_dump_sga_heap':
ksm.c:(.text+0x4998): undefined reference to `kghdmp_new'
/oracle/app/product/9.2/db_1/lib//libserver9.a(ksm.o): In function `ksm_4031_dump':
ksm.c:(.text+0x4b9f): undefined reference to `kghdsdump'
ksm.c:(.text+0x4bdb): undefined reference to `kghdsdump'
ksm.c:(.text+0x5168): undefined reference to `kghdsdump'
/oracle/app/product/9.2/db_1/lib//libserver9.a(ksm.o): In function `ksmhdm':
ksm.c:(.text+0x8769): undefined reference to `kghdmp_new'
ksm.c:(.text+0x87ac): undefined reference to `kghdmp_new'
ksm.c:(.text+0x8809): undefined reference to `kghdmp_new'
ksm.c:(.text+0x884d): undefined reference to `kghdmp_new'
ksm.c:(.text+0x8888): undefined reference to `kghdmp_new'
/oracle/app/product/9.2/db_1/lib//libserver9.a(qm.o): In function `qm_initDirs':
qm.c:(.text+0x1a40): undefined reference to `qmxSetData0'
qm.c:(.text+0x1ad1): undefined reference to `qmxSetData0'
qm.c:(.text+0x1b62): undefined reference to `qmxSetData0'
qm.c:(.text+0x1bf3): undefined reference to `qmxSetData0'
qm.c:(.text+0x1c7f): undefined reference to `qmxSetData0'
/oracle/app/product/9.2/db_1/lib//libserver9.a(qm.o):qm.c:(.text+0x1d1f): more undefined references to `qmxSetData0' follow
/oracle/app/product/9.2/db_1/lib//libserver9.a(kcl.o): In function `kclpto':
kcl.c:(.text+0x17a7): undefined reference to `skgmmap_ro'
/oracle/app/product/9.2/db_1/lib//libserver9.a(kcl.o): In function `kclbr':
kcl.c:(.text+0xa737): undefined reference to `skgmmap_ro'
/oracle/app/product/9.2/db_1/lib//libserver9.a(kcl.o): In function `kclswrite':
kcl.c:(.text+0xaf6c): undefined reference to `skgmmap_ro'
/oracle/app/product/9.2/db_1/lib//libserver9.a(kcl.o): In function `kcllwr':
kcl.c:(.text+0xb8f9): undefined reference to `skgmmap_ro'
/oracle/app/product/9.2/db_1/lib//libserver9.a(kcl.o): In function `kclsplit':
kcl.c:(.text+0x157ee): undefined reference to `skgmmap_ro'
/oracle/app/product/9.2/db_1/lib//libserver9.a(kcl.o):kcl.c:(.text+0x16156): more undefined references to `skgmmap_ro' follow
/oracle/app/product/9.2/db_1/lib//libserver9.a(kks.o): In function `kkslod':
kks.c:(.text+0x1777): undefined reference to `kglatclr'
/oracle/app/product/9.2/db_1/lib//libserver9.a(kokc.o): In function `kokcsodl':
kokc.c:(.text+0xd47): undefined reference to `kocdsfr'
/oracle/app/product/9.2/db_1/lib//libserver9.a(koka.o): In function `kokaclc':
koka.c:(.text+0x6330): undefined reference to `kgiCloseCursors'
/oracle/app/product/9.2/db_1/lib//libserver9.a(opifcs.o): In function `opifcs':
opifcs.c:(.text+0x57): undefined reference to `kgi_mark_csc'
opifcs.c:(.text+0xf5): undefined reference to `kgi_clear_csc'
/oracle/app/product/9.2/db_1/lib//libserver9.a(kkxm.o): In function `kkxmindl':
kkxm.c:(.text+0x259): undefined reference to `kgmindl'
/oracle/app/product/9.2/db_1/lib//libserver9.a(psdicd.o): In function `psdres1':
psdicd.c:(.text+0x34c4): undefined reference to `kglgbo92'
/oracle/app/product/9.2/db_1/lib//libserver9.a(kaf9ir2.o): In function `kafger9ir2_srp':
kaf9ir2.c:(.text+0x28c): undefined reference to `kdr9ir2_pop'
/oracle/app/product/9.2/db_1/lib//libserver9.a(qmts.o): In function `qmtsSetBoolean':
qmts.c:(.text+0x5bd0): undefined reference to `qmxSetData0'
qmts.c:(.text+0x5bee): undefined reference to `qmxSetData0'
/oracle/app/product/9.2/db_1/lib//libserver9.a(qmts.o): In function `qmtsSetNumber':
qmts.c:(.text+0x5cc7): undefined reference to `qmxSetData0'
/oracle/app/product/9.2/db_1/lib//libserver9.a(qmts.o): In function `qmtsSetNumber2':
qmts.c:(.text+0x5d8d): undefined reference to `qmxSetData0'
/oracle/app/product/9.2/db_1/lib//libserver9.a(qmts.o): In function `qmtsSetVarchar':
qmts.c:(.text+0x5e3f): undefined reference to `qmxSetData0'
/oracle/app/product/9.2/db_1/lib//libserver9.a(qmts.o):qmts.c:(.text+0x5ed5): more undefined references to `qmxSetData0' follow
collect2: ld returned 1 exit status
make: *** [/oracle/app/product/9.2/db_1/rdbms/lib/oracle] Error 1
End output from spawned process.
----------------------------------
Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target 'ioracle' of makefile '/oracle/app/product/9.2/db_1/rdbms/lib/ins_rdbms.mk'. See '/oracle/app/oraInventory/logs/installActions2010-10-18_12-15-10PM.log' for details.
Exception Severity: 1
Calling Action unixActions10.1.0.3.0 make
registerOnly = false
installMakePath = /usr/bin/make
installMakeFileName = /oracle/app/product/9.2/db_1/network/lib/ins_net_client.mk
installTarget = client_sharedlib
undoMakeFileName =
installArguments = ORACLE_HOME=/oracle/app/product/9.2/db_1,
logFile = /oracle/app/product/9.2/db_1/install/make.log
undoTarget =
progMsg = Building client shared libraries
The output of this make operation is also available at: '/oracle/app/product/9.2/db_1/install/make.log'
但升级至9.2.0.8没有任何问题,估计是Oracle patch一bug,在9.2.0.8上解决了。
发表评论
-
buffer cache 的内部结构
2020-03-18 14:21 584BUFFER CACHE作为数据块的 ... -
Oracle OMC介绍
2020-03-18 13:19 495Oracle管理云服务(OMC)的大数据平台,自动收集的企业 ... -
参加Oracle勒索病毒防范专题培训会议
2019-09-27 17:15 5312019年7月22日,受邀参加Oracle勒索病毒防范专题培训 ... -
记一次内存换IO的Oracle优化
2019-09-27 16:50 835某客户数据库从P595物理 ... -
如何定位Oracle SQL执行计划变化的原因
2019-07-03 14:49 1471性能优化最难的是能够 ... -
如何定位Oracle SQL执行计划变化的原因
2018-10-30 09:24 1185性能优化最难的是能够 ... -
数据库性能优化目标
2018-10-08 10:59 528从数据库性能优化的场 ... -
数据库无法打开的原因及解决办法
2018-10-05 20:45 2145数据库的启动是一个相当复杂的过程。比如,Oracle在启动之前 ... -
怎么样彻底删除数据库?
2018-09-18 11:10 608Oracle提供了drop database命令用来删除数据库 ... -
Oracle减少日志量的方法
2018-09-10 10:17 871LGWR进程将LOG BUFFER中的 ... -
如何快速关闭数据库
2018-09-09 13:14 1240“一朝被蛇咬,十年怕井绳”。在没被“蛇”咬之前,很多DBA喜欢 ... -
关于《如何落地智能化运维》PPT
2018-05-17 10:19 1137在DTCC 2018发表《如何落地智能化运维》演讲,主要内容如 ... -
记录在redhat5.8平台安装oracle11.2容易忽视的几个问题
2018-05-11 19:58 587问题一:ping不通问题 在虚拟机上安装好linux系统后, ... -
《Oracle DBA实战攻略》第一章
2018-05-11 10:42 954即日起,不定期更新《OracleDBA实战攻略》一书电子版,请 ... -
Oracle 12c新特性
2018-05-11 10:33 907查询所有pdb [oracle@gj4 ~]$ sqlplu ... -
关于修改memory_target的值后数据库无法启动的问题
2017-02-28 12:24 3990操作系统:RHEL6.5 数据库版本:11.2.0.4 ... -
10g rac安装error while loading shared libraries libpthread.so.0 问题
2017-02-28 12:22 70311g rac安装在二节点跑脚本一般会报此错误: 解决这个问 ... -
记一次Oracle会话共享模式故障处理过程
2017-02-27 19:16 805故障简述 XXX第八人民医院HIS数据库7月13日11点左右从 ... -
RESMGR:cpu quantum等待事件处理过程
2017-02-27 18:23 2656由于数据库上线过程中出现大量的RESMGR:cpu quant ... -
谈谈log file sync
2014-03-19 14:18 1776数据库中的log file sync等待事件指的是,当user ...
相关推荐
6. **补丁验证**:安装完成后,使用`opatch lsinventory`命令确认补丁已成功安装,并检查Oracle的错误日志以确认没有安装问题。 7. **重启数据库和服务**:某些补丁可能需要重新启动数据库实例或Oracle服务以使更改...
在Red Hat Enterprise Linux Advanced Server 5 (RHEL AS5) 上安装Oracle 9i数据库时,需要特别关注一些关键步骤和必要的补丁包。Oracle 9i是一款相对较老的数据库系统,但在某些环境下仍然有着其独特的应用价值。...
**第二章 在LINUX下安装ORACLE 9I数据库安装前准备** 2.1 **硬件需求** 确保硬件满足Oracle 9i的最低配置要求,包括至少1GB内存,足够的CPU资源,以及用于数据存储的高速硬盘。 2.2 **软件需求** 确保安装了必要...
2. **安装与配置**:在Windows或Linux环境下安装Oracle 9i,包括选择合适的硬件和软件需求,设置环境变量,创建数据库实例,配置网络服务名等步骤。 3. **SQL语言**:Oracle 9i支持标准SQL,包括数据查询、插入、...
这份文档涵盖了Oracle9i在不同Unix平台上的安装、配置、管理和故障排除,包括AIX-Based Systems、Compaq Tru64 UNIX、HP 9000 Series HP-UX、Linux Intel以及Sun Solaris等系统。 ### 重要知识点: #### 1. Oracle...
9. 高可用性与灾难恢复:Oracle 9i支持如RAC(Real Application Clusters)和Data Guard等高可用性解决方案,以及闪回技术,用于在发生错误或灾难时快速恢复。 10. 网络配置:Oracle数据库通常需要在网络环境中运行...
在Linux环境下操作Oracle数据库,尤其是Oracle 11g和9i版本,对于系统管理员和DBA来说是一项重要的技能。以下是一些关键知识点和步骤,帮助你理解和执行在Linux上启动和停止Oracle数据库的过程: 1. **切换用户**:...
本文将详细解析RHEL5(Red Hat Enterprise Linux 5)操作系统上安装Oracle 9i数据库的过程,结合提供的文件名称,我们将探讨相关配置和步骤。 首先,安装Oracle 9i前需要确保RHEL5系统已经完全更新并安装了必要的...
在Linux操作系统上安装Oracle数据库,特别是老版本如Oracle9i时,可能会遇到各种问题。本指南主要针对在SUSE Linux 9环境下安装Oracle9i时遇到的一个常见问题——图形安装界面无法显示。 【问题描述】 当尝试在SUSE...
这份名为"RedHat Linux AS4下安装Oracle9i.pdf"的文档,应详细记录了这些步骤,并可能提供了安装过程中遇到问题的解决方案,对于在相同环境下安装Oracle 9i的用户具有很高的参考价值。通过阅读和遵循文档中的指南,...
Oracle从Oracle 9i开始引入Real Application Clusters(RAC),使得数据库能够在多个节点之间共享,减少了对昂贵大型服务器的依赖。 然而,尽管Oracle提供了自己的集群软件和ASM(Automatic Storage Management)...
- **版本1.2** (2000/10): 修改了Linux安装部分内容,并增加了数据字典参考、删除冗余记录的方法以及常见错误处理等。 - **版本1.3** (2001/03): 对安装部分、init.ora配置进行了更新,并新增了手工建库和MTS配置等...
在Linux系统中,首先运行`./runInstaller -record -destinationFile /tmp/install_database.rsp`,这会启动Oracle Universal Installer (OUI),记录下安装过程中所有的用户选择,但不会真正安装,只会创建一个响应...
本文将基于"Oracle傻瓜手册v2.0.doc"的内容,深入解析Oracle 8i和9i的基础知识,包括安装配置、数据库管理、数据结构以及开发工具等方面。 1. **Oracle版本区别** Oracle 8分为普通版和Internet版,普通版如8.0.5...
- **软件**:网络环境、Windows Server/NT 或 Linux 或 Unix 操作系统、Oracle 9i。 - **硬件**:至少 PIII 以上 CPU,256MB 以上内存,有 2GB 以上的空闲磁盘空间。 #### 五、实验报告要求 - **实验目的**:明确...
- **操作系统平台**:主要介绍了在Solaris 8 Intel Platform + Oracle8i R3以及Red Hat Linux 7.3 + Oracle9i R2上的配置和使用方法。 - **示例数据库**:以`oradb`作为数据库实例名,数据库用户为`dbuser`,口令为`...
- **Oracle9i**:目前主要版本是第二版,即9.2版本。 #### 二、手册适用环境与配置方法 - **手册特点**:本手册主要介绍Oracle配置的基本方法,重点在于操作实践而非理论解释。 - **操作系统选择**:避免了Windows...
- **Oracle**: 支持更广泛的操作系统,不仅包括Windows(32位和64位),还支持Linux以及多种UNIX变体如Solaris、HP-UX、AIX等。 #### 二、版本与发行版 - **SQLServer**: 当前最新版本为SQLServer 2008,即将发布的...
Oracle 使用 Alert Log 来记录数据库运行时的重要事件,包括警告和错误信息。而 SQL Server 则使用 Error Log 来记录系统级和应用程序级的错误信息。这些日志对于定位问题和解决问题都非常有帮助。 #### 数据库安全...