Re: Beginner Connection problem (simple maybe?)

Andy wrote:

> I have two connection issues which may be related (I don't know!)
>
> On (windows2000) The server
> a) I can log onto the server as the administrator and connect to the
> Oracle 9i DB using the system login
> b) If I log onto the server as anyone else (e.g. Domain administrator)
> I cannot log on to sqlplus or create a dsn (using the system login),
> due to the following error
> Unable to connect
> SQLState=08501
> ORA-03113: end-of-file on communication channel
>
> From a client
> (Windows NT4, Oracle Client drivers 9.02.00.00)
> If I attempt to create a DSN (using system login) to connect to the
> Oracle server, I get the following
> Unable to connect
> SQL State=S1000
> Ora-12545: Connect failed because target host or object does not
> exist
>
> Does anybody have any ideas?
> This is a default 9i installation, and I was not aware of any
> installation errors when i installed it.
>
> Many thanks in advance, Andy Smith

What product are you using to attempt to log into Oracle 9i?

It sure isn't SQL*Plus.

My guess is that you are not logging in as the user that installed the Oracle software. Why not?

Daniel Morgan Received on Thu Feb 13 2003 - 17:33:54 CST