sqlplus登录时的数据库名是SYSTEM,但用plsql登录时却是默认数据库名SQL plsql 登录时,要选数据库的,选哪个登录哪个。sqlplus 你没有指定,就是本机上的,如果本机有两个,你在注册表中能看到默认的那个,也就是你 DBCA 后建的那个。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 sys/密码@IP地址:1521/服务名 as sysdba或sys/密码@tns别名 as sysdba 输入system/oracle@ORCL后出现这个问题,我的tnsnames.ora是这样的:# tnsnames.ora Network Configuration File: E:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora# Generated by Oracle configuration tools.ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =172.16.82.247 )(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) )SYSTEM = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.82.247)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = system.MYORACLE) ) )LISTENER_MYORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))LISTENER_SYSTEM = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) 你确定走的是你这个tns文件吗执行下tnsping orcl1、看看能不能通2、看看sqlnet.ora的路径是哪,这个文件所在路径下应该有tnsname.ora的文件,这个文件才是生效的tns 看一下tns文件是不是有问题,注意空格的影响 谢谢版主的无私奉献。 我的路径居然是E:\app\Administractor\poduct\11.2.0\dbhome_2\network\admin\sqlnet.ora,应该是dbhome_1。那我应该如何修改路径呢? 谢谢版主的无私奉献。 我的路径居然是E:\app\Administractor\poduct\11.2.0\dbhome_2\network\admin\sqlnet.ora,应该是dbhome_1。那我应该如何修改路径呢?把你的这个服务名添加到这个文件里 用你现在的tnsname.ORA覆盖E:\app\Administractor\poduct\11.2.0\dbhome_2\network\admin\tnsname.ora 请教异常原因error:ORA-06550 Pro*c获取UPDATE或INSERT影响条数 oracle10g安装,你对指定目录没有足够写入权限 SQL语句。 多表联合查询 技巧问题啊 revoke问题,用户权限无法撤销? 快速删除问题,求解答 Oracle和SQLServer2000能同时安装吗??? 有了ORACLE9i的前三张CD,第四张client是否不用了? 求助!在用SQL语句查询oracle表时遇到的一个问题,急! in与exists 的问题。。。 5千万数据 表中,求一个删除sql
或
sys/密码@tns别名 as sysdba
输入system/oracle@ORCL后出现这个问题,我的tnsnames.ora是这样的:
# tnsnames.ora Network Configuration File: E:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =172.16.82.247 )(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)SYSTEM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.82.247)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = system.MYORACLE)
)
)
LISTENER_MYORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
LISTENER_SYSTEM =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
执行下tnsping orcl
1、看看能不能通
2、看看sqlnet.ora的路径是哪,这个文件所在路径下应该有tnsname.ora的文件,这个文件才是生效的tns
我的路径居然是E:\app\Administractor\poduct\11.2.0\dbhome_2\network\admin\sqlnet.ora,应该是dbhome_1。那我应该如何修改路径呢?
我的路径居然是E:\app\Administractor\poduct\11.2.0\dbhome_2\network\admin\sqlnet.ora,应该是dbhome_1。那我应该如何修改路径呢?
把你的这个服务名添加到这个文件里