Error 12154 Oracle Odbc
Contents |
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 oracle odbc ora 12154 reload this page. Please enter a title. You can not post oracle error 12154 received logging on to the standby a blank message. Please type your message and try again. More discussions in ODBC All PlacesDatabaseDatabase Application
Oracle Error 12154 Encountered
DevelopmentWindows and .NETODBC This discussion is archived 11 Replies Latest reply on Jul 27, 2013 2:48 PM by aefb3eb8-b393-4133-8d46-6337253a7c34 Oracle ODBC Connection - ora-12154 984717 Jan 14, 2013
Oracle Database Error 12154
4:05 PM Hello all, i have one DB-Server and one Application-Server. From the App-Server i want to access the db via odbc. Even if i create the odbc connection in windows odbc manager and click "test connection", i get the error "Ora-12154 TNS: Angegebener Connect Identifier konnte nicht aufgelöst werden" DB-Server: Oracle DB 11.0.2g 64 bit oracle tns error 12154 App-Server: windows 2008 R2 64Bit, login as network administrator Oracle Instantclient_11_2 with installed ODBC drivers folder of instantclient: "C:\ora\instantclient_11_2_new" folder of tnsnamesora: "C:\ora\net" environment variables: -ORACLE_HOME: "C:\ora\instantclient_11_2_new" -Path: "C:\ora\instantclient_11_2_new" -TNS_Admin: "C:\ora\net" tnsnames.ora: bns = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.99.99)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = bns) ) ) Anybody has an idea what the issue is ? Unfortunately this is the first odbc connection to the oracle db. Thanks for your help I have the same question Show 0 Likes(0) 39819Views Tags: none (add) odbcContent tagged with odbc This content has been marked as final. Show 11 replies 1. Re: Oracle ODBC Connection - ora-12154 Tridus Jan 15, 2013 12:06 PM (in response to 984717) Well, that error primarily comes up if it can't find your tnsnames.ora file. It could be not picking up the TNS_ADMIN environment variable, so you could try setting it in the registry instead. Like Show 0 Likes(0) Actions 2. Re: Oracle ODBC Connection - ora-12154 624
resolve the connect identifier specified"? Article: 00951 Last Reviewed: 7th September 2006 Revision: 1 This error indicates that Oracle is unable to locate the service name specified in your
12154 Oracle Error Code
Easysoft ODBC-Oracle Driver ODBC data source. You need to check the Database ora-12154 tns could not resolve service name attribute value in the data source.If you are using the standard Oracle client, the Database attribute value must specify a ora-12154 tns could not resolve the connect identifier specified windows 7 valid service name defined in tnsnames.ora. For example, for the following tnsnames.ora entry, the Database attribute value needs to be my_database: my_database = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = my_host)(PORT https://community.oracle.com/thread/2488042 = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = my_database) ) ) If you are using the Instant Client without a tnsnames.ora file, the Database attribute value needs to be a SQL connect URL rather than a service name: //host:port/service_name where host is the host name or IP address of the Oracle database server, port is the Oracle listener port and service_name is the service http://www.easysoft.com/support/kb/kb00951.html name. For example: //my_host:1521/my_database If you want to use the Instant Client with a tnsnames.ora file, the Database attribute value must specify a tnsnames.ora service name and you need to set and export the TNS_ADMIN environment variable. Set TNS_ADMIN to specify the location of the tnsnames.ora file. For example: TNS_ADMIN = /home/oracle/network/admin export TNS_ADMIN Applies To Products Easysoft ODBC-Oracle Driver Knowledge Base Feedback * Did this content help you? Yes No Maybe * Please select one option based on your first choice: I'm very satisfied I think it will help, but I haven't tried it yet It is helpful, but I need more information It is helpful, but hard to understand Seemed relevant in search results, but didn't help me The information is incorrect The page contains one or more broken links Suggest new content or let us know how we can improve this content: (* Required Fields) About Easysoft Contact Us About Us Clients Upgrade Offer Blog Careers Products ODBC Drivers JDBC Drivers Bridges and Gateways In Development Services Consultancy Training Custom Development Licensing Product Licenses Prices Support Support Home Solution Wizard Getting Started Guides User Guides Knowledge Base Search Easysoft.c
Links Social Groups Pictures & Albums Members List Search Forums Show Threads Show Posts Tag Search Advanced Search Go to Page... https://www.zabbix.com/forum/showthread.php?t=53288 Thread Tools Display Modes #1 07-04-2016, 13:06 mark.chan Junior Member Join Date: Mar 2016 Posts: 21 ODBC oracle error on web interface ORA-12154: TNS:could http://scn.sap.com/thread/1688856 not resolve the connect ident Problems come out one by one..... After solving [Driver Manager]Can't open lib '/usr/lib/oracle/12.1/client64/lib/libsqora.so.12.1' : file not found]| and other problem Cannot connect to ODBC error 12154 DSN:[SQL_ERROR]:[08004][12154][[unixODBC][Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified ]| those error message are shown on web interface again, the isql is work... Code: [root@localhost ~]# isql -v uatt +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL> quit For the env: Code: [root@localhost ~]# echo $LD_LIBRARY_PATH oracle error 12154 /usr/lib/oracle/12.1/client64/lib/ [root@localhost ~]# echo $TNS_ADMIN /usr/lib/oracle/12.1/client64/network/admin mark.chan View Public Profile Send a private message to mark.chan Find all posts by mark.chan #2 08-04-2016, 04:41 Atsushi Senior Member Join Date: Aug 2013 Location: Japan Posts: 435 Please read error messages. Location of the configuration files, such as tnsnames.ora is will incorrect. It might also be improved by setting such as the environment variable ORACLE_HOME. Atsushi View Public Profile Send a private message to Atsushi Find all posts by Atsushi #3 08-04-2016, 04:50 mark.chan Junior Member Join Date: Mar 2016 Posts: 21 But when i use isql to connect, it is ok. is that add the ORACLE_HOME to to sysconfig/zabbix ? edit: i now adding those var into 3 files: /root/.bash_profile , /root/.bashrc and /etc/sysconfig/zabbix Code: LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib export LD_LIBRARY_PATH TNS_ADMIN=/usr/lib/oracle/12.1/client64/network/admin export TNS_ADMIN ORACLE_HOME=/usr/lib/oracle/12.1/client64 export ORACLE_HOME and it doesn't work..... Code: [root@localhost ~]# ls -al $ORACLE_HOME/network/admin/ total 4 drwxr-xr-x. 2 root root 25 Apr 6 17:54 . drwxr-xr-x. 3 root root 18 Apr 6 17:54
and SafetyAsset NetworkAsset Operations and MaintenanceCommerceOverviewSubscription Billing and Revenue ManagementMaster Data Management for CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning and AnalysisTreasury and Financial Risk ManagementHuman ResourcesOverviewCore Human Resources and PayrollHuman Capital AnalyticsTalent ManagementTime and Attendance ManagementManufacturingOverviewManufacturing NetworkManufacturing OperationsResponsive ManufacturingMarketingOverviewMarket with Speed and AgilityUnique Customer ExperiencesReal-Time Customer InsightsR&D/EngineeringOverviewDesign NetworkDesign OrchestrationProject and Portfolio ManagementSalesOverviewCollaborative Quote to CashSales Force AutomationSales Performance ManagementSelling Through Contact CentersServiceOverviewEfficient Field Service ManagementOmnichannel Customer ServiceTransparent Service Process and OperationsSourcing and ProcurementOverviewContingent Workforce ManagementDirect ProcurementSelf-Service ProcurementServices ProcurementStrategic Sourcing and Supplier ManagementSupply ChainOverviewDemand ManagementDemand NetworkLogistics NetworkManufacturing Planning and SchedulingResponse NetworkResponse and Supply ManagementSales, Inventory, and Operations PlanningTransportation ManagementWarehouse ManagementSustainabilityOverviewEnvironment, Health, and SafetyProduct Safety and Stewardship NetworkBrowse by IndustryAerospace and DefenseAutomotiveBankingChemicalsConsumer ProductsDefense and SecurityEngineering, Construction, and OperationsHealthcareHigh TechHigher Education and ResearchIndustrial Machinery and ComponentsInsuranceLife SciencesMediaMill ProductsMiningOil and GasProfessional ServicesPublic SectorRetailSports and EntertainmentTelecommunicationsTravel and TransportationUtilitiesWholesale DistributionBrowse Platform and TechnologyAnalyticsOverviewBusiness IntelligencePredictive AnalyticsGovernance, Risk, and ComplianceEnterprise Performance ManagementApplication Platform and InfrastructureOverviewApplication PlatformContent and CollaborationInterface ManagementProcess Management and IntegrationData ManagementOverviewBig Data on HadoopData WarehousingDatabase ManagementEnterprise Information ManagementIT ManagementOverviewApplication Lifecycle ManagementIT Infrastructure ManagementSecurity SoftwareOverviewApplication and IT Infrast