Oracle ERROR linked server MSDORA ORA-12154, ODBC works

I am trying to link a MS SQL Server 2005 to an oracle 10g database. I have tried MSDAORA provider and get ORA-12154 "TNS:Could not resolve names" I have verifiy TNSNAMES.ora is correct and can connect ussing ORACLE ODBC.I try using ORAOLEDB.Oracle and it gives OLE DB provider "oRAoledb.Oracle" for l ...

Oracle ORA-12154 TNS:could not resolve service name, but TNSPING works ok ?

We have a situation which has occured since a reload , where by we get the "ORA-12154 TNS:could not resolve service name" error when we try to connect via sqlplus either from windows command prompt or from the sqlplusw.exe , But we can tnsping the database CBREDP and server CBCLUST5 ok . the listene ...

Oracle ORA-12154 DB Link works when I'm on the server, but not from client

I'm sure this has a simple resolution, I've just been looking at it too long!! I have 2 Linux servers, each with a 10.2.0.3 database running. I need to create a db link from server A to server B, piece of cake, right? If I am logged on directly to Server A (using Putty), as the Oracle user. I have t ...

ORA-12154 as oracle user, whit the root account it works fine

I've a problem with a client installation if I try to connect to the database. I've the following configuration:1. Database: Running on a Ubuntu Jeos VM, Oracle 11g (Release 11.1.0.6.0 64 bit)2. Client: Running on a CentOS 5.2 VM, Oracle Client 10g Linux 32bitI've configured the tnsnames.ora and sto ...

Oracle ORA-12154 Error - NET8 Connection Tester Works Though

I have copied over a tnsnames.ora file from another machine I know that works fine. It has one Oracle home.When I try to connect via SQLPlus or Oracle DBA studio, I get told that it cannot resolve the service name and the ORA-12154 error. However, when I go into Net8 Assistant and test the connectio ...

Oracle tnsping ok, but sqlplus can't connect ora-12154

All, I have installed on my linux the 10.1.0.3 oracle client and I can do tnsping to my tnsnames.ora databases but I can't connect with sqlplus... I have an error: ora-12154I have readed metalink documentation and I think everything is ok, but still can't connect... Can anybody help me please?Here i ...

Oracle tnsping is working but ora-12154

i am facing a problem in linux env. tnsping is workin good. as i connec with database , face error with ora-12154.what r the checks and how to varify these. ...

ORA-12154: TNS:could not resolve service

I have been struggling with this error since long time. my application is written in asp.net using Oracle database (10.2.0.4). We have oracle client with version 9.2.0.4 installed in the application server. The problem is that my application some times (not consistence) throws ORA-12154: TNS:could n ...

Oracle ORA-12154 trying to connect using TOAD

I have Oracle 10G up and running on W2K, and working fine with sqlplus.I have setup the registration KEYS (HKEY_LOCAL_MACHINE/...) so TOAD can look at the proper Database, but when I try to connect, I get the famous (and frustrating!) "ORA-12154: TNS:listener does not currently know of service reque ...

Oracle ora-12154 after creation of second database

DB 10g ver 10.1.0.2.0OS Windows server 2003 32bit +sp1Summary:Due to the addition of extra storage to the server I decided to rebuild from scratch, and all was working correctly until I came to create a second database on the server, once this is created I get ORA-12154 errors at logon for both data ...

Oracle 64-bit OCILogon() is fine, but 32-bit version always gives ORA-12154

I am porting an application from Oracle 9.2 on Solaris 8 on Sparc toOracle 10.2 on Solaris 10 on x64, using Sun C++ 5.8 on both.The Oracle installation was quite straightforward, and everything works fine, except that if I compile my app for 32-bit all I ever get fromOCI is 'ORA-12154: TNS:could not ...

Oracle ORA-12154 TNS resolve error with ProC

Hi all, I have a program written in ProC which works fine when it connects to a local database. However, it is unable to connect to a remote database. The code for making the connection is: EXEC SQL BEGIN DECLARE SECTION;char name[20];char pwd[20];char dbname[20];char dbstring[20];EXEC SQL END DECLA ...

Oracle OCI application fails always with 'ORA-12154: TNS:could not resolve the ..'

