Re: cannot connect as ssys

On 14 Jan 2006 00:19:02 -0800, "Pradeep" <agarwalp_at_eeism.com> wrote:

>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

• No version
• server manager has been desupported since ages
• connect internal has been deprecated and doesn't exist anymore in 9i
• the correct syntax to connect as sys in 9i is connect sys/<password> as sysdba This also works on 8i
• you should change all default passwords
• connect / as sysdba should work always
• You really need to start reading those manuals asap.

--
Sybrand Bakker, Senior Oracle DBA