Spfile and user environment variables and export

Spfile and user environment variables and export RAC database environment variable settings

[oracle@rac1 ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Fri Aug 31 12:45:01 2012 Copyright (c) 1982, 2005, Oracle.  All rights reserved. Connected to an idle instance. SQL> startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/opt/oracle/product/10.2.0/db_1/dbs/initorcl1.ora' [oracle@rac1 dbs]$ more initORCL1.ora SPFILE='+DATA/ORCL/spfileORCL.ora'

 

Note that initORCL1.ora sid is ORCL1 in uppercase, so note the following when setting ORACLE_SID.

export ORACLE_SID=ORCL1SQL> conn / as  sysdba Connected to an idle instance. SQL> create pfile from spfile='+DATA/ORCL/spfileORCL.ora'; File created. SQL> startup ORA-29760: instance_number parameter not specified

 

This is because instance_numberexport ORACLE_SID = ORCL1 is not specified. Note that the following number '1' is added: pfile configuration :*. db_name = 'orcl '. bash_profile configuration: export ORACLE_SID = orcl1 the root cause is not the size problem, but the dba during installation, which is caused by insufficient care and is a standard installation problem, if the oracle sid written to the database in dbca is in lower case, or the environment variable is configured later, the current problem will not occur if the sid is configured in the upper case.