Business Objects Error Ora-12154
Contents |
SAP BusinessObjects Web IntelligenceWhere is this place located?All Places SAP BusinessObjects Web Intelligence 2 Replies Latest reply: Jun 10, 2011 10:20 AM by Mark Prosser
Error While Trying To Retrieve Text For Error Ora-12154
ORA-12154: TNS: could not resolve the connect identifier specified(Webi) Amit Pathak ora 12154 error in oracle 11g Jun 10, 2011 7:08 AM Currently Being Moderated Hi All,We are using BOBJ Edge 3.1on top
Ora 12154 Error Solution
of Oracle 9i.Iam able to create the Universe,connection and the Desktop Intelligence Reports.But when iam trying to create a Webi Report, iam getting the error message ora 12154 error in toad "u201CORA-12154: TNS: could not resolve the connect identifier specifiedu201D.Iam gettig the same error when iam trying to preview the QAAWS.Any idea why we are getting this issue.RegardsAmit 6788Views Re: ORA-12154: TNS: could not resolve the connect identifier specified(Webi) Mark Prosser Jun 10, 2011 10:20 AM (in response to Amit Pathak) Currently Being Moderated You ora 12154 tns error need to make sure that you have a correct TNSNAMES.ORA file set up with the SID for your target schema on your Webintelligence server. Ask your Oracle DBA to set it up for you. Alert Moderator Like (0) Re: ORA-12154: TNS: could not resolve the connect identifier specified(Webi) Amit Kumar Jun 10, 2011 10:20 AM (in response to Amit Pathak) Currently Being Moderated Hi,Please go through by below links.http://www.forumtopics.com/busobj/viewtopic.php?p=323318http://www.forumtopics.com/busobj/viewtopic.php?p=546397&sid=867a249397f1827c4290cb6de57b1affThanks,Amit Alert Moderator Like (0) Re: ORA-12154: TNS: could not resolve the connect identifier specified(Webi) Mukunthan Damodharan Dec 23, 2011 6:28 AM (in response to Amit Pathak) Currently Being Moderated Hi,Please ensure the user which you are connecting does not have symbol @ , because after @ symbol it will be taken as the instance to which you are trying to connect.RegardsD.Mukunthan Alert Moderator Like (0) Go to original post Actions Login to follow, like, comment, share and bookmark content. Login Register Follow SCNJive Software Version: 5.0.6.2 , revision: 201308121150.54f5b14.release_5_0_6_2
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows <
Ora 12154 Tns Could Not Resolve Service Name
Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design ora 12154 tns no listener MEMBERS Paul_Pedant MarkDeVries DACREE Inside-ERP MacProTX VoIP_News Inside-CRM I_am_the_dragon PCMag Michael Meyers-Jouan maxwellarnold TerryCurran Chris_Day Andrew.S.Baker JoeTorre bracke Richard Locutus DukeGanote Craig
Ora 12154 Tns Could Not Resolve Service Name Oracle 9i
Borysowich Ramnath.Awate Dennis Stevenson Nikki Klein AbhaiTripathi mircea_luca bluesguyAZ59 Clinton Jones knowscognosdoi iudithm Iqbalyk COMPANIES Alfresco Software, Inc. Cisco EdgeWave Citrix View All Topics View All Members View All Companies Toolbox for IT Topics Oracle Groups Ask https://scn.sap.com/thread/1972319 a New Question Oracle BI The Oracle BI group is for the discussion of technical issues that arise during the implementation, configuration, or daily use of Oracle Business Intelligence solutions. Home | Invite Peers | More Oracle Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and http://oracle.ittoolbox.com/groups/technical-functional/oracle-bi-l/business-objects-designer-xi-error-ora12154-1744776 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Business Objects Designer XI - Error ORA-12154 Jonathan Camilleri asked Dec 4, 2007 | Replies (2) Environment BO XI R2 installed on a virtual machine (Virtual PC 2005) OS: WinXPSP2 I'm getting this error when (Universe) Designer is trying to connect to the databases. The connection through other tools seems fine. Error: TNS:could not resolve the connect identifier specified. Join this group Popular White Paper On This Topic The Six Questions Every IT Leader Needs to Ask 2Replies Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Michael McErlain, CBIP replied Dec 4, 2007 JonLooks like your Oracle middleware is not set up properly to connect to the database(s). Oracle needs to know where the data server is located by putting an entry the TNSNAMES.ORA file. You can locate this file in your Oracle directory in the NETWORK \ ADMIN subdirectory. Put an entry to the database serving the data you are looking fo
while creating a linked server to Oracle ★★★★★★★★★★★★★★★ SnehadeepJune 30, 201028 0 0 0 This is one of the most common errors while creating linked server to Oracle database. Today I will discuss the reason https://blogs.msdn.microsoft.com/dataaccesstechnologies/2010/06/30/ora-12154-tns-could-not-resolve-the-connect-identifier-specified-error-while-creating-a-linked-server-to-oracle/ for this error and possible resolutions.
Full error message: OLE DB provider "MSDAORA" for linked server "LINKED_ORA" returned message "ORA-12154: TNS:could not resolve the connect identifier specified". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "MSDAORA" for linked server "LINKED_ORA". First of all make sure you have reviewed the following Microsoft KB article ora 12154 that has a lot of good information on troubleshooting Oracle linked server issues. How to set up and troubleshoot a linked server to an Oracle database in SQL Server http://support.microsoft.com/kb/280106 Also make sure you have installed Oracle Client on the SQL server. If the SQL server is 64 bit then we need to install 64 bit Oracle provider. You can also create linked server using Oracle ODBC ora 12154 tns driver together with Microsoft OLE DB provider for ODBC. Once again on a 64 bit SQL server you need to install the 64-Bit OLEDB Provider for ODBC (MSDASQL) and 64 bit Oracle ODBC drivers. However 64-Bit OLEDB Provider for ODBC (MSDASQL) is already there in Windows Vista/Windows Server 2008 and later OS. This particular error message is a very general error message and can happen for quite a number of reasons. For general understanding of the error, you can review oracle documentation like this http://ora-12154.ora-code.com/ In SQL Server Linked Server, it could indicate a few things (not limited to)– 1. SQL Server (and oracle net libraries) is not able to get the TNS alias from tnsnames.ora file. 2. Something is wrong with the way the alias is created in the tnsnames.ora file (incorrect syntax) 3. TNS alias could not be resolved into a connect descriptor Below is a list of things that you can try to resolve this issue. 1. Verify that the tnsnames.ora file has the alias and the service name that the customer is using. TNS entry for the Oracle database =========================== OracleDB_Dev = (DESCRIPTION = (ADDRESS_LIS