A brief discussion on Oracle login method

Source: Internet
Author: User

First, There are two ways in which Oracle login authentication is managed:

1, Operating system authentication method

2. Password Authentication

Second, the operating system certification overview and Implementation methods

1, warm-up small experiment

Sql>-- First we close the database

sql> shutdown Immediate

The database is closed.

The database has been uninstalled.

The ORACLE routine has been closed.

Sql>-- Let's use sys to see if we can log in

Sql> Conn/as SYSDBA

Connected to the idle routine.

Sql> Show User

USER is "SYS"

Sql>--In fact, we are in the operating system login mode implementation of the login, we discuss in detail the implementation of the operating system login mode

Sql>-- Let's try it again, we're just going to use a user login that does not exist for Oracle

Sql> Conn Xiaoming/as SYSDBA

Connected to the idle routine.

Sql> Show User

USER is "SYS"

Sql>-- through the above example we can see that in the operating system authentication login mode, any one user can use the identity of Sysdba to log on to Oracle, but the actual user or sys;

2. How to use operating system login mode under Windows operating system

First in When installing an Oracle database in a Windows environment, use the Administrator user to log on to the operating system;

we need to find Sqlnet.ora files under the \network\admin directory of the $oracle _home(Oracle Installation home directory) , For example, the path to my local machine is:

E:\app\neusoft\product\11.2.0\dbhome_1\NETWORK\ADMIN\sqlnet.ora

The contents of the file are summarized as follows:

# sqlnet.oranetwork Configuration File:e:\app\neusoft\product\11.2.0\dbhome_1\network\admin\sqlnet.ora

#Generated by Oracle configuration tools.

# Thisfile is actually generated by NETCA. But if customers choose to

# install ' Software only ', this file wont exist and without the native

#authentication, they is not being able to connect to the database on NT.

    1. Authentication_services= (NTS)

    1. Directory_path= (TNSNames, Ezconnect)

The contents of # represent the meaning of the note, and the translation of the comment is

the configuration path for the Sqlnet.ora is:E:\app\neusoft\product\11.2.0\dbhome_1\network\admin\sqlnet.ora

This file is automatically generated by the Configuration tool

This file is actually generated by NETCA(netconfiguration Assistant). However, if the user chooses "Install only database software" at the time of installation, this file will not produce

If you want to use the operating system authentication method to login to Oracle, you need to do the following settings:sqlnet. Authentication_services= (NTS)

will be Remote_login_passwordfile=none,remote_login_passwordfile translation is a remote login password file, the default value of this parameter is exclusive, That is exclusive, exclusive;

Set statement: Sql> alter system set Remote_login_passwordfile=none scope=spfile;

The required scope is SPFile, which requires a restart of the DB instance to take effect after the statement is committed.

3. How to implement the operating system login mode under UNIX operating system

first , the Sqlnet.ora file will be sqlnet. Authentication_services= (beq), stating that if this file does not exist, it can be created manually.

second , as with the Windows operating system, use the sql>alter system set Remote_login_passwordfile=none scope=spfile; statement to set remote_login_passwordfile to None

Three, password authentication overview and realization Way

1, first sqlnet.ora file to modify the sqlnet. Authentication_services= (None)

2. Perform showparameter remote_login_passwordfile in sqlplus to see if the value is EXCLUSIVE or SHARED ;

3.if the value of the parameter remote_login_passwordfile is null or NONE, you need to use the statement Sql>alter system set Remote_login_ Passwordfile=exclusive scope=spfile; Reboot the instance to take effect;

4 requires the installation of the Database home directory ( $oracle _home folder, if the file name is " Span style= "color: #FF0000;" >unix operating system environment ' start + db instance name,

if the operating system is Windows Environment , you should pwd+ DB instance name . Ora,password is the login password specified for sys user,entries is the optional Maximum number of users with Sysdba/sysoper permissions;

Examples of formats are:

Orapwd File=e:\app\neusoft\product\11.2.0\dbhome_1\database\orapworclpassword=neusoft entries=5;

5.Check The v$pwfile_users view to see a list of users with Sysdba/sysoper permissions in the database ;

6, we can use the authorization statement to assign Sysdba,sysoper permissions to any specified user:

GRANT Sysdba,sysoper to System;

select* from V$pwfile_users;


This article is from the "Oralce Learning path" blog, make sure to keep this source http://dushuai.blog.51cto.com/9461011/1599022

A brief discussion on Oracle login method

Related Article

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: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.