需要配置tns文件(TNSNAMES.ORA)
解决方案 »
- oracle 安装问题
- Oracle11g 启动startup.bat文件报错
- 请教索引覆盖?
- 求救 帮忙看一下 这段PL/SQL 有没有语法错误?? 谢谢啦
- VS2005下用occi访问Oracle11g
- 千万级数据库表索引无法生效,求解答
- 怎么在 win xp 环境下设置 sql*plus 的 SQLPATH 这个环境变量,怎么我的设置总是不起效?
- 讨论算法,如何解析excel的公式
- Oracle序列能否归零?
- 对关键字,用Number型快还是Char型快?
- 有什么办法提高这个SQL语句查询速度?解决后另加分
- oracle和sql server相比,有什么优势啊,为什么大型的项目用的是oracle而不是采用sql server啊?
需要如下参数:
sid,ip地址,本地服务名
# Generated by Oracle configuration tools.ptzzg =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ptzzg)
)
)JXC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ORCL)
)
)INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = ptzzg)
(PRESENTATION = http://admin)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)XQ =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ORCL)
)
)