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 Oracle快速入门 如何获得数据库连接 存储过程返回记录总是出错 Pro*C编译问题(超奇怪) 如何用sql取到3个月的数据 新手请教如何写一个oracle双重循环sql(50分) SELECT REMAINDER(10,4) FROM DUAL;在Oracle 9i中執行為什么會報錯? 回滚段为什么不回滚 一个关于PL/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。那我应该如何修改路径呢?
把你的这个服务名添加到这个文件里