When trying to connect to a database in Toad, the connection window will not allow me to connect using 'local'.
ORA-12154: TNS:could not resolve the connect identifier specified (LOCAL).
Toad requires the specific database name.
In Toad for Oracle you cannot use the phrase 'local' to connect to the database. You should use the name of the local database in the database field.
Also keep in mind, if the Oracle client is picked up correctly, Toad's database field should list the database you have access to based off of the tnsnames.ora file. From there the local database can be selected.
For more info regarding common connection issues in Toad, please refer to solution SOL7712.
