用Oracle 11g 自带的 SQL Develpoer 连接本地机上的Oracle 11g数据库!~
下面是我的情况,请耐心的看完,谢谢。SQL Develpoer 连oracle 有3种连接方式,
1.Basic
2.TNS
3.Advanced我全都试过了,说说各种方式的结果1.Basic
分别填写
Hostname:localhost;
Port:1521;
SID:orcl
结果是 ORA-12505 2.TNS
选择Network Alias
结果是 The Network Adapter could not establish the connection
选择Connection Identifier
结果是连接成功,这是也唯一的能连接成功3.Advanced
Custom JDBC URL:
jdbc:oracle:thin:@localhost:1521:orcl
结果是 ORA-12505 PS:JDK 1.6, ORACLE 11g
监听和服务也都运行了。本身用JDBC代码连接Oracle数据库也出问题,异常提示为:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
localhost:1521:orcl帮帮我啊,都困扰我几天了,一直都没有找到办法
以下为$ORACLE_HOME/network/admin下
listener.ora,tnsnames.ora,sqlnet.ora三个文件的的内容# listener.ora Network Configuration File: F:\app\Administrator\product\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)-----------------------
# tnsnames.ora Network Configuration File: F:\app\Administrator\product\11.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
-------------------------
# sqlnet.ora Network Configuration File: F:\app\Administrator\product\11.1.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
下面是我的情况,请耐心的看完,谢谢。SQL Develpoer 连oracle 有3种连接方式,
1.Basic
2.TNS
3.Advanced我全都试过了,说说各种方式的结果1.Basic
分别填写
Hostname:localhost;
Port:1521;
SID:orcl
结果是 ORA-12505 2.TNS
选择Network Alias
结果是 The Network Adapter could not establish the connection
选择Connection Identifier
结果是连接成功,这是也唯一的能连接成功3.Advanced
Custom JDBC URL:
jdbc:oracle:thin:@localhost:1521:orcl
结果是 ORA-12505 PS:JDK 1.6, ORACLE 11g
监听和服务也都运行了。本身用JDBC代码连接Oracle数据库也出问题,异常提示为:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
localhost:1521:orcl帮帮我啊,都困扰我几天了,一直都没有找到办法
以下为$ORACLE_HOME/network/admin下
listener.ora,tnsnames.ora,sqlnet.ora三个文件的的内容# listener.ora Network Configuration File: F:\app\Administrator\product\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)-----------------------
# tnsnames.ora Network Configuration File: F:\app\Administrator\product\11.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
-------------------------
# sqlnet.ora Network Configuration File: F:\app\Administrator\product\11.1.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
解决方案 »
- Oracle11 安装后找不到Enterprise Manager Console
- 32位数据库升级到64位的问题
- oracle中clob字段不能用distinct?
- 视图查询和直接查询错误
- 请问哪里可以下oracle8.17 for window ?
- 怪了,点击Net8 Configuration Assistant 无反应?
- JAVA应用如果连续向ORACLE增加3000字以上的文章造成CPU100%,请帮助,谢谢!!!
- oracle数据库里是不是不能插入 繁体字——————
- 存储过程中用变量做表名怎么办?求解
- 问一个关于Oracle9i JDeveloper的问题,请有经验的朋友进来看看,谢谢!(初学者)
- oracle9i ORA-01843:无效的月份(急,在线等。)
- ★★★★★★★ Oracle 测试带返回游标的存储过程 ★★★★★★★
我自己的就是服务器啊。写localhost 可以吗?
反正不管是写 localhost还是写IP 192.....什么的 都没有测试成功过
# needed to connect to an HS AgentLISTENER =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
)SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=dg4odbc)
(ORACLE_HOME=E:\app\Administrator\product\11.1.0\db_1)
(PROGRAM=dg4odbc)
)
)#CONNECT_TIMEOUT_LISTENER = 0
ORA-12505: TNS: 监听程序当前无法识别连接描述符中所给出的 SID (DBD ERROR: OCIServerAttach)
这是什么意思,
改为ADDRESS=(PROTOCOL=tcp)(HOST=计算机名)(PORT=1521))
方法:开始->控制面板->管理工具->事件查看器
可以看到 应用程序、安全性、系统3个日志文件. 原来是应用程序的日志文件已经满了. 无奈只好手动把最大限制改到1024. 因为不敢清除. 所以只好改大.