oracle11g数据库,修改了内存参数memory_max_target=943718400,关闭数据库重新启动的时候报错[oracle@instuctor shm]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Mon Nov 19 09:34:11 2012Copyright (c) 1982, 2011, Or
原创 2013-07-31 10:00:14
802阅读
 启动Oracle 11gR2后报错:ORA-00845 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, 2011, Oracle.  All rights reserved. Connec
转载 2012-02-14 10:07:00
82阅读
2评论
启动Oracle 11gR2后报错:ORA-00845rac1:/home/oracle> sqlplus / as sysdba;SQL*Plus: Release 11.2.0.3.0 Production o
转载 2012-02-14 10:07:00
60阅读
2评论
启动Oracle 11gR2后报错:ORA-00845rac1:/home/oracle> sqlplus / as sysdba;SQL*Plus: Release 11.2.0.3.0 Production onTue Feb 14 09:11:41 2012Copyright (c) 1982, 2011, Oracle.  All rights reserved.Connected
原创 2021-12-31 11:54:57
197阅读
启动Oracle 11gR2后报错:ORA-00845 rac1:/home/oracle> sqlplus / as sysdba;SQL*Pl
原创 2022-09-02 10:19:02
226阅读
启动Oracle 11gR2后报错:ORA-00845rac1:/home/oracle> sqlplus / as sysdba;SQL*Plus: Release 11.2.0.3.0 Production onTue Feb 14 09:11:41 2012Copyright (c) 1982, 2011, Oracle.  All rights reserved.Connected
原创 2022-01-05 13:34:29
323阅读
下午想把一个11.2.0.2实例的memory_target AMM内存初始化参数修改到2000M,改好后重启发现实例起不来了,出现了ORA-00845错误: [oracle@rh2 ~]$ [oracle@rh2 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.2.0 Production on Tue May 3 19:43:50 2011
原创 2011-05-03 20:20:14
738阅读
登录root用户: vi /etc/fstab #modify: SGA Size tmpfs                   /dev/shm     &
原创 2012-05-16 13:43:16
651阅读
1点赞
1评论
环境:RHEL  6.2  x64Oracle 11.2.0.1.0Memory  4GMEMORY_TARGET=1584M/dev/shm  2G将MEMORY_TARGET调整为2048M后,重启数据库报错ORA-00845: MEMORY_TARGET not supported on this systemoerr ora 84500845, 00
原创 2014-02-24 17:07:38
368阅读
oracle11g ORA-00845: MEMORY_TARGET not supported on this system
转载 2011-07-21 17:08:34
1137阅读
在使用11G的AMM进行内存管理的时候,memory_target的值受到两个值的影响,一个是实际的服务器的物理内存,
原创 2022-08-17 01:21:47
151阅读
故障:ORA-00845: MEMORY_TARGET not supported on this system Oracle 11g的Linux版本在修改了MEMORY_TARGET或者SGA_TARGET后启动可能会报错: SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance
原创 2012-01-21 14:28:22
9483阅读
tmpfs小于ORACLE SGA,默认的大小是RM(物理内存)的一半,由于tmpfs既使用内存,又可能使用了部分交换分区,所以不能指望使用tmpfs提高的读写速率倍数就等于(内存读写速率/磁盘读写速率)[root@oracle ~]# vim /etc/fstab我们要修改大小我们现在物理内存是1G  调整tmpfs大小,别超过内存+swap的大小。如果系统资源紧张,用完了内存,用到s
原创 2013-05-28 10:04:23
533阅读
前段时间在虚拟机上装了个oracle11g,最近做测试,电脑资源有点紧张,把分配的4G内存改为2G内存了,在启动oracle的时候,会报如下错误[oracle@oracleserver ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Sun Aug 10 00:08:44 2014Copyright (c) 198
原创 2014-08-10 00:20:24
613阅读
12.2 asmca fails with 'ORA-00845'
原创 2018-12-09 11:57:01
761阅读
2点赞
1评论
ORA-00845: MEMORY_TARGET not supported on this system报错解决Oracle启动报错   ORA-00845: MEMORY_TARGET not supported on this system报错解决   SQL> startup   ORA-00845: MEMORY_TARG
原创 2016-04-23 20:52:22
1429阅读
[oracle@up ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Tue Nov 10 19:26:05 2015Copyright (c) 1982, 2009, Oracle.  All rights reserved.Connected to an idle instance.SQL> s
原创 2015-11-10 11:29:04
1170阅读
环境:RHEL6.6+11gR2RAC由于虚拟环境搭建rac做测试,设置虚机内存为3G,打补丁导致pc机太慢,因此调整两台虚拟机内容为2534M内存,启动虚拟后发现数据库无法启动,尝试在单节点手工启动报如下错误:oracle@cluster2 ~]$ sqlplus /nologSQL*Plus: Release 11.2.0.4.0 Production on Sat May 28 01:03:
原创 2016-05-30 16:17:09
694阅读
ORA-00845: MEMORY_TARGET not supported
原创 2018-08-16 12:29:35
2110阅读
1点赞
listener.ora文件:# listener.ora Network Configuration File: d:/app/john/product/11.1.0/db_1/network/admin/listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER =   (SID_LIST = &nb
转载 精选 2014-12-19 17:38:18
530阅读
  • 1
  • 2
  • 3
  • 4
  • 5