Sql Plus 登录时出现下面的错误。 当连接数达到326后,建立新的连接的时候出现下面的错误: ora-12500: TNS:监听程序无法启动专用服务器进程 已经存在的连接可以正常使用。 请问要改那些参数呀,谢谢!
by ghyang660518 - Oracle - 2005-10-25 11:19:46 阅读(2758) 回复(3)
oracle log: LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up oraCLE RDBMS Version: 10.1.0.2.0. System parameters with non-default values: processes = 300 sessions = 335 __shared_pool_size = 83886080 __large_pool_size = 4194304 __java_pool_size = 8388608 nls_language = SIMPLIFIED CHINESE nls_territory ...
错误信息是: ora-27123: unable to attach to shared memory segment IBM AIX RISC System/6000 Error: 13: Permission denied 更改init文件,将原来的shared_pool_size从30000000改为30000000之后, 还出错: ora-01078: failure in processing system parameters 过程是:将f80上的8.1.6克隆到一台s85,s85上面原来有8.1.7两套 请大侠帮忙,感激不尽!!
[code]$ sqlplus '/as sysdba' SQL*Plus: Release 9.2.0.1.0 - Production on Fri Jan 14 10:22:31 2011 Copyright (c) 1982, 2002, oracle Corporation. All rights reserved. Connected to an idle instance. SQL> startup mount oraCLE instance started. Total System Global Area 3742858704 bytes Fixed Size 740816 bytes Variable Size 1677721600 bytes Database Buffers 2063597...
ora9i 下修改数据库的语言,ora-00600: 无法启动数据库 在Linux AS4.0, ora9i 下修改数据库的语言: SQL>;update props$ set value$='AL16TF16' where name='NLS_CHARACTERSET'; 发现数据库只能mount,不能Open, 错误如下:ora-00444: background process "QMN0" failed while starting ora-00600: internal error code, arguments: [], [], [], [], [], [], [], [] 即使是sys user 也不能对数据库做任何操作 :em16:
我的数据库有2个实例,我shutdown immediate时会报以下错误呢?? ora-00106: 无法在连接到调度程序时启动/关闭数据库 我郁闷,我只有从起机器!!!!!
我sys/sys@ldp shutdown immediate为什么老报ora-00106: 无法在连接到调度程序时启动/关闭数据库呢?我的机器有2个实例名,难道会影响? 哪位大哥能帮忙
我在sql>;下执行 sql>; conn 用户名/密码@db_name as sysdba 已连接 sql>;shutdown ora-00106错误:无法在连接调度程序时启动或关闭数据库 请问该如何解决? 谢谢!
在sco unix 5.0.7 上安装了oracle 7.3.4后,用 lsnrctl start 成功启动了监听进程,可在用oracle client 8.0.5连接不上,错误如下: Connecting.... The test did not succeed. ora-12500: TNS:监听器无法启动专用服务器进程 There may be an error in the fields entered or the server may not be ready for a connection. You can check the server and retry, or continue.