ORA-00845 Oacle 11g常见的shm问题(二)

2014-11-24 17:50:56 · 作者: · 浏览: 1
-id/cciss-3600508b1001c59983f902a5494c7d076-part1 /boot
ext3 acl,user_xattr 1 2
#/dev/data/lv_data /oracle_bk ext3 acl,user_xattr 1 2
/dev/data/lv_data /oracle ext3 defaults 0 0
proc /proc proc defaults 0 0
sysfs /sys sysfs noauto 0 0
debugfs /sys/kernel/debug debugfs noauto 0 0
usbfs /proc/bus/usb usbfs noauto 0 0
devpts /dev/pts devpts mode=0620,gid=5 0 0
tmpfs /dev/shm tmpfs defaults,size=256G 0 0
#/dev/mapper/oraclevg-oraclelv01 /oracle ext3 defaults 0 0
#/dev/mapper/oraclevg-oraclelv02 /oracle/oradata2 ext3 defaults 0 0


srv-bioradb:~ # mount /dev/shm


srv-bioradb:~ # df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/system-lv_root 358G 8.5G 331G 3% /
devtmpfs 127G 624K 127G 1% /dev
/dev/cciss/c0d0p1 1.6G 106M 1.4G 8% /boot
/dev/mapper/data-lv_data 2.3T 1.8T 364G 84% /oracle
/dev/mapper/oraclevg-oraclelv01 2.9T 201M 2.7T 1% /oracle1
tmpfs 256G 0 256G 0% /dev/shm
srv-bioradb:~ #
srv-bioradb:~ #


srv-bioradb:~ #


启动oracle,不再报错,问题解决
srv-bioradb:~ # whoami
root
srv-bioradb:~ # su - oracle
srv-bioradb:~> sqlplus / as sysdba



SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 25 18:46:06 2013



Copyright (c) 1982, 2011, Oracle. All rights reserved.



Connected to an idle instance.



SQL> startup
ORACLE instance started.



Total System Global Area 2.1913E+11 bytes
Fixed Size 2241384 bytes
Variable Size 1.0469E+11 bytes
Database Buffers 1.1435E+11 bytes
Redo Buffers 88821760 bytes
Database mounted.
Database opened.


SQL>


推荐阅读: