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