Error when trying to set up Oracle connection

Asked By 0 points N/A Posted on -
qa-featured

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.

Thanks!

DB Error

Database connection cancelled or failed.

                   OK

SHARE
Answered By 0 points N/A #104029

Error when trying to set up Oracle connection

qa-featured

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.

#NAMES.DEFAULT_DOMAIN =

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.

Clair Charles

Login/Register to Answer

Related Questions