RE: Root to connect as system

Hi,

I have managed to make it work. On a HP-UX box I can get root to connect as internal, system and whatever else I please. It can run scripts, shutdown and startup and do whatever u want.

I know this is a "no-no" but I really did not have a choice in the matter. The stupid application only wanted root to run some create schema and create table scripts.

Cheers,

Sujatha

-----Original Message-----
Sent: Wednesday, 31 October 2001 5:10 AM To: Multiple recipients of list ORACLE-L

Joe:

I have a vague, hazy recollection of that as well. Way back under v6 (when men
were men and sheep were nervous :-) ), I think I recall reading that the root user
was forbidden to do a "connect internal" to the database even if a member of the
"dba" group. I remember having to setup an account to be used, but that may have
been specific to our port (DEC Ultrix).

Ahhhhh, yes. The days of SQL*DBA (didn't even have to "connect internal" to startup/shutdown the database back then). . .

Actually, I just ran a really quick test under Linix and it wouldn't take. This
was under v8.1.7. I will have to get access to some other systems tonight to see
if it is true for v7/v9 and other OS's such as Solaris and HP-UX.

Joe Testa wrote:

> my question is "why are you insisting on root logging into the
> database???" create a new userid to do the connection.
>
> i thought i remembered somewhere about root not being able to login,
> maybe that was back and hardcoded for svrmgrl.
>
> joe
>
> Sujatha Madan wrote:
> >
> > Ok, I have solved the issue of the listener, however I still cannot get
root
> > to log on as system.
> >
> > - My Oracle home is set correct
> > - My Oracle sid is set correct
> > - ld library path is correct
> > - other path;s are correct
> >
> > does anyone have an idea on how to fix this?
> >
> > thanx
> >
> > -----Original Message-----
> > Sent: Tuesday, 30 October 2001 1:40 PM
> > To: Multiple recipients of list ORACLE-L
> >
> > I have set the SID correct and all the environment variables correctly.
What
> > I didn't do was set up the listener and tnsnames. However, when I am
trying
> > to set up the listener, for some reason it is not able to find the
> > executables. It is looking in a different directory. The Oracle Home is
set
> > correctly.
> >
> > -----Original Message-----
> > Sent: Tuesday, 30 October 2001 12:20 PM
> > To: Multiple recipients of list ORACLE-L
> >
> > Looks like your oracle sid is set incorrectly and you
> > are trying to connect without using a tns service name
> >
> > Deepak
> >
> > PS: have you set the env variables .. type env at the
> > unix prompt and check if PATH /ORACLE_HOME/
> > LD_LIBRARY_PATH are set correctly
> >
> > --- Sujatha Madan <sujatha.madan_at_cmc.cwo.net.au>
> > wrote:
> > > Hi,
> > >
> > > How can I allow root to connect to the database as
> > > system. At the moment
> > > when I try this, I keep getting a ORA-01034: Oracle
> > > not available error,
> > > even though the database is up and running fine.
> > >
> > > Regards,
> > >
> > > Sujatha
> > > --
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > --
> > > Author: Sujatha Madan
> > > INET: sujatha.madan_at_cmc.cwo.net.au
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX:
> > > (858) 538-5051
> > > San Diego, California -- Public Internet
> > > access / Mailing Lists
> > >
> > --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an
> > > E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > > 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB
> > > ORACLE-L
> > > (or the name of mailing list you want to be removed
> > > from). You may
> > > also send the HELP command for other information
> > > (like subscribing).
> >
>
> --
> Joe Testa
> Performing Remote DBA Services, need some backup DBA support?
> For Sale: Oracle-dba.com domain, its not going cheap but feel free to
> ask :)
> IM: n8xcthome or joen8xct
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Joe Testa
> INET: teci_at_the-testas.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

--
====================================================================
Byron Pearce                         mailto:bpearce_at_tenure.com
Tenure Systems, Inc.                 Arlington, Texas

"It's hard to be a ninja when you wear a beeper."


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Byron Pearce
  INET: bpearce_at_tenure.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sujatha Madan
  INET: sujatha.madan_at_cmc.cwo.net.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).