Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Connect with SQL*Plus 3.3
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