How to resolve the Oracle related error “ORA-12154”
Posted by Nico Wang on 20 March 2014 01:39 PM


Run into the error like ORA-12154: TNS: could not resolve the correct identifier specified.



It is probably that you are using the Oracle Instant Client which is not supported by Appeon, if this is the case, then you need to install the full client to resolve this kind of issue.



#1- Please make sure there is only one oracle client installed on Appeon Server, if you are using 32-bit Appeon Server, please install 32-bit Oracle client, otherwise please install 64-bit Oracle client.

#2- Additionally, please try the steps below to solve this issue:

Step 1- Login to Windows as a user with Administrator privileges. 

Step 2 - Launch Windows Explorer from the Start Menu and navigate to the ORACLE_HOME folder. This is typically the "Ora9i" folder under the "Oracle" folder (i.e. D:\Oracle\Ora9i).

Step 3 - Right-click on the ORACLE_HOME folder and choose the "Properties" option from the drop down list. Then the Properties window should appear. 

Step 4 - Click on the Security tab of the Properties window. 

Step 5 - Click on Authenticated Users item in the Name list (on Windows XP the Name list is called Group or user names). 

Step 6 - Uncheck the Read and Execute box in the Permissions list under the Allow column (on Windows XP the Permissions list is called Permissions for Authenticated Users). 

Step 7- Re-check the Read and Execute box under the Allow column (this is the box you just unchecked). 

Step 8 - Click the Advanced button and in the Permission Entries list make sure you see the Authenticated Users listed there with: 

Permission = Read & Execute 

Apply To = This folder, subfolders and files 

Double check the Apply onto drop-down box and make sure it is set to This folder, subfolders and files. 

Step 9 - Click the Ok button until you close out all of the security properties windows. The cursor may present the hour glass for a few seconds as it applies the permissions you just changed to all subfolders and files. 

Step 10 - Reboot your computer to assure that these changes have taken effect.

(1 votes)
This article was helpful
This article was not helpful

Comments (0)
Post a new comment 

Please login if you wish to leave a comment about this article.

Help Desk Software by Kayako Fusion

Copyright © 2019 Appeon.  All rights reserved.  Terms of Use | Privacy Statement