PL/SQL在Server2008 R2上装不上

解决办法, PL/SQL安装在客户端。  但是用户是 系统用户,所以添加链接字符串的时候有问题。

修改 tnsnames.ora文件

LINYANG =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = LY-app-server)(PORT = 1521))
    )
    (CONNECT_DATA =
 (SERVER = DEDICATED)
      (SERVICE_NAME = LinYang)
    )
  )     添加   (SERVER = DEDICATED)

利用SQL/PLUS解决

set oracle_sid=linyang(实例名)

sqlplus / as sysdba

 

错误码: ORA-28009:connection as sys should be as sysdba or sysoper