Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ora-12541 ORA-12154: TNS:could not resolve the connect identifier specified

631401Apr 10 2008 — edited Apr 13 2008
I am having trouble obtaining an ODBC connection from a client XE to a server XE. ora-12541 ORA-12154: TNS:could not resolve the connect identifier specified

I am new to Oracle.
I have oracle client XE running on my XP pro box.
I have oracle server XE running on an XP pro box on the LAN.
I am trying to connect to the oracle database using ODBC from my client box.
I can logon to the oracle server box through HTTP.
I can logon to the oracle server box by using a connection string in "Command Line SQL" from my client computer. I can then run queries on my client computer. (select * from global_name)
I cannot setup an ODBC connection in windows which will connect to the oracle server box from my client box. (I have no trouble connecting to MSSQL databases).
I can ping my server by hostname or ip address. Both ok.
I can run tnsping XE on the server box and it works. I believe this tells me my server listener is working.
I cannot run tnsping on my client box as it is not included in the download for Client XE.
Windows firewall is turned off on both machines.

I have been reading all over the web for and all attempts fail. Most all help says use Oracle Net Manager or some such tool. They then say go to start\programs\oracle….etc. There is no type program included on the server or the client software. I would like to know here I can download it.

XEClint\Bin is the firs entry in my PATH. The tnsnames.ora, sqlnet.ora, and listner.ora files are there. I have been to http://www.oracle.com/technology/software/products/database/xe/files/install.102/b25143/toc.htm several times. My tnsnames.ora are identical to the ones in the example except for the host =.

I have 3 tnsnames.ora files on my computer:
Directory of c:\
04/03/2008 11:43 AM 635 tnsnames.ORA

Directory of c:\Documents and Settings\All Users\Application Data\Microsoft\Net
work
04/03/2008 11:43 AM 635 tnsnames.ORA
1 File(s) 635 bytes

Directory of c:\XEClient\bin
04/03/2008 11:43 AM 635 tnsnames.ORA
1 File(s) 635 bytes

They are all identical.

When I ran lsnrctl status on the server the results were the same as found in other articles in the web site. Default service XE

I have the Oracle in XE Client driver in my windows ODBC driver list of the client box. And other Oracle drivers.

It appears I am lost.

Any help would be appreciated.

Randy
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 10 2008
Added on Apr 10 2008
5 comments
1,053 views