Re: Connection to databse requires hostname

Simon Hibbs wrote:
> 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

 From what you have written it is impossible to know what you are doing and in what version.

1. 10.? ... out to three decimal places
2. What are you using for host?
3. What is in your listener.ora?
4. What is in your tnsnames.ora?
5. What is in your sqlnet.ora?

Just post the relevant parts if you know what they are.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org