ORA-00845 ORACLE11G常见的shm问题(二)

2014-11-24 15:08:42 · 作者: · 浏览: 1
ata/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>