Shulou(Shulou.com)06/01 Report--

NAMES.DIRECTORY_PATH setting in sqlnet.ora [@ more@]

Sqlplus sys/oracle@orcl

If my sqlnet.ora looks like this

D:oracleproduct10.2.0db_1NETWORKADMIN > type sqlnet.ora

# This file is actually generated by netca. But if customers choose to

# install "Software Only", this file wont exist and without the native

# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES = (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES,HOSTNAME)

Then, the client will first look for the orcl record in the tnsnames.ora file. If there is no corresponding record, try to take orcl as a host name, resolve its ip address through the network, and then connect to the instance of GLOBAL_DBNAME=orcl on this ip. Of course, orcl is not a host name.

If I were like this,

NAMES.DIRECTORY_PATH= (TNSNAMES)

Then the client will only look up orcl records from tnsnames.ora.

There are other options in parentheses, such as LDAP, which are not commonly used.

Here is a summary of the behavior characteristics when the REMOTE_LOGIN_PASSWORDFILE parameter takes different values.

The REMOTE_LOGIN_PASSWORDFILE parameter can have three values: EXCLUSIVE (default), NONE, and SHARED.

1) when the value is EXCLUSIVE

Allows the client to log in to the database instance with SYSDBA or SYSOPER privileges to complete database management operations

Allows you to grant and reclaim SYSDBA or SYSOPER permissions.

2) when the value is NONE

Prohibit clients from logging in to the database instance with SYSDBA or SYSOPER permissions to complete database management operations

It is prohibited to grant and reclaim SYSDBA or SYSOPER permissions.

3) when the value is SHARED

Allows the client to log in to the database instance with SYSDBA or SYSOPER privileges to complete database management operations

It is prohibited to grant and reclaim SYSDBA or SYSOPER permissions.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.