Oracle SQL Developer(版本1.5.5)连接问题, Oracle11g(版本11.2)

配置软件安装目录下D:\app\Administrator\product\11.2.0\dbhome_2\NETWORK\ADMIN的tnsnames.ora文件:

修改当前环境下的主机名/端口和服务名;

如:

# tnsnames.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_2\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.


LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN-COSDJDSFC4C)(PORT = 1521))




ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)


ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN-COSDJDSFC4C)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = OracleServiceORCL)
)
)

以上是我本机配置

建立连接:

使用scott账号密码tiger, 这个账号通过sysdba账号使用sqlplus解锁 ,设置界面如下:

注意: 经测试不能使用sysdba建立连接, 否则失败.

初学者, 艰难爬行中...