I am facing a problem on my Dual Core AMD 'AMD Athlon(tm) 64 X2 Dual Core Processor 3800+' running Solaris 10 x86-64 - 11.06. I am using ORACLE 10g: SQL*Plus: Release 10.2.0.1.0 - Production on Tue Oct 16 22:35:27 2007As long as I compiled and linked my app using the flag '-m64' everything worked fi ...

Oracle ORA-12154: TNS error, but only when I start sql from some directories

Using AIX 5.2I'm trying to start sqlplus and I get the ORA1254 error, but not from all directories. If I start from the cd it always works, but from other locations it's very hit and miss.I've checked that the ORACLE_SID is set, and tnsping works .. but I still get the error when I start sql.e.g.ech ...

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

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 ...

Oracle ora-12154: TNS: Could not resolve the connect identifier specified error

we have oracle database 10.2.0.3 on unix server.I installed the oracle client 10.2.0.1 on win 2003 server.from the command prompt when I do the tnsping database name it works finebut when i use sqlplus it gives me ora-12154 error.I have installed the same client on another win 2003 server and it wor ...

Oracle RMAN giving error ORA-12154

ok before I go ahead,...I have tried to resolve this but still no luck so seek helpdatabase: 10.2.0.3 on solaris 9$ cat listener.oraSID_LIST_LISTENER_testdb =(SID_LIST =(SID_DESC =(SID_NAME = PLSExtProc)(ORACLE_HOME = /u01/app/oratest/product/10.2.0/db_1)(PROGRAM = extproc))(SID_DESC =(SID_NAME = te ...

Oracle ORA-12154 - TNS couldnt resolve service name

I have created the following db link :CREATE DATABASE LINK RAN.WORLDCONNECT TO IDENTIFIED BY USING 'DCCCSN1' select * from dual@RAN.WORLDThis gives ORA-12154 - TNS couldnt resolve service nameCan someoen advice regarding this please ? I can use the user id and password used to create the db link to ...

Oracle TNS error ORA-12154

One of our client is trying to connect to our database from his local pc. We are able to connect to the database fine from here. But when he connects from his pc via vpn it gives him this error:Ora-12154: TNS:could not resolve the connect identifier specified.I checked the path and the Oracle client ...

Oracle Need assistance with ORA-12154 issue

I know this has been answered several times so i'll try to eliminate most of the common troubleshooting. I'm on a 64 bit windows server running one database called PECDB on Oracle Database 10.2.0.1. sqlnet.ora:SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)TNSnames.o ...

Oracle ORA-12154: TNS:could not resolve the connect identifier specified (sqlplus)

I don't know if this has ever been posted, but since I've spent a week figuring it out (no joke, a week), I thought I would post it so that no one else has to waste this much time."ORA-12154: TNS:could not resolve the connect identifier specified" from what I've seen on this site is a major problem ...

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

Can anyone help me with the below sqlplus user12@192.60.0.118:1541/MEDFGSQL*Plus: Release 10.2.0.4.0 - Production on Thu Jul 16 13:07:03 2009Copyright (c) 1982, 2007, Oracle. All Rights Reserved.ERROR:ORA-12154: TNS:could not resolve the connect identifier specified tabsdb02:oracle:/oracle/applt/ora ...

Oracle Error ORA-12154: TNS:could not resolve the connect identifier specified

I'm attempting to use a vbscript to make a connection to an Oracle 10g database. The script I am using is a known working script that I have copied from an old machine to my new machine. It still works from my old machine (Running Windows XP SP3), but when ran on my new machine (Running Windows XP S ...

ORA-12154 using Oracle.DataAccess.Client

I am experiencing an ORA-12154 exception when accessing a remote Oracle database using ADO.NET called from c# code running on a Windows 2003 system. The code functions correctly on our internal (remote) database using the Oracle XE 10.2 Client. At the customer site with Oracle 10.1 Client the same c ...

Oracle ORA-12154: TNS:could not resolve service name from server

I can connect to my database from a client, but not from the host via SQLNET. This is not a problem yet, as I can connect without a connect string (using ORACLE_SID env var instead), but I would like to fix it.I have tried all the usual steps listed in metalink Note:114516.1. My tnsnames.ora on my c ...

Oracle Mobile Server Error: ORA-12154

HelloI have installed oracle 9i db on a win 2000 machine. The database works fine. Then I try to install oracle mobile server 9i on the same machine and in the same oracle_home. When the Mobile Server Repository Wizard tries to install the repository in the database it gets an error.ORA-12154 TNS: c ...

Ora-12154 Connecting to WebServer

I have a web application on a Win2K web server connecting to an Oracle 8 database. When I access the site from the web server i.e. http://localhost/site it works correctly.When I attempt to access the site from a remote client i.e. http://<servername>/siteI get the following error"Error w ...

userid in formsweb.cfg => ORA-12154

Hi! I am trying to access a forms server on http://sun2:7778/dev60cgi/f60cgi?config=QQ1, where QQ1 is defined in formsweb.cfg:[QQ1]serverURL=form=login01userid=nn1/nn1@qq1...'QQ1' is in my tnsnames.ora OK. I can tnsping qq1 successfully, I can sqlplus nn1/nn1@qq1 successfully. But I can't access it ...

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

I created a seperate oracle 10.1 database for our application successfully on Fedora Linux OS Hat. Currently, I access to remote database server through putty SSH.I can connect also our database successfully but when I tried it to connect through service name it gives me the following error message. ...

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

I have oracle 10g and Developer suite installed locally in my system and I have edited my TNSNAMES.ora file and added a entry for VISLINUX(for both Developer suite and oracle DB TNSNAMES.ora files).When I use TNSPING comand I get an error for the schemas APPDEV and VISLINUX.D:\Documents and Settings ...

ORA-12154: TNS:could not resolve service name

I am doing a big conversion on the company application. This application was done under VB6 SP6 front end and MSSQL 2000 for back end. And now, the company wants to move in to the ORACLE environment. So, I converted all the SQL statement used in the application and also the connection string.Here's ...

Oracle Intermittent ORA-12154 using Perl DBI

I'm trying to debug an app we have that uses Perl to connect toan 8.1.7 database.Works fine 95% of the time, but every so often we get anORA-12154 error. This just started a few weeks ago, and no-oneseems to know of any changes to the systems.Anyone run into something similar? Here's the error we ge ...

Oracle 9i client/IIS 5.1/PHP (4.3.1) - ORA-12154 error but only under IIS PHP

Hi, newbie to the forum so hope you can help.I have on my Windows XP pc, Apache, IIS 5.1, Oracle 9i client, PHP 4.3.1 and IE 6 web browser. I have a server elsewhere with an Oracle 8.1.7 database on it.* My Oracle 9i client works - I can use SQL Plus.* My PHP app works through Apache to the Oracle d ...

Oracle PLEASE HELP! Installation error :ORA-12154 - TNS

When I'm installing 9ilite and when it comes to the mobile server repository screen, it get an error message :"ORA-12154 - TNS: could not resolve service name".But my service name pass the test of TNSPING.Please help me and any suggestion is greatly apprieciated. ...

Oracle Connect to Remote Database - ORA-12154

When attempting to use OCI to attach to a remote database I cannot resolve the service name.However, I am able to connect using tnsping.Example output is:bash-2.03$ bin/msgoptim mo password mo Message Optimiser - Version 1.0Oracle DB InitialisingDatabase Access Error - ORA-12154: TNS:could not resol ...

Oracle ORA-12154: TNS:could not resolve service name

Right then,I have Oracle client and a version of Oracle Personal Edition running on my Win2k system. The tnsnames.ora and sqlnet.ora files are the same (except for the header line e.g. # TNSNAMES.ORA Network ...I can tnsping the personal edition instance fine but when I attempt to tnsping the db for ...

Oracle ORA-12154: TNS: could not resolve service name

When I tried to use Oracle ODBC 32bit test, I got the error "SQLState: 08001Native error code: 12154Driver Message:[Microsoft][ODBC Driver for Oracle] [Oracle]ORA-12154: TNS: could not resolve service name"When I tried to link the database in Access, I got the same error "ODBC - call failed. [Micros ...

Oracle ORA-12154 error

When I try to connect with isqlplus from my client machine I getORA-12154: TNS:could not resolve the connect identifier specifiedAs sqlplus from the client works OK, I've been told that the problem could be the tnsnames.ora int the server. I've tried creating that file but it is not working. ...

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

I am having a problem with this symptom with instanceClient on windows 2003. I have instantClient installed ind:\oracle\instantClient_1, and I have the location in thePATH. I also have a tnsnames.ora and sqlnet.ora in thedirectory above (and sqlplus.exe is in the same directory).If I start sqlplus f ...

Oracle ORA-12154 at connect with service-name

When i connect in SQL*Plus with the following command it works fine.connect scott/tiger@db1Now when i connect with the service_name i get the error ORA-12154.connect scott/tiger@nb1:1521:db1.workgroupThis connect uses HTML DB and therefore i'm not able to install it.DB Vers. 10.1.0.2.0Many thanks in ...

Oracle ORA-12154 at connect with service-name

When i connect in SQL*Plus with the following command it works fine.connect scott/tiger@db1Now when i connect with the service_name i get the error ORA-12154.connect scott/tiger@nb1:1521:db1.workgroupThis connect uses HTML DB and therefore i'm not able to install it.DB Vers. 10.1.0.2.0Many thanks in ...

Oracle TNS error ORA-12154 : can connect to one server but not to another.

I have a Forms 6.0 application running on a Solaris box. It connectsfine to an Oracle 9.0 server but fails with ORA-12154 when trying toconnect to Oracle 10g running on a different server.'sqlplus' can connect fine to both servers . 'tnsping'result is succesful from the Solaris client to both server ...

Oracle Connection string + ora-12154

I wrote smart program using odp.net and (Oracle.DataAccess)on my computer (vs 2005 using c#) it works perfectly. when i copied the source code to other computer with the same features that i mention (after changing the ConnectionString to a tested successfully ConnectionString and after creating the ...

Oracle ORA-12154: TNS:could not resolve service name

Hi, We have oracle 9.2.0 running on a linux system called lbfdw1. The tnsnames file has the following entry in it:LBFDW1 =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = lbfdw1)(PORT = 1521)))(CONNECT_DATA =(SID = DW901)(server = dedicated)))The listener.ora file has this in it:LISTE ...

