Home > ora 12154 > business objects error ora-12154

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

 

Related content

12154 error in toad

Error In Toad table id toc tbody tr td div id toctitle Contents div ul li a href Error Received Logging On To The Standby g a li li a href Error Connecting To a li ul td tr tbody table p Oracle SQL Server PRODUCTSDiscussion Resources Backup Reporter Benchmark Factory Code Tester for Oracle SQL relatedl Navigator SQL Optimizer for IBM DB SQL Optimizer ora toad for Oracle SQL Optimizer for SQL Server SQL Optimizer for SAP toad oracle ora ASE Spotlight on DB LUW Spotlight on Oracle Spotlight on SQL Server Spotlight on SAP ASE ora toad windows

asp net ora 12154 error

Asp Net Ora Error table id toc tbody tr td div id toctitle Contents div ul li a href Ora Error Solution a li li a href Ora Error Informatica a li li a href Ora Error a li li a href Ora Error a li ul td tr tbody table p here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the relatedl workings and policies of this site About Us Learn more ora error in oracle g about Stack Overflow the company Business Learn more about hiring developers

crystal reports error ora-12154

Crystal Reports Error Ora- table id toc tbody tr td div id toctitle Contents div ul li a href Ora Tns Error a li li a href Ora Tns Could Not Resolve Service Name a li ul td tr tbody table p SAP Crystal Reports version for Visual StudioWhere is this place located All Places SAP Crystal Reports version for Visual Studio Replies Latest relatedl reply Jan PM by Andrew error while trying to retrieve text for error ora- Paes Tweet Crystal Reports Windows Server ORA- TNS could not resolve the ora error in oracle g connect identifier specified Andrew

database server error ora-12154

Database Server Error Ora- table id toc tbody tr td div id toctitle Contents div ul li a href Error While Trying To Retrieve Text For Error Ora- a li li a href Ora Tns Could Not Resolve Service Name a li li a href Ora Tns No Listener a li ul td tr tbody table p TNS received bad packet type from network layer Cause Internal error Action Not normally visible to the user For further details turn on tracing and reexecute the operation If error persists relatedl contact Worldwide Customer Support ORA- TNS unable to send break message

database error code 12154 ora 12154

Database Error Code Ora table id toc tbody tr td div id toctitle Contents div ul li a href Ora Error In Oracle g a li li a href Ora Tns Could Not Resolve Service Name a li li a href Ora Tns Could Not Resolve The Connect Identifier Specified Xe a li ul td tr tbody table p TNS received bad packet type from network layer Cause Internal error Action Not normally visible to the user For relatedl further details turn on tracing and reexecute the operation database link ora If error persists contact Worldwide Customer Support ORA- TNS

dblink error ora-12154

Dblink Error Ora- table id toc tbody tr td div id toctitle Contents div ul li a href Ora- Connection Description For Remote Database Not Found a li li a href Create Database Link Oracle a li ul td tr tbody table p here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site relatedl About Us Learn more about Stack Overflow the company Business Learn ora error in oracle g more about hiring developers or posting ads with us Stack Overflow Questions Jobs

error 12154 ora-12154

Error Ora- table id toc tbody tr td div id toctitle Contents div ul li a href Ora Error a li li a href Ora Tns Could Not Resolve Service Name a li li a href Ora Error In Oracle a li li a href Error Ora a li ul td tr tbody table p SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support SPAN Development Implementation Consulting StaffConsulting PricesHelp Wanted Oracle PostersOracle Books Oracle Scripts Ion Excel-DB relatedl Don Burleson Blog P TD TR ora tns could not resolve the connect identifier

error attach server ora-12154

Error Attach Server Ora- table id toc tbody tr td div id toctitle Contents div ul li a href Error While Trying To Retrieve Text For Error Ora- a li li a href Ora Error In Toad a li li a href Ora Tns Error a li li a href Ora Tns No Listener a li ul td tr tbody table p while creating a linked server to Oracle x x x x x x x x x x x x x x x SnehadeepJune This is one relatedl of the most common errors while creating linked p h id

error code ora 12154

Error Code Ora table id toc tbody tr td div id toctitle Contents div ul li a href Ora Tns Could Not Resolve Service Name Oracle i a li li a href Ora Tns Could Not Resolve The Connect Identifier Specified Xe a li ul td tr tbody table p TNS received bad packet type from network layer Cause Internal error Action Not normally visible to the user For further details turn on tracing and reexecute relatedl the operation If error persists contact Worldwide Customer Support ora error in oracle g ORA- TNS unable to send break message Cause Unable

error from recovery catalog database ora-12154

Error From Recovery Catalog Database Ora- table id toc tbody tr td div id toctitle Contents div ul li a href Ora Error In Oracle g a li li a href Rman Ora a li li a href Rman- Error From Recovery Catalog Database a li ul td tr tbody table p ORA- database link ora TNS could not resolve service name message p h id Ora Error In Oracle g p Tue August in lukfai Messages Registered July p h id Rman Ora p Location India Junior Member C set oracle sid katie C net start oracleServiceKatie The OracleServicekatie

error from auxiliary database ora-12154

Error From Auxiliary Database Ora- table id toc tbody tr td div id toctitle Contents div ul li a href Database Link Ora a li li a href Ora Error Solution a li li a href Ora Error a li li a href Ora Error a li ul td tr tbody table p NEWNAME FOR DATAFILE and SET NEWNAME FOR TEMPFILE SET NEWNAME FOR TABLESPACE relatedl SET NEWNAME FOR DATABASE The following variables are p h id Database Link Ora p introduced for SET NEWNAME from gR - b The file name remains ora error in oracle g same as

error ora 12154 could not resolve service name

Error Ora Could Not Resolve Service Name table id toc tbody tr td div id toctitle Contents div ul li a href Ora Tns Could Not Resolve Service Name Oracle i a li li a href Ora Tns Could Not Resolve The Connect Identifier Specified Xe a li li a href Ora Tns Could Not Resolve The Connect Identifier Specified At Oci Call Ociserverattach a li ul td tr tbody table p here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About

error ora 12154 in

Error Ora In table id toc tbody tr td div id toctitle Contents div ul li a href Sqlnet Ora a li li a href Ora Error Toad a li li a href Error While Trying To Retrieve Text For Error Ora a li li a href Ora Error In Oracle a li ul td tr tbody table p while creating a linked server to Oracle x x x x x x x x x x x x x x x SnehadeepJune This is one of the most common errors relatedl while creating linked server to Oracle database Today I

error ora 12154 tns could not resolve the service name

Error Ora Tns Could Not Resolve The Service Name table id toc tbody tr td div id toctitle Contents div ul li a href Ora Tns Could Not Resolve Service Name Oracle i a li li a href Ora Tns Could Not Resolve Connect Identifier Specified g a li li a href System Data Oracleclient Oracleexception Ora Tns Could Not Resolve The Connect Identifier Specified a li li a href Ora Tns Could Not Resolve The Connect Identifier Specified N a li ul td tr tbody table p here for a quick overview of the site Help Center Detailed answers

error ora-12154 toad

Error Ora- Toad table id toc tbody tr td div id toctitle Contents div ul li a href Ora Toad Windows a li li a href Ora Tns Error a li li a href Ora Toad a li ul td tr tbody table p NoSQL Oracle SQL Server PRODUCTSDiscussion Resources Benchmark Factory Code Tester for Oracle SharePlex SQL Navigator SQL Optimizer relatedl Spotlight Stat Toad Intelligence Central Toad Data Modeler toad oracle ora Toad Data Point Toad Extension for Eclipse Toad for Hadoop Toad for p h id Ora Toad Windows p IBM DB Toad for Oracle Toad for MySQL

error ora 12154 tns could not resolve service name

Error Ora Tns Could Not Resolve Service Name table id toc tbody tr td div id toctitle Contents div ul li a href Ora Tns Could Not Resolve Service Name Oracle i a li li a href Ora Tns Could Not Resolve Service Name Windows a li li a href Ora Tns Could Not Resolve Connect Identifier Specified g a li ul td tr tbody table p TNS received bad packet type from network layer Cause Internal error Action Not normally visible to the user For further details turn on relatedl tracing and reexecute the operation If error persists contact

error ora-12154 oracle

Error Ora- Oracle table id toc tbody tr td div id toctitle Contents div ul li a href Ora Oracle i a li li a href Oracle Ora Database Link a li li a href Ora Oracle a li li a href Ora Oracle a li ul td tr tbody table p server but either failed to contact the server or did not find a relatedl matching service name on that server TNS or oracle error ora 'Transparent Network Substrate' is a transport protocol that allows Oracle sessions to p h id Ora Oracle i p communicate across a network

error ora 12154 tns could

Error Ora Tns Could table id toc tbody tr td div id toctitle Contents div ul li a href Ora Tns Could Not Resolve Service Name Oracle i a li li a href Ora Tns Could Not Resolve The Connect Identifier Specified Xe a li li a href Ora Tns Could Not Resolve Service Name Windows a li li a href Ora Tns Could Not Resolve The Connect Identifier Specified N a li ul td tr tbody table p TNS received bad packet type from network layer Cause Internal error Action Not normally visible to the user For further details

