Oracle逆向工程

来源：cnblogs　　作者：从未太晚　　时间：2018/10/8 9:02:20　　对本文有异议

搞了好久终于弄完了,想把PD图弄成Oracle数据库的表

遇到的坑分享下

安装完64位的Server ,默认的listener.ora文件有PROGRAM和ENVS这两个节点

Plsql(32位client)连接报 ORA-28547,删掉PROGRAM和ENVS这两个节点就可以连接了,贴下配置文件

# listener.ora Network Configuration File: E:\app\admin\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = ORCL) 
      (SID_NAME = ORCL)
      (ORACLE_HOME = E:\app\admin\product\11.2.0\dbhome_1)
    )
  )
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.160)(PORT = 1521))
    )
  )
ADR_BASE_LISTENER = E:\app\admin

oracle 使用普通用户scott,scott默认不是开启的,sql代码开启scott,创建表空间

 create tablespace KSQ datafile 'E:\app\KSQ.dbf' size 200m autoextend on next 100m maxsize unlimited; 
 
 alter user scott identified by 123 default tablespace KSQ; 
 
 grant dba to scott ;
 
  alter user scott account unlock;