Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old June 14th, 2007, 06:07 AM
Registered User
Join Date: Jun 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Ora-12154 on Windows 2003 Server

I installed Oracle8.1.7 on Windows 2003 server (IP: But there is a problem now.

I'm trying to create a DB Link to connect another Oracle8 server (IP:

The link creates successfully. But when I try to select * from table_name@db_link, it display ORA-12154: TNS:could not resolve service name.

If I install Oracle8.1.7 on windows 2000 server, this will not happen.

Is this problem caused by 2003 server? How to resolve it?

I searched it from Internet, and tried to resolve it by modify tnsnames.ora, but failed.

Old June 14th, 2007, 03:10 PM
Friend of Wrox
Join Date: Jun 2003
Posts: 344
Thanks: 0
Thanked 1 Time in 1 Post

can you do a TNSPING from one server to the other ?
Old June 15th, 2007, 02:04 AM
Registered User
Join Date: Jun 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts

anybody help me?

Similar Threads
Thread Thread Starter Forum Replies Last Post
CDO not work in Windows 2003 server pushpa C# 2005 1 October 17th, 2007 08:10 AM
Windows Server 2003 neil.abachi07 Windows Server 1 September 13th, 2007 02:11 PM
DBLink ORA-12154 nkrust Oracle 2 May 20th, 2007 11:54 PM
Windows 2003 Server R2 srutter BOOK: Professional Web Parts and Custom Controls ASP.NET ISBN: 0-7645-7860-X 4 February 25th, 2006 06:52 PM
ASP and Windows 2003 Server gerhard@krenn.net Classic ASP Professional 9 March 23rd, 2004 06:04 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.