ITPub博客

首页 > 数据库 > Oracle > orapwd 使用注意事项

orapwd 使用注意事项

原创 Oracle 作者:woshizhaofang 时间:2012-02-15 22:51:00 0 删除 编辑

1.remote_login_passwordfile=EXCLUSIVE

2.若是在Linux下 建立的PASSWORDfile的路径是有要求的。

3.更详细的看这个:http://www.itpub.net/thread-906008-1-1.html

文档(Database Administrator's Reference
10g Release 2 (10.2) for UNIX-Based Operating Systems
)中明确说明了passwordfile的命名方式

1.4.5 Running the orapwd Utility

You can use a password file to identify users that can use the SYSDBA and SYSOPER privileges when connecting to the database. If you use Oracle Database Configuration Assistant to create a database, then the assistant creates a password file for the new database. If you create the database manually, then create the password file for it as follows:

  1. Log in as the Oracle software owner.

  2. Use the orapwd utility to create the password file as follows:

    $ $ORACLE_HOME/bin/orapwd file=filename password=password entries=max_users
    

    The following table describes the values that you must specify in this command.

Value Description
filename The name of the file in which password information is written

The name of the file must be orapwsid, and you must supply the full path name. Its contents are encrypted. Typically, the password file is created in the $ORACLE_HOME/dbs directory.

password The password for the SYS user

If you use an ALTER USER statement to change the password for the SYS user after you connect to the database, then both the password stored in the data dictionary and the password stored in the password file are updated. This parameter is mandatory.

max_users Sets the maximum number of entries permitted in the password file. This is the maximum number of distinct users permitted to connect to the database simultaneously with either the SYSDBA or the SYSOPER privilege.

[@more@]

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/20766695/viewspace-1057365/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: 047第二题
下一篇: 047第11题
请登录后发表评论 登录
全部评论
  • 博文量
    7
  • 访问量
    38676