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

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

1.在navicate连接属性配置时,服务名或SID:XE

原因是:

D:oracle11gapporacleproduct11.2.0servernetworkADMIN 下的tnsnames.ora中.

XE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = john-PC)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE) <----这是赤裸裸的坑爹呢! 说好的oracl不用.
    )
  )

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.需在开始菜单中先: 点击:运行SQL命令行,

点击:运行SQL命令行,

输入:conn

输入用户名,输入用户密码

然后在用navicate 连接即可!

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!