Error Code 17014
Contents |
Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified at OCI call OCIServerAttach. [nQSError: 17014] Could not connect to nqserror 17014 could not connect to oracle database obiee Oracle database. The error is simply OBIEE reporting that it tried to
Nqserror 17001 In Obiee 11g
connect from the BI Server to an Oracle database and the Oracle client returned an error. Distilling it nqserror 17014 in obiee 11g down gives us this error: ORA-12154: TNS:could not resolve the connect identifier specified at OCI call OCIServerAttach. This generally means one of three things: You've got the correct Data
Ora-12154: Tns:could Not Resolve The Connect Identifier Specified At Oci Call Ociserverattach
Source Name (DSN) in your connection pool configuration, but not in your tnsnames.ora file You've got the correct DSN in your tnsnames.ora but you've not updated the connection pool, or connection pools You've got the correct DSN in your connection pool and tnsnames.ora, but have multiple tnsnames.ora files and OBIEE is using a different one from the one you've got could not connect to oracle database in obiee 11g the correct DSN in. To check your connection pool, open the RPD in Adminstration tool and go to the Physical Layer. Expand the Database, and double-click on the Connection Pool (if you're not sure which one, then check all of them!). In the connection pool check the Data Source Name and make sure it matches to what you have in your tnsnames.ora file: To check your tnsnames.ora, first locate it. This ties in with the third point on my list too. Be aware that you may have several copies of this file, so make sure you're opening the correct one. I've not done extensive testing of this but until proven otherwise I would assume that OBIEE uses the tnsnames.ora in $ORACLE_HOME/network/admin/ $ORACLE_HOME should be set in [OracleBI]/setup/user.sh or your user profile. Note that it's the home for the connectivity (usually client), not necessarily your DB. Once you've located the correct tnsnames.ora file check that it has a valid entry for the DSN in your connection pool. You should use the tnsping utility to validate it: $t
Check Error Console Dashboard Database Display Error Enterprise Manager Mobile Model Check Error nQSError OBIEE
Obiee 11g Tnsnames Ora Location
11.1.1.7 Oracle Error Code Performance Presentation Server Error Properties
Nqserror 43113 Message Returned From Obis
Queries Repository Server XML edit CONTACT Name *Email *Message *VerificationPlease enter any two digits error codes: opr4onwy:u9im8tac:oi2dl65p *Example: 12This box is for spam protection - please leave it blank: RECENT Add a message to the Sign In page The primary https://rnm1978.wordpress.com/2009/10/22/troubleshooting-obiee-and-ora-12154-tnscould-not-resolve-the-connect-identifier/ key of the logical level is not unique Invalid identifier at OCI call OCIStmtExecute (2) Cannot read property ‘getAttribute' of null Change "signing-in-failed" message on Sign In screen Tagscatalog manager column selector connection pool consistency check content delete dimension entry error Error No. 39008 hostname HTML identifier http://www.obiee247.com/tag/nqserror-17014/ instanceconfig.xml key level locked LOV Managed server Node manager nQSError: 10058 nQSError: 15001 nQSError: 17001 nQSError: 17010 nQSError: 17014 nQSError: 43093 nQSError: 43113 nQSError: 43119 OBIEE ORA-00942 Oracle BI processes physical column prompt prompts replace repository rpd runcat.sh Sign In tnsnames.ora user warning webcat Weblogic server xml Tag: nQSError: 17014 ORACLE not available ORA-27101: shared memory realm does not exist Linux-x86_64 Problem: Error message in report Screenshot: Screenshot text: State: HY000. Code: 10058. [NQODBC][SQL_STATE: HY000][nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] The query failed: [nQSError: 17001] Oracle-foutcode: 1034, bericht: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux-x86_64 Error: 2: No such file or directory at OCI call OCISessionBegin. [nQSError: 17014] Can not connection to the Oracle Database (HY000) Causes: There are lots of causes and solutions to th
With Error: "ORA-12504 or ORA-12154″ February 21, 2012 OBIEE Architect Leave a comment Applies to Business Intelligence Suite Enterprise Edition - http://obiee-blog.info/tag/connection-pool/ Version: 11.1.1.3.0 [1905] to 11.1.1.5.0 [1308] [Release: 11g to 11g] Symptoms After upgrading to Oracle Business Intelligence Enterprise Edition (OBIEE) 10g to OBIEE 11g, when viewing a dashboard or creating a new analysis in Answers, the following error occurs: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from obiee 11g OBIS. [nQSError: 43119] Query Failed: [nQSError: 17001] Oracle Error code: 12504, message: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA at OCI call OCIServerAttach. [nQSError: 17014] Could not connect to Oracle database. (HY000) Or you might get the error: [2010-11-16T06:02:38.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 004_ILDmfHpFw000jzwkno0002Xk0000qx] [tid: 4f353960] [nQSError: 17014] Could not connect to in obiee 11g Oracle database. [[ [nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified at OCI call OCIServerAttach. [nQSError: 43093] An error occurred while processing the EXECUTE PHYSICAL statement. [nQSError: 43113] Message returned from OBIS. It looks like all the database connections have been broken. Another symptom that may occur is that the BI Server does not start up and you get the following error in the nqserver.log: [ecid: 00hxwa3cUNZ4aq_S9Q2FSx0001SO000000] [tid: 814] [36007] Loading repository E:\obiee11g\instances\instance2\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository\11rpd.rpd. [2011-01-06T20:20:52.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00hxwa3cUNZ4aq_S9Q2FSx0001SO000000] [tid: 19b4] [nQSError: 17014] Could not connect to Oracle database. [[[nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specifiedat OCI call OCILogon. Changes Upgraded from OBIEE 10g to OBIEE 11g. Cause In OBIEE versions prior to 11g, it uses the database client home tnsnames.ora file to resolve the tnsname. But OBIEE 11g uses the tnsnames.ora file installed within its installation home. The path is [middleware home]/[oracle home]/Oracle_BI1/network/admin By default, there are
be down. Please try the request again. Your cache administrator is webmaster. Generated Mon, 10 Oct 2016 20:55:41 GMT by s_wx1131 (squid/3.5.20)