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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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. ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
I have created the following db link :CREATE DATABASE LINK RAN.WORLDCONNECT TO IDENTIFIED BY USING 'DCCCSN1' select * from [email protected] 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 ...
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 ...
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 ...
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 ...
Can anyone help me with the below sqlplus [email protected]: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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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. ...
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 ...
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 ...
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 ...
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 ...
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. ...
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 ...
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 ...
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 ...
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. ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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. ...
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 ...