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 09:49:11 +0100
Message-ID: <81g86t$kc7$1@news.imaginet.fr>


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.
Received on Wed Nov 24 1999 - 02:49:11 CST

Original text of this message

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