Re: Can't start Oracle (Linux) instances...

From: Kasper Myram <kasper_at_ecovisor.com>
Date: Fri, 30 Mar 2001 10:08:36 +0200
Message-ID: <9a1ep0$81m$1@news.inet.tele.dk>

"Adam Moore" <adam_at_foo.sweet.as> wrote in message news:slrn9c7f2n.sgg.adam_at_foo.sweet.as...
> >Not even sys har 'suffecient priviledges' to start the instances, and I'm
> >pretty much locked out.
> >I can though connect internal as the user 'oracle' and fire off 'startup'
> >but it doesn't do any difference :(
> Paste the error you're getting. You might also want to have a look at
> $ORACLE_BASE/admin/SID/bdump/alert_SID.log - it's probably giving a more
> helpful error message.

km_at_sydpolen:~$ svrmgrl

Oracle Server Manager Release 3.1.6.0.0 - Production

Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production With the Partitioning option
JServer Release 8.1.6.0.0 - Production

SVRMGR> connect internal
Password:
ORA-01031: insufficient privileges
SVRMGR>

This is NOT true... or shouldn't be! :) User 'km' is member of group 'dba' and should be able to connect internal. Not even root can do a connect internal!
Well, I can connect internal and do a startup with user 'oracle' (who BTW is owner), but take a look at this:

km_at_sydpolen:~$ sqlplus webdev/password_at_instance

SQL*Plus: Release 8.1.6.0.0 - Production on Fri Mar 30 10:01:01 2001

ERROR:
ORA-01034: ORACLE not available

Enter user-name:

NOT TRUE! User 'oracle' har indeed started Oracle, and root has started listener-service... WHY can't I connect then?!

I'm blank...

Kasper

Received on Fri Mar 30 2001 - 02:08:36 CST