error oracle connection error ora-12154

Error Oracle Connection Error Ora- table id toc tbody tr td div id toctitle Contents div ul li a href Oracle Ora Database Link a li li a href Oracle Odbc Ora a li li a href Oracle Ora a li ul td tr tbody table p TNS received bad packet type from network layer Cause Internal error Action Not normally visible to the user For further details turn on tracing and relatedl reexecute the operation If error persists contact Worldwide Customer ora error in oracle g Support ORA- TNS unable to send break message Cause Unable to send break

ora 12154 database driver error

Ora Database Driver Error table id toc tbody tr td div id toctitle Contents div ul li a href Sqlnet ora Location a li li a href Informatica Oracle Connection String a li ul td tr tbody table p WizardInformatica Cloud for Amazon AWSComplex Event ProcessingProactive Healthcare Decision ManagementProactive MonitoringReal-Time Alert ManagerRule PointData IntegrationB B Data ExchangeB B Data TransformationData Integration HubData relatedl ReplicationData ServicesData Validation OptionFast CloneInformatica PlatformMetadata ManagerPowerCenterPowerCenter ora- tns could not resolve the connect identifier specified in informatica ExpressPowerExchangePowerExchange AdaptersData QualityAddress DoctorAddress Doctor CloudData as a ServiceData informatica repository service ora- ExplorerData QualityData Quality Services Strike Iron

ora 12154 dblink error

Ora Dblink Error table id toc tbody tr td div id toctitle Contents div ul li a href Ora- a li ul td tr tbody table p here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more relatedl about Stack Overflow the company Business Learn more about hiring developers ora tns could not resolve the connect identifier specified g or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x p h id Ora-

ora 12154 tns error in toad

Ora Tns Error In Toad table id toc tbody tr td div id toctitle Contents div ul li a href Ora Toad a li li a href Ora Tns Could Not Resolve Service Name a li ul td tr tbody table p NoSQL Oracle SQL Server PRODUCTSDiscussion Resources Benchmark Factory Code Tester for Oracle SharePlex SQL Navigator SQL Optimizer Spotlight Stat Toad Intelligence Central relatedl Toad Data Modeler Toad Data Point Toad Extension for p h id Ora Toad p Eclipse Toad for Hadoop Toad for IBM DB Toad for Oracle Toad for toad tns admin environment variable is not

ora 12154 error in oracle 11g

Ora Error In Oracle g table id toc tbody tr td div id toctitle Contents div ul li a href Ora- Tns Listener Does Not Currently a li li a href Ora- Oracle c a li li a href Error While Trying To Retrieve Text For Error Ora- a li ul td tr tbody table p to send data Connection probably disconnected Action Reestablish connection If the error is persistent turn relatedl on tracing and reexecute the operation ORA- TNS received ora error in oracle c bad packet type from network layer Cause Internal error Action Not normally ora error

ora 12154 error in oracle forms

Ora Error In Oracle Forms p CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError You don't have JavaScript enabled This tool uses JavaScript and much of it will not work correctly without it enabled Please turn JavaScript back on and relatedl reload this page Please enter a title You can not ora oracle g post a blank message Please type your message and try again More discussions ora tns could not resolve service name in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived Previous Next Replies Latest reply on Aug PM by rajeysh Go to original post

ora 12154 error toad

Ora Error Toad table id toc tbody tr td div id toctitle Contents div ul li a href Ora Tns Could Not Resolve Service Name a li li a href Tns admin Environment Variable Is Not Defined a li li a href Tnsnames ora Location a li ul td tr tbody table p NoSQL Oracle SQL Server PRODUCTSDiscussion Resources Benchmark Factory Code Tester for Oracle SharePlex SQL Navigator SQL Optimizer Spotlight Stat Toad Intelligence Central Toad Data Modeler Toad Data Point Toad relatedl Extension for Eclipse Toad for Hadoop Toad for IBM DB Toad ora toad for Oracle Toad for

ora 12154 toad error

Ora Toad Error table id toc tbody tr td div id toctitle Contents div ul li a href Ora Toad a li li a href Tns admin Environment Variable Is Not Defined a li ul td tr tbody table p NoSQL Oracle SQL Server PRODUCTSDiscussion Resources Benchmark Factory Code Tester for Oracle SharePlex SQL Navigator SQL relatedl Optimizer Spotlight Stat Toad Intelligence Central Toad Data p h id Ora Toad p Modeler Toad Data Point Toad Extension for Eclipse Toad for Hadoop ora tns could not resolve service name Toad for IBM DB Toad for Oracle Toad for MySQL Toad