sql*net2.3问题,要多少分给多少分,只要能解决 用tnsping可以通吗?如果不通,错误信息是什么?sql plus不能进入提示什么信息? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 2000下可以ping 通错误信息:不能连接到数据库 我是没有用过 Oracle 7.3,版本太老了在你的 WINDOWS2000的 tnsnames.ora 文件加入以下内容试试更改相应的IP和SERVICE NAME或SIDTEST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SERVER端的SID) ) )然后在SCO 5.05端启动监听器 lsnrctl start 连接时,用 system/manager@test试试 当然要配置监听服务了,我这边有个例子scounix5.0.4+oracle7.3.4编辑 etc/listener.oraLISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= TCP)(Host= ip)(Port= 1521)) )SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME= dbname) (ORACLE_HOME= /usr/oracle) (SID_NAME = sidname) ) )STARTUP_WAIT_TIME_LISTENER = 0CONNECT_TIMEOUT_LISTENER = 10TRACE_LEVEL_LISTENER = OFF在用oracle用户运行:lsnrctl start SQL 与 oracle 数据库链接插入数据。100分 对物化视图建立全文检索索引后,该物化视图不能被删除 oracle存储过程能否获得行号? 如何用pl/sql developer创建多个存储过程 oracle 字定义类型 oracle外连接问题 求一条SQL语句删除重复记录 急问Ora12560错误!!! 如何能从oracle中获得访问信息? 数据库服务启动问题! 如果表结构已经有了,如何从一个大的exp后的dmp文件中导入某张(些)表的数据? sql*net问题,急急急!!!!
错误信息:不能连接到数据库
更改相应的IP和SERVICE NAME或SID
TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SERVER端的SID)
)
)然后在SCO 5.05端启动监听器 lsnrctl start
编辑 etc/listener.oraLISTENER =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= TCP)(Host= ip)(Port= 1521))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME= dbname)
(ORACLE_HOME= /usr/oracle)
(SID_NAME = sidname)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF在用oracle用户运行:lsnrctl start