问题是这样的。我刚刚用plsql连接也是提示ora -12154 错误,但是我网上找到了解决的方法。(即:进入PLSQL Developer主界面,菜单Tools-Preferences,在设置窗口中,选择Oracle-Connection,对应设置窗口中,找到Oracle Home,选择OraHome92,保存设置,
资料来源:学网(www.xue5.com),原文地址:http://www.xue5.com/itedu/200707/118227.html)
我估计我的报表也是这个错误,但是我找不到找个设置的位置。请问,report 6i 如何设置连接的数据库呢?错误如图:
资料来源:学网(www.xue5.com),原文地址:http://www.xue5.com/itedu/200707/118227.html)
我估计我的报表也是这个错误,但是我找不到找个设置的位置。请问,report 6i 如何设置连接的数据库呢?错误如图:
解决方案 »
- [在线等...](java)Oracle中Long类型存储
- 创建的触发器带有编译错误
- oracle客户端无法连接数据库,网络配置助手测试是通的
- eclipse中连接oracle的问题
- 初学者表示SQL DEVELOPER连接不上 求帮助
- 异构环境的数据库性能调优
- 请教oracle 数据隔离或缓存问题?
- 高分求解Oracle9.2安装问题!
- 我在PL/SQL的Command Window中能执行以下语名:
- ORA-00445: background process W000 did not start after 120 seconds导致数据库死机
- REDHAT9+ORACLE9 proc预编译的时候。PC源程序回车换行符如果是0D0A就不能编译,不想转成0A,有什么方法可以直接编译(不好实现)
- 100分求,怎么把oracle函数传入的参数当作要查询的字段?
orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orac2)
)
)
第一:我的这个文件下面没有orcl=....
我文件下面是这样的:
Beq-local.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = beq.world)
(PROTOCOL = BEQ)
(PROGRAM = oracle73)
(ARGV0 = oracle73ORCL)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Tcp-loopback.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Example1.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = Production1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = SID1)
)
)
Example2.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = spx.world)
(PROTOCOL = SPX)
(Service = Server_lsnr)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Example3.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = nmp.world)
(PROTOCOL = NMP)
(Server = FinanceServer1)
(Pipe = ORAPIPE)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Rep60_MHW,Rep60_MHW.world=(ADDRESS=(PROTOCOL=tcp)(HOST=MHW)(PORT=1949))
我需要什么样改呢?帮忙指导一下,谢谢了。
Beq-local.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = beq.world)
(PROTOCOL = BEQ)
(PROGRAM = oracle73)
(ARGV0 = oracle73ORCL)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Tcp-loopback.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Example1.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = Production1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = SID1)
)
)
Example2.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = spx.world)
(PROTOCOL = SPX)
(Service = Server_lsnr)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Example3.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = nmp.world)
(PROTOCOL = NMP)
(Server = FinanceServer1)
(Pipe = ORAPIPE)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = MHW)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ORCL)
)
)Rep60_MHW,Rep60_MHW.world=(ADDRESS=(PROTOCOL=tcp)(HOST=MHW)(PORT=1949))