navicate 连接 oracle11g精简版数据库时:
环境: win7 64位, oracle11g精简版
1.在navicate连接属性配置时, 服务名或SID: XE
D:\oracle11g\app\oracle\product\11.2.0\server\network\ADMIN 下的tnsnames.ora中.
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = john-PC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE) <----这是赤裸裸的坑爹呢! 说好的ORCL不用
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
2.(win10 测试不需设置oci.dll)
navicate设置oci.dll:
打开navicate -->工具-->选项-->OCI : 设置为 D:\oracle11g_xe\app\oracle\product\11.2.0\server\bin\oci.dll
D:\oracle11g_xe : 为oracle安装目录
3.开始菜单 -->Orace Database 11g... --> 运行SQL命令,
输入:conn
输入用户名(system), 输入用户密码(设置的密码), 测试账户密码是否正确, 密码建议root 好记啊!
然后在用navicate 连接即可!
4: 注意: 精简版Oracle会占用 8080 端口,需要把 tomcat 改端口.