OraFAQ Forum: Server Administration » Moving spfile to ASM disk

Home » RDBMS Server » Server Administration » Moving spfile to ASM disk (oracle12c)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Moving spfile to ASM disk [message #648164]

Wed, 17 February 2016 18:56

shrinika
Messages: 304
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.

Report message to a moderator

Re: Moving spfile to ASM disk [message #648165 is a reply to message #648164]

Wed, 17 February 2016 19:01

John Watson
Messages: 8795
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.

Report message to a moderator

Re: Moving spfile to ASM disk [message #648201 is a reply to message #648165]

Thu, 18 February 2016 08:21

shrinika
Messages: 304
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!

Report message to a moderator

Re: Moving spfile to ASM disk [message #648215 is a reply to message #648201]

Thu, 18 February 2016 09:57

Michel Cadot
Messages: 68348
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'

Report message to a moderator

Re: Moving spfile to ASM disk [message #648262 is a reply to message #648215]

Fri, 19 February 2016 08:27

shrinika
Messages: 304
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>

Report message to a moderator

Re: Moving spfile to ASM disk [message #648272 is a reply to message #648262]

Fri, 19 February 2016 09:53

Michel Cadot
Messages: 68348
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Thanks for the feedback and detailed solution.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 06 09:17:28 CST 2023