This section shows an example XHTML document.
<html> <head> <meta content="text/html; charset=UTF-8" http-equiv="Content-Type"/> <title>ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor</title> <meta name="atg:enum:$ccDataSource" content="eserver"/> <meta name="atg:string:$solution_id" content="primus7524"/> <meta name="atg:string:$solution_uuid" content="0060142a-e7e8-11d4-bb25 -00508b603c17"/> <meta name="atg:number:$usecount" content="8"/> <meta name="atg:enum:author" content="dbell" scheme="Author=dbell"/> <meta name="atg:enum:modified_by" content="administrator" scheme="Modified By=administrator"/> <meta name="atg:enum:owner" content="dbell" scheme="Owner=dbell"/> <meta name="atg:enum:ownergroup" content="Primus" scheme="Owner Group=Primus"/> <meta name="atg:number:date_created" content="979200000" scheme="Date Created=979200000"/> <meta name="atg:number:date_modified" content="1043359892" scheme="Date Modified=1043359892"/> <meta name="atg:enum:status" content="published" scheme="Status=Published"/> <meta name="atg:enum:category" content="changerequired" scheme="Category=Change Required"/> <meta name="atg:enum:database" content="oracle8.0.6" scheme="Database=Oracle 8.0.6"/> <meta name="atg:enum:database" content="oracle8.1.6" scheme="Database=Oracle 8.1.6"/> <meta name="atg:enum:localization" content="english (us)" scheme="Localization=English (US)"/> <meta name="atg:enum:supportadvisory" content="no" scheme="Advisory=No"/> <meta name="atg:index:$solution_id" content="primus7524"/> <meta name="atg:index:$solution_uuid" content="0060142a-e7e8-11d4-bb25 -00508b603c17"/> <meta name="atg:enum:$solution_class" content="Support"/> <meta name="atg:enum:$view_access" content="Everyone"/> </head> <body> <div class="atg:role:id" id="0">primus7524</div> <div class="atg:role:fact" id="1">SQLPlus</div><br/> <div class="atg:role:fact" id="2">Net8 Assistant</div><br/> <div class="atg:role:fact" id="3"> The Oracle database is on a server separate from the system running sqlplus </div><br/> <div class="atg:role:fact" id="4">Tns_service name is correct</div><br/> <div class="atg:role:symptom" id="5"> ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor </div><br/> <div class="atg:role:symptom" id="6"> Unable to connect to the Oracle database/instance with SQLPlus </div><br/> <div class="atg:role:fix" id="7"> Change the Host section in the tnsnames.ora file to the fully qualified name of the database server (example: db_server.primus.com) or the IP address. </div><br/> </body> </html>