Ora 12154 Tns Protocol Adapter Error
Contents |
and SafetyAsset NetworkAsset ora-12154: tns:could not resolve service name Operations and MaintenanceCommerceOverviewSubscription Billing and Revenue ManagementMaster Data ora-12154 tns could not resolve the connect identifier specified windows 7 Management for CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning and
Tns Could Not Resolve The Connect Identifier Specified Sqlplus
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 asp.net ora-12154: tns:could not resolve the connect identifier specified 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 Service
specified Posted by Anil Kumar on December 3, 2014 All Posts, Database, Oracle DBA 2 Comments Rate this post This issue is faced in some versions of oracle as ORA-12154: tns could not resolve the connect identifier specified odbc TNS: Could not resolve service name. Mostly this issue comes in Oracle 10g
Ora-12154 Tns Could Not Resolve Service Name Oracle 11g
and Oracle 11g Express edition which i have faced. When you or any application try to connect to an Oracle
Ora-12154 Sqlplus
Service via Oracle Networking SQL*Net, it looks up the connect data for the service. When this lookup fails, Oracle client show an error message ORA-12154. Sometimes this error comes when one database instance tries https://scn.sap.com/thread/3311918 to connect to another database instance via database link. Root Cause: You try to connect to Oracle but the service name is either missing from the TNSNAMES.ORA file or is incorrectly defined. Resolution: Option-1: You have to make sure that the TNSNAMES.ORA file exists in the correct directory and accessible. %ORACLE_HOME% /network/admin/ Ex: In Oracle 11g express, it is located at below path. C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN Option-2: You have to http://itbloggertips.com/2014/12/ora-12154-tns-could-not-resolve-the-connect-identifier-specified/ make sure that the service name that you are trying to connect is included in the TNSNAMES.ORA file and that it is correctly defined. Option-3: Make sure that TNSNAMES is listed as one of the values of the names.directory_path parameter in the sqlnet.ora Oracle Net profile. Option-4: You have to make sure that the syntax of TNSNAMES.ORA file is correct. For example, if there are unmatched brackets in the file (ie: open bracket without the corresponding close bracket), the file will be rendered unusable. XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = TESTING.COM)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) If you are still facing the same issue, please write to us in comment section. We will try to help you. Get Free Blogging Tips & Technology updates in your Email !!! Subscribe via RSS feed 0 Related PostsResolved ORA-12528: TNS:listener: all appropriate instances are blocking new connections errorHow to Multiplex Control Files in OracleFixed ORA-12518: TNS:listener could not hand off client connectionOracle DBA TipsFixed - ORA-12560: TNS: protocol adapter errorFixed - ORA-00844: Parameter not taking MEMORY_TARGET into accountHow to change the SID of an Oracle XE instanceHow to Enable/Disable Archive Log Mode i
Επιλέξτε τη γλώσσα σας. Κλείσιμο Μάθετε περισσότερα View this message in English Το YouTube εμφανίζεται στα Ελληνικά. Μπορείτε https://www.youtube.com/watch?v=oIsbPJGC2k4 να αλλάξετε αυτή την προτίμηση παρακάτω. Learn more You're viewing YouTube in Greek. You can change this preference below. Κλείσιμο Ναι, θέλω να τη κρατήσω Αναίρεση Κλείσιμο Αυτό το βίντεο δεν είναι could not διαθέσιμο. Ουρά παρακολούθησηςΟυράΟυρά παρακολούθησηςΟυρά Κατάργηση όλωνΑποσύνδεση Φόρτωση... Ουρά παρακολούθησης Ουρά __count__/__total__ Oracle - TNS : Protocol Adapter Error Working Solution Srijit Banerjee ΕγγραφήΕγγραφήκατεΚατάργηση εγγραφής800800 Φόρτωση... Φόρτωση... Σε λειτουργία... Προσθήκη σε... Θέλετε να could not resolve το δείτε ξανά αργότερα; Συνδεθείτε για να προσθέσετε το βίντεο σε playlist. Σύνδεση Κοινή χρήση Περισσότερα Αναφορά Θέλετε να αναφέρετε το βίντεο; Συνδεθείτε για να αναφέρετε ακατάλληλο περιεχόμενο. Σύνδεση 49.380 προβολές 76 Σας αρέσει αυτό το βίντεο; Συνδεθείτε για να μετρήσει η άποψή σας. Σύνδεση 77 6 Δεν σας αρέσει αυτό το βίντεο; Συνδεθείτε για να μετρήσει η άποψή σας. Σύνδεση 7 Φόρτωση... Φόρτωση... Φόρτωση... Η δυνατότητα αξιολόγησης είναι διαθέσιμη όταν το βίντεο είναι ενοικιασμένο. Αυτή η λειτουργία δεν είναι διαθέσιμη αυτήν τη στιγμή. Δοκιμάστε ξανά αργότερα. Ανέβηκε στις 14 Φεβ 2012Oracle - TNS