Re: ORA-12154: TNS:could not resolve service name in sql+ only

"Debbie" <DEBBIELOKE_at_YAHOO.CO.UK> wrote in message news:eec445c4.0209190644.47df6697_at_posting.google.com...
> A bit of history;
> I have a machine (w2k) set up with Oracle 9i that has a database
> called Prod. The database works perfectly, i can connect to it, make
> changes and have no issues with it whatsoever.

Sorry: we need to be more specific here. Are you working *on that machine* when you can connect perfectly? Or are you accessing it over the network. If you're doing it all on the machine directly, then it's very likely to work without a hassle, because you aren't actually putting Net8 to the test yet.

> I have now installed Oracle onto a second PC (w2k) and am trying to
> connect to the database on the original PC.
> I have set up a database called Prod1 with a host name of the first PC
> and I can see the database and data. All works well, until this
> error!
>
> I get this error message when I try to connect to SQL+ on the second
> pc. I am connected to the database (prod1), can see all information
> in the database and make changes to it (that appear on both PC's) via
> Enterprise manager. It is only when trying to launch SQL+ that this
> message appears.
>

Nope... you've gone off the deep end on this one. It's not clear from your description what's happening, what you're typing, and a goodly much else besides.

I presume you are saying that, whilst seated at PC2 (which is running the PROD1 database) you are trying to connect, via SQL*Plus, to the PROD database on PC1. Is that right?

> Here is my tnsnames.ora file, which i cant see any errors with;
>
> # TNSNAMES.ORA Network Configuration File:
> C:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
> # Generated by Oracle configuration tools.
> PROD1.ORANZ.CO.UK =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = oranz02)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = prod)
> )
> )
>

See, this is where I get confused. You've a service alias called PROD1.... which is connecting to the service PROD. Yet earlier, I thought you said you had a database called PROD running on your first machine, and PROD1 running on your second machine. Who can say what you're trying to connect to and from where... 'cos I can't tell.

Is this the TNSNAMES.ORA file from the first machine, or the second?

> When i type the following command line into SQL+ -
> Connect mis_staging/mis_staging_at_PROD1.ORANZ.CO.UK;
> i get the nasty messge;
> ORA-12154: TNS:could not resolve service name.
>

Check that you haven't got multiple copies of the tnsnames.ora floating around on your hard disk. Check that sqlnet.ora doesn't have a line such as "SQLNET.DEFAULT_DOMAIN" (delete it if so, and try again).

Otherwise, write back with more precision as to what you are typing, where, and attempting to do what.

Regards
HJR
> I am at a complete loss with this. I have only been using Oracle a
> couple of weeks and we are testing it to see if it is going to work
> for us in a development capacity. I therefore purchased the media
> pack but no support with the database and this is proving to be a real
> nightmare. Please help!
Received on Thu Sep 19 2002 - 19:48:56 CDT