日期:2014-05-17  浏览次数:20850 次

oracel 8.1.6 客戶端無法登陸
您好!
下面是我数据库的配置文件

instance_name = cfntorcl
service_names = cfntorcl
db_files = 1024
control_files = ("D:\oracle\oradata\cfntorcl\control01.ctl", "D:\oracle\oradata\cfntorcl\control02.ctl", 
"D:\oracle\oradata\cfntorcl\control03.ctl")
open_cursors = 600
max_enabled_roles = 30
db_file_multiblock_read_count = 8
db_block_buffers = 119807
shared_pool_size = 327155711
large_pool_size = 614400
java_pool_size = 20971520
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
processes = 815
parallel_max_servers = 5
log_buffer = 32768
max_dump_file_size = 10240 # limit trace file size to 5M each
global_names = true
oracle_trace_collection_name = ""
background_dump_dest = D:\oracle\admin\cfntorcl\bdump
user_dump_dest = D:\oracle\admin\cfntorcl\udump
db_block_size = 8192
remote_login_passwordfile = exclusive
os_authent_prefix = ""
job_queue_processes = 4
job_queue_interval = 60
open_links = 4
distributed_transactions = 10
mts_dispatchers = "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
compatible = 8.1.0
sort_area_size = 65536
sort_area_retained_size = 65536


环境是 window server 2003 32bit + oracle 8.16
4G 內存

最近一段時間以來(可能是客戶端開始增加的原因),每次差不多SESSESION 達到了 460多個的時候,
就出現無法登陸或者監聽服務死掉,但如果每次把服務器重新啟動一下,就又能有2天時間不會出現問題。
過了兩天就差不多又出現同樣問題。
查看日誌有如下錯誤:

Wed Mar 31 11:57:15 2010
Errors in file D:\oracle\admin\cfntorcl\udump\ORA03848.TRC:
ORA-00600: 內部錯誤碼, 參數: [12333], [7], [3], [75], [], [], [], []



找到 ORA03848.TRC 又有如下問題,
還有其他問題,但篇幅有限
*** SESSION ID:(83.291) 2010-03-31 11:57:15.376
*** 2010-03-31 11:57:15.376
ksedmp: internal or fatal error
ORA-00600: 內部錯誤碼, 參數: [12333], [7], [3], [75], [], [], [], []
Current SQL information unavailable - no session.
----- Call Stack Trace -----



肯請指點,應該如何去解決,謝謝!


------解决方案--------------------
ORA-00600,噶经典的错误。


有没有metalink帐号?建议上去查查。