修改 E:\oracle\ora817\network\ADMIN\sqlnet.ora SQLNET.AUTHENTICATION_SERVICES= (NTS) 这样之后,在服务器上SQL> conn / as sysdba 已连接。 SQL> show user USER 为"SYS" SQL> conn sys/xxxxxxx as sysdba 已连接。 SQL>
那需要用户有alter user权限
我现在可以用system/manager进去了
我知道了alter user怎么用了,犯了一个低级错误
ALTER USER { user { IDENTIFIED { BY password | EXTERNALLY | GLOBALLY AS 'external_name' } | DEFAULT TABLESPACE tablespace | TEMPORARY TABLESPACE tablespace | QUOTA { integer [ K | M ] | UNLIMITED } ON tablespace [QUOTA { integer [ K | M ] | UNLIMITED } ON tablespace]... | PROFILE profile | DEFAULT ROLE { role [, role]... | ALL [EXCEPT role [, role]...] | NONE } | PASSWORD EXPIRE | ACCOUNT { LOCK | UNLOCK } } [ IDENTIFIED { BY password | EXTERNALLY | GLOBALLY AS 'external_name' } | DEFAULT TABLESPACE tablespace | TEMPORARY TABLESPACE tablespace | QUOTA { integer [ K | M ] | UNLIMITED } ON tablespace [QUOTA { integer [ K | M ] | UNLIMITED } ON tablespace]... | PROFILE profile | DEFAULT ROLE { role [, role]... | ALL [EXCEPT role [, role]...] | NONE } | PASSWORD EXPIRE | ACCOUNT { LOCK | UNLOCK } ]... | user [, user]... proxy_clause } ;
这些用户和密码大概被上一个DBA修改了。
http://expert.csdn.net/Expert/topic/1203/1203142.xml?temp=.965069
E:\oracle\ora817\network\ADMIN\sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES= (NTS)
这样之后,在服务器上SQL> conn / as sysdba
已连接。
SQL> show user
USER 为"SYS"
SQL> conn sys/xxxxxxx as sysdba
已连接。
SQL>
{ user
{ IDENTIFIED
{ BY password | EXTERNALLY | GLOBALLY AS 'external_name' }
| DEFAULT TABLESPACE tablespace
| TEMPORARY TABLESPACE tablespace
| QUOTA { integer [ K | M ] | UNLIMITED } ON tablespace
[QUOTA { integer [ K | M ] | UNLIMITED } ON tablespace]...
| PROFILE profile
| DEFAULT ROLE
{ role [, role]... | ALL [EXCEPT role [, role]...] | NONE }
| PASSWORD EXPIRE
| ACCOUNT { LOCK | UNLOCK }
}
[ IDENTIFIED
{ BY password | EXTERNALLY | GLOBALLY AS 'external_name' }
| DEFAULT TABLESPACE tablespace
| TEMPORARY TABLESPACE tablespace
| QUOTA { integer [ K | M ] | UNLIMITED } ON tablespace
[QUOTA { integer [ K | M ] | UNLIMITED } ON tablespace]...
| PROFILE profile
| DEFAULT ROLE
{ role [, role]... | ALL [EXCEPT role [, role]...] | NONE }
| PASSWORD EXPIRE
| ACCOUNT { LOCK | UNLOCK }
]...
| user [, user]... proxy_clause
}
;