Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sqlplus from a perl script is giving ORA-12545 error.
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