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

[oracle@up ~] $sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue Nov 10 19:26:05 2015

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

Connected to an idle instance.

SQL > startup

ORA-00845: MEMORY_TARGET not supported on this system

SQL >

Error reason: tmpfs space cannot be less than the value of MEMORY_TARGET, tmpfs space is too small to start the database

[root@up ~] # vi / u01/app/oracle/product/11.2.0/dbs/init.ora

Db_name='ORCL'

Memory_target=1G

Processes = 150

Audit_file_dest='/admin/orcl/adump'

Audit_trail = 'db'

Db_block_size=8192

Db_domain=''

The size of the memory_target parameter in the database parameter file is 1G

[root@up] # df-h

Filesystem Size Used Avail Use% Mounted on

/ dev/sda3 26G 17G 7.4G 70% /

Tmpfs 242m 0 242m 0% / dev/shm

/ dev/sda1 190M 28M 153M 16% / boot

The tmpfs space size is 242m, so the database cannot be started

The solution is to modify the mount option of tmpfs in / etc/fstab to increase the space of tmpfs

[root@up ~] # vi / etc/fstab

UUID=a6948461-a0e3-4e64-bf75-e9a45864d48a / ext4 defaults 1 1

UUID=0d5a41b3-3988-467f-be75-93e0e4fad1e9 / boot ext4 defaults 1 2

UUID=bba460fd-bdbe-4a7e-ba49-4016f4633067 swap swap defaults 0 0

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

Devpts / dev/pts devpts gid=5,mode=620 0 0

Sysfs / sys sysfs defaults 0 0

Proc / proc proc defaults 0 0

Modify the tmpfs mount to set the tmpfs space size to 2G

Restart the system

[root@up] # df-h

Filesystem Size Used Avail Use% Mounted on

/ dev/sda3 26G 17G 7.4G 70% /

Tmpfs 2.0G 0 2.0G 0% / dev/shm

/ dev/sda1 190M 28M 153M 16% / boot

The changed tmpfs is 2G

[root@up ~] # su-oracle

[oracle@up ~] $sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue Nov 10 19:40:28 2015

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

Connected to an idle instance.

SQL > startup

ORACLE instance started.

Total System Global Area 409194496 bytes

Fixed Size 2213856 bytes

Variable Size 301991968 bytes

Database Buffers 96468992 bytes

Redo Buffers 8519680 bytes

Database mounted.

Database opened.

Problem solved. Database startup completed.

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.