初级问题。请指点!!!! 需要配置tns文件(TNSNAMES.ORA) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 首先你要配置一个netserver,然后进行连接! 把你的tnsnames.ora贴出来,还有目标数据库的SID。 tnsnames.ora文件存放在oraclehome\Ora81\network\ADMIN下 用DBA STUDIO配置本地服务。需要如下参数:sid,ip地址,本地服务名 # TNSNAMES.ORA Network Configuration File: C:\oracle\ora81\NETWORK\ADMIN\tnsnames.ora# 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) ) ) 求解:PL/SQL包創建的錯誤 tnsping 不通 帮忙看看我的oracle语句哪里出错 SQL 混杂排序 求解中.... 问一下下面这两种Oracle分页哪种写法是对的 我是学SQL的 请问oracle跟SQL在语句表达上有什么区别么? 数据库发布问题 关于lock的问题,请进,谢谢! 如何取时间字段比当前时间早的语句 新手刚接触oracle运维,备份变慢问题咨询 有什么办法提高这个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)
)
)