UNIX环境
oracle软件安装用户为oracle,存在数据库用户dba11,密码为dba11,$ORACLE_SID为ora11用oracle用户登陆UNIXoracle>sqlplus dba11/dba11@ora11
SQL*Plus: Release 11.1.0.6.0 - Production on Tue Jan 5 09:31:34 2010Copyright (c) 1982, 2007, Oracle. All rights reserved.ERROR:
ORA-01017: invalid username/password; logon denied
但这样可以登陆:oracle>sqlplusSQL*Plus: Release 11.1.0.6.0 - Production on Tue Jan 5 09:49:28 2010Copyright (c) 1982, 2007, Oracle. All rights reserved.Enter user-name:dba11
Enter password:Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL>请问这是为什么呢?
oracle软件安装用户为oracle,存在数据库用户dba11,密码为dba11,$ORACLE_SID为ora11用oracle用户登陆UNIXoracle>sqlplus dba11/dba11@ora11
SQL*Plus: Release 11.1.0.6.0 - Production on Tue Jan 5 09:31:34 2010Copyright (c) 1982, 2007, Oracle. All rights reserved.ERROR:
ORA-01017: invalid username/password; logon denied
但这样可以登陆:oracle>sqlplusSQL*Plus: Release 11.1.0.6.0 - Production on Tue Jan 5 09:49:28 2010Copyright (c) 1982, 2007, Oracle. All rights reserved.Enter user-name:dba11
Enter password:Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL>请问这是为什么呢?
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ora11)
)
)请问 @ 后面的应该怎么配置呢?
ORA-01017: invalid username/password; logon denied
Enter user-name:还是不行啊!
ORA-01017: invalid username/password; logon denied
Enter user-name:还是不行啊!
[oracle@yangtk ~]$ sqlplus system@\"172.25.13.227/ora11g_p.ytk-thinkpad\"
$sqlplus /nolog
SQL>conn user/pwd;
这样也很简洁..
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716
oracle软件安装用户为oracle,存在数据库用户dba11,密码为dba11,$ORACLE_SID为ora11 用oracle用户登陆UNIX oracle>sqlplus dba11/dba11@ora11 sqlplus dba11/dba11@ora11--此处的orall不应该是oracle的实例,而应该是你在tnsnames.ora文件中配置的网络服务名称.
以下是2楼的配置tnsnames.ora的方法。
ORA11 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ora11)
)
)
以网络服务名为ORALL为例,进行说明。你在登录时应该这样了
sqlplus dba11/dba11@ORALL;
在linux下可以啊。
和
sql dba11/dba11@tnsname不是一样的。
上面是登录你本地的ORACLE_SID指定的数据库实例下面是登录你tnsname里配置的指定的数据库实例