navicate 连接 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) <----这是赤裸裸的坑爹呢! 说好的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 连接即可!