Minimum parameter requirements for Oracle instance Creation

What are the minimum parameters for creating an instance in Oracle? This is a question that many people have asked. The following describes the minimum parameter requirements for creating an instance in Oracle for your reference.

We know that during Oracle startup, you need to read the parameter file (pfile/spfile) to create an instance. during Oracle startup, the books that search for parameter files are sequential: spfile. ora, spfile. ora, init. ora.

During Oracle 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, 2002, Oracle Corporation.  All rights reserved.  
  
  
 
  
  
Connected to an idle instance.  
  
  
 
  
  
SQL> startup nomount;  
  
  
ORA-01078: failure in processing system parameters  
  
  
LRM-00109: could 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 May  8 11:09:04 2006  
  
  
Starting ORACLE instance (normal)  
  
  
Mon May  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   
  
  
  
 
 

Statement syntax for oracle time addition and subtraction

How to check the oracle deadlock

A Simple Method for recording the execution time of Oracle statements

Statement of Oracle paging Query

Oracle condition branch statement example