[root@XY-EMPIDB ~]# su - oracle[@more@][oracle@XY-EMPIDB ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon May 27 15:09:48 2013

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

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

SQL> show parameter memory

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 3152M
memory_target big integer 3152M

SQL> alter system set memory_target=2048m;

System altered.

SQL> alter system set memory_max_target=2048m scope=spfile;

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

关机
[root@XY-EMPIDB ~]# init 0

==============================================================
开机之后

[oracle@XY-EMPIDB ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 27-MAY-2013 15:25:29

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

Starting /u01/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/diag/tnslsnr/XY-EMPIDB/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XY-EMPIDB)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 27-MAY-2013 15:25:29
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/diag/tnslsnr/XY-EMPIDB/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XY-EMPIDB)(PORT=1521)))
The listener supports no services
The command completed successfully

中间启动database的时候出现ORA-00845: MEMORY_TARGET not supported on this system

需要修改tmpfs的大小

修改 /etc/fstab记录 tmpfs /dev/shm tmpfs defaults,size=4096M 0 0
[root@XY-EMPIDB ~]# more /etc/fstab

#
# /etc/fstab
# Created by anaconda on Mon Jun 18 18:38:04 2012
#
# Accessible filesystems, by reference, are maintained under '/dev/disk'
# See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info
#
/dev/mapper/VolGroup-lv_root / ext4 defaults 1 1
UUID=a03ac782-5c61-432b-8cf7-82364fbc1885 /boot ext4 defaults 1 2
/dev/mapper/VolGroup-lv_swap swap swap defaults 0 0
#tmpfs /dev/shm tmpfs defaults 0 0
tmpfs /dev/shm tmpfs defaults,size=4096M 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0

mount -o remount,size=4G /dev/shm
[root@XY-EMPIDB ~]# su - oracle
[oracle@XY-EMPIDB ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon May 27 15:35:28 2013

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 2137886720 bytes
Fixed Size 2215064 bytes
Variable Size 587203432 bytes
Database Buffers 1543503872 bytes
Redo Buffers 4964352 bytes
Database mounted.
Database opened.

ITPub博客

ORA-00845: MEMORY_TARGET not supported on this system

最新文章