浏览 6204 次
精华帖 (0) :: 良好帖 (0) :: 新手帖 (0) :: 隐藏帖 (0)
|
|
---|---|
作者 | 正文 |
发表时间:2006-11-07
在本地按照默认安装oracle10g,pl/sql developer 7.0.0.1050,使用一切正常 以域用户登陆到域后,可以通过pl/sql developer登陆数据库,可通过左侧Brower中树形菜单查看任何对象,例如双击tables,列出所有的表,右键单击某表,弹出菜单中的new,drop,rename,descipe,view,edit等都可以用,但是edit data,query data不可用, 提示错误: Could not logon as system ORA-28547: 链接服务器失败,可能是oracle net 管理错误 然后就退出登陆了 net congfig如下: 服务名:ora10 链接类型:数据库默认设置 地址配置: 协议:TCP/IP 主机名:192.168.1.92 端口号:1521 LISTENER: --监听位置: ---网络地址: ----协议:TCP/IP ----主机:192.168.1.92 ----端口:1521 --数据库服务: ----数据库1: -----全局数据库名ora10 -----oracle主目录:D:\oracle\product\10.2.0\db_2 -----sid:ora10 我用的操作系统是win server 2003 域用户权限administrators用户组的。 # listener.ora Network Configuration File: D:\oracle\product\10.2.0\db_2\NETWORK\ADMIN\listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (PROGRAM = extproc) (SID_NAME = PLSExtProc) (ORACLE_HOME = D:\oracle\product\10.2.0\db_2) ) (SID_DESC = (GLOBAL_DBNAME = ora10) (ORACLE_HOME = D:\oracle\product\10.2.0\db_2) (SID_NAME = ora10) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.92)(PORT = 1521)) ) ) SAVE_CONFIG_ON_STOP_LISTENER = TRUE # tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_2\NETWORK\ADMIN\tnsnames.ora # Generated by Oracle configuration tools. ORA10 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.92)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ora10) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) 声明:ITeye文章版权属于作者,受法律保护。没有作者书面许可不得转载。
推荐链接
|
|
返回顶楼 | |