Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
ALIM | Exor
  • Product Communities
  • AssetWise
  • ALIM | Exor
  • More
  • Cancel
ALIM | Exor
ALIM | Exor - Wiki ORA-12154: TNS: could not resolve the connect identifier specified error when opening exor
    • Sign in
    • -Exor - Wiki
      • +ALIM Document Manager
      • +AWLRS
      • Exor Accidents Manager
      • +Exor Asset Manager
      • +Exor CIM / FIM
      • +Exor Document Manager
      • +Exor Enquiry Manager
      • +Exor Information Manager
      • +Exor Information Manager TMA Reporting Pack
      • +Exor Maintenance Manager
      • +Exor Maintenance Mobile
      • +Exor MapCapture
      • +Exor MapCapture (ESRI)
      • +Exor MCI MapCapture Interface
      • +Exor Network Event Manager
      • +Exor Network Manager
      • -Exor Oracle
        • An add on for this website has failed to run
        • Blank Exor screen
        • Core: User has active job(s)
        • Discoverer Plus does not start.
        • Discoverer return not all records
        • Forms Session Slow or Frequently Disconnected
        • FRM-40010, Cannot read form
        • FRM-40112 - Attempted go_item to non enabled item
        • How to increase the limit of extracted records in Oracle Discoverer Plus
        • Not all rows have been retrieved
        • ORA-04068: existing state of package has been discarded
        • ORA-12154: TNS: could not resolve the connect identifier specified error when opening exor
        • Oracle version for Exor 4700
        • Screen appears blank after trying to launch application
        • Slow Form Response Time
        • Unable to launch forms
        • User can’t view any reports
      • Exor Problems and Solutions
      • +EXOR product placeholder
      • +Exor Public Enquiry Manager API
      • +Exor Schemes Manager
      • +Exor Spatial Manager
      • +Exor Street Gazetteer Manager
      • Exor Streetworks Manager
      • +Exor Streetworks Mobile
      • +Exor Structures Manager
      • Exor Structures Mobile
      • +Exor TMA API and Web Service
      • +Exor TMA Noticing Manager
      • +Exor TMA Permitting Manager
      • +Exor UKPMS
      • ORA-20000: HIG-0230: Inconsistency detected error on login
      • +Transportation Intelligence Gateway
      • +Video Series for Exor
      • Working From Home with Exor

     
     Questions about this article, topic, or product? Click here. 

    ORA-12154: TNS: could not resolve the connect identifier specified error when opening exor

      Product(s): Exor Server
      Version(s): 04.07.00.01
      Environment: N/A
      Area: N/A
      Subarea: N/A

    Problem

    When opening Exor forms this error appears, ORA-12154: TNS: could not resolve the connect identifier specified. 

    Solution

    Check if this issue happens for single user or multiple users.

    Steps to resolve/fix ORA-12154 :

    1. Does TNSNAMES.ORA file exists and is in the proper directory and is accessible$ORACLE_HOME/network/admin/tnsnames.ora
    2. Is there any syntax errors anywhere in the TNSNAMES.ORA file? Unmatched parentheses or stray characters for example?  All parenthesis around the TNS entry should be properly terminated. There should be no control characters at the end of the instance or database name
    3. Is service name used as the connect identifier exists in the TNSNAMES.ORA file
    4. Check instance name has been entered correctly in tnsnames.ora.
    5. Make sure that "TNSNAMES" is listed as one of the values of the NAMES.DIRECTORY_PATH parameter in the Oracle Net profile (SQLNET.ORA)
    6. If problem still persists, try to re-create TNS entry in tnsnames.ora.
    7. Domain name entry in sqlnet.ora should not be conflicting with full database name.

     

      Original Author: Jyoti Patil
    • ORA-12154
    • TNS
    • Share
    • History
    • More
    • Cancel
    • Jyoti Patil Created by Bentley Colleague Jyoti Patil
    • When: Thu, Dec 29 2016 6:01 AM
    • Sarah Willis-Culpitt Last revision by Bentley Colleague Sarah Willis-Culpitt
    • When: Wed, Nov 14 2018 9:29 AM
    • Revisions: 3
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2021 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies