Tuesday 15 May 2012

oracle - ORA-12541:TNS:No listener while connecting to DB using toad, when computer is in domain -



oracle - ORA-12541:TNS:No listener while connecting to DB using toad, when computer is in domain -

my scheme in domain of company. installed oracle in system. able connect oracle using sql plus, whenever tried connect through using toad next error coming.

googled , tried many solutions, nil worked.

see listener.ora file

sid_list_listener = (sid_list = (sid_desc = (sid_name = plsextproc) (oracle_home = c:\oraclexe\app\oracle\product\11.2.0\server) (program = extproc) ) (sid_desc = (sid_name = clrextproc) (oracle_home = c:\oraclexe\app\oracle\product\11.2.0\server) (program = extproc) ) ) listener = (description_list = (description = (address = (protocol = ipc)(key = extproc1)) (address = (protocol = tcp)(host = asdi303.abc.com)(port = 1521)) ) ) default_service_listener = (xe)

in tnsnames.ora, host asdi303.abc.com only...

oracle database-administration

No comments:

Post a Comment