plsql连不上本地oracle
plsql连不上Oracle啊~~~我要崩溃啊~~cmd里面sqlplus完美登陆啊~~~plsql就是一直报错couldnotresolvetheconnectiden...
plsql连不上Oracle啊~~~我要崩溃啊~~cmd里面sqlplus完美登陆啊~~~plsql就是一直报错could not resolve the connect identifier specified 一样的用户名密码就是登不上啊~~~我连的是本地的数据库 什么Ora不要配的 求大神帮忙~~~解决问题再送你分数
展开
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)
)
)
找到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)
)
)
已赞过
已踩过<
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
