Search notes:

Oracle Instance

An Oracle instance consists of
Server processes are associated with an instance but are not part of the instance.
When an Oracle Database is shut down, there is no instance.

Memory management

The main memory structures are

Starting an instance

Starting an instance automatically creates the mandatory background processes.

See also

v$instance
Some (memory-)data of the instance can be queried from the so called fixed (X$) tables.
Compare with the SQL Server instance.
Oracle Architecture
instance recovery
oradebug allows to inspect and change memory in the instance.
A client needs Oracle Net to connect to an instance.
oradim allows to start and stop instances (as well as the corresponding Windows services).
orastart is a simple PowerShell script that starts both, an instance and listener.
The init parameter cpu_count specifies the number of CPUs for an instance.

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1741097716, '18.118.255.51', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/architecture/instance/index(84): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78