1 plsql远程连接oracle数据库

1 TNS:无监听程序

然后切换到oracle /bin 目录，cd $ORACLE_HOME/bin

启动监听， lsnrctl start

2 plsql连接远程数据库

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

将上面的代码整成一行，并放到plsql数据库位置