unable to connect SQLState=08004 Oracle ODBC ORA-12154:TNS..

i am using windows xp. Client 11g R2 ----------------------- Oracle Linux Database 11g R2 i am able to connect to Database using SQLPLUS but when i try to use "ORACLE ODBC Driver Configuration"and try to test connection then i am getting the following error.unable to connect SQLState=08004 Oracle OD ...

unable to connect SQLState=08004 Oracle ODBC ORA-12154:TNS..

i used Windows 7 and i used client Oracle 11.2.2 Win_Client 32 when i m going to create ODBC its make error unable to connect SQLState=08004 Oracle ODBC ORA-12154:TNS.. but i used sql developer i can see all of my table form server.any one help me how can i slove my problem. ...

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 CacheConnect - ORA-12154 TNS resolution failure

I am trying to configure cache connect to connect with my oracle instance, but I keep getting the following error:C:\Documents and Settings\tferguso>ttadmin -cacheuidpwdset -cacheuid cacheadmin-cachepwd timesten tobys_tt_store*** [TimesTen][TimesTen 7.0.5.0.0 ODBC Driver][TimesTen]TT5220: Permane ...

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

ORA-12154 Oracle Client Error with VirtualBox

This is rather lengthy and I am not sure this is the right forum for this question but it does involve the Oracle Client.My development environment consists of a single workstation that is not connected to a network. The OS for the database is Linux CentOS (Red Hat Enterprise Linux 3 or 4). The data ...

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

This is rather lengthy and I am not sure this is the right forum for this question but it does involve the Oracle Client.My development environment consists of a single workstation that is connected to the network. The OS for the database is Windows Server 2003. The database is running fine from the ...

Oracle DNS Set Up system throw as ORA-12154; TNS :could not resolve the connect id

While i'm creating DNS set up system throws below message unable to connectSQLState=08004DNS Set Up for instantclient(win32-10.2.0.4) system throw as ORA-12154; TNS :could not resolve the connect identified specified.operationg system:xpdir path:C:\Oracle\instantclient10_2TNSNAMES.ORA(C:\Oracle\inst ...

Resolving ORA 12154 error on Oracle8i

So that we may better diagnose DOWNLOAD problems, please provide the following information.- Server name - Filename - Date/Time March 28 9:00 am- Browser + Version Internet Explorer 5.5- O/S + Version Windows 98SE- Error Msg ORA 12154 : TNS : could not resolve service name ORA 12154 : TNS : could no ...

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

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

anyone can help me. i am using powerbuilder9.0 for frontend and oracle 8i as my backend.i am facing trouble to connect oracle8i with pb9.0.during runtime or preview oracle8i successfullyconnect with pb9.0 but on excution the software .it gives messge ORA-12154 TNS:could not resolve servicename.pleas ...

Oracle ORA-12154

Happy New Year Everyone,Please help me out:I have Windows XP and had Oracle8i client installed on it. Then I decided to remove the client and installed Oracle9i Personal Edition. The installation went smoothly, however, when I tried to connect to my existing Crystal 8.5 reports, all of them are gett ...

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

I have installed Oracle 9i, release Release 9.2.0.1.0 ON a Windows 2000 m/c. And Forms 6i. I am trying to connect to the database, even from SQL Plus ( from C:\ora9i\Bin) folder, I am getting "ORA-12154: TNS:could not resolve service name" error message. Here is my TNSNAMES.ORA FILE # TNSNAMES.ORA N ...

Oracle ORA-12154: TNS:could not resolve service name, URGENT.

I have installed Oracle 9i, release Release 9.2.0.1.0 ON a Windows 2000 m/c. And Forms 6i. I am trying to connect to the database, even from SQL Plus ( from C:\ora9i\Bin) folder, I am getting "ORA-12154: TNS:could not resolve service name" error message. Here is my TNSNAMES.ORA FILE # TNSNAMES.ORA N ...

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

when i am trying to connect to oracle database from asp.net the following error is occuringORA-12154: TNS:could not resolve the connect identifier specifiedwhen i am connecting from oracle client enterprise manager it is connects smoothly....so please help me to solve this problem ...

SQLState=S1000, Proc to Export Tables into Flat Files

