登陆oracle9i的问题 服务名 不对~~C:\tnsping 服务名 <- 看通不通可以用 Net Configuration Assistant 来配置一下~ :) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 你的Oracle服务开了吗?实例和侦听服务. 先要用Enterprise Manager Configuration Assistant 配置才可以用!我刚试过! 1.先检查服务是否启动,包括实例和监听是否启动,如果没有启动则启动服务2.如果已经启动还是连不上,则更改tnsnames.ora文件或者用net configuration assistant配置网络服务名 Net Configuration Assistant 配置服务名 你到你的安装目录下的network\admin下面找一个tnsname.ora的文件,看看你服务实例指向的服务器是否正确 # TNSNAMES.ORA Network Configuration File: c:\oracle\ora92\network\admin\tnsnames.ora# Generated by Oracle configuration tools.ORADB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = yz)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oradb) ) )TESTCUST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = yz)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = Testcust) ) )INST1_HTTP = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = yz)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = MODOSE) (PRESENTATION = http://HRService) ) )EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )我做了2个数据库 子查询ROWNUM Oracle中使用触发器 论坛变样了。 JIoracle里怎么显示有几个数据库?MYSQL里是用SHOW DATABASES; Oracle的SQL PLUS能打开,STUDIO打不开方案看不到表了! 在线等,win2000 server下载安装oracle8.1.6老是不成功,救命啊 文字内容如何合并(急) 请问大家通过用户需求调研该如何确定表结构?怎样调研用户需求的表结构? ORACLE 安装问题??搞不懂,很郁闷 关于用JDBC连oracle的问题,请各位仁兄帮忙!急! 求1Z0-031的培训教材电子版 oracle 10g无法登陆问题?
实例和侦听服务.
我刚试过!
2.如果已经启动还是连不上,则更改tnsnames.ora文件或者用net configuration assistant配置网络服务名
# Generated by Oracle configuration tools.ORADB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yz)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oradb)
)
)TESTCUST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yz)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = Testcust)
)
)INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yz)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)我做了2个数据库