- 论坛徽章:
- 0
|
看Oracle的官方资料,<<Oracle? Database Administrator's Guide>>
对于需要密码验证的时候,官方资料只是要求
例如资料上写
Adding Users to a Password File
When you grant SYSDBA or SYSOPER privileges to a user, that user's name and privilege information are added to the password file. If the server does not have an EXCLUSIVE password file (that is, if the initialization parameter REMOTE_LOGIN_PASSWORDFILE is NONE or SHARED, or the password file is missing), Oracle Database issues an error if you attempt to grant these privileges.
A user's name remains in the password file only as long as that user has at least one of these two privileges. If you revoke both of these privileges, Oracle Database removes the user from the password file.
Creating a Password File and Adding New Users to It
Use the following procedure to create a password and add new users to it:
Follow the instructions for creating a password file as explained in "Using ORAPWD".
Set the REMOTE_LOGIN_PASSWORDFILE initialization parameter to EXCLUSIVE. (This is the default.)
Note:
REMOTE_LOGIN_PASSWORDFILE is a static initialization parameter and therefore cannot be changed without restarting the database.
Connect with SYSDBA privileges as shown in the following example, and enter the SYS password when prompted:
CONNECT SYS AS SYSDBA
Start up the instance and create the database if necessary, or mount and open an existing database.
Create users as necessary. Grant SYSDBA or SYSOPER privileges to yourself and other users as appropriate. See "Granting and Revoking SYSDBA and SYSOPER Privileges", later in this section.
Granting and Revoking SYSDBA and
压根就没有提到sqlnet.ora这个文件
可是从网上查到的中文资料,无一例外的说修改
SQLNET.AUTHENTICATION_SERVICES=(NTS)(window平台)
SQLNET.AUTHENTICATION_SERVICES=(NONE)(unix平台)
难道Oracle的官方资料也是漏写东东的啊
而且我查看了我自己的sqlnet.ora文件
连SQLNET.AUTHENTICATION_SERVICES这个选项都没有的哦
如果要改成密码验证,还得自己加这个选项?晕晕得啊 大虾指较啊
[oracle@etl admin]$ cat sqlnet.ora
# sqlnet.ora Network Configuration File: /opt/oracle/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
[oracle@etl admin]$ pwd
/opt/oracle/oracle/product/10.2.0/db_1/network/admin |
|