ora-04031 无法分配XXX字节的共享内存(XXX)”的解决办法

产品

	ORA-00204: error in reading (block 3, # blocks 8) of controlfile

	ORA-00205: error in identifying control file, check alert log for more inf.

	oracle非法关机引起redolog丢失，导致数据库实例无法正常启动(ORA-00313 ORA-00312 ORA-00376)

	ORA-00376:此时无法读取文件3

	ORA-00604: 递归 SQL 级别 1 出现错误

	ORA-00821: Specified value of sga_target 4072M is too small, needs to be at least 13896M，数据恢复技术服务

	ORA-00845: MEMORY_TARGET not supported on this system

	ORA-01078: failure in processing system parameters

	ORA-01078: failure in processing system parameters

	ORA-01078: failure in processing system parameters

	ORA-01078: failure in processing system parameters

	ORA-01113:文件7需要介质恢复

	ORA-01157: cannot identify/lock data file 8 - see DBWR trace file，数据恢复技术服务

	ora-01190:控制文件或数据文件3来自最后一个RESETLOG之前

	ORA-01552 cannot use system rollback segment for non-system tablespace

	ORA-01624: 日志3是紧急修复实例

	ORA-01658 oracle导入数据出错：ORA-01658：无法为表空间TESt中的段创建INITIAL区

	ORA-00823: Specified value of sga_target greater than sga_max_size

	ORA-03113: end-of-file on communication channel，数据恢复技术服务

	ora-04031 无法分配XXX字节的共享内存(XXX)”的解决办法

	ORA-07391: sftopn: fopen error, unable to open text file

	ORA-27072: File I/O error

	ORA-32001: write to SPFILE requested bu no SPFILE specified at startup.

	SQL 错误: ORA-65096: 公用用户名或角色名无效

	ASM Disk Group mount failure，数据恢复技术服务

	ASM Disk Group 中只能mount 一个节点DATA的磁盘

	CRS-4535: Cannot communicate with Cluster Ready Services，数据恢复技术服务

	CRS-0184: Cannot communicate with the CRS daemon，数据恢复技术服务

	CRS-0215: Could not start resource 'ora.test.db 2 1'，数据恢复技术服务

	CRS-4124: Oracle HighAvailability Services startup failed，数据恢复技术服务

	CRS-4535: Cannot communicate with Cluster Ready Services，数据恢复技术服务

	[INS-06006] Passwordless SSH connectivity not set up between the following node(s)，数据恢复技术服务

	[INS-20802] Oracle Cluster Verification Utility failed，数据恢复技术服务

	[INS-32016] The selected Oracle home contains directories or files，数据恢复技术服务

	[INS-40724] No locally defined network interface matches the SCAN，数据恢复技术服务

	CRS-0215: Could not start resource 'ora.test.db 2 1'，数据恢复技术服务

	invalid stored block lengs，数据恢复技术服务

	libmpfr.so.1()(64bit) is needed by cpp-4.4.6-3.el6.x86_64

	oracle实例名: error while loading shared libraries: libskgxp10.so: cannot open shared object file: No such file or directory.

	Linux-x86_64 Error

	Oracle Custer Verification Utility Failed (see details) Recommended，数据恢复技术服务

	ohasd failed to start at/u01/app/11.2.0/grid/crs/install/rootcrs.pl line 443，数据恢复技术服务

	SP2-0042: unknown command "DATAFILE" - rest of line ignored.

	TNS-12541: TNS: 无监听程序

	ORA-00334: archived log: '+DATA//dbm/onlinelog/group_1.log

	ORA-01034: ORACLE not available，数据恢复技术服务

	ORA-01078: failure in processing system parameters，数据恢复技术服务

	ORA-01110 数据文件坏，数据恢复技术服务

	ORA-01589: must use RESETLOG or NORESETLOGS option for database open，数据恢复技术服务

	ORA-02019: connection description for remote database not found，数据恢复技术服务

	ORA-003111:cannot read header from archived log

	ORA-12504: TNS:listener was not given the SID in CONNECT_DATA，数据恢复技术服务

	ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor，数据恢复技术服务

	TNS-12535: TNS: 操作超时，数据恢复技术服务

	ORA-15018: diskgroup cannot be created，数据恢复技术服务

	ORA-15081 failed to submit an IO operation to disk

	oracle Database 11.2 Error Messages

	oracle Database 19C Error Messages

	oracle Database 21C Error Messages

	Oracle Database 技术支持电话: 13301272832 (微信同号)

	Moble: 13301272832 (微信同号)


	Tel: 　010-82666745

	联系人：　霍经理

	QQ: 　　619804118

	E-mail: 　　bjslkc@163.com

	公司：北京深蓝融鑫科技发展有限公司

”ora-04031 无法分配XXX字节的共享内存(XXX)”-->解决方法



错误”ora-04031 无法分配XXX字节的共享内存(XXX)”的解决办法：
oracle :
sys用户以sysdba身份登录
先查看当前shared_pool_size值
sql>show parameter shared_pool_size;
sql>alter system set shared_pool_size=’比原先值适当增加’ scope=spfile;

中国·北京联系方式：

1）联系人：　霍经理
2）手　机：　13301272832 (微信同号)
3）QQ: 619804118
4）联系电话：（010）82666745
5）传　　真：（010）82666745
6）E-mail: 　　bjslkc@163.com
7）公司：北京深蓝融鑫科技发展有限公司
8）地址：北京市海淀区西北旺
9）公司地址、乘车路线及公司位置地图