Msdaora Tns Error
Contents |
Last updated: April 22, 2016 - 4:40 am UTC Category: SQL*Plus � Version: 9.2.0 Latest Followup You Asked i'm running oracle on ora 12154 error in oracle 11g standalone computer at home.it used to work properly but from couple ora-12154 tns could not resolve service name of days i'm getting error stating "ORA-12560: TNS:protocol adapter error " what should i do? please ora-12154 tns could not resolve the connect identifier specified windows 7 help.. (scott/tiger) and we said... sounds like the database is not up. you probably restarted your machine and the instance is not set to autostart C:\Documents tns could not resolve the connect identifier specified sqlplus and Settings\tkyte>sqlplus scott/tiger SQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:43:55 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options scott%ORA10GR1> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.4.0
Tns Could Not Resolve The Connect Identifier Specified Odbc
- Production With the Partitioning, OLAP and Data Mining options C:\Documents and Settings\tkyte>net stop oracleserviceora10gr1 The OracleServiceORA10GR1 service is stopping......... The OracleServiceORA10GR1 service was stopped successfully. C:\Documents and Settings\tkyte>sqlplus scott/tiger SQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:44:35 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: ERROR: ORA-12560: TNS:protocol adapter error SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus C:\Documents and Settings\tkyte>net start oracleserviceora10gr1 The OracleServiceORA10GR1 service is starting.......... The OracleServiceORA10GR1 service was started successfully. C:\Documents and Settings\tkyte>sqlplus scott/tiger SQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:45:12 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options scott%ORA10GR1> in the above ora10gr1 is my oracle sid, you can use control
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies
Asp.net Ora-12154: Tns:could Not Resolve The Connect Identifier Specified
of this site About Us Learn more about Stack Overflow the company Business tns could not resolve the connect identifier specified oracle 10g Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges error while trying to retrieve text for error ora-12154 Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: https://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:431775600346873836 Sign up Oracle (0x80004005)ORA-12154: TNS:could not resolve the connect identifier up vote 8 down vote favorite 1 I'm trying to connect to an oracle db from an ASP classic application, however I keep running into the ORA-12154 error. TNSNAMES.ORA is configured properly DBSOURCE.A.B.com = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = C.D.B.com)(PORT = 1231)) ) (CONNECT_DATA = (SERVICE_NAME = DBSOURCE) http://stackoverflow.com/questions/3477445/oracle-0x80004005ora-12154-tnscould-not-resolve-the-connect-identifier ) ) I can TNSPING C:\Documents and Settings\USERID.A>tnsping DBSOURCE TNS Ping Utility for 32-bit Windows: Version 10.2.0.4.0 - Production on 09-MAR-2 011 09:12:31 Copyright (c) 1997, 2007, Oracle. All rights reserved. Used parameter files: C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = C.D.B.com)(PORT = 1231))) (CONNECT_DATA = (SERVIC E_NAME = DBSOURCE))) OK (30 msec) I can create an ODBC connection and I've tested the connection which is successful. I can connect to the oracle db through toad. I've checked my sqlnet.ora file NAMES.DEFAULT_DOMAIN = A.B.com SQLNET.AUTHENTICATION_SERVICES= (NONE) NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) I've also checked that the TNSNAMES.ORA as one of my system paths. I can connect to the DB with SQLPLUS Here is the code that throws the error dim CnnStr Set Cnn = Server.CreateObject("ADODB.Connection") CnnStr="Provider=MSDAORA.1;Password=pass;User ID=user;Data Source=DBSOURCE" Cnn.Open CnnStr I am running windows XP Pro 32bit SP3 I've tested this on a co-workers machine and the asp app has no issues, am I missing a configuration somewhere or did I mess up my config? Thanks for the help everyone! oracle asp
ODP.NET OLE DB providersOracle Provider for OLE DBMicrosoft OLE DB Provider for Oracle ODBC driversOracle https://www.connectionstrings.com/oracle/ in OraHome92Oracle in XEClientOracle in OraClient11g_home1Microsoft ODBC Driver for OracleMicrosoft ODBC for Oracle Wrappers and othersMSDataShape.NET Framework Data Provider for OLE DB.NET Framework Data Provider for ODBC .NET Framework Data Provider for Oracle Standard Data Source=MyOracleDB;Integrated Security=yes; This one works could not only with Oracle 8i release 3 or laterOracle Specifying username and password Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;
Integrated Security=no; This one works only with Oracle 8i release 3 or laterOracle Omiting tnsnames.ora This is another type of Oracle connection string could not resolve that doesn't rely on you to have a DSN for the connection. You create a connection string based on the format used in the tnsnames.ora file without the need to actually have one of these files on the client pc. SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)));
uid=myUsername;pwd=myPassword; Oracle Omiting tnsnames.ora Alternative Some reported problems with the one above and Visual Studio. Use the next one if you've encountered problems. Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)));
User Id=myUsername;Password=myPassword; Oracle Using Connection Pooling The connection pooling service will create a new pool if it can't find any existing pool that exactly match the new connections connection string properties. If there is a matching pool a connection will be recycled from that pool. Data Source=myOracleDB;User Id=myUsername;Password=myPassword;