Q1: What is Oracle Database Server?
Q2: What is Oracle Database Instance?
Q3: How to find how many database are running on a server?
Q4: How to connect to oracle database - ORCL?
Q5: After connecting to database how to verify the database name?
Q6: What is Oracle Home ?
Q7: How many databases/Instances I can create on each single Oracle Home?
Q8: How to find how many database are installed on a server irrespective of database instance is running or not?
Q9: Is there any limit to No of database files in a Database and how to find the No of datafiles on a Database?
Q10: Is there any limit to Size of each datafile and how to find the current used size of a datafile?
Q11: Is there any limit to total size of the database and how to find the total size of a database?
Q12: How many Oracle Database or Oracle Database servers I can install on a host/Server?
Q13: Can I have Instance and database on different servers?
Q14: What is the pfile/spfile location?
Q15: What are Database startup sequence?
Q16: If I have spfile and pfile in $ORACLE_HOME/dbs location, while starting the database which one will be picked up to start Oracle Instance?
Q17: How to start your database using pfile?
Q18: Can I create pfile from spfile or spfile from pfile?
Q19: What are the Oracle Database log_mode & how to check current log_mode of a database and how to switch the log mode them?
Q20: How to shutdown Oracle Instance or Oracle Database?
Q21: How to find the tablespace created on a Oracle Database?
Q22: How to find the number tablespace on a Oracle Database?
Q23: How to find the tablespace and associated datafiles on a Oracle Database?

#Architecture #DatabaseServer #Standalone #listener #tnsnames #MemoryStructure #backgroundProcessess #StorageStructure #Exadata #RAC #ASM #Oracle

Regards,
Mallikarjun Ramadurg
Mobile: +91 9880616848
WhatsApp: +91 9880616848