Shulou(Shulou.com)06/01 Report--

Open the virtual machine and find that the instance does not work.

[root@wenxi ~] # su-oracle

Sq [oracle@wenxi ~] $sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Aug 2 14:59:54 2016

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

Connected to an idle instance.

SYS@ odb > startup nomout

SP2-0714: invalid combination of STARTUP options

[oracle@wenxi ~] $oerr ora 000845

00845, 00000, "MEMORY_TARGET not supported on this system"

/ / * Cause: The MEMORY_TARGET parameter was not supported on this operating system or / dev/shm was not sized correctly on Linux.

/ / * Action: Refer to documentation for a list of supported operating systems. Or, size / dev/shm to be at least the SGA_MAX_SIZE on each Oracle instance running on the system.

The new memory management parameter MEMORY_TARGET in oracle 11g can automatically adjust SGA and PGA. This feature requires the use of / dev/shm shared file system, and requires that / dev/shm must be greater than MEMORY_TARGET. If / dev/shm is smaller than MEMORY_TARGET, an error will be reported.

[oracle@wenxi] $df-h / dev/shm/

Filesystem Size Used Avail Use% Mounted on

Tmpfs 1.5G 72K 1.5G 1% / dev/shm

* .memory_target=1603272704 is about 1.6G

The solution is to increase the space for / dev/shm

[oracle@wenxi ~] $cat / etc/fstab | grep tmpfs

Tmpfs / dev/shm tmpfs defaults 0 0

[root@wenxi] # mount-o remount,size=2G / dev/shm

[root@wenxi] # df-h / dev/shm/

Filesystem Size Used Avail Use% Mounted on

Tmpfs 2.0G 72K 2.0G 1% / dev/shm

[root@wenxi ~] # vim / etc/fstab

Tmpfs / dev/shm tmpfs defaults,size=2G

It's open normally.

SYS@ odb > startup

ORACLE instance started.

Total System Global Area 1603411968 bytes

Fixed Size 2253664 bytes

Variable Size 989858976 bytes

Database Buffers 603979776 bytes

Redo Buffers 7319552 bytes

Database mounted.

Database opened.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.