Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sqlplus from a perl script is giving ORA-12545 error.

Re: sqlplus from a perl script is giving ORA-12545 error.

From: pdqd <pdqd_at_rediffmail.com>
Date: 14 May 2003 05:42:08 -0700
Message-ID: <1bd79fdb.0305140442.4fba8619@posting.google.com>


yong321_at_yahoo.com (Yong Huang) wrote in message news:<b3cb12d6.0305131212.76bb4c93_at_posting.google.com>...
> pdqd_at_rediffmail.com (pdqd) wrote in message news:<1bd79fdb.0305130509.5d2bc495_at_posting.google.com>...
> > Hi Friends,
> > -
> > Using a perl script i am running 'sqlplus' command(sqlplus
> > <dbuid>/<dbpasswd>@DB1 @oracle.sql ). I get the following error
> > message...
> > -
> > ORA-12545: Connect failed because target host or object does not exist
>
> Why not post the part of your code that connects to the database? At
> least we can tell whether you're missing backslash in front of @.
>
> Yong Huang

Thanks a lot. There wasn't '\' infront of '@'. I made the change and it is working now.
 I have another question. In the documentation on sqlplus it is given that the command to run the sql script is as follows.. sqlplus <dbuid>/<dbpasswd> @<sql_script_name> but this fails with the same error message(ORA-12545), but if i add the database name (@DB1 - as in the one i posted in my original post above ) it works. Could this be because of setup problem? or it is an expected behaviour?
-
Kindly suggest.
-
Thanks and Regards,
Parimal. Received on Wed May 14 2003 - 07:42:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US