Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: OO4O: ORA-12154 Error - TNS:could not resolve the connect identifier specified
"Brian Peasland" <dba_at_nospam.peasland.net> wrote in message
news:J6962F.9o6_at_igsrsparc2.er.usgs.gov...
>
> I'm not an expert with ASP, but is IFSP2 the TNS entry you are using to
> denote the database to connect to? If so, then verify that it is defined
> correctly in your TNSNAMES.ORA configuration file. Also, verify that you
> can TNSPING that entry, "tnsping ifsp2". If not, then you have either 1)
> configured your tnsnames incorrectly, 2) have an incorrect sqlnet.ora
> configuration file, or 3) your software cannot see these files.
>
Yes, IFSP2 is the DB alias. It is defined correctly - AFAIK, the test server was set up the same way as the development server, and shares the same TNSNAMES.ORA file (and other config).
I didnt know about TNSPING, but it worked a treat - all aliases resolve to the right locations.
I'm not sure, but I think I have made some progress... I'll post back if/when I can confirm it.
Thanks for your response, Brian.
Chris Received on Wed Sep 27 2006 - 08:59:56 CDT