Database Architecture An Oracle database server consists of an Oracle database and an Oracle instance. Oracle Database architecture is based on physical and logical structures. Oracle Database Physical Structure Oracle database consists of physical files to store information. Basically there are three types of physical files required for database: Core Files: Data Files [...]
Archive for March, 2011
6 Mar
Shutdown Hangup Scenario
If Shutdown normal or shutdown immediate hangs and you try to connect as sys, it would get you connected either as idle instance or simply connected which is in reality a fake connection. In a particular scenario, I changed ORACLE_HOME from EM and then issued simple “SHUTDOWN” command which took a long time to complete. [...]
