Re: tnsping and sqlplus output OK, but [ORA-12545: Connect failed because target host or object does not exist]

  • From: Ron Crisco <ron.crisco@xxxxxxxxxxxx>
  • To: cichomitiko@xxxxxxxxx
  • Date: Mon, 10 May 2010 09:42:09 -0500

Sorry, I didn't notice the extra "/" character. Just remove the / after the
<<EOF and the script should work correctly. The /nolog is not needed. Also,
the "exit" command is not needed, but I don't think it causes any problem.

Ron

On Mon, May 10, 2010 at 9:36 AM, Radoulov, Dimitre <cichomitiko@xxxxxxxxx>wrote:

> On 10/05/2010 16.30, Sven Aluoor wrote:
>
>> On Mon, May 10, 2010 at 3:50 PM, Ron Crisco<ron.crisco@xxxxxxxxxxxx>
>>  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
>
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2010