Oracle Database Connection to TOAD
Issues of Oracle Database Connection to TOAD Connections to Oracle database via TNS are bit of a painful until you get all the components in the TNS configured correctly. We generally get different types of errors when we try to connect the DB using TOAD. Usually we get Host, Port & Service Name in the TNS Entry but SID is excluded from it. But if we supply the SID information instead of service name it gets connected easily. If we get the SID for the database we can easily connect to the DB using TOAD. Solution of Oracle Database Connection by TOAD: We can connect to any database instance using TOAD by the following steps: 1. Connect to the database using SQL*Plus as below Ø User Name: ORACLE_USER Ø Password: ORACLE_password1 Ø Host String: 156.14.200.90:1542/VISSVC(host:port/Service Name) Ø Or conn ORACLE_USER / ORACLE_password1@156.14.200.90:1542/ORAVISSVC (Conn user/password@...