Re: cannot connect as ssys

From: <fitzjarrell_at_cox.net>
Date: 14 Jan 2006 12:17:32 -0800
Message-ID: <1137269852.388658.70370@g47g2000cwa.googlegroups.com>

Comments embedded.
Pradeep 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

Reading the manual for this error would explain much, had you taken the time to do so:

/export/home/oracle> oerr ora 1034
01034, 00000, "ORACLE not available"
// *Cause: Oracle was not started up. Possible causes include the following:

//         - The SGA requires more space than was allocated for it.
//         - The operating-system variable pointing to the instance is
//           improperly defined.
// *Action: Refer to accompanying messages for possible causes and
correct
//          the problem mentioned in the other messages.
//          If Oracle has been initialized, then on some operating
systems,
//          verify that Oracle was linked correctly. See the platform
//          specific Oracle documentation.

> 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
>

I would shutdown the instance and restart it:

SVRMGR> shutdown immediate
Database closed.
Database dismounted.
SVRMGR> startup nomount
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

SRVMGR> alter database mount exclusive;
Database mounted.
SVRMGR> alter database open;
Database opened.
SVRMGR> shutdown immediate
Database closed.
Database dismounted.
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;
....

If this doesn't restore the ALL_OBJECTS view you have a seriously broken database which needs to be dropped and recreated. Of course, you provide absolutely NO version information, nor any platform, so it is virtually impossible to assist you further. And, the use of svrmgrl indicates a release of 8.1.7 or earlier, although 8i should be managed through sqlplus, not svrmgrl. Also, CONNECT INTERNAL was last seen in 8.1.7.4; it no longer exists. Obviously, from this output, you are running a desupported release of Oracle; one can only guess as to the reason for this.

> issues
> 1. all_objects does not exist.

See above.

> 2. not able to connect as sysdba

Most certainly you can:

SVRMGR> connect internal
Password:
Connected.

What, exactly, do you think INTERNAL represents if not SYS as SYSDBA? You are clearly in dire need of reading, quite carefully, the Concepts Guide, followed by the Administration Guide, for your particular release.

>
> Kindly help

Kindly post useful items such as Oracle version and operating system as posts such as yours, absent such data, are essentially wastes of bandwidth for all concerned. You've been provided as much help as is possible given the dearth of information in your post. Submit a proper question, including all pertinent details, if you want any sort of usable response outside of pure speculation.

> Thanks
> Pradeep

David Fitzjarrell Received on Sat Jan 14 2006 - 14:17:32 CST