Re: Can't sqlplus /

Hi,

Maybe a late answer. SQLPLUS / is used for users which are identified externally ( Create user <username> identified externally. for example In this way it is possible to have the OS handle security.

Hope it helps :-)

James-TK Low wrote:

> Hi, after setting the password file as suggested by you.
>
> "sqlplus /" still does not works. But "sqlplus internal" does, so an
> improvement.
>
> K.Vinayak's solution will make "sqlplus /" work.
>
> But only after granting connect to ops$oracle.
>
> So, thanks for all the help.
>
> Regards,
> James
>
> John Chiu wrote:
> >
> > Have you setup your password file by running orapwd?
> >
> > John Chiu
> >
> > James-TK Low <jameslow_at_cls.uob.com.sg> wrote in message
> > news:381EA2B3.A152E5E1_at_cls.uob.com.sg...
> > > Hi, sorry to ask this basic question.
> > >
> > > I have just installed Oracle 8i on solaris with account=oracle8i, and
> > > group=dba8i.
> > >
> > > When I logged in to oracle8i, I can't just use "sqlplus /" to get into
> > > the sys. But doing a "svrmgrl" and then, "connect internal" is ok.
> > >
> > > I have another Oracle 8.0.5 installion elsewhere (not set up by me of
> > > course) and "sqlplus /" works.
> > >
> > > Does anyone know why?
> > >
> > > Thanks for any info.
> > >
> > > Regards,
> > > James

--
Met vriendelijke groet,

Geert Roelof van der Ploeg

grploeg_at_orion-it.nl
grploeg_at_xs4all.nl Received on Sun Nov 14 1999 - 18:02:50 CST