Shulou(Shulou.com)05/31 Report--

This article introduces the "Oracle password files and operating system authentication knowledge points" related knowledge, in the actual case of the operation process, many people will encounter such a dilemma, and then let the editor lead you to learn how to deal with these situations! I hope you can read it carefully and be able to achieve something!

I. password file

Function: mainly carry on the authentication of dba authority.

Location:

Storage location under Linux: $ORACLE_HOME/dbs/orapw$ORACLE_SID

Namely: ORACLE_HOME/dbs/orapw

Second, whether the operating system authentication or not

It is decided that in two parameters

1 、 remote_remote_login_passwordfile

Located in the $ORACLE_HOME/dbs/spfile$ORACLE_SID.ora parameter file.

None: turn off password file authentication.

Exclusive: open password file authentication and use it exclusively (default).

Shared: to authenticate password files, dba users with different instances can share password files.

2 、 SQLNET.AUTHENTICATION_SERVICES

Located at $ORACLE_HOME/network/admin/sqlnet.ora.

None: turn off operating system authentication, only password authentication.

All:Linux and AIX systems, turn on operating system authentication and turn off password file authentication, but password file authentication is required remotely.

Nts: used for Windows platform to open operating system authentication.

III. Testing

1. Add SQLNET.AUTHENTICATION_SERVICES = none to sqlnet.ora and try dba secret-free login.

one

two

three

four

five

six

seven

eight

nine

[ora122@enmodb1 admin] $sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Fri Mar 1 23:49:34 2019

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

ERROR:

ORA-01017: invalid username/password; logon denied

Enter user-name:

ERROR:

ORA-01017: invalid username/password; logon denied

2. Set SQLNET.AUTHENTICATION_SERVICES = all and try to log in without secret for dba users again.

one

two

three

four

five

six

[ora122@enmodb1 admin] $sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Fri Mar 1 23:52:25 2019

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

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0-64bit Production

SYS@ora122 >

Or comment out, the default is to use operating system authentication.

This is the end of the content of "what are the password files and operating system authentication knowledge points of Oracle". Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.