Re: ORA-12154: TNS:could not resolve service name in XXX

I had a similar problem. Worked up a tnsnames.ora file on windoz machines. Thought it would be no big deal if it was copied over to linux and used. But there is a big deal.. Oracle can't handle the <CR><NL> character sequence, in a unix environment. Go figure... There used to be a dos2unix program lying around my linux box. A couple of distributions later, I find none.. vi works well though.. $ vi tnsnames.ora :set ff=unix :w! Did the trick for me, HTH. -Joe ""Peter J. Krawetzky"" <krawetzky1@earthlink.net> wrote in message news:001801c09cce$8c530160$d70e1eac@W559878.hartford.aetna.com... > I appears that PHP does not know about the paths for Oracle. I am only > guessing at this because I haven't installed Oracle on a Linux/Apache box > but I think Apache is not aware of the Oracle paths that are required. You > might need to recompile Apache with the appropriate configuration > parameters. > -----Original Message----- > From: Vlad <vlad@zircon.net.ua> > To: php-db@lists.php.net <php-db@lists.php.net> > Date: Thursday, February 22, 2001 7:40 AM > Subject: Re: [PHP-DB] ORA-12154: TNS:could not resolve service name in XXX > > > >Hi All > >Oracle is installed on SCO UnixWare > >Client that I use to connect on Windows 98 > >env variables ORACLE_HOME, TNS_ADMIN for client is correctly defined > >by the way I created ODBC source for my ORACLE connection and tested it. > >Then I tryed to connect using PHP's odbc_connect and have the same > >problem... > >Is there any solution? > >Thanks, Vlad > > > >> Make sure your tnsnames.ora file is setup correctly and that your > >> environment variables are setup correctly. > >> > >> What OS are you using on the machine that Oracle is installed on? > >> > >> Peter J. Krawetzky > >> -----Original Message----- > >> From: Vlad <vlad@zircon.net.ua> > >> To: php-db@lists.php.net <php-db@lists.php.net> > >> Date: Thursday, February 22, 2001 3:25 AM > >> Subject: [PHP-DB] ORA-12154: TNS:could not resolve service name in XXX > >> > >> > >> >Hello All > >> >I have some problems connecting ORACLe from my php script. > >> >connection string: > >> > $conn = OCILogon("asu", "asu", "asu"); > >> >failed with > >> > ORA-12154: TNS:could not resolve service name in XXX > >> > > >> >Regards, Vlad > >> >e-mail: zzzvlad@ukr.net > >> >IóQ: 1042225964 > >> > > >> > > >> > > >> >-- > >> >PHP Database Mailing List (http://www.php.net/) > >> >To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > >> >For additional commands, e-mail: php-db-help@lists.php.net > >> >To contact the list administrators, e-mail: php-list-admin@lists.php.net > >> > > >> > > >> > >> > >> -- > >> PHP Database Mailing List (http://www.php.net/) > >> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > >> For additional commands, e-mail: php-db-help@lists.php.net > >> To contact the list administrators, e-mail: php-list-admin@lists.php.net > >> > >> > > > > > >-- > >PHP Database Mailing List (http://www.php.net/) > >To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > >For additional commands, e-mail: php-db-help@lists.php.net > >To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >