数据库为11g快捷版,命令行模式可以使用。安装了oracle9i精简版客户端、plsql。
数据库的tnsnames.ora配置如下:
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
客户端tnsnames.ora配置如下:
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
但是用plsql连接的时候就是报错。
在cmd中 tnsping xe 报错:TNS-12541:TNS:无监听程序
请问该怎么解决
cmd-->sqlplus ç¨æ·å/å¯ç å°±å¯ä»¥è¿æ¥ä¸äº
Windowsæå¡éæOracleXETNSListeneræå¡ï¼å¹¶ä¸å·²ç»å¯å¨
sqlplus ç¨æ·å/å¯ç è¿ç§è¿æ¥æ¶ä¸éè¿ä¾¦å¬æå¡ç
æçä½ åçæ¯æå¡å¨çtnsnames.ora åâ客æ·ç«¯âçtnsnames.oraï¼ä½ æè°å®¢æ·ç«¯æ¯å¨åªå¿ï¼åæ°æ®åºå¨ä¸å°æå¡å¨ä¸åï¼
å¦æä¸æ¯çè¯ï¼é£ä¹HOST = localhostçå
¶ä¸localhostå
容åºè¯¥æ¯æå¡å¨çip