Home » RDBMS Server » Server Administration » Keeping get ORA-12571 error, instance crashes
| Keeping get ORA-12571 error, instance crashes [message #57440] |
Mon, 16 June 2003 07:55 |
Michael Zhang
Messages: 5
Registered: April 2002
|
Junior Member |
|
|
Dear all,
My envireoment is :
Two-node RAC
OS: Windows 2000 Advance Server with Service Pack3
Oracle: 9iRAC9.2.0.1.0 with 9.2.0.3 Patchset
RAM:2GB
NIC:GB NICs
This morning, customer reported that they can not connect to database occasionally at 10:02. I checked alert1.log, found that there is a ORA-12571. At 11:24, user reported then could not connect to database completely. There are many ORA-12571 errors. This is the secondary crash in two days. The follow is the instance1's init file:
*.background_dump_dest='Y:oracleadminentranzbdump'
*.cluster_database_instances=2
*.cluster_database=TRUE
*.compatible='9.2.0.1.0'
*.control_files='\.control01','\.control02'
*.core_dump_dest='Y:oracleadminentranzcdump'
*.db_block_size=8192
*.db_cache_size=314572800
*.db_domain=''
*.db_file_multiblock_read_count=32
*.db_keep_cache_size=8388608
*.db_name='entranz'
*.db_recycle_cache_size=8388608
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
entranz2.instance_name='entranz2'
entranz1.instance_name='entranz1'
entranz2.instance_number=2
entranz1.instance_number=1
*.java_pool_size=33554432
*.job_queue_processes=2
*.large_pool_size=134217728
entranz1.local_listener='LISTENER_ENTRANZ1'
entranz2.local_listener='LISTENER_ENTRANZ2'
entranz1.log_archive_dest_1='LOCATION=Y:oracleORADATAENTRANZarchive_1'
entranz2.log_archive_dest_1='LOCATION=Y:oracleORADATAENTRANZarchive_2'
*.log_archive_format='%t_%s.dbf'
*.log_archive_start=true
*.log_buffer=1572864
entranz1.O7_DICTIONARY_ACCESSIBILITY=TRUE
entranz2.O7_DICTIONARY_ACCESSIBILITY=TRUE
*.open_cursors=1000
*.parallel_automatic_tuning=TRUE
*.pga_aggregate_target=100663296
entranz1.PROCESSES=1500#LARGE
entranz2.PROCESSES=1500#LARGE
*.query_rewrite_enabled='FALSE'
*.remote_listener='LISTENERS_ENTRANZ'
*.remote_login_passwordfile='exclusive'
*.SESSIONS=1655
entranz1.shared_pool_size=134217728
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
entranz2.thread=2
entranz1.thread=1
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=21600
entranz1.undo_tablespace='UNDOTBS1'
entranz2.undo_tablespace='UNDOTBS2'
*.user_dump_dest='Y:oracleadminentranzudump'
The trace file is like:
Redo thread mounted by this instance: 1
Oracle process number: 101
Windows thread id: 2720, image: ORACLE.EXE
*** 2003-06-15 11:19:55.000
*** SESSION ID:(281.234) 2003-06-15 11:19:55.000
FATAL ERROR IN TWO-TASK SERVER: error = 12571
*** 2003-06-15 11:19:55.000
ksedmp: internal or fatal error
Current SQL statement for this session:
Select Active_Flag, Address, Attribute_01, Attribute_02, Attribute_03, Attribute_04, Attribute_05, Attribute_06, Attribute_07, Attribute_08, Attribute_09, Attribute_10, Birthday, City, Country_Or_Territory_Code, Country_or_Territory_ID, Country_Or_Territory_Name, Default_Language_ID, Full_Name, Hashed_Password, Internal_Note, Login_Name, Message_At_Login, Password_Answer, Password_Question, Personal_Government_Identifier, Postal_Code, Primary_Email, Province, Registered_From_IP, Secondary_Email, Sex, System_User_ID, User_Account_ID, Ban_Start, Ban_End, Created_Date from User_Account_D
Any one can help me?
Thanks a lot.
|
|
|
|
Goto Forum:
Current Time: Fri Sep 20 08:26:07 CDT 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
