Originally posted by diwakar
Dear Sir,
Even your option had been tried before and the output is as follows:


SQL> connect sys@dcbl as sysdba
Enter password:
Connected to an idle instance.
SQL> select * from v$instance;
select * from v$instance
*
ERROR at line 1:
ORA-01012: not logged on


SQL>


So how to go about from this point??

Regards,

K.Diwakar
Your connected to an idle instance, start the DB before you select from DD views.

HTH