Re: cannot connect as ssys

Anno Domini 14-1-2006 9:19, Pradeep sprak aldus:
> 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
>
>

I think you can connect as sys, but apparantly YOU do not know how to do that.

# svrmgrl
SVRMGR> connect internal

or

# sqlplus "/ as sysdba"

or

# sqlplus "sys/<password> as sysdba"

The datadictionary view you were trying to access is probably "ALL_OBJECTS". Do not forget the underscore in its name. Received on Sat Jan 14 2006 - 03:16:14 CST