sqlplus ora-12514解决
sqlplus ora-12514解决
搜索文件:
搜索文件:
[html]
tnsnames.ora
编辑:在最后一行添加
[java]
#-------------------------------------------------------------
Locals=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = zhExtJsDB)
)
)
Locals=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = zhExtJsDB)
)
)
这里Locals 就是登陆的时候用的字符串,HOST=127.0.0.1就是你要SQLPLUS连接的数据库主机的地址,这里数据库为本地
SERVICE_NAME=zhExtJsDB就是你要连接的数据库名字。
下面就是登陆:
登陆成功!
下面就是登陆:
登陆成功!