IBM Support

Test Connecting to Oracle: ORA-06413: Connection not open

Troubleshooting


Problem

Error number -9: DMS-E-GENERAL, A general exception has occurred during operation 'attach database'. ORA-06413: Connection not open This error occurs when you are attempting to test a database connection for Oracle Net 8.

Resolving The Problem

This error can occur when using Net 8 and the path to the executable contains an opening or closing bracket: '(' or ')'. To resolve this issue, rename the directory (or tree) containing the Impromptu executable so that it does not contain any bracket characters.

[{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Impromptu","Platform":[{"code":"PF025","label":"Platform Independent"},{"code":"PF033","label":"Windows"}],"Version":"3rd Party X.X;Impromptu 5.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

72100

Document Information

Modified date:
15 June 2018

UID

swg21367874