日期:2014-05-17  浏览次数:20978 次

ORA-12514.急。sqlplus可以登录,但是plsql报错
如题。
oracle 10.1.0.2.0 安装成功后 sqlplus 可以登录。
但是plsql报错 ora-12514

aa =
  (DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
  (CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = aa)
  )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
  )
  (CONNECT_DATA =
  (SID = PLSExtProc)
  (PRESENTATION = RO)
  )
  )

如果把localhost 改成ip 地址也不行。
这是为什么?


------解决方案--------------------
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor 
Check that the SERVICE_NAME parameter 

还是说你选择的SERVICE_NAME有可能不对。

你本机只装过一次Oracle?