Re: Problems Connecting Oracle database XSQL and/or JSP via apache

> To connect with "/ as sysdba" the OS User must have the group ORADB
> wich can be assigned with computermanagement in the controlpanel.
>
> The oracle installation presumably was made by the OS user administrator
> which is correct for Windows (hey while writing I realize that this is
> something
> I learned at least two years ago, might be outdated information!),
> but afterwards perhaps you tried a different user account?
>
> try the following sequence in sqlplus:
>
> c:\sqlplus scott/tiger_at_yourdb
>
> [..]
> connected
> sqlplus> connect sys/<yoursyspwd>@yourdb as sysdba
> connected
> sqlplus>
>
> and that should get you on. The connect "/ as sysdba" only works if
> the OS User is privileged to connect without a password. Administrator
> usually is, other users by default are not.
>
> You only want to log on as sys or system when doing database
> maintainance,
> not for simple test purpose, though.
>
> Hope this helps
>
> Holger

THANKS A LOT :-D IT FINALLY WORKS! You would not believe how many hours I have spent trying to resolve this problem. I can now get on with my disertation!

Cheers to everybody who helped!

Mark Starmer Received on Wed Oct 30 2002 - 04:37:24 CST