Way to find the SID of the database

In $ORACLE_HOME\NET80 or NETWORK\ADMIN,  
   Open the file tnsnames.ora and it can show some entries as mentioned
    below:
    SIDSAMPLE (DESCRIPTION (ADDRESS = (PROTOCOL = TCP)(HOST =  
                             193.156.145.121)(PORT = 1521)) (CONNECT_DATA = (SID =          
                              XYZ)) )
Here    SIDSAMPLE is the SID you have to provide while connecting forms to db.

Read Full Post »