Re: Internal connexion with SQLPLUS ?

Cedric,

I searched the Oracle's metalink technical forum and found that connect internal functionality through sqlplus was not working under Oracle 8.0.4 which you indicated you are using... There was a fix to this problem under Oracle 8.0.5.

In article <81g86t$kc7$1_at_news.imaginet.fr>,   "Cédric Avenas" <cedric.avenas_at_ad6.com> wrote:
> My REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED.
>
> perfect_golf_at_my-deja.com a écrit dans le message
> <81eiai$5qv$1_at_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.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 24 1999 - 10:07:03 CST