oracle11g 端口,navicate 连接 oracle11g精简版 监听不到端口 和 用户密码错误

navicate 连接 oracle11g精简版数据库时:

环境: win7 64位, oracle11g精简版

1.在navicate连接属性配置时, 服务名或SID: XED:\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)

)

)

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 改端口.