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: Connect with SQL*Plus 3.3

Re: Connect with SQL*Plus 3.3

From: <fuocor_at_novachem.com>
Date: 1997/04/05
Message-ID: <33469a6a.7173699@news.htw-zittau.de>#1/1

is there possibly an entry in the product_profile table for column "product = "SQL*PLUS" that is preventing users from logging on?, or is there a profile being added to each user at creation that might be limiting a resource. Just some ideas. I have never ran into this problem.

Regards,
Richard Fuoco

On Sat, 05 Apr 1997 01:01:37 GMT, John_Steven.Remus_at_akh-wien.ac.at (John Remus) wrote:

>I got a problem with the connection via SQL*Plus 3.3 to a Oracle7
>Workgroup Server DB 7.3.2.2.1 on a NT 4.0 Server.
>
>Its impossible to connect with any user exept 'system'.
>If I try (for example with 'Scott') the SQL*Plus window writes the
>first two default lines out:
>
>SQL*Plus:Release 3.3.2.0.2 - Production.......
>Copyright (c) Oracle Coporation......
>
>and nothing else.
>After this I can only terminate the task.
>It makes no difference if I try from a client or on the
>server-machine.
>If I connect with 'system'...no problem.
>With any other tool I can connect with every user from any client.
>
>First I've executed 'catalog.sql' + 'catproc.sql' but nothing changes.
>Then I've installed the whole DB new....same problem.
>
>Thank's in advance for help !
Received on Sat Apr 05 1997 - 00:00:00 CST

Original text of this message

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