oracle连接啥这么复杂啊.oracle 10g
用ps/sql dev怎么也连不上.
用sqlplus可以登陆.net manager之前测试连接了成功的.现在搞得也连接不了.listener.ora:SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\program\10.2.0\db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 20090604-1449)(PORT = 1521))
)
)------------------------------------------------------------
tnsnames.ora:FIRSTDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 5555))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 6666))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = FirstDB)
)
)ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)我晕了.这文件我手动改过.重新启动监听,服务后,还是一样不能用pl/sql dev连接.
oracle本身有没有像sqlserver企业管理器里查看表,视图之类的工具啊,不可能全用sqlplus搞吧,效率太低了.
谢谢.
用ps/sql dev怎么也连不上.
用sqlplus可以登陆.net manager之前测试连接了成功的.现在搞得也连接不了.listener.ora:SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\program\10.2.0\db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 20090604-1449)(PORT = 1521))
)
)------------------------------------------------------------
tnsnames.ora:FIRSTDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 5555))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 6666))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = FirstDB)
)
)ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)我晕了.这文件我手动改过.重新启动监听,服务后,还是一样不能用pl/sql dev连接.
oracle本身有没有像sqlserver企业管理器里查看表,视图之类的工具啊,不可能全用sqlplus搞吧,效率太低了.
谢谢.
解决方案 »
- sql嵌套查询,left join不上,帮忙看看语句写得有没问题
- 会用Oracle Spatial的过来,怎么生成oracle的network?
- 表记录拼凑问题
- oracle排序
- ORCLE里在'零零零零零'到'ZZZZZ'里的随机数怎么取啊.
- java存储过程----不能解析类
- Oracel 远程连接超时!(地址什么都在Net8 Assistant里配好了)就是连不上的!
- 为什么返回数据集增大时,出现错误提示:unable to allocate an extent of 100 blocks from tabglespace 3.
- 客户端信息问题
- 一个简单的关于count的查询问题
- plsql dev设置问题
- oracle10g 表闪回,提示名称为ORA-01555:快照过旧:回退段号3("SYSSMU3$")过小
Connected.
SQL>
不过,估计楼主想问的问题5楼是正解
至于那个工具ObjectBrowser,青娃...都延好的