Oracle conn protocol adapter error resolution

Oracle conn protocol adapter error-Solution

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

C: \ Documents ents and Settings \ administrator> sqlplus/nolog

SQL * Plus: Release 10.2.0.1.0-Production on Wednesday December 26 09:47:16 2012

Copyright (c) 1982,200 5, Oracle. All rights reserved.

SQL> conn sys/mima as sysdba
Connected.

SQL>

 

Connected.
SQL> desc v $ log
Is the name empty? Type
-----------------------------------------------------------------------------

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
*
Row 3 has an error:
ORA-00923: the requested FROM keyword not found

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;
Database Log mode archiving Mode
Enable automatic archiving
Archiving end point USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 269
Next archive log sequence 269
Current Log sequence 272
SQL> select thread, archived, status, first_change # from v $ log;
Select thread, archived, status, first_change # from v $ log
*
Row 3 has an error:
The ORA-00904: "THREAD": the identifier is invalid.

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: unable to start ORACLE that is already running-Close it first
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

1 2 Next Page