Oracle conn 协议适配器错误解决

Oracle conn 协议适配器错误 --解决方法
C:Documents and Settingsadministrator>set oracle_sid=myoracleC:Documents and Settingsadministrator>sqlplus /nologSQL*Plus: Release 10.2.0.1.0 - Production on 星期三 12月 26 09:47:16 2012Copyright （c） 1982, 2005, Oracle. All rights reserved.SQL> conn sys/mima as sysdba
已连接。SQL>
已连接。
SQL> desc v$log
名称是否为空？类型
----------------------------------------- -------- ---------------------------- GROUP# NUMBER
THREAD# NUMBER
SEQUENCE# NUMBER
BYTES NUMBER
MEMBERS NUMBER
ARCHIVED VARCHAR2（3）
STATUS VARCHAR2（16）
FIRST_CHANGE# NUMBER
FIRST_TIME DATESQL> select archived status first_change# from v$log;
select archived status first_change# from v$log
*
第 1 行出现错误:
ORA-00923: 未找到要求的 FROM 关键字
SQL> select archived, status, first_change# from v$log;ARC STATUS FIRST_CHANGE#
--- ---------------- -------------
NO INACTIVE 8776731
NO INACTIVE 8824917
NO CURRENT 8848969SQL> archive log list;
数据库日志模式存档模式
自动存档启用
存档终点 USE_DB_RECOVERY_FILE_DEST
最早的联机日志序列 269
下一个存档日志序列 269
当前日志序列 272
SQL> select thread,archived, status, first_change# from v$log;
select thread,archived, status, first_change# from v$log
*
第 1 行出现错误:
ORA-00904: "THREAD": 标识符无效
SQL> select thread#,archived, status, first_change# from v$log; THREAD# ARC STATUS FIRST_CHANGE#
---------- --- ---------------- -------------
1 NO INACTIVE 8776731
1 NO INACTIVE 8824917
1 NO CURRENT 8848969SQL> show parameter db_recoveryNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string C:/flash_recovery_area
db_recovery_file_dest_size big integer 2G
SQL> startup
ORA-01081: 无法启动已在运行的 ORACLE - 请首先关闭它
SQL> show parameter log_archive_dest;NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest string
log_archive_dest_1 string
log_archive_dest_10 string
log_archive_dest_2 string
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
log_archive_dest_9 stringNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
SQL> archive log list

Hibernate 注解案例更新Oracle表的统计信息 GATHER_TABLE_STATS相关资讯 Oracle conn Oracle适配器错误协议适配器错误 Oracle入门教基础教程本文评论查看全部评论（0）