Re: tnsping and sqlplus output OK, but [ORA-12545: Connect failed because target host or object does not exist]
From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Mon, 10 May 2010 16:36:30 +0200
Message-ID: <4BE819EE.3060807_at_gmail.com>
On 10/05/2010 16.30, Sven Aluoor wrote:
> On Mon, May 10, 2010 at 3:50 PM, Ron Crisco<ron.crisco_at_method-r.com> wrote:
>
>> You're attempting to connect twice, so the error is from the default connect
>> of sqlplus. Use sqplus -S /nolog in the command line to prevent this.
>> Ron Crisco
>>
> Hi Ron
>
> Thanks for your answer, but this doesn't work.
>
> I changed script to "sqlplus -S /nolog<<EOF /> ..." but have still the error
>
[...]
Date: Mon, 10 May 2010 16:36:30 +0200
Message-ID: <4BE819EE.3060807_at_gmail.com>
On 10/05/2010 16.30, Sven Aluoor wrote:
> On Mon, May 10, 2010 at 3:50 PM, Ron Crisco<ron.crisco_at_method-r.com> wrote:
>
>> You're attempting to connect twice, so the error is from the default connect
>> of sqlplus. Use sqplus -S /nolog in the command line to prevent this.
>> Ron Crisco
>>
> Hi Ron
>
> Thanks for your answer, but this doesn't work.
>
> I changed script to "sqlplus -S /nolog<<EOF /> ..." but have still the error
>
[...]
Just remove the forward slash after the here-document marker:
sqlplus -S<<EOF> ...
user/pass
...
EOF
Regards
Dimitre
-- http://www.freelists.org/webpage/oracle-lReceived on Mon May 10 2010 - 09:36:30 CDT