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: Cédric Avenas <cedric.avenas_at_ad6.com>
Date: Wed, 24 Nov 1999 18:08:58 +0100
Message-ID: <81h5gh$4vu$1@news.imaginet.fr>


Great thanks for your help !
Discuss with you was really a pleasure.

                        Cedric (a happy guy).

perfect_golf_at_my-deja.com a écrit dans le message <81h2f4$vbn$1_at_nnrp1.deja.com>...
>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 - 11:08:58 CST

Original text of this message

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