阿里云快速做网站,带后台网站模板,网站模块设计,龙海建设局网站上图是oracle体系总架构图今天突然公司所有终端pos机不能刷卡消费#xff0c;财务室不能充值#xff0c;一下很多电话打过来了#xff0c;第一反应肯定数据库出问题了#xff0c;登陆到数据库服务器#xff0c;果然sqlplus连进去后就不断提示要求输入用户名#xff0c;弹… 上图是oracle体系总架构图今天突然公司所有终端pos机不能刷卡消费财务室不能充值一下很多电话打过来了第一反应肯定数据库出问题了登陆到数据库服务器果然sqlplus连进去后就不断提示要求输入用户名弹出一下提示ERROR:ORA-00020: maximum number of processes (150) exceededEnter user-name: sysEnter password:ERROR:ORA-00020: maximum number of processes (150) exceededEnter user-name: sysEnter password:ERROR:ORA-01017: invalid username/password; logon deniedSP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus思考分析了一会果断把oracle通过任务管理器把其相关进程给杀了终于可以进去了通过研究解决办法如下oraclewu101:~ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 15 17:07:40 2013Copyright (c) 1982, 2011, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL show parameter processes;NAME TYPE VALUE------------------------------------ ----------- ------------------------------aq_tm_processes integer 1db_writer_processes integer 1gcs_server_processes integer 0global_txn_processes integer 1job_queue_processes integer 1000log_archive_max_processes integer 4processes integer 150SQL alter system set processes1500 scope spfile;System altered.SQL commit;Commit complete.SQL shutdown abort # 这个命令慎重执行若是在生产环境下还是用shutdown immediate比较好小白是自己的环境才如此暴力强制下线的。ORACLE instance shut down.SQL startupORACLE instance started.Total System Global Area 1603411968 bytesFixed Size 2228784 bytesVariable Size 1073745360 bytesDatabase Buffers 520093696 bytesRedo Buffers 7344128 bytesDatabase mounted.Database opened.SQL show parameter processes;NAME TYPE VALUE------------------------------------ ----------- ------------------------------aq_tm_processes integer 1db_writer_processes integer 1gcs_server_processes integer 0global_txn_processes integer 1job_queue_processes integer 1000log_archive_max_processes integer 4processes integer 1500windows上的oracle的pfile和spfile的路径在如下目录D:\app\Administrator\product\11.2.0\dbhome_1\database 今天给大家分享一个oracle问题的解决实例 如启动Oracle时提示“ORA-00600: internal error code, arguments”错误 SQL startup ORA-00600: internal error code, arguments: [ksunfy : too few sessions], [9504], [75040], [], [], [], [], [], [], [], [], []” 解决办法这里的错误说明Oracle的processes和sessions的值调的太大了。 1修改processes和sessions的值可先通过目前有问题的spfile创建成新的pfile因为pfile是文本文件它才打得开用以下命令创建create pfile from spfile;然后到D:\app\Administrator\product\11.2.0\dbhome_1\database下vim INIThlecard.ORA然后修改里面的值如下 *.processes10000 *.sessions10000 保存 2SQL create spfile from pfile File created. SQL startup ORACLE instance started. Total System Global Area 8.5516E10 bytes Fixed Size 2237776 bytes Variable Size 8858372784 bytes Database Buffers 7.6504E10 bytes Redo Buffers 151142400 bytes Database mounted. Database opened. 转载于:https://blog.51cto.com/liukexing/1973619
