(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)      

              (SID_NAME = auxdb)

            )

        (SID_DESC =

              (GLOBAL_DBNAME = orcl)

              (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)      

              (SID_NAME = orcl)

            )            

    )

 

 

LISTENER =

    (DESCRIPTION_LIST =

        (DESCRIPTION =

            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

            (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.199)(PORT = 1521))

        )

    )

 

 

tnsnames.ora

ORCL =

    (DESCRIPTION =

        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.199)(PORT = 1521))

        (CONNECT_DATA =

            (SERVER = DEDICATED)

            (SERVICE_NAME = orcl)

        )

    )

 

 

EXTPROC_CONNECTION_DATA =

    (DESCRIPTION =

        (ADDRESS_LIST =

            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

        )

        (CONNECT_DATA =

            (SID = PLSExtProc)