Minimum parameter requirements for Oracle instance Creation

We know the minimum parameter requirements for creating an oracle instance. During Oracle startup, you need to read the parameter file (pfile/spfile) to create an instance. during Oracle startup, the order of search for parameter files is spfile. ora, spfile. ora, init. ora.
During instance creation, the minimum parameter required by Oracle is db_name.
Let's look at a test to start an instance with any settings. In this example, oracle_sid = JULIA:

[Oracle @ jumper DBS] $ export oracle_sid = Julia [Oracle @ jumper DBS] $ sqlplus "/As sysdba" SQL * Plus: Release 9.2.0.4.0-production on Mon May 8 11:08:36 2006 Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved. Connected to an idle instance. SQL> startup nomount; ORA-01078: Failure in Processing System Parameters LRM-00109: cocould not open parameter file '/opt/Oracle/product/9.2.0/dbs/initjulia. ora'

The last file checked by Oracle is initjulia. ora. Let's create this file and then create the database instance:

SQL>! Echo "db_name = Julia">/opt/Oracle/product/9.2.0/dbs/initjulia. ora SQL> startup nomount; Oracle instance started. Total system global area 97588504 bytes Fixed size 451864 bytes Variable Size 46137344 bytes Database buffers 50331648 bytes Redo buffers 667648 bytes

Let's take a look at the default storage location of various types of files:

SQL> show parameter dump_dest Name type value ---------------------------------------------------------------------------------------- Background_dump_dest string? /Rdbms/log Core_dump_dest string? /Dbs User_dump_dest string? /Rdbms/log SQL> show parameter control_files Name type value ---------------------------------------------------------------------------------------- Control_files string? /Dbs/cntrl @. DBF

By the way, let's take a look at the default information recorded in the alarm log:

[Oracle @ jumper DBS] $ cat $ ORACLE_HOME/rdbms/log/alert_julia.log Mon can 8 11:09:04 2006 Starting Oracle instance (normal) Mon can 8 11:09:04 2006 Warning: einval creating segment of size 0x0000000006400000 Fix SHM parameters in/etc/system or equivalent License_max_session = 0 License_sessions_warning = 0 SCN scheme 2 Using log_archive_dest parameter Default Value License_max_users = 0 Sys auditing is disabled Starting up Oracle RDBMS version: 9.2.0.4.0. System Parameters with non-default values: Db_name = Julia Pmon started with PID = 2 Dbw0 started with PID = 3 Lgwr started with PID = 4 Ckpt started with PID = 5 SMON started with PID = 6 Reco started with PID = 7