I am trying to create a Procedure that will export all the tables present in the database to corresponding flat files. The below procedure builds fine but gives a run-time error as below:SQLState = S1000, NativeError = 0Error = [Microsoft][ODBC SQL Server Driver]Unable to open BCP host data-fileNULL ...

Oracle @@@ You have to read this ! ORA-12154 dilemma @@@

I have am running out of patience, I have loaded Oracle 8.1.5 & Enterprise Management 2.0.4, went thru the Net8 easy config routine and did get a successful connection, but my question is not how can i log in to the security manager ? or any other management tool. I uses system:manager to log in ...

Oracle ora-12154(in olog) occurs in hp-unix's daemon, why?

I have a program in hp-unix's daemon and oracle 8.1.6 oci, when execute the function of olog, ora-12154 occurs, while execute the oci program solely, it's successful. Why?Who can help me? ...

error ORA-12154

error ora-12154: TNS: could not resolve service name.how do you troubleshoot this error? ...

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

ORA-12154 tns:could not resolve service name

I have been trying to figure this one out for some time now. I finally gave up and decided to ask here.I am getting the following error:ORA-12154 tns:could not resolve service nameI have checked out tnsnames.ora and everything looks good.I have Oracle 9i running on RedhatLinux 9. Everything runs gre ...

ORA-12154: TNS:could not resolve service name

I'm running the following on the same Solaris 8 machine (same user):Oracle 9i (9.0.1.4) database clientOracle 9iAS (9.0.3 - J2EE & Web Cache)and I am having difficulty in setting up the environment correctly. I have created an OC4J data source (type II driver) and get the following error when I ...

ORA-12154: Only from ASP

