Posts

Showing posts from December, 2014

Oracle Database Error Solutions & DBA Knowledge Base

Welcome to Oracle Database Error Solutions, a professional technical knowledge base dedicated to helping Oracle Database Administrators, Oracle E-Business Suite administrators, developers, and IT professionals troubleshoot Oracle Database and Oracle Linux issues with confidence.

This website provides practical, real-world troubleshooting guides based on hands-on Oracle administration experience. You'll find detailed solutions for Oracle Database errors, RMAN backup and recovery, Data Guard, ASM, RAC, Oracle Linux administration, Oracle E-Business Suite (EBS), cloning, performance tuning, patching, installation, and day-to-day DBA tasks.

Whether you're resolving ORA-27101, ORA-28040, ORA-01555, ORA-12154, ORA-01017, or other Oracle errors, our step-by-step articles are designed to save you time and help you solve problems efficiently.

sys / as sysdba should require a password

sys / as sysdba should require a password Applies to:             Enterprise Linux – Version: 5 Description:             Sqlplus / as sysdba connections go through OS authentication rather than database authentication. Any user with OS access can log into database irrespective of valid account available in database. Sys / as sysdba could not login without a password. How can we control OS authentication to stop any OS user to login as SYSDBA? Solution: Set the following parameter in init.ora file: REMOTE_OS_AUTHENT = FALSE open sqlnet.ora file and set the following parameter: SQLNET.AUTHENTICATION_SERVICES=(NONE) save and exit file. now you cannot login "sys / as sysdba" without password. 👉 Check our complete guide: Oracle Error Codes Guide Author Box About the Author Rana Abdul Wahid  is an experienced Oracle Database Administrat...