??????dos???????????????????PL/SQL?????????? ORA-12541 ??12154??????Oracl Net Manager ??????ú??????????????????????????????????????????D:oracleproduct10.1.0db_1 etworkadminlistener.ora ?? tnsnames.ora ??????????????????????????????????????λ?????????и????????????????listener??

????????->cmd???dos????????lsnrctl stop????lsnrctl start????????μ?????????

???????????????pl/sql???????ORA-12541:TNS:?????????

????1. ???oracleproduct10.1.0db_1NETWORKloglistener.log??

????TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Production on 04-1?? -2010 13:38:34

????Copyright (c) 1991?? 2004?? Oracle. All rights reserved.

??????????????D:oracleproduct10.1.0db_1 etworkadminlistener.ora

????д??D:oracleproduct10.1.0db_1 etworkloglistener.log????????

????д??D:oracleproduct10.1.0db_1 etwork racelistener.trc????????

?????????????0

?????? pid=7180 ???

????????: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.pipeEXTPROCipc)))

??????????????????: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=pc-xxx.mail.yyy.cn)(PORT=1521)))

????TNS-12542: TNS: ?????????

????TNS-12560: TNS: Э????????????

????TNS-00512: ??????????

????32-bit Windows Error: 48: Unknown error

???????????: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.pipeEXTPROCipc)))

????2. Oracle??listener????????

????3. ??oracleproduct10.1.0db_1NETWORKADMINlistener.ora

#listener.oraNetworkConfigurationFile??D??oracleproduct10.1.0db_1 etworkadminlistener.ora
#GeneratedbyOracleconfigurationtools.
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=PLSExtProc)
(ORACLE_HOME=D??oracleproduct10.1.0db_1)
(PROGRAM=extproc)
)
)
LISTENER=
(DESCRIPTION_LIST=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))
)
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=pc-xxx.mail.yyy.cn)(PORT=1521))
)
)
)

??????(ADDRESS = (PROTOCOL = TCP)(HOST = pc-xxx.mail.yyy.cn)(PORT = 1521))

???????(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))

????pc-xxx.mail.yyy.cn????????

????127.0.0.1?????????????????ip?????

????4. ??oracleproduct10.1.0db_1NETWORKADMIN nsnames.ora

??????????????

ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = pc-xxx.mail.yyy.cn)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

??????(ADDRESS = (PROTOCOL = TCP)(HOST = pc-xxx.mail.yyy.cn)(PORT = 1521))

???????(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))

????5. ?????????listener

????????->cmd???dos????????lsnrctl stop????lsnrctl start?????