oracle数据库：数据文件_笔记11

where

file - name of password file (required),

password - password for SYS will be prompted if not specified at command line,

entries - maximum number of distinct DBA (optional),

force - whether to overwrite existing file (optional),

ignorecase - passwords are case-insensitive (optional),

nosysdba - whether to shut out the SYSDBA logon (optional Database Vault only).

There must be no spaces around the equal-to (=) character.

在登录拥有Oracle软件的操作系统账户时，使用的命令为：

[oracle@vcenteroracle ~]$ orapwd file=orapw$ORACLE_SID password=bar entries=20

目前该文件中只有一个用户，也就是用户SYS，尽管数据库上还有其他SYSDBA账户，但它们还不在密码文件中。基于以上设置，我们可以第一次作为SYSDBA通过网络连接Oracle:

[oracle@localhost ~]$ sqlplus sys/bar@172.16.40.252/orcl as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Sep 10 08:50:48 2013

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from scott.emp;

EMPNO ENAME JOB MGR HIREDATE SAL COMM

---------- ---------- --------- ---------- --------- ---------- ----------

DEPTNO

----------

7369 SMITH CLERK 7902 17-DEC-80 800

20

...

我们通过了认证，所以登录成功，现在可以通过SYSDBA账户成功的启动、关闭和远程管理这个数据库了。

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> conn ops$tkyte/test@172.16.40.252/orcl as sysdba

Connected.

下面，再看另一个用户OPS$TKYTE,它已经是一个SYSDBA,但还不能远程连接，

idle>create user ops$tkyte identified by test;

User created.

idle>grant sysdba to ops$tkyte;

Grant succeeded.

原因是，OPS$TKYTE还不在密码文件中。要把OPS$TKYTE放到密码文件中，需要重新对该账户授予SYSDBA：

这样会在密码文件中创建一个条目，Oracle现在会保持密码“同步”。如果OPS$TKYTE修改了他的密码，原来的密码将无法完成远程SYSDBA连接，新密码才能启动SYSDBA连接：

sys@ORCL>alter user ops$tkyte identified by something_else;

User altered.

[oracle@localhost ~]$ sqlplus ops$tkyte/test@172.16.40.252/orcl as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Sep 10 09:05:19 2013

Copyright (c) 1982, 2011, Oracle. All rights reserved.

ERROR:

ORA-01031: insufficient privileges

Enter user-name:

ERROR:

ORA-01017: invalid username/password; logon denied

Enter user-name:

ERROR:

ORA-01017: invalid username/password; logon denied

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

[oracle@localhost ~]$ sqlplus ops$tkyte/something_else@172.16.40.252/orcl as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Sep 10 09:26:06 2013

Copyright (c) 1982, 2011, Oracle. All rights reserved.

ERROR:

ORA-01031: insufficient privileges

Enter user-name: ops$tkyte/something_else@172.16.40.252/orcl as sysdba

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from scott.emp;

EMPNO ENAME JOB MGR HIREDATE SAL COMM

---------- ---------- --------- ---------- --------- ---------- ----------

DEPTNO

----------

7369 SMITH CLERK 7902 17-DEC-80 800

20

...http://www.52ij.com/jishu/5155.htmloracle数据库：数据文件_笔记10