Oralce学习笔记（plsql链接客户端）

oracle10g=
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.110)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
)

进ORACLE服务端文件夹NetWork/admin/tnsnames.ora粘贴上面代码
进oracle客户端文件夹NetWork/admin/tnsnames.ora黏贴上面代码
进plsql输入用户密码如果还不行就进plsql 在菜单tool的Preferences里面
选择OracleHome fempty is autodetectd的值选择客户端