我刚安装的ORACLE8,单机使用,可是在SQLPLUS中连接system/manager可以,可是加上主机字符串就无法连接,怎么回事?如何处理 帖出tnsnames.ora来?抱什么错,你也不说,怎么回答你的问题? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 # TNSNAMES.ORA Network Configuration File: D:\Oracle\Ora81\network\admin\tnsnames.ora# Generated by Oracle configuration tools.ORA2000 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = cshis)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = his) ) )EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )***********************************************************奇怪的是system/managerher/master可以进入SQLPLUS但是system/manager@hisher/master@his即加上SID就不可以报:ERROR:ORA-12547: TNS: 丢失联系还有我想模仿公司的数据库在自己机子上建立了一个,并将公司的数据做了bak.dmp.可是在自己的机子敲"imp c:\bak.dmp"报:SP2-0734: 未知的命令开头 "imp c:\bak..." - 忽略了剩余的行。 ORA2000 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 换成ip)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = 远程服务器) --或者换成sid=.... ) )system/manager@ORA2000her/master@ORA2000imp c:\bak.dmp --没有这么用的imp(imp80) 回车,按提示做或者去查查help. jlandzpa(ORA-00600)按你要求试过了.不可以.*****************************************************************# TNSNAMES.ORA Network Configuration File: D:\Oracle\Ora81\network\admin\tnsnames.ora# Generated by Oracle configuration tools.ORA2000 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ora2000) ) )EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )*************************************************************输入:system/manager@ora2000--------->ERROR:ORA-12547: TNS: 丢失联系输入:system/manager---------------->连接到: Oracle8i Enterprise Edition Release 8.1.6.0.0 - ProductionWith the Partitioning optionJServer Release 8.1.6.0.0 - Production****************************************************************关于第二个问题:SQL> HELPSP2-0171: HELP 不可访问。SQL> HELP;SP2-0171: HELP 不可访问。SQL> IMPSP2-0042: 未知命令"IMP" -- 其余行忽略。SQL> 你是连本地?ORA2000 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ) (CONNECT_DATA = (Sid = ora2000) --确信本地的sid为 ora2000 ) )imp(80) 在dos下运行. 我确实在本地。我DROP用户后,再建并授权都可以。可是每次EXIT SQLPLUS后,再连接就不可以了还有IMP怎么用呀?我的DMP在C盘。 imp username/passwd file=.... commit=y ignore=y full=y 抱歉多次打扰你Microsoft Windows 2000 [Version 5.00.2195](C) 版权所有 1985-2000 Microsoft Corp.C:\>imp voice/sjc600 file=c:\bak.dmp commit=y ignore=y full=yImport: Release 8.1.6.0.0 - Production on 星期日 7月 14 16:54:47 2002(c) Copyright 1999 Oracle Corporation. All rights reserved.IMP-00058: ORACLE 错误1045出现ORA-01045: user VOICE lacks CREATE SESSION privilege; logon denied用户名: 给你新建的用户授:grant create session to ....我吃饭去了. jlandzpa(ORA-00600)麻烦你再看一下吧,在不添加SID情况下,我导入成功了.只是不加SID使我不明白.请帮我解决.我的电脑叫CSHIS,安装ORACLE设的SID是ora2000************************************************# TNSNAMES.ORA Network Configuration File: D:\Oracle\Ora81\network\admin\tnsnames.ora# Generated by Oracle configuration tools.ORA2000 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ora2000) ) )EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )*********************************************************************运行实例如下:SQL> conn voice/sjc600@ora2000ERROR:ORA-12547: TNS: 丢失联系警告: 您不再连接到 ORACLE。SQL> conn voice/sjc600已连接。SQL> ORA2000 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = cshis)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = his) ) )这样的设置,应该是 conn system/manager@ora2000怎么是 ...@his 呢?????居然还有人说: 主机字符串应该填你的数据库名,或服务器名。我倒主机字符串又叫 net_service_name是随便命名的一个名字而已跟数据库名,sid,服务器名 是八秆子打不着只不过你配置的时候可能什么都写一样的,自己分不清楚而已了 oracle学习小组-- RAC 安装 数据的备份和恢复 急!关于表内字段名映射后建view的问题 一个表的信息如何关联后横向输出 如何以参数形式向数据库中进行插入数据 其中有日期数据类型的数据? 请教,下面的sql 如何写 sql语句 关于ORACLE的基础问题 在SCO OpenServer5.0.x+Oracle7.3.3下,C怎么调用OCI访问数据库呢?代码又如何编译? OracleManagementServer启动问题 sql/plus连接问题/ sys用户是不是不能进SQL*PLUS
# Generated by Oracle configuration tools.ORA2000 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = cshis)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = his)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)***********************************************************
奇怪的是
system/manager
her/master
可以进入SQLPLUS
但是
system/manager@his
her/master@his
即加上SID就不可以
报:
ERROR:
ORA-12547: TNS: 丢失联系
还有我想模仿公司的数据库在自己机子上建立了一个,并将公司的数据做了bak.dmp.可是在自己的机子敲"imp c:\bak.dmp"报:
SP2-0734: 未知的命令开头 "imp c:\bak..." - 忽略了剩余的行。
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 换成ip)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = 远程服务器) --或者换成sid=....
)
)system/manager@ORA2000
her/master@ORA2000imp c:\bak.dmp --没有这么用的imp(imp80) 回车,按提示做或者去查查help.
# TNSNAMES.ORA Network Configuration File: D:\Oracle\Ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.ORA2000 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora2000)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
*************************************************************
输入:system/manager@ora2000--------->ERROR:
ORA-12547: TNS: 丢失联系
输入:system/manager---------------->
连接到:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production****************************************************************
关于第二个问题:
SQL> HELP
SP2-0171: HELP 不可访问。
SQL> HELP;
SP2-0171: HELP 不可访问。
SQL> IMP
SP2-0042: 未知命令"IMP" -- 其余行忽略。
SQL>
ORA2000 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(Sid = ora2000) --确信本地的sid为 ora2000
)
)imp(80) 在dos下运行.
还有IMP怎么用呀?我的DMP在C盘。
(C) 版权所有 1985-2000 Microsoft Corp.C:\>imp voice/sjc600 file=c:\bak.dmp commit=y ignore=y full=yImport: Release 8.1.6.0.0 - Production on 星期日 7月 14 16:54:47 2002(c) Copyright 1999 Oracle Corporation. All rights reserved.
IMP-00058: ORACLE 错误1045出现
ORA-01045: user VOICE lacks CREATE SESSION privilege; logon denied用户名:
我吃饭去了.
麻烦你再看一下吧,在不添加SID情况下,我导入成功了.只是不加SID使我不明白.请帮我解决.
我的电脑叫CSHIS,安装ORACLE设的SID是ora2000
************************************************
# TNSNAMES.ORA Network Configuration File: D:\Oracle\Ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.ORA2000 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora2000)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)*********************************************************************运行实例如下:
SQL> conn voice/sjc600@ora2000
ERROR:
ORA-12547: TNS: 丢失联系
警告: 您不再连接到 ORACLE。
SQL> conn voice/sjc600
已连接。
SQL>
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = cshis)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = his)
)
)这样的设置,应该是 conn system/manager@ora2000
怎么是 ...@his 呢?????
居然还有人说: 主机字符串应该填你的数据库名,或服务器名。我倒
主机字符串又叫 net_service_name
是随便命名的一个名字而已
跟数据库名,sid,服务器名 是八秆子打不着
只不过你配置的时候可能什么都写一样的,自己分不清楚而已了