Error Message When Calling Oraenv Script From User Not In Dba/Oinstall Group

Normally when we run oraenv script from different user than oracle we usually get the below error: [oratest@GI01 ~]$ . oraenv ORACLE_SID = [oratest] ? testdb ORACLE_BASE environment variable is not being set since this information is not available for the current user ID oratest. You can set ORACLE_BASE manually if it is required. [oratest@GI01Continue reading “Error Message When Calling Oraenv Script From User Not In Dba/Oinstall Group”

How to Use Operating System Authentication for Different User in Oracle

We normally use Linux Oracle user to authenticate for SYSDBA privilege and we don’t need to pass the username/password for it. But how can we do it for a different we have, how can the different user can connect to Database using OS Authentication. [oratest@GI01 ~]$ . oraenv ORACLE_SID = [oratest] ? testdb ORACLE_BASE environmentContinue reading “How to Use Operating System Authentication for Different User in Oracle”