This is for beginners who want to connect Toad to 10g Database
Install 10g client on windows or 10g Developer-Suite,which is a simple task of accepting the defaults and clicking Next on the OUI screen.
After installing Oracle D2k…….or Oracle 10g client
Choose Net Configuration Assistant in Oracle DevsuiteHome1
Then choose Net Service Name configuration and click next
Enter the Service name as VIS which is the ORACLE_SID(Database Name) for our instance
You can get it from Linux terminal by going to oracle user (#su – oracle)
And type ($echo $ORACLE_SID) and press Enter which gives a name.
This should be entered in text box in next screen.
Then choose TCP and click Next
Next type the Hostname (IP-address) of the machine.
You can get this by typing (#hostname –i) in terminal
Enter the port number as 1521 and click next, you can the port number using following command as oracle user
$lsnrctl status $ORACLE_SID|grep -i port
Choose yes,Perform test and click next
It should return Test...Successful
Choose no and click next and follow the screen shots hereafter…..