oracle conn 协议适配器错误-已解决

oracle conn 协议适配器错误 --解决方法

C:\Documents and Settings\administrator>set oracle_sid=myoracle

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>