Re: tnsping and sqlplus output OK, but [ORA-12545: Connect failed because target host or object does not exist]
From: Sven Aluoor <aluoor_at_gmail.com>
Date: Mon, 10 May 2010 16:30:36 +0200
Message-ID: <AANLkTilI8Ystig5UWncEcNNKkO5PlqC5lk3-vUSHsUiJ_at_mail.gmail.com>
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
Date: Mon, 10 May 2010 16:30:36 +0200
Message-ID: <AANLkTilI8Ystig5UWncEcNNKkO5PlqC5lk3-vUSHsUiJ_at_mail.gmail.com>
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
ERROR:
ORA-12545: Connect failed because target host or object does not exist
cheers Sven
-- http://www.freelists.org/webpage/oracle-lReceived on Mon May 10 2010 - 09:30:36 CDT