Re: Unable to use Oracle

"Daz" <dhutchison_at_freeuk.com> wrote in message news:pdze7.211152$cc1.10929493_at_nnrp3.clara.net...
>
> Hello everyone.
>
>
> I'm having some trouble with a user connecting to an Oracle database.
>
> He's getting the error below, after typing in his username and password
>
> 'Database Access was Denied Error(EDB42):ORA-12203: TNS: unable to connect
> to destination'
>
> He uses a static ip address for this system which appears to be configured
> correctly. All other applications on his system work ok.
> It doesn't seem to be a permissions/password problem as any user
> credentials come back with the same message. It has been six months since
> the user has accessed the system. He does have a new laptop, but is still
> using his old hard disk which was swapped in from his old faulty one.
>
> The database is not in a remote location, but resides on his laptop. His
tns
> config file appears to be correctly configured for local host.
> He can ping other Oracle servers on the external network successfully.
>
> Can anyone help? Thanks in advance.
>
>
>
>

This is sqlnet problem. However if Oracle was correctly setup on that laptop he wouldn't have had to use sqlnet at all. Check whether he has a variable ORACLE_SID in hkey\local_machine\software\oracle
If not add it, and give the correct value.The default is ORCL. The error is saying he can't reach the host. I very much doubt whether TCP/IP is correctly configured on that system. Using localhost as hostname should have been sufficient.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Wed Aug 15 2001 - 15:52:26 CDT