cannot connect as ssys

From: Pradeep <agarwalp_at_eeism.com>
Date: 14 Jan 2006 00:19:02 -0800
Message-ID: <1137226742.033420.193640@g14g2000cwa.googlegroups.com>

SVRMGR> connect sys/change_on_install_at_orcl ORA-01034: ORACLE not available
SVRMGR> connect sys/change_on_install
ORA-01034: ORACLE not available
SVRMGR> connect internal
Password:
ORA-01031: insufficient privileges
SVRMGR> connect internal
Password:
Connected.
SVRMGR> select * from v$instance

     2> ;
select * from v$instance
*
ORA-01034: ORACLE not available
SVRMGR> startup
ORACLE instance started.

Total System Global Area                          4915200 bytes
Fixed Size                                          49152 bytes
Variable Size                                     4587520 bytes
Database Buffers                                   204800 bytes
Redo Buffers                                        73728 bytes

Database mounted.
Database opened.
SVRMGR> select * from all objects;
select * from all objects

*

ORA-00903: invalid table name
SVRMGR> select * from all_objects;
select * from all_objects

*

ORA-00942: table or view does not exist

issues
1. all_objects does not exist.
2. not able to connect as sysdba

Kindly help
Thanks
Pradeep Received on Sat Jan 14 2006 - 02:19:02 CST