Oracle OS verification Logon

Source: Internet
Author: User

Oracle OS verification Logon

Username and password are our most common security authentication policies and the most common security protection policies we use in various application system software. It is a natural responsibility for Oracle to maximize the security of system data.
From the earliest version to today, Oracle has continuously improved its user name and password security policy. For example, after entering the 11g, the Default Profile requires regular user password modification, strengthen the user password encryption algorithm and optimize and improve data dictionary views such as dba_users. Today we are going to discuss another Oracle verification policy-OS verification policy.
Here, we need to clarify. The most common OS verification policy occurs on the Oracle server. Outstanding Performance: If we have passed the operating system-level verification, that is, logging on to the server (Remote Desktop or SecurCRT), Oracle considers that the current user can pass the authentication, no additional database verification is required. Of course, this requires that operating system users belong to specific user groups, such as oinstall and dba in Linux. For example, we often start the conn/method used to disable the server, which is the login authentication method of this type. Note: By configuring parameters in sqlnet. ora, we can disable this feature.
The common OS authentication policy has two features: one is that the server takes effect locally and the client's Anonymous logon is invalid. The other user can only log on to the system as the administrator, but cannot log on to other users. Is there a way to remotely and anonymously log on to the client and implement non-sys users?


Installing Oracle 12C in Linux-6-64

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian


In this article, we will introduce this method.

1. experiment environment Introduction

The lab environment is Oracle 11g, and the specific version is The server is in Linux.

SQL> select * from v $ version;



Oracle Database 11g Enterprise Edition Release Production

PL/SQL Release

CORE Production

TNS for Linux: Version

NLSRTL Version

Parameters related to this experiment are kept in the default state.

SQL> show parameter OS



Db_lost_write_protect string NONE

Diagnostic_dest string/u01/app

Optimizer_index_cost_adj integer 100

OS _authent_prefix string ops $

OS _roles boolean FALSE

Remote_ OS _authent boolean FALSE

Remote_ OS _roles boolean FALSE

Timed_ OS _statistics integer 0

By default, you can only perform Anonymous Logon on the server. After logon, the system role with the highest permission appears.

SQL> conn/as sysdba


SQL> show user


The as sysdba logon process is not allowed.

SQL> conn/


ORA-01017: invalid username/password; logon denied

Next we will discuss how to perform OS-level verification.

For more details, please continue to read the highlights on the next page:

  • 1
  • 2
  • 3
  • Next Page

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.