Showing posts with label OS Authentication. Show all posts
Showing posts with label OS Authentication. Show all posts

Friday, 16 December 2016

Enable OS Authentication in Oracle Database - Linux/Unix

Enable OS Authentication in Linux/Unix


How do we enable OS User Login Access in Oracle Database 11g in Linux? Can normal user like Oracle or Grid can login into Oracle Database 11g?

As I mentioned in one of my previous posts regarding - How do we enable OS Authentication in Oracle database 11g in Windows? - I showed you how do we manage to login via OS User into Oracle Database 11g

Now OS Authenticated Login in Linux is very similar to Windows except the fact that you don't need to mention the domain info while creating OS User in Oracle Database. So lets begin,

Thursday, 15 December 2016

OS Authentication in Oracle Database 11g

OS Authentication in Oracle Database 11g - Learn how to perform OS Authenticated Login in Oracle Database


How do you create a OS Authenticated User in Oracle Database 11g? Can I login via my OS User in Oracle Database 11g? Login into Oracle Database using SQLPLUS /

Yes, we can create a OS Authenticated User in Oracle Database or in simple words, I can make my current OS User to login into Oracle Database without even providing the credentials. For this, I'll login like 

Sqlplus /

There are basically 3 types of login scenarios that we follow in our local environment to connect to Oracle Database i.e.

1) Sqlplus / as sysdba
2) Sqlplus user@SID/Password or Sqlplus /@SID as sysdba or Sqlplus sys/***@SID as sysdba
3) Sqlplus /