Oracle ORA-12154 after a few hours

My application runs fine for a few hours, before returning an "ORA-12154: TNS:could not resolve service name" error when trying to open an ADO connection to an Oracle 9i database. 1) What does this mean? It can't find the name server, it can't find a matching name in the name server, it can't find t ...

Oracle ORA-12535 TNS:Operation time Out and ORA-12154:TNS Could not resolve servic

Greetings!!!I have installed my Oracle Database 10g & Developer Suite 10g in Windows XP Pro Machine. Oracle Application Server 10g is also installed in Windows 2003 Server machine.Both machine have different domain.When using Form Developer Suite OC4J to run my form program, i can connect to the ...

Oracle ORA-12535 TNS:Operation time Out and ORA-12154:TNS Could not resolve servic

Greetings!!!I have installed my Oracle Database 10g & Developer Suite 10g in Windows XP Pro Machine. Oracle Application Server 10g is also installed in Windows 2003 Server machine.Both machine have different domain.When using Form Developer Suite OC4J to run my form program, i can connect to the ...

Oracle ORA-12154: can not solve it.

tired of fighting with mistakes, I post here - Suse 9.3; Oracle 10g;here are the main config file:*-*-*-*-* LISTENER.ORA-*-*-*-*-*-*-*-*SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(SID_NAME = PLSExtProc)(ORACLE_HOME = /opt/oracle/product/10g)(PROGRAM = extproc)))LISTENER =(DESCRIPTION_LIST =(DESCRIPTIO ...

Oracle ORA-12154: TNS:could not resolve the connect identifier specified ORA-12162

I am tired of this problem, hopefully some one could help me out. I was able to login using sqlplus on DB server locally. I installed Oracle client on my workstation and trying to login to the DB on DB server. Its not working. I could not figure out why? I tried the tnsping, and it is working fine. ...

Oracle ORA-12154: TNS:could not resolve service name

I have an ASP.NET web site that connects to an Oracle database using the ODBC driver for Oracle (Oracle in OraHome90). It is connecting to a development Oracle 9i database. When I run the web site from my computer (localhost) it works flawlessly. When I promote it to our development box I get the fo ...