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

User oracle should start the listener. What is listener.ora set as? What is oracle_home in oratab set as?

"Kasper Myram" <kasper_at_ecovisor.com> wrote in message news:9a1ep0$81m$1_at_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
>
> Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
>
> 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
>
> (c) Copyright 1999 Oracle Corporation. All rights reserved.
>
> 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 Mon Apr 02 2001 - 06:22:54 CDT