TDM 4.2.6.12 Cannot Connect: "NET: Invalid SID"

Toad Data Modeler
1

Received error message is:

Connection failed because of the following error: “NET: Invalid SID”.

Connection settings are:

1, Data Source: Database RE - Toad for Oracle
2, Data Provider: Connection via TCP/IP

The same set of parameters are used by Toad for Oracle Database 11.5.1.2 successfully without any problem. Parameters include:

  • Local Net Service Names
  • Host, Port, Service Name
  • User Name, Password

In the TDM GUI, there is NO place for me to define SID though.

This is my first time using TDM. Really frustrating. Please help! Thanks!

Message was edited by: Sailor

2

Hi,

Are you using Connections view? And are you using a Toad for Oracle Alias (from the Toad for Oracle Aliases tab in Select Connection)? And are you trying to use Local Net Service Name? Please, try to set up the connection in Reverse Engineering wizard, not in Connections.

Thank you,
Lukas