Error when trying to set up Oracle connection

Asked By Mark Sanchez 0 points N/A Posted 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.

Thanks!

DB Error

Database connection cancelled or failed.

                   OK

• Status: Open
• Question Views: 837
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database

Answered By Clair Charles 15 points N/A #104029

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.

#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

About Clair Charles

Questions
1

Answers
495

Best Answers
109

• Vote Up 0 Vote Down

• Posted on - 12/21/2011
• Question Category: Oracle Database