今天一台Linux服務器擴展了一下內存
達到
G
開發的人自己修改了一下SGA結果數據庫無法啟動了
啟動不了時
出的錯誤是這個樣子的:
[oracle@neirong oracle]$ sqlplus
/ as sysdba
SQL*Plus: Release
Production on Fri Nov
:
:
Copyright (c)
Oracle Corporation
All rights reserved
Connected to an idle instance
SQL> startup
ORA
: unable to attach to shared memory segment
Linux Error:
: Invalid argument
Additional information:
Additional information:
SQL> exit
Disconnected
在
位平台上
缺省的SGA最大只能擴展到
G
如果需要支持更大的內存
就需要降低mapped_base
重新Link Oracle軟件
俺的平台為:
[oracle@neirong bdump]$ cat /etc/redhat
release
Red Hat Enterprise Linux AS release
(Taroon Update
)
簡單操作如下:
cd $ORACLE_HOME/rdbms/lib
cp ksms
s ksms
s
bak
genksms
s
x
> ksms
s
make
f ins_rdbms
mk ksms
o
make
f ins_rdbms
mk ioracle
此處先備份ksms
s文件
如果編譯過程中出現錯誤
保證操作可以被恢復:
恢復步驟大致如下:
cd $ORACLE_HOME/rdbms/lib
cp ksms
s
bak ksms
s
genksms > ksms
s
make
f ins_rdbms
mk ksms
o
make
f ins_rdbms
mk ioracle
以下是操作日志:
[oracle@neirong dbs]$ cd $ORACLE_HOME/rdbms/lib
[oracle@neirong lib]$ genksms
s
x
> ksms
s
[oracle@neirong lib]$ make
f ins_rdbms
mk ksms
o
[oracle@neirong lib]$ make
f ins_rdbms
mk ioracle
Linking Oracle
rm
f /opt/oracle/product/
/rdbms/lib/oracle
gcc
o /opt/oracle/product/
/rdbms/lib/oracle
L/opt/oracle/product/
/rdbms/lib/
L/opt/oracle/product/
/lib/
L/opt/oracle/product/
/lib/stubs/
Wl
E `test
f /opt/oracle/product/
/rdbms/lib/skgaioi
o && echo
/opt/oracle/product/
/rdbms/lib/skgaioi
o` /opt/oracle/product/
/rdbms/lib/opimai
o
/opt/oracle/product/
/rdbms/lib/ssoraed
o /opt/oracle/product/
/rdbms/lib/ttcsoi
o
/opt/oracle/product/
/lib/nautab
o /opt/oracle/product/
/lib/naeet
o
/opt/oracle/product/
/lib/naect
o /opt/oracle/product/
/lib/naedhs
o
/opt/oracle/product/
/rdbms/lib/config
o
lserver
lodm
lskgxp
lskgxn
lclient
lvsn
lwtcserver
lcommon
lgeneric
/opt/oracle/product/
/rdbms/lib/defopt
o
lknlopt `if /usr/bin/ar tv /opt/oracle/product/
/rdbms/lib/libknlopt
a | grep
xsyeolap
o > /dev/null
>&
; then echo
loraolap
; fi`
lslax
lpls
lplp
lserver
lclient
lvsn
lwtcserver
lcommon
lgeneric
lknlopt
lslax
lpls
lplp
ljox
lserver
locijdbcst
lwwg
`cat /opt/oracle/product/
/lib/ldflags`
lnsslb
lncrypt
lnsgr
lnzjs
ln
lnl
lnro
`cat /opt/oracle/product/
/lib/ldflags`
lnsslb
lncrypt
mv
f /opt/oracle/product/
/bin/oracle /opt/oracle/product/
/bin/oracleO
mv /opt/oracle/product/
/rdbms/lib/oracle /opt/oracle/product/
/bin/oracle
chmod
/opt/oracle/product/
/bin/oracle
此後數據庫可以以超過
G的SGA區設置啟動:
SQL> startup
ORACLE instance started
Total System Global Area
bytes
Fixed Size
bytes
Variable Size
bytes
Database Buffers
bytes
Redo Buffers
bytes
Database mounted
Database opened
From:http://tw.wingwit.com/Article/program/Oracle/201311/18967.html