How to fix a broken asm spfile, held within asm send article as pdf my server rebooted itself and when it came back up, none of the databases or asm had restarted. Dec 16, 20 oracle 11gr2 have many new futures in grid computing area. If the parameter spfile and pfile returned some value thats mean the spfile is located in that disk. Enterprise manager provides a guibased option for migration of a database to asm storage.
For example, create an oracle asm spfile from the existing pfile. In the previous blog post, to the question where is the asm spfile i answered by running asmcmd spget. But note the following when replacing a spfile that resides in asm. To install and initially configure an oracle asm instance, use oracle universal installer. Asm instance not using spfile even spfile exists in diskgroup doc id 1638239. Oracle first look for a sp file and after that after a p file sp file s provide the following advantages over p file s. Asm disk wont be onlinemounted if asm instance isnt started.
Backup and restore using create pfile from spfile and create spfile from pfile can also be used. Asm unable to get logical block size for asm spfile oracle. When installing oracle asm in a clustered oracle asm environment, oui creates a single, shared spfile for oracle asm in a disk group. Fixing a problem with the asm spfile preventing rac 12c from.
Tom i am going through your book effective oracle by design. Db has not been restarted then why the spfile read it is showing because as per my understanding it shows message like this when we start the db. If no spfile is associated with the instance, then the database looks for the platformspecific default server parameter file name. You can administer oracle asm initialization parameter files with sqlplus, asmca, and asmcmd commands. When an oracle asm instance searches for an initialization parameter file, the. Create a pfile with one line in it that identifies the path to the. In oracle rac database spfile must be created on shared asm storage. Ora file has given way to a more robust method the server parameter file spfile. Mar 26, 2016 for spfile, you need to find where your spfile file is on asm, remember your database is not even mounted, so oracle is totally lost as where the location of databases spfile is.
Dec 16, 2010 here, i just showed you,how to move asm spfile from one diskgroup to another diskgroup. When the default server parameter file is used by the server, the value of spfile is internally set by the server. At this time it does not validate the new parameter value. I would suggest start by checking asm is running and then query the status of your diskgroups. Each database use a spfile pfile, in this rac the spfile is in the asm, so each database instance can access the same spfile, this is correct.
By default, a new oracle database will be working on a pfile, so the spfile must be created from the pfile at the sql prompt. How to install oracle 12c and asm on redhat oracle database. How to fix a broken asm spfile, held within asm rants. Creating, copying, and moving an spfile into a disk group. In this case it will be necessary to shutdown the database and asm instances, then. When upgrading an oracle asm instance, if the asm spfile was originally in a shared file system, then the upgraded oracle asm instance retains the spfile in the same location. Starting up an oracle asm instance with an incorrect spfile path. Getting the database parameters from a spfile frits hoogland weblog. If you look here, youll see a link to the spfile to its true asm place.
By default, a new oracle9i database will be working on a pfile, so the spfile must be created from the pfile at the sql prompt. Set some database options and rename the spfile in asm. Lets assume you made a change to the asm server parameter file that causes an issue. Ora32000 not able to modify the rdbms spfile which is there. If a parameter is changed using the alter system set command oracle will apply this parameter change to the current sp file. A spfile is a binary version of the parameter file of the oracle database. The following is an example of how to move your spfile from asm to your file system or vice versa.
How to check whether oracle instance is started using pfile. In what order does oracle search for the pfile and spfile locations at database startup time. How to move spfile from asm to filesystem the geek diary. One of them is oracle local repository olr, this repository designed to store information and profiles for local resources, resources th.
About initialization parameter files for an oracle asm instance. Do not perform rest of the steps if you want to use pfile. The spfile is different from the pfile in that it can not be directly edited. Other databases uses asm so everything seems to be ok except there is no spfile. Because database was not accepting the parameter values. Asm instance not using spfile even spfile exists in. Some more articles you might also be interested in. How to check whether oracle instance is started using. Find out the spfile location in asm smart way of technology. Apr 11, 2010 create spfile from pfile when the database is started with a pfile. When using a nondefault server parameter file, you must specify the server parameter filename in the startup command when you start up the database.
Until the next time we had to use create spfile the nightmare got back again. This chapter describes how to migrate part or all of your database into and out of asm storage using recovery manager. Locate the oracle asm spfile using the asmcmd spget command. How can i tell if my database was started with a spfile. Ora32000 not able to modify the rdbms spfile which is there in asm. Hello i know that in oracle11gr2 spfile location and diskstring parameters are located in oracle local registry. Asm unable to get logical block size for asm spfile. Dec 02, 2015 fixing a problem with the asm spfile preventing rac 12c from starting this is a little note to myself on how to fix a corrupt spfile in clustered asm. May 30, 2003 oracle s traditional method of storing parameters in the init. It usually happens in combination with spfile creation in asm, or. How does oracle reads spfile and mounts instance when the spfile is stored in asm. Asm instance not using spfile even spfile exists in diskgroup.
You can back up, copy, or move an oracle asm spfile with the asmcmd spbackup, spcopy, or spmove commands. When installing oracle asm in a clustered oracle asm environment, oui creates a single, shared. Since you can not change a spfile directly, oracle allows you to manage the spfile via the alter system command. Oct 14, 2014 find out the spfile location in asm list the asm disk maps to be partition. When the db is created the spfile inside asm is as below. It says that one of the reasons to use spfile is if i use oemoms to startstop database, the pfile needs to be on the machine where oms is installed or pfile should be accessible to the machine running oms. Mar 02, 2011 recreating spfile on asm storage from pfile filed under. Learn what truly works in converting and maintaining your parameters without ever having to use an editor again. Mar 06, 20 in this post, i am going to explain how we can create recreating the spfile for rac instances. If you specify the oracle asm filename syntax, then the database creates the spfile in an oracle asm disk group. About backing up, copying, and moving an oracle asm.
The asm spfile in this case is located on a raw device, so backup and recovery from and to a raw device is explained. Also the asm has its own spfile, normally in a rac the asm spfile lives on the ocrvoting disk diskgroup, so each asm instance can access the same spfile, this is correct. Is there a view where i can check whether an instance had been started using a pfile or an spfile. The asm spfile is stored in a disk group during installation. For information about the asmca gui and commandline interfaces, see managing oracle asm with asmca. Indeed, during a new asm installation, the oracle universal installer oui. Stepbystep database configuration optional and site specific. Making a back up copy of an oracle asm spfile in a disk group. Add new logfile groups to use asm diskgroups and drop old logfile groups which are on file system. By looking at these values, oracle reads spfile and mounts the asm instance. This is because it has a header and footer that contains binary values. Recreating spfile on asm storage from pfile dba sensation. Aug 17, 2015 enable the use of oracle managed files on asm diskgroups. About initialization parameter files for an oracle asm.
Settings for oracle asm instance initialization parameters are discussed in this topic. But then you get the location of the local one you used. While it is possible to edit the spfile, using editors like vi will corrupt the spfile. Ora it gives path of spfile file which is getting used by database for starting up. Then the logical assumption would be that either asm is not started properly or the diskgroups configured for asm have not been mounted properly or the file is no longer present. Few days back i was changing some memory parameters and was unable to start the database. It usually happens in combination with spfile creation in asm, or with rman spfile restores to asm. For information about asmcmd commands for managing an oracle asm spfile. Beginners guide to working with spfile in oracle asm the geek. If the spfile path in the gpnp profile is incorrect, you can start the oracle asm instance as follows. L eventually we decided to give up this solution and we are using spfile in a regular file system. Ora32000 not able to modify the rdbms spfile which is.
Jul 20, 2012 this morning, i was wondering how asm instance could be started if the spfile is stored inside asm disk. The the spfile is really just a flatfile text file, with binary ascii nul character padding at the beginning and end of. So the first thing i did was to confirm that the spfile is in the asm disk. If the instance is running with spfile parameter and you have changed the dynamic parameter to spfile only. If you have corrupted your spfile and its easy to do it you can start with a local pfile and the create spfile from pfile. Another thing that is not usual and everytime i do, someone be surprised. Can i edit my spfile, or should i recreate by spfile from my pfile. The oracle spfile is a binary representation of the text0based init. Creating a text parameter file is a convenient way to get a listing of the current parameter settings being used by the database, and it lets you edit the file easily in a text editor and then convert it back into a.
The oracle spfile is a binary representation of the textbased init. Create spfile on asm from pfile on filesystem grepora. But this is available only if the asm instance is started. Use the create pfile statement to export either a binary server parameter file or the current inmemory parameter settings into a text initialization parameter file. Sometimes you need to recreate spfile from pfile located on filesystem and viceversa. How to move asm spfile from one diskgroup to another diskgroup.
1020 807 71 323 432 296 301 1112 334 1367 4 964 1252 797 616 1258 1120 1075 25 898 764 1176 1464 1577 1079 1291 1566 1275 272 914 401 350 133 68 1095 57 192 1048 512 404 1301 758 494 551 394 1438 1406