sqlplus sys/passw0rd@orcl as sysdba 跟sqlplus sys/passw0rd as sysdba@orcl有啥不
sqlplus sys/passw0rd@orcl as sysdba 跟sqlplus sys/passw0rd as sysdba@orcl有啥不一样的sqlplus sys/passw0rd@orcl as sysdba
bash-4.2$ vi /home/oracle/.profile
bash-4.2$ sqlplus sys/passw0rd@orcl as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 11 21:46:20 2013
Copyright (c) 1982, 2009, Oracle.All rights reserved.
ERROR:
ORA-01031: insufficient privileges
但是sqlplus sys/passw0rd as sysdba@orcl
就直接等进去了
为什么呢？
本帖最后由 hmchzb19 于 2013-03-12 11:07 编辑
但是我这样就不行，而且就算我输入sys/pass0rd
还是会报错，这是为什么呢？
sqlplus sys/passw0rd@ORCL as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 11 21:52:52 2013
Copyright (c) 1982, 2009, Oracle.All rights reserved.
ERROR:
ORA-01031: insufficient privileges
Enter user-name: sys
Enter password:
ERROR:
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
如果我这里password 写成pass0rd as sysdba 就能登录，但是sqlplus sys/passw0rd@ORCL as sysdba 总是报错
ORA-01031: insufficient privileges 一个走侦听，一个走本地
页:
[1]