Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Internal connexion with SQLPLUS ?

Re: Internal connexion with SQLPLUS ?

From: <perfect_golf_at_my-deja.com>
Date: Tue, 23 Nov 1999 17:19:21 GMT
Message-ID: <81eiai$5qv$1@nnrp1.deja.com>


Hi There,

Cedric, Can you tell me your REMOTE_LOGIN_PASSWORDFILE parameter setting within your init???.ora file.

In article <81dmph$i3e$1_at_news.imaginet.fr>,   "Cédric Avenas" <cedric.avenas_at_ad6.com> wrote:
> Thanks a lot for your attention.
> But when I retry it's the same way.
>
> I explain you in more details what it happens:
>
> Connection by SQLPLUS:
> - What I do:
> SQL> connect internal/password_at_alias
> - SQL Message:
> ORA-01031 insufficient privileges
> Obviously, it doesn't work.
>
> Connection by SQL Worksheet (Windows mode):
> - What I do:
> Connection by the same connect string as SQLPLUS
> - SQL Worksheet Message:
> "Connected but no version information available"
> But it works when I query the V$LOGFILE table for example.
>
> My Oracle & OS configuration:
> Windows NT 4
> Oracle 8.0.4.0.0
>
> Thanks for your spent time...
>
> perfect_golf_at_my-deja.com a écrit dans le message
> <813rrj$qo0$1_at_nnrp1.deja.com>...
> >In article <813i3e$keb$1_at_news.imaginet.fr>,
> > "Cédric Avenas" <cedric.avenas_at_ad6.com> wrote:
> >> Can I connect to database with Internal user by SQLPLUS ?
> >> When I try, it doesn't work.
> >>
> >> It works with SQL Worksheet and I can query the database.
> >>
> >> Thanks..
> >>
> >> Hi there,
> >
> >I tried connecting to internal in SQLPLUS and it works...
> >How did you try to connect???
> >At the SQL Prompt, I keyed the following:
> >SQL> connect internal/xxxxx_at_zzzzz
> >
> >Note: fill in your internal password where xxxxx
> > fill in your host string where zzzzz
> >
> >
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 23 1999 - 11:19:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US