Unable to connect to Oracle database after setting up new Windows Server - HxGN SDx - Update 63 - Administration & Configuration

Administration and Configuration of HxGN SDx

Language
English
Product
HxGN SDx
Search by Category
Administration & Configuration
SmartPlant Foundation / SDx Version
10

This solution applies to Windows Server installations where the Oracle 64-bit client has been installed on the application server.

Problem

After installing the 64-bit Oracle client software on a Windows Server application server, you receive an Oracle error, "Unable to connect to the database" on trying to test your connection.

Solution

After installing the 64-bit Oracle client on Windows Server, the server must be rebooted.