plsql连不上本地oracle

Question

plsql连不上Oracle啊~~~我要崩溃啊~~cmd里面sqlplus完美登陆啊~~~plsql就是一直报错could not resolve the connect identifier specified 一样的用户名密码就是登不上啊~~~我连的是本地的数据库 什么Ora不要配的 求大神帮忙~~~解决问题再送你分数

Answer 1

到你的安装目录，我的是：C:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN

找到tnsnames.ora，看你配置的是否正确

LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)