Re: differences between Solaris and Windows in sqlplus connection specifiers?

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Mon, 03 Jan 2005 16:22:27 -0800
Message-ID: <41d9e097$1_1@127.0.0.1>

FC wrote:

> <tanel.poder_at_gmail.com> wrote in message
> news:1104753645.516543.122690_at_f14g2000cwb.googlegroups.com...
>

>>Hi,
>>
>>Put the connection string between quotation marks.
>>Otherwise, tell us which error message you get.
>>
>>Tanel.
>>

>
>
> Tanel,
> I already tried that, it doesn't work in my case.
> I tried with both single and double quotes around the descriptor, as shown
> in the Net Admin Guide, but, as I said, it works on windows clients, not on
> solaris.
>
> I am getting ORA-12545, so I am wondering if this could be a dns problem.
> Tomorrow I'll try with a straight IP address.
>
> Do you happen to know if the same technique works inside the connector
> string for db links?
> I hadn't the time to try it out today, I'll do it tomorrow.
>
> Thanks and bye,
> Flavio

Perhaps I am misinterpretating your statement above ... but Oracle does not like dynamic IP addresses. Have you checked the values of ORACLE_SID and ORACLE_HOME environment variables in the current session?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Mon Jan 03 2005 - 18:22:27 CST