Home » RDBMS Server » Server Administration » Moving spfile to ASM disk (oracle12c)
Moving spfile to ASM disk [message #648164] Wed, 17 February 2016 18:56 Go to next message
shrinika
Messages: 306
Registered: April 2008
Senior Member
My database is 12c and it is single instance database. My database is running on ASK disk.
I am trying to move my spfile to ASM disk and it is not happening...


The DB is running with pfile.
sys@usben> startup nomount pfile=$ORACLE_HOME/dbs/initusben.ora
ORACLE instance started.

Total System Global Area  281018368 bytes
Fixed Size                  2923440 bytes
Variable Size             222299216 bytes
Database Buffers           50331648 bytes
Redo Buffers                5464064 bytes
sys@usben> alter database mount;
sys@usben> alter database open;
sys@usben> show parameter spfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string



Let me try to create the spfile under dbs directory.

sys@usben> create spfile from pfile;

File created.

sys@usben> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
sys@usben> startup
ORACLE instance started.

Total System Global Area  281018368 bytes
Fixed Size                  2923440 bytes
Variable Size             222299216 bytes
Database Buffers           50331648 bytes
Redo Buffers                5464064 bytes
Database mounted.
Database opened.
sys@usben> show parameter spfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /ora/app/oracle/product/12.1.0
                                                 .1/db_1/dbs/spfileusben.ora


The spfile is successfully created and the DB is using spfile.

Let me create the spfile in ASM disk.


sys@usben> create spfile='+DATA' from pfile='/ora/app/oracle/product/12.1.0.1/db_1/dbs/initusben.ora';

File created.

sys@usben> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
sys@usben> !
[oracle@RACTEST1 dbs]$ mv initusben.ora initusben.ora.gold1
[oracle@RACTEST1 dbs]$ mv spfileusben.ora spfileusben.ora.old
[oracle@RACTEST1 dbs]$ exit
sys@usben> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/ora/app/oracle/product/12.1.0.1/db_1/dbs/initusben.ora'
sys@usben> !
[oracle@RACTEST1 dbs]$ exit
exit

sys@usben>


Still it is trying to search the pfile while starting up the database.

The spfile is successfully created in ASM disk.

ASMCMD> ls -l
Type Redund Striped Time Sys Name
PARAMETERFILE UNPROT COARSE FEB 16 16:00:00 Y spfile.295.903975691
ASMCMD>


What am i missing here?

Any help is appreciated.
Re: Moving spfile to ASM disk [message #648165 is a reply to message #648164] Wed, 17 February 2016 19:01 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
You need to adjust your database's registration in the OLR, something like

srvctl modify database -db orcl -spfile +data/whatever_it_is_called

and then start it with srvctl.
Re: Moving spfile to ASM disk [message #648201 is a reply to message #648165] Thu, 18 February 2016 08:21 Go to previous messageGo to next message
shrinika
Messages: 306
Registered: April 2008
Senior Member
Thanks John! My database is non RAC database.. It means, we can not
store spfile in ASM disk for non RAC database. I believe, my
assumption is correct based on your input.

Thanks again!
Re: Moving spfile to ASM disk [message #648215 is a reply to message #648201] Thu, 18 February 2016 09:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

No, you posted your question in RAC forum, this is why John answered with a RAC related answer.
You move your SPFILE in ASM without RAC.

Create a /ora/app/oracle/product/12.1.0.1/db_1/dbs/initusben.ora file containing one line:
spfile='+DATA/whatever_it_is_called'

Re: Moving spfile to ASM disk [message #648262 is a reply to message #648215] Fri, 19 February 2016 08:27 Go to previous messageGo to next message
shrinika
Messages: 306
Registered: April 2008
Senior Member
Thanks Michael. Now i am able to move the spfile in ASM disk.

Here are the steps.. Just posting here for others reference.

sys@usben> show parameter spfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string
-- Creating spfile in ASM disk
sys@usben> create spfile='+DATA/USBEN/PARAMETERFILE/spfileusben.ora' from PFILE;

File created.

sys@usben> !

-- Here i updated the parameter file to point to SPFILE in ASM disk.

[oracle@RACTEST1 dbs]$ cat initusben.ora
SPFILE='+DATA/USBEN/PARAMETERFILE/spfileusben.ora'
[oracle@RACTEST1 dbs]$
-- Restart the database with spfile.
sys@usben> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
sys@usben> startup
ORACLE instance started.

Total System Global Area  281018368 bytes
Fixed Size                  2923440 bytes
Variable Size             222299216 bytes
Database Buffers           50331648 bytes
Redo Buffers                5464064 bytes
Database mounted.
Database opened.
sys@usben> set echo on
sys@usben> set feedback on
sys@usben> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      +DATA/USBEN/PARAMETERFILE/spfileusben.ora

sys@usben>
Re: Moving spfile to ASM disk [message #648272 is a reply to message #648262] Fri, 19 February 2016 09:53 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Thanks for the feedback and detailed solution.

Previous Topic: Importance of oratab
Next Topic: PARALLELISM - Processor
Goto Forum:
  


Current Time: Fri Mar 29 07:39:33 CDT 2024