W2k professional server IIS 5Oracle 8.1.7I am getting the following error message while trying to connect to Oracle from ASP.Microsoft OLE DB Provider for ODBC Drivers (0x80004005)[Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS:could not resolve service name/oratest/testora1.asp, line 28I ...

a problem about ORA-12154

$./sqlplus urechum/urechum@rechumSQL*Plus: Release 9.2.0.1.0 - Production on Wed Mar 12 09:18:45 2003Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.ERROR:ORA-12154: TNS:could not resolve service nameI tried to connet oracle server on win2k from client in linux with sqlplus,but i m ...

ORA-12154 problem while connecting using Forms Builder

I installed Oracle 9i and Developer Forms & Reports 6i on the samemachine.I keep getting this error (ORA-12154: TNS:could not resolve service name)when I try to connect using Forms Builder.I’m able to connect using the SQLPlus if I enter username = system, pass = manager and SID = prima.smart o ...

d2k 6i connection error ora 12154 TNS could not resolved service name

I've developer 6i installed on my computerI am connecting to oracle 9i .I am unable to connect to database.it give message ora 12154 TNS could not resolved service name I have two oracle home.I am able to connect through same connect string in ODBC testCan some help me to sort this problem ...

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 error

I have developed an application using Oracle 8i as my backend. When my client tries to open the application, he gets the following error ORA-12154: TNS: could not resolve service name error Can any body suggest a solution. Thanks in advance ...

ORA-12154 error-Urgent Help required

Hai all, I have developed an application in VB and have connected to Personal Oracle 8i through ODBC. I have given the DSN name and User Name in the ODBC connection and left the Server name blank sice it is the local server. The VB applicaton and the personal oracle are in the same PC. When my clien ...

newbie - another ORA-12154 :(

I've the old ORA-12154 Problem. I've read through all the articles regarding that problem and tried the recommended solutions, but none worked.I'm running Oracle 9.2.0.1.0 on a win2003-Server.srv-name: srvlei05sid stwlHere are my sqlnet.ora, tnsnames.ora and listener.ora# SQLNET.ORA Network Configur ...

Oracle Reports - ORA-12154

I am able to launch Oracle Reports via X-windows. I can make modifications to the report layout, but when I attempt to connect to the database I get the ORA-12154 error. I know this means that the alias that I'm using to connect to the database isn't correct.I found my tnsnames.ora file in the path ...

ORA 12154: TNS: Service name could not...

At work I'm writing a program to store reports in to an oracle database.On the developing computer I can access the database and do what is needed.With Toad I can look in to the database from any point on the network.The database is on de coporate network.When I run my program on another pc then the ...

Error while trying to retrieve text for error ORA-12154

When i try to execute sumple query with ASP.NET I receive this error:Error while trying to retrieve text for error ORA-12154 [OracleException: Error while trying to retrieve text for error ORA-12154]System.Data.OracleClient.DBObjectPool.GetObject(Ob ject owningObject, Boolean& isInTransaction) + ...

sqlplus tns errors ORA-12154

I have Oracle 9.2 client installed on my Windows XP workstation and can connect to the Oracle databases on remote server with the Oracle Enterprise Manager software. However, when I attempt to connect to Oracle via SQL*Plus or via Quest TOAD software, I keep getting TNS Oracle errors ORA-12154. I ha ...

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

can anyone help me connecting to my remote oracle server site?i actually have my TNS file set up.. i installed an oracle basic client and set-up the environment variables correctly, but as i connect to the remote server using toad, i get an error "ORA-12154: TNS could not resolve the connect id ...

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

I am getting the following common error trying to connect to an Oracle 10g database with DBArtisan (version 7.3.1):ORA-12154: TNS: could not resolve the connect identifier specified.After googling this error I see that it is common, and there is a lot of similar advice available. To my knowledge I h ...

how to solve ora-12154 error

i can see my form out put because of "ORA-12154: TNS:could not resolve the connect identifier specified" error...i did lots of researches for this error but no use i cant solve it...so can anyone help me ...thanx ...

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

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

ORA-12154: TNS:could not resolve the connect identifier specified [10g XE]

GreetingsThere are many topics on this issue over the internet but None of them addresses this issue properly, so I couldn't find a solution to the problem.I installed: *Oracle Database 10g Express Edition*After the installation was done, I opened SQL Command Line and I used the command "connec ...

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

ODBC Error: SQLSTATE = S1000, Native error code = -5099

I created a stored procedure:CREATE PROCEDURE SideCheckUpdate(IN :vSU_ID INTEGER, IN :vBoardThick INTEGER, IN :vComp_ID INTEGER); BEGIN DECLARE :vNumberOfSides INTEGER;SELECT Quantity INTO :vNumberOfSides FROM WO_UNITCOMPONENTS WHERE SU_ID = :vSU_ID AND Comp_ID = 0; IF (:vNumberOfSides > 0) THEN ...

Oracle ORA-12154

Whenever my OCI client app tries to connect to an Oracle instance on a remote server machine, I get this error:ORA-12154: TNS:could not resolve service nameWhat is the correct way of specifying the service name?I have attempted to modify the "tnsnames.ora" file but that also did not work. ...

Oracle AQ problems, OCIServerAttach, OCI_EVENTS, OCIInitialize, ORA-12154

Greetings. I have a modest-sized MT application that is using C++ with OCI and all has been working well for 9 months. I recently wrapped some basic AQ functions for OO access to simple AQ Enqueue and Dequeue operations. This went very well and I can now successfully send/receive CLOB's to a third p ...

Oracle AQ problems, OCIServerAttach, OCI_EVENTS, OCIInitialize, ORA-12154

Greetings. I have a modest-sized MT application that is using C++ with OCI and all has been working well for 9 months. I recently wrapped some basic AQ functions for OO access to simple AQ Enqueue and Dequeue operations. This went very well and I can now successfully send/receive CLOB's to a third p ...

Oracle Error ORA-12154

When I try to connect with a database, shows this error:SQL> conn system/manager@orcl.mycompanyERROR:ORA-12154 TNS:could not resolve service name ...

ora_logon receive ora-12154

I'am having serious problems in put php acessing a remote oracle 8 database, i have tried several configurations but always end up with Oracle: Connection Failed: ORA-12154: TNS:could not resolve service name in /var/www/htdocs/support/teste.php on line 5I can access this database from sqlplus and w ...

Error ORA-12154

I'm having trouble connecting remotely to a Oracle 8i database from a remote server running Apache Operating system = Solaris 2.6.PHP compiles fine with oci8 support , sqlplus connects fine , I changed the user inside the httpd.conf file in Apache to be oracle in group dba.The problem occurs when I ...