Ociserverattach Error 12154
Contents |
failed" I can connect to Oracle via other means, but in SqlDbx, when attempting a connection, I get the following error... OCIServerAttach ociserverattach example failed ORA-12154: TNS:could not resolve the connect identifier specified. I have ociserverattach failed with ora-12154 three Oracle versions installed. I cannot tell in SqlDbx which version, or which TNSNAMES.ORA file is being ora-12154: tns:could not resolve the connect identifier specified referenced. Any ideas? #2 2010-07-29 11:29:04 Jason Lipman Guest Re: Connection Error "OCIServerAttach failed" Solved the problem. I moved Oracle 11 ahead of the other two versions ora-12154 tns could not resolve service name in the computer's path variable. Now 11 is referenced and SqlDbx is making a connection. I do not know why it failed to open Oravle 10.x, but it is working now. Thank you. Jason Lipman #3 2010-07-29 15:15:03 sqldbxhelp Administrator Re: Connection Error "OCIServerAttach failed" You can select Oracle home in Options->Oracle in Current Home
Ora-12154 Tns Could Not Resolve The Connect Identifier Specified Windows 7
combo box. Also you can see what TNSNAMES.ORA file is used. On login dialog select Oracle as DBMS type and click "..." button. You will see TNSNAMES.ORA file used on a bottom. Offline #4 2011-03-14 04:09:17 Vijesh Guest Re: Connection Error "OCIServerAttach failed" Hi All, I am also facing the same problem. But I dont want to install any other version of Oracle Client. Please assist how to solve this issue. I have Oracle 10 client. Vijesh #5 2011-03-17 19:51:16 sqldbxhelp Administrator Re: Connection Error "OCIServerAttach failed" Try to start SqlDbx with command line -l and take a look at file SqlDbx.exe.log which will be generated in the same directory where SqlDbx.exe located and email it to support (at) sqldbx.com Offline #6 2011-10-09 20:04:05 gap0134 Member Re: Connection Error "OCIServerAttach failed" I had the same problem. Not sure if you have the same exact issue or not. Try this: http://sqldbx.com/forum/viewtopic.php?pid=1252#p1252 Offline Pages: 1 Index »Oracle »Connection Error "OCIServerAttach failed" Board footer Powered by FluxBB
Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified at OCI call OCIServerAttach. [nQSError: 17014] Could not connect to Oracle database. The error is simply OBIEE reporting that it tried to connect from the BI Server
Error While Trying To Retrieve Text For Error Ora-12154
to an Oracle database and the Oracle client returned an error. Distilling it down gives ora-12154 tns could not resolve service name oracle 11g 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 tns-03505 got the correct Data 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 http://www.sqldbx.com/forum/viewtopic.php?id=246 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 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 https://rnm1978.wordpress.com/2009/10/22/troubleshooting-obiee-and-ora-12154-tnscould-not-resolve-the-connect-identifier/ 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: $tnsping ORCL TNS Ping Utility for HPUX: Version 10.2.0.1.0 - Production on 22-OCT-2009 12:38:33 Copyright (c) 1997, 2005, Oracle. All rights reserved. Used parameter files: /app/oracle/product/10.2.0/network/admin/sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = myoracleserver)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ORCL))) OK (0 msec) If you think you've eliminated these three possibilities then the next step would be to enable tracing in your Oracle Client so that you can see a bit more of what is going on. Add this to your $TNS_NAMES/sqlnet.ora file: trace_level_client = 10 trace_unique
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! http://www.dba-oracle.com/t_ora_12154_tns_resolve_service_name.htm Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
ORA-12154: TNS http://www.perlmonks.org/?node_id=543134 could not resolve service name tips Question: I need help with this error: ORA-12154: TNS: could not resolve service name.Answer: The ORA-12154 is a very not resolve common error, always related to your local copy of the tnsnames.ora file, your listener configuration and your database name aliases. Make sure that your listener is listening for the same service name that you are using. Your service name might have an alias, so check for global (world) entries and local entries. could not resolve Check: $ORACLE_HOME/network/admin/tnsnames.ora Check your global_name setting with this SQL: select * from global_name; The query value should match your init.ora parms for db_name and db_domain, You can change the global_name with an ALTER DATABASE command, as follows: alter database rename global_name to xxx; Also see these notes on configuring your tnsnames.ora file and troubleshooting network errors. Rampant author Steve Callan notes this on the ORA-12154 error: "One of the most common errors related to improper configuration is the "ORA-12154: TNS: could not resolve service name" error. It is not uncommon for new users of Oracle to spend hours upon hours trying to figure out what their mistake is when ORA-12154 appears." The oerr utility notes this on the ORA-12154 error:: $oerr ora 12154 ORA-12154: TNS:could not resolve the connect identifier specifiedCause: A connection to a database or other service was requested using a connect identifier, and the connect identifier specified could not be resolRecentThreads NewestNodes Donate What'sNew on Apr 13, 2006 at 16:16UTC ( #543134=perlquestion: print w/replies, xml ) Need Help?? Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question: I am having problems connecting to Oracle databases using Perl. I am able to connect to these databases using Benthic Golden32(third party software) and SQLPlus. Im using activestate perl 5.6, DBD-Oracle 1.16, DBI 1.48. I never had this problem before using the same scripts. I just got a new computer at work, dualcore Xeons and now I cant connect after re-installing everything. Here is the error: failed: ORA-12154: TNS:could not resolve the connect identifier specif +ied (DBD ERROR: OCIServerAttach) on line 70. Heres the code for my script: line 70 is the line that starts with my $dbp = DBI->.... print "Setting Database Connection to CDW-P.....\n"; # setting up database connection to CDW-P my $dbp = DBI->connect( 'dbi:Oracle:CDWP02' , "$user1" , "$passw") || die "Database connection not made: $DBI::errstr"; # Queries $Total_Free = "select SUM(BYTES/(1024*1024*1024)) as FREE_GB\n". "from dba_free_space WHERE TABLESPACE_NAME = 'USERSAUTO'"; $Total_V_Used = "select SUM(bytes/(1024*1024*1024)) as USE_GB\n". "from dba_segments WHERE TABLESPACE_NAME = 'USERSAUTO'\n"; $Used_by_ID = "select owner, SUM(bytes/(1024*1024*1024)) as TOTAL_GB\n +". "from dba_segments WHERE TABLESPACE_NAME = 'USERSAUTO'\n". "group by owner\n". "order by TOTAL_GB desc"; # Run Used Space Query print "Getting Used Space.\n"; ### Prepare a SQL statement for execution $CDWP_space_used = $dbp->prepare( "$Total_V_Used"); ### Execute the statement in the database $CDWP_space_used->execute; while ( $row = $CDWP_space_used->fetchrow_array( ) ) { $GC_space_used = $row; } print "$GC_space_used , Total CDW-P space\n"; [download] Let me know if you need more information or the whole code for the script. Thanks in advance to all u perl gurus....2006-04-14 Retitled by planetscape, as per Monastery guidelines Original title: 'DBD error Ora-12154