Error: ORA-00845 after Oracle 11gR2 is started

Source: Internet
Author: User

There are already many examples of this error on the Internet. I will record it myself.

Error: ORA-00845 after Oracle 11gR2 is started

Rac1:/home/oracle> sqlplus/as sysdba;

SQL * Plus: Release 11.2.0.3.0 Production onTue Feb 14 09:11:41 2012

 

Copyright (c) 1982,201 1, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup

ORA-00845: MEMORY_TARGET not supported onthis system

This error has been handled before, because the tmpfs size MEMORY_TARGET setting will report this error.

Processing

[Root @ localhost ~] # Umount tmpfs

(Busy may be returned here. Restart it and then umount)

[Root @ localhost ~] # Mount-t tmpfs shmfs-o size = 1g/dev/shm (no restart required)


[Root @ localhost ~] # Vi/etc/fstab (restart to take effect here)

Tmpfs/dev/shm tmpfs ults, size = 1g 0 0


[Root @ localhost ~] # Df-h
File System capacity used available % mount point
/Dev/mapper/VolGroup00-LogVol00
18G 15G 2.2G 87%/
/Dev/sda1 99 M 12 M 82 M 13%/boot
/Dev/hdc 2.9G 2.9G 0 100%/media/RHEL_5.3 i386 DVD
Shmfs 1.0G 0 1.0G 0%/dev/shm


[Root @ localhost ~] # Su-oracle


SQL * Plus: Release 11.2.0.1.0 Production ction on Mon Jun 25 15:00:48 2012

Copyright (c) 1982,200 9, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 422670336 bytes
Fixed Size 1336960 bytes
Variable Size 281020800 bytes
Database Buffers 134217728 bytes
Redo Buffers 6094848 bytes

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.