Re: Help for sql-oracle mode

[Anders Wirzenius]

Misskiss <misskiss.wang@gmail.com> writes:

> Tim X <timx@nospam.dev.null> writes:
> 
> > "misskiss wang" <misskiss.wang@gmail.com> writes:
> >
> > Can you access the database just running SQL-Plus? Oracle is natorious
> > for providing misleading error messages. For example, you will get that
> > same error message if you specify the wrong SID. The first thing I wold
> > do is try 
> >
> > sqlplus DB1
> >
> > and hit enter when prompted for the username and password. If that
> > works, then we know the problem isn't with Oracle and have to look
> > closer at sqlplus. 
> >
> > Tim
> >
> > P.S.
> >
> > I've never seen an Oracle database that didn't require a username - the
> > username determines the schema - I guess you can have one, just never
> > come across it before. 
> > -- 
> > tcross (at) rapttech dot com dot au
> >
> 
> Thanks a lot for the help! I tried "sqlplus DB1", it's the same problem,
> I still cannot login DB server. However, if I use a GUI tool to login
> the server, leave both user name and password as blank, I can login the
> server. It's really unconvininet for me... Is there any good solutions?
> 
> Thanks a lot!
> 
> Misskiss

Just my 2 cnts:
Maybe your network uses a single login system and your credentials
are fetched from the Active Domain when using a GUI tool?

-- 
Anders