oracle conn 协议适配器错误 --解决方法
C:\Documents and Settings\administrator>sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on 星期三 12月 26 09:47:16 2012
Copyright (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 DATE
SQL> 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 8848969
SQL> 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 8848969
SQL> show parameter db_recovery
NAME 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 string
NAME 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
数据库日志模式 存档模式
自动存档 启用
存档终点 USE_DB_RECOVERY_FILE_DEST
最早的联机日志序列 269
下一个存档日志序列 269
当前日志序列 272
SQL> desc v$flash_recovery_area_usage;
名称 是否为空? 类型
----------------------------------------- -------- ----------------------------
FILE_TYPE VARCHAR2(12)
PERCENT_SPACE_USED NUMBER
PERCENT_SPACE_RECLAIMABLE NUMBER
NUMBER_OF_FILES NUMBER
SQL> select * v$flash_recovery_area_usage;
select * v$flash_recovery_area_usage
*
第 1 行出现错误:
ORA-00923: 未找到要求的 FROM 关键字
SQL> select * from v$flash_recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE 0 0 0
ONLINELOG 0 0 0
ARCHIVELOG 99.75 0 179
BACKUPPIECE 0 0 0
IMAGECOPY 0 0 0
FLASHBACKLOG 0 0 0
已选择6行。
SQL> select sum(PERCENT_SPACE_USED)*3/100 from v$flash_recovery_area_usage;
SUM(PERCENT_SPACE_USED)*3/100
-----------------------------
2.9925
SQL> show parameter recovery
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string C:/flash_recovery_area
db_recovery_file_dest_size big integer 2G
recovery_parallelism integer 0
SQL> rman
SP2-0042: 未知命令 "rman" - 其余行忽略。
SQL> select * from v$flash_recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE 0 0 0
ONLINELOG 0 0 0
ARCHIVELOG 99.75 0 179
BACKUPPIECE 0 0 0
IMAGECOPY 0 0 0
FLASHBACKLOG 0 0 0
已选择6行。
SQL>