vs2015 访问oracle数据库,报8.17版本错误

版权声明:本文为博主原创文章,遵循 CC 4.0 by-sa 版权协议,转载请附上原文出处链接和本声明。
本文链接:https://blog.csdn.net/fivestar2009/article/details/80279108

这两天在调试vs2015访问oracle的问题,是别的公司的工程,拿过就报连接数据错误

解决“System.Data.OracleClient需要Oracle客户端软件8.1.7或更高版本
网上给了很多解决办法,都没有实现,最后原因是System.Data.OracleClient 的原因,把它替换成Oracle.ManagedDataAccess,就行了
展开阅读全文

打开oracle数据库报ora-01092;ora00704;ora00600错误

04-23

错误日志如下:rnrn1.alert_ora11.logrnrnMon Apr 23 15:25:04 2018rnAdjusting the default value of parameter parallel_max_serversrnfrom 1280 to 120 due to the value of parameter processes (150)rnStarting ORACLE instance (normal)rnLICENSE_MAX_SESSION = 0rnLICENSE_SESSIONS_WARNING = 0rnInitial number of CPU is 32rnNumber of processor cores in the system is 16rnNumber of processor sockets in the system is 2rnPicked latch-free SCN scheme 3rnMon Apr 23 15:25:23 2018rnUsing LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DESTrnAutotune of undo retention is turned off. rnLICENSE_MAX_USERS = 0rnSYS auditing is disabledrnNUMA system with 2 nodes detectedrnStarting up:rnOracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionrnWith the Partitioning, OLAP, Data Mining and Real Application Testing options.rnWindows NT Version V6.2 rnCPU : 32 - type 8664, 16 Physical CoresrnProcess Affinity : 0x0x0000000000000000rnMemory (Avail/Total): Ph:178047M/261741M, Ph+PgF:215729M/300653M rnUsing parameter settings in server-side spfile D:\APP\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEORA11.ORArnSystem parameters with non-default values:rn processes = 150rn sga_target = 78592Mrn control_files = "D:\APP\ORADATA\ORA11\CONTROL01.CTL"rn control_files = "D:\APP\FAST_RECOVERY_AREA\ORA11\CONTROL02.CTL"rn db_block_size = 8192rn compatible = "11.2.0.4.0"rn db_files = 600rn db_recovery_file_dest = "D:\app\fast_recovery_area"rn db_recovery_file_dest_size= 400Grn undo_management = "MANUAL"rn undo_tablespace = "UNDOTBS1"rn remote_login_passwordfile= "EXCLUSIVE"rn db_domain = "unicom.db2"rn dispatchers = "(PROTOCOL=TCP) (SERVICE=ora11XDB)"rn audit_file_dest = "D:\APP\ADMIN\ORA11\ADUMP"rn audit_trail = "DB"rn db_name = "ora11"rn open_cursors = 300rn pga_aggregate_target = 26174Mrn diagnostic_dest = "D:\APP"rnMon Apr 23 15:25:34 2018rnPMON started with pid=2, OS id=4924 rnMon Apr 23 15:25:34 2018rnPSP0 started with pid=3, OS id=2512 rnMon Apr 23 15:25:35 2018rnVKTM started with pid=4, OS id=4640 at elevated priorityrnVKTM running at (10)millisec precision with DBRM quantum (100)msrnMon Apr 23 15:25:35 2018rnGEN0 started with pid=5, OS id=4820 rnMon Apr 23 15:25:35 2018rnDIAG started with pid=6, OS id=2792 rnMon Apr 23 15:25:35 2018rnDBRM started with pid=7, OS id=4732 rnMon Apr 23 15:25:35 2018rnDIA0 started with pid=8, OS id=1564 rnMon Apr 23 15:25:35 2018rnMMAN started with pid=9, OS id=1688 rnMon Apr 23 15:25:35 2018rnDBW0 started with pid=10, OS id=4528 rnMon Apr 23 15:25:35 2018rnDBW1 started with pid=11, OS id=4480 rnMon Apr 23 15:25:35 2018rnDBW2 started with pid=12, OS id=3588 rnMon Apr 23 15:25:35 2018rnDBW3 started with pid=13, OS id=624 rnMon Apr 23 15:25:35 2018rnLGWR started with pid=14, OS id=2208 rnMon Apr 23 15:25:35 2018rnCKPT started with pid=15, OS id=3608 rnMon Apr 23 15:25:35 2018rnSMON started with pid=16, OS id=3376 rnMon Apr 23 15:25:35 2018rnRECO started with pid=17, OS id=4544 rnMon Apr 23 15:25:35 2018rnMMON started with pid=18, OS id=4288 rnMon Apr 23 15:25:35 2018rnMMNL started with pid=19, OS id=4740 rnMon Apr 23 15:25:35 2018rnstarting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...rnstarting up 1 shared server(s) ...rnORACLE_BASE from environment = D:\apprnMon Apr 23 15:25:35 2018rnALTER DATABASE MOUNTrnSuccessful mount of redo thread 1, with mount id 918190256rnDatabase mounted in Exclusive ModernLost write protection disabledrnCompleted: ALTER DATABASE MOUNTrnMon Apr 23 15:25:40 2018rnALTER DATABASE OPENrnBeginning crash recovery of 1 threadsrn parallel recovery started with 31 processesrnStarted redo scanrnCompleted redo scanrn read 0 KB redo, 0 data blocks need recoveryrnStarted redo application atrn Thread 1: logseq 17, block 3, scn 5833380769rnRecovery of Online Redo Log: Thread 1 Group 2 Seq 17 Reading mem 0rn Mem# 0: D:\APP\ORADATA\ORA11\REDO02.LOGrnCompleted redo application of 0.00MBrnCompleted crash recovery atrn Thread 1: logseq 17, block 3, scn 5833400770rn 0 data blocks read, 0 data blocks written, 0 redo k-bytes readrnMon Apr 23 15:25:48 2018rnLGWR: STARTING ARCH PROCESSESrnMon Apr 23 15:25:48 2018rnARC0 started with pid=54, OS id=4336 rnARC0: Archival startedrnLGWR: STARTING ARCH PROCESSES COMPLETErnARC0: STARTING ARCH PROCESSESrnMon Apr 23 15:25:49 2018rnARC1 started with pid=55, OS id=3684 rnMon Apr 23 15:25:49 2018rnARC2 started with pid=56, OS id=4956 rnMon Apr 23 15:25:49 2018rnARC3 started with pid=57, OS id=3356 rnARC1: Archival startedrnARC2: Archival startedrnARC1: Becoming the 'no FAL' ARCHrnARC1: Becoming the 'no SRL' ARCHrnARC2: Becoming the heartbeat ARCHrnThread 1 advanced to log sequence 18 (thread open)rnARC3: Archival startedrnARC0: STARTING ARCH PROCESSES COMPLETErnThread 1 opened at log sequence 18rn Current log# 3 seq# 18 mem# 0: D:\APP\ORADATA\ORA11\REDO03.LOGrnSuccessful open of redo thread 1rnMon Apr 23 15:25:51 2018rnMTTR advisory is disabled because FAST_START_MTTR_TARGET is not setrnMon Apr 23 15:25:51 2018rnSMON: enabling cache recoveryrnErrors in file D:\APP\diag\rdbms\ora11\ora11\trace\ora11_ora_5104.trc (incident=82985):rnORA-00600: 内部错误代码, 参数: [16703], [1403], [20], [], [], [], [], [], [], [], [], []rnIncident details in: D:\APP\diag\rdbms\ora11\ora11\incident\incdir_82985\ora11_ora_5104_i82985.trcrnArchived Log entry 289791 added for thread 1 sequence 17 ID 0x36b80a19 dest 1:rnUse ADRCI or Support Workbench to package the incident.rnSee Note 411.1 at My Oracle Support for error and packaging details.rnErrors in file D:\APP\diag\rdbms\ora11\ora11\trace\ora11_ora_5104.trc:rnORA-00704: 引导程序进程失败rnORA-00704: 引导程序进程失败rnORA-00600: 内部错误代码, 参数: [16703], [1403], [20], [], [], [], [], [], [], [], [], []rnErrors in file D:\APP\diag\rdbms\ora11\ora11\trace\ora11_ora_5104.trc:rnORA-00704: 引导程序进程失败rnORA-00704: 引导程序进程失败rnORA-00600: 内部错误代码, 参数: [16703], [1403], [20], [], [], [], [], [], [], [], [], []rnError 704 happened during db open, shutting down databasernUSER (ospid: 5104): terminating the instance due to error 704rnMon Apr 23 15:26:02 2018rnInstance terminated by USER, pid = 5104rnORA-1092 signalled during: ALTER DATABASE OPEN...rnopiodr aborting process unknown ospid (5104) as a result of ORA-1092rnMon Apr 23 15:26:11 2018rnORA-1092 : opitsk aborting processrnrnrn2.ora11_ora_5104.trcrnrnTrace file D:\APP\diag\rdbms\ora11\ora11\trace\ora11_ora_5104.trcrnOracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionrnWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsrnWindows NT Version V6.2 rnCPU : 32 - type 8664, 16 Physical CoresrnProcess Affinity : 0x0x0000000000000000rnMemory (Avail/Total): Ph:177945M/261741M, Ph+PgF:215586M/300653M rnInstance name: ora11rnRedo thread mounted by this instance: 1rnOracle process number: 22rnWindows thread id: 5104, image: ORACLE.EXE (SHAD)rnrnrn*** 2018-04-23 15:25:47.636rn*** SESSION ID:(177.3) 2018-04-23 15:25:47.636rn*** CLIENT ID:() 2018-04-23 15:25:47.636rn*** SERVICE NAME:() 2018-04-23 15:25:47.636rn*** MODULE NAME:(sqlplus.exe) 2018-04-23 15:25:47.636rn*** ACTION NAME:() 2018-04-23 15:25:47.636rn rnSuccessfully allocated 31 recovery slavesrnUsing 6 overflow buffers per recovery slavernrn*** 2018-04-23 15:25:47.776rnThread 1 checkpoint: logseq 17, block 2, scn 5833380767rn on-disk rba: logseq 17, block 3, scn 5833380769rn start recovery at logseq 17, block 3, scn 5833380769rnrn*** 2018-04-23 15:25:47.808rnStarted writing zeroblks thread 1 seq 17 blocks 3-10rnrn*** 2018-04-23 15:25:47.808rnCompleted writing zeroblks thread 1 seq 17rn==== Redo read statistics for thread 1 ====rnTotal physical reads (from disk and memory): 4096Kbrn-- Redo read_disk statistics --rnRead rate (ASYNC): 0Kb in 0.02s => 0.00 Mb/secrn----------------------------------------------rn----- Recovery Hash Table Statistics ---------rnHash table buckets = 1048576rnLongest hash chain = 0rnAverage hash chain = 0/0 = 0.0rnMax compares per lookup = 0rnAvg compares per lookup = 0/0 = 0.0rn----------------------------------------------rnrn*** 2018-04-23 15:25:47.808rnKCRA: start recovery claims for 0 data blocksrnrn*** 2018-04-23 15:25:47.808rnKCRA: blocks processed = 0/0, claimed = 0, eliminated = 0rnrn*** 2018-04-23 15:25:47.808rnRecovery of Online Redo Log: Thread 1 Group 2 Seq 17 Reading mem 0rnrn*** 2018-04-23 15:25:47.823rnCompleted redo application of 0.00MBrnrn*** 2018-04-23 15:25:47.823rnCompleted recovery checkpointrn----- Recovery Hash Table Statistics ---------rnHash table buckets = 1048576rnLongest hash chain = 0rnAverage hash chain = 0/0 = 0.0rnMax compares per lookup = 0rnAvg compares per lookup = 0/0 = 0.0rn----------------------------------------------rnRecovery sets nab of thread 1 seq 17 to 3 with 8 zeroblksrnrn*** 2018-04-23 15:25:51.589rnIncident 82985 created, dump file: D:\APP\diag\rdbms\ora11\ora11\incident\incdir_82985\ora11_ora_5104_i82985.trcrnORA-00600: 内部错误代码, 参数: [16703], [1403], [20], [], [], [], [], [], [], [], [], []rnrnORA-00704: 引导程序进程失败rnORA-00704: 引导程序进程失败rnORA-00600: 内部错误代码, 参数: [16703], [1403], [20], [], [], [], [], [], [], [], [], []rnORA-00704: 引导程序进程失败rnORA-00704: 引导程序进程失败rnORA-00600: 内部错误代码, 参数: [16703], [1403], [20], [], [], [], [], [], [], [], [], []rnrn*** 2018-04-23 15:25:52.323rnUSER (ospid: 5104): terminating the instance due to error 704rnrnrn3.ora11_ora_5104_i82985.trcrnrnDump continued from file: D:\APP\diag\rdbms\ora11\ora11\trace\ora11_ora_5104.trcrnORA-00600: 内部错误代码, 参数: [16703], [1403], [20], [], [], [], [], [], [], [], [], []rnrn========= Dump for incident 82985 (ORA 600 [16703]) ========rnrn*** 2018-04-23 15:25:51.589rndbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)rn----- Current SQL Statement for this session (sql_id=1h50ks4ncswfn) -----rnALTER DATABASE OPENrnrn----- Call Stack Trace -----rnrn 论坛

没有更多推荐了,返回首页