Simon Hibbs schreef:
> I am working on a 10g database installed on RH AS 4, but I'm having an
> annoying problem.
>
> I can only connect to the database if I use the full hostname as well
> as the SID. If I use the SID alone, it won't go through. I have
> checked the configuration of the server and the client setup -
> tnsnames.ora and listener.ora and they seem fine.
>
> In anyone aware of any known issues, or common mistakes that would
> cause this?
>
> Many thanks for any assistance.
>
>
> Simon Hibbs
>
sqlnet.ora - the one you did not list.
It may contain "names.default_domain"
And of course, tnsnames.ora just lists aliases.
If you want to connect to Fred, Barney and Wilma, do so, when
you do not like prodspa.simon.hibbs.com
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Mon Apr 23 2007 - 13:33:36 CDT
