His database version is Oracle 11g R2.
I tried to start up database but it raised :
SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system
SQL> exit
Hmmmmm, that`s new for me, never faced before.
Checked disk space
[root@localhost ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/cciss/c0d0p3 209G 27G 171G 14% /
/dev/cciss/c0d1p1 903G 265G 592G 31% /oradata
/dev/cciss/c0d0p1 99M 24M 71M 26% /boot
tmpfs 3.9G 0 3.9G 0% /dev/shm
[root@localhost ~]#
Increased tmpfs size. To do that open fstab file via any editable program (gedit, vi etc)
[root@localhost ~]# vi /etc/fstab
...
tmpfs /dev/shm tmpfs defaults,size=8G
(Some one decreased this value that is was reason)
[root@localhost ~]# more /etc/fstab
LABEL=/ / ext3 defaults 1 1
LABEL=/oradata /oradata ext3 defaults 1 2
LABEL=/boot1 /boot ext3 defaults 1 2
tmpfs /dev/shm tmpfs defaults,size=8G 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0
LABEL=SW-cciss/c0d0p2 swap swap defaults 0 0
/swapfile swap swap defaults 0 0
To make change effective immediately run:
[root@localhost ~]# mount -o remount /dev/shm
Check
[root@localhost ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/cciss/c0d0p3 209G 27G 171G 14% /
/dev/cciss/c0d1p1 903G 265G 592G 31% /oradata
/dev/cciss/c0d0p1 99M 24M 71M 26% /boot
tmpfs 8.0G 0 8.0G 0% /dev/shm
[root@localhost ~]#
Let`s start a database
[oracle@localhost dbs]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production on Wed Nov 30 10:17:30 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 5277921280 bytes
Fixed Size 2213096 bytes
Variable Size 4496296728 bytes
Database Buffers 738197504 bytes
Redo Buffers 41213952 bytes
Database mounted.
Database opened.
SQL> exit
Thanks, It worked for me :)
ReplyDeleteCmaj welcome, nice to hear that.
ReplyDeleteThanks Ulfet ...working fine :):)
ReplyDeleteRamkumar welcome.
ReplyDeleteThank you so much. it solved my issue
ReplyDeleteRavi, nice to hear it. Welcome
ReplyDelete