pl/sql developer连接linux下的oracle11g R2报错

  1.ORA-12541:TNS 无监听程序

     最后，通过修改/u01/app/Oracle/product/11.2.0/db_1/network/admin/listener.ora和tnsnames.ora的host地址为ip地址后解决。

  // listener.ora文件

 LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.116.133)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/Oracle

//tnsnames.ora文件

# tnsnames.ora Network Configuration File: /u01/app/Oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

LZH =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.116.133)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = lzh.com)
    )
  )


LISTENER_LZH =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.116.133)(PORT = 1521))

2.ORA-01031：insufficient privileges

  

   如上图，连接oralce会报错，最后查得“连接为”应该选择“normal”，暂时未知为什么选择“SYSDBA”会报错。

   然而，如果按照下图登录，却不会报错。

   system和sys都好像是可以作为dba的，难道记错了，下次再查查资料。