SAP BASIS,HANA AND ORACLE DBA BLOGS

Oracle Multitenant Option - 12c : Frequently Asked Questions Oracle Multitenant Option - 12c : Frequently Asked Questions. APPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.1 [Release 12.1] Information in this document applies to any platform. PURPOSE  To document many aspects & usages of pluggable database for better understanding and quick references of this product. QUESTIONS AND ANSWERS General CDB / PDB Concept in  12c Multitenant Architecture What is a pluggable database (PDB) in Multitenant Architecture? Pluggable Databases (PDBs) is new in Oracle Database 12c Release 1 (12.1). You can have many pluggable databases inside a single Oracle Database occurrence. Pluggable Databases are fully backwards compatible with an ordinary pre-12.1 database. Why would I consider using the Multitenant option ? You should consider following Database Consolidation Goals to achieve: Reduce Total Cost of Operation ...

Password File Authentication in Oracle Database PUBLISHED by anand gupta Introduction As a DBA we must have used  sqlplus “/as sysdba”  to connect to database, atleast hundred times a day. Never bothered about the password to provide !!! This is because we were using OS level authentication. We can change the configuration and make Oracle to ask for the password. Well, “/as sysdba” works fine if we are connecting to the host where the database is actually installed. For example I have installed a database as oracle01 user (which belongs to DBA group) on one of my host called “host1”. I telnet to host1 as oracle01 user and provide the password to login. Once I successfully login to the host, there ends the authentication part. Not for administering the database all I have to do is to use our famous command to connect to database – “sqlplus /as sysdba”. The reason above thing work is because I was using Operating System level authentication. If I try to conne...