Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "what is the startup sequence of Oracle RAC environment parameter files". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

How to find the location of the parameter file when Oracle RAC starts.

In a stand-alone environment, the order in which Oracle looks for startup parameter files is spfile.ora-- > spfile > .ora-> .init.ora

Let's test the lookup order of parameter files in the RAC environment

We copy the parameter file in ASM to the $ORACLE_HOME/dbs/ directory and rename it spfileorcl1.ora, and the file in ASM is called spfileorcl.ora

[oracle@rac1 dbs] $echo $ORACLE_ SIDorcl1 [oracle @ rac1 dbs] $pwd/u01/app/oracle/product/11.2.0/dbhome_1/ dbs [oracle @ rac1 dbs] $lltotal 24 RWQ RWQ-1 oracle asmadmin 1544 Jan 10 22:04 hc_orcl1.dat-rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora-rw-r- 1 oracle oinstall 37 Dec 23 18:31 initorcl1.ora-rw-r- 1 oracle oinstall 1536 Dec 23 17:55 orapworcl1-rw-r- 1 oracle oinstall 4608 Jan 10 22:03 spfileorcl1.ora [oracle@rac1 dbs] $sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Thu Jan 10 22:25:00 2019Copyright (c) 1982 2013, Oracle. All rights reserved.Connected to an idle instance.SQL > startupORACLE instance started.Total System Global Area 784998400 bytesFixed Size 2257352 bytesVariable Size 616566328 bytesDatabase Buffers 163577856 bytesRedo Buffers 259864 bytesDatabase mounted.Database opened.SQL > show parameter spfileNAME TYPE VALUE-- -spfile string / u01/app/oracle/product/11.2.0 / dbhome_1/dbs/spfileorcl1.ora

The database started successfully. Use the / u01/app/oracle/product/11.2.0 / dbhome_1/dbs/spfileorcl1.ora parameter file

Change the sspfileorcl1.ora file name to spfile.ora restart database [oracle@rac1 dbs] $mv spfileorcl1.ora spfile.ora [oracle@rac1 dbs] $lltotal 24LV RWLLLI-1 oracle asmadmin 1544 Jan 10 22:25 hc_orcl1.dat-rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora-rw-r- 1 oracle oinstall 37 Dec 23 18:31 initorcl1.ora-rw-r- 1 oracle oinstall 1536 Dec 23 17:55 orapworcl1-rw-r- 1 oracle oinstall 4608 Jan 10 22:28 spfile.ora [oracle@rac1 dbs] $SQL > shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL > startupORACLE instance started.Total System Global Area 784998400 bytesFixed Size 2257352 bytesVariable Size 616566328 bytesDatabase Buffers 163577856 bytesRedo Buffers 259864 bytesDatabase mounted.Database opened.SQL > show parameter spfileNAME TYPE VALUE---spfile string / u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfile.ora

Database started successfully, use / u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfile.ora file

Change the spfile.ora file name to spfile1.ora restart database [oracle@rac1 dbs] $mv spfile.ora spfile1.oraSQL > startupORACLE instance started.Total System Global Area 784998400 bytesFixed Size 2257352 bytesVariable Size 616566328 bytesDatabase Buffers 163577856 bytesRedo Buffers 259864 bytesDatabase mounted.Database opened.SQL > show parameter spfileNAME TYPE VALUE- -spfile string + DATA01/orcl/spfileorcl.ora

Also started successfully, using the parameter file in ASM

Let's change the ORACLE_SID to any value and start the database export ORACLE_SID=orcl11SQL > startupORA-01078: failure in processing system parametersLRM-00109: could not open parameter file'/ u01ApplicationoracleUniproductUniverse 11.2.0 dbhomeowners 1DB dbsUniverse initorcl11.ora'

Note that the initorcl11.ora file cannot be found, where orcl11 is the ORACLE_ Sid value we just modified, so let's see what the correct file initorcl1.ora is.

[oracle@rac1 dbs] $cat initorcl1.oraSPFILE='+DATA01/orcl/spfileorcl.ora'

It turned out to point to the file address on the ASM disk. Using this file, you can point the parameter file anywhere.

In Oracle RAC environment, Oracle looks for startup parameter files during startup, which is the same as in stand-alone environment:

Spfile.ora-- > spfile > .ora-> init.ora

When you save the startup parameter file using ASM, the location of the parameter file is saved in the init.ora file

This is the end of the content of "what is the startup order of the Oracle RAC environment parameter file". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.