Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Connect with SQL*Plus 3.3
fuocor_at_novachem.com wrote:
>
> 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 !
I can't remember if catalog.sql runs pupbld.sql...
When you log in as system. Did you check Scott's connect/resource priv's? Received on Mon Apr 07 1997 - 00:00:00 CDT