Database Error 12154 Sap
Contents |
on OracleWhere is this place located?All Places SAP on Oracle 11 Replies Latest reply: Aug 2, 2013 8:23 AM by Marius Burger Tweet RSA1 Database error 12154 at CON issue Tolulope OKUSAGA Jul 29, oracle database error 12154 2013 2:17 PM Currently Being Moderated Good day,I am trying to extract
Oracle Database Error 12154 Ora-12154
data from an Oracle database that is hosted onanother server.I have configured the tnsnames.ora at the OS level.I completed tableau oracle database error 12154 a test with tnsping and also connect to the database viasqlplus. Everything works fine at the OS level.I have created the connection parameters via tx:DBCOHowever i get the system message with error 12154 received logging on to the standby 11g text "Database error 12154 at CON"when i create a DB connection via tx:RSA1.Regards,Tolu DBCO.png 11.8 K 2028Views Tagsnone (add) Topics: enterprise_data_warehousing/business_warehouse Re: RSA1 Database error 12154 at CON issue Ranganath Korata Jul 29, 2013 2:23 PM (in response to Tolulope OKUSAGA) Currently Being Moderated Hi,It would be a task of the Basis, so please have them take a look at it.Thanks,Ranga Alert
Error 12154 Connecting To
Moderator Like (0) Re: RSA1 Database error 12154 at CON issue Johan Van Zyl Jul 29, 2013 2:28 PM (in response to Tolulope OKUSAGA) Currently Being Moderated Hi Tolulope, oerr ora 1215412154, 00000, "TNS:could not resolve the connect identifier specified"// *Cause: A connection to a database or other service was requested using// a connect identifier, and the connect identifier specified could not// be resolved into a connect descriptor using one of the naming methods// configured. For example, if the type of connect identifier used was a// net service name then the net service name could not be found in a// naming method repository, or the repository could not be// located or reached.// *Action:// - If you are using local naming (TNSNAMES.ORA file):// - Make sure that "TNSNAMES" is listed as one of the values of the// NAMES.DIRECTORY_PATH parameter in the Oracle Net profile// (SQLNET.ORA)// - Verify that a TNSNAMES.ORA file exists and is in the proper// directory and is accessible.// - Check that the net service name used as the connect identifier// exists in the TNSNAMES.ORA file.// - Make sure there are no syntax err
Currently Being Moderated Database error: ORA-12154: TNS: Could not resolve the connect identifier specified. (IES 10901) (WIS 10901 created by Murugan Ganapathy on Apr 18, 2014 3:28 AM, last modified by Murugan Ganapathy error 12154 received logging on to the standby rac on Apr 18, 2014 4:18 AM Version 1 Tweet Hi ,Here error 12154 connecting to standby host , i am sharing my experience on issue and solution for the TNS Error..I faced the issue,
Error 12154 Creating Remote Archivelog File
In Universe connection, server is responding and does not give error. i was able to use universe for query panel and can see the objects from the http://scn.sap.com/thread/3398578 same universe. But once we execute the query, then Error comes in the BO Launchpad.The below details explains more about the environment, issue and solutions.Issue:-ERROR: Database error: ORA-12154: TNS: Could not resolve the connect identifier specified. (IES 10901) (WIS 10901) Issue Details:In Universe connection, server is responding and does not give error. Able to use universe http://scn.sap.com/docs/DOC-54300 for query panel and can see the objects from the same universe. But once we execute the query,then Error comes in the BO Launchpad. Tools Used:Universe Connection - Relational Authentication - EnterpriseUser Name - AdministratorBo- BI4.1Bo web - 64 bitOracle -11gServer oracle -64 bitClient oracle - 32 bit Solution:-Check TNS Name in Environmental variable If you are using local naming (tnsnames.ORA file) , Make sure that "tnsnames" is listed as one of the values of the NAMES.DIRECTORY_PATH parameter in the Oracle Net profile (SQLNET.ORA)Verify that a tnsnames.ORA file exists and is in proper directory and is accessible. (in my case, TNS Name was pointing to Network path not my system directory path)Check that net service name used as the connect identifier exists in tnsnames.ORA file.No syntax errors anywhere in tnsnames.ORA file.Look for unmatched parentheses or stray characters. Errors in a tnsnames.ORA file may make it unusable.Check TNS Entry at BO server whether Oracle Server TNS Entry added in that TNS.ORA file or not R
try again. 4 Replies Latest reply on Mar 25, 2015 7:44 AM by Mark Fraser Oracle database error 12154: ORA-12154: TNS:could not resolve the connect identifier specified tonyfeole https://community.tableau.com/thread/122839 Jan 16, 2013 2:03 PM I have Tableau Desktop 7.0 installed on my local pc along with the Oracle Client drivers. I am able to create a successful ODBC connection using MS Access and TNSNAMES.ora file. However, when I try to connect directly to Oracle using Tablue Desktop, Server Name, Service Name and Port Number (under Advanced error 12154 Settings) I get the Oracle database error 12154: ORA-12154: TNS:cound not resolve the connection identified. Has anyone come accross this same issue and was there a workable solution available? Thanks in advance.-Tony I have the same question Show 0 Likes(0) 5221Views Tags: none (add) This content has been marked as final. Show 4 replies 1. Re: Oracle database database error 12154 error 12154: ORA-12154: TNS:could not resolve the connect identifier specified Dimitri.B Jan 16, 2013 8:32 PM (in response to tonyfeole) This can happen if Tableau can't find TNSNAMES.ora, which usually happens with non-standard installations of Oracle, i.e. Oracle home directory is not where Tableau expects it to be. You might need to set up an environment variable as described here: http://kb.tableausoftware.com/articles/knowledgebase/oracle-connection Like Show 1 Likes(1) Actions 2. Re: Oracle database error 12154: ORA-12154: TNS:could not resolve the connect identifier specified David Edwards Feb 13, 2014 9:10 AM (in response to tonyfeole) I guess this might be necro posting, but since it was never answered.....Tony,I am also experiencing this problem in v8.0 and v8.1.The article that Dimitri is referring to does not describe or address the problem that Tony and I are having.Specifically, it is for setting up the TNSNAMES.ora file so that you can use the service name to connect, rather than a host:port/servicename connection string.I was able to follow the instructions in the oracle connection knowledge base article that Dimitri li