Dual Oracle Home

Error message

When using direct connect to an Oracle database, and attempting to publish an .mxd, error message "Server Object instance creation failed - server library cannot be loaded" is encountered Conversely, when connecting to an ArcSDE service, .mxd can be published successfully

Solution or Workaround

This issue can occur because the Oracle 32-bit client is not installed on the server. ArcGIS Server 9.x and 10.0 is a 32-bit application, and requires the use of the Oracle 32-bit client for direct connect

Install the Oracle 32-bit client. If you are installing the 32-bit client on a system that already has the Oracle 64-bit client installed, you can use the ‘dual oracle home’ solution. Please see the following Oracle Metalink articles for further information

''Considerations Using The Oracle Client With Microsoft Products on 64 bit Operating System [ID 781432.1] ''

Using Windows Client Drivers in Multiple Oracle Client Homes [ID 1053922.1]

Other Links

https://support.oracle.com/CSP/ui/flash.html