N/APosted on - 12/19/2011
I wanted to move my server to something that runs Presentation Server 4.5 64-Bit using CHFARM.
I already have Oracle Data Store. While trying to set up Oracle connection, I got this error message saying, “Database connection cancelled or failed.” What should I do?
The image is shown below together with what I tried to do and the error occurred while trying to do it.
Database connection cancelled or failed.
Error when trying to set up Oracle connection
The cause of that problem is a result of a connection using SQLPlus to the Oracle server failing and with the following error: “ORA-12154: TNS:could not resolve the correct identifier specified”, and therefore you will need to resolve it. You may find that it may be easy to ping the NetBIOS name of the Oracle server, but you will discover that issue is Domain Name Service (DNS) related.
To resolve the error, you will need to locate and comment out the following line in the sqlnet.ora file.
Once you have done that, then the DNS will not attempt to use only the default DNS server for the domain to resolve the name of the Oracle service, but it will resolve the name of the Oracle service by the use of an alternative DNS server or broadcast.