今天一开机打开PL/SQL就报ORA-12541: TNS: 无监听程序,我是本地的数据库,确认监听开了,检查了两个文件。
listener.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = chinese-825f848)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
tnsnames.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = chinese-825f848)(PORT = 1521))
)
)
将本机名chinese-825f848改为本机的IP192.168.0.106问题就解决了。