• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1212
  • Last Modified:

init.ora/ SPFILE

I have a database , not sure if it uses pfile or spfile or whatever.
I need to change certain init.ora parameters and create a spfile. I guess this is pretty starigh forward?
Can someone please give me step by step procedure for this please. something like..
1)shutdown the database (shutdown immediate)
2) create spfile from pfile
3) alter system set XXX =1000 scope =spfile;
etc etc

I know the above steps are wrong, please give me the correct order and correct syntax

many thanks!!

0
crishna1
Asked:
crishna1
  • 4
  • 3
2 Solutions
 
sathyagiriCommented:
Shut down your database.
Modify any init.ora parameters and re-start
Creat your spfile from pfile
Then modify any pararmeters using alter commands with the scope parameter.

See here for details
http://www.psoug.org/reference/init_dot_ora.html
0
 
anand_2000vCommented:
Generally if you create a database using DBCA it comes with spfile and pfile will be in Admin path
Try this.

sql > / as sysdba

sql > create pfile from spfile;

go to $ORACLE_HOME/dbs - Unix
go to ORACLE_HOME/database -- windows

You will find Init and spfile both

Open the InitDbname.ora and modify the parameters

Remove the spfile using rm or delete

sqlplus > / as sysdba

sqlplus > startup (Now it will start with pfile as Spfile is removed )

sqlplus > create spfile from pfile;

sqlplus > shutdown immediate

sqlplus > startup

So now your database starts with spfile and from now you can start using alter commands as lik sathya said above
0
 
anand_2000vCommented:
dynamic parameters can be modified online and will take effect on modified.

Static Init parameters will need a database bounce back .
0
Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

 
crishna1Author Commented:
Anand, Satya,

Thanks a lot , will try this and let you know how it goes.
0
 
crishna1Author Commented:
Anand,

 i see a startup in your notes above , but the database was never shut down?

The databse  is UP right now, do i have to shut it down before i do the followng?

sql > / as sysdba

sql > create pfile from spfile;

go to $ORACLE_HOME/dbs - Unix
go to ORACLE_HOME/database -- windows

You will find Init and spfile both

Open the InitDbname.ora and modify the parameters

Remove the spfile using rm or delete

sqlplus > / as sysdba

sqlplus > startup (Now it will start with pfile as Spfile is removed )

0
 
crishna1Author Commented:
Anand,
also , as shown below , i am reading your instructions , looks like first we are creating PFILE from SPFILE, the open initdbname.ora and modify , then delete existing spfile , then starup the database (no intruction to shutdown) and then create SPFILE again, startup and shutdown again, and from now on start using alter commands?? lil confusing , may be i am not reading it right?
0
 
anand_2000vCommented:
sorry about the prev post....
create pfile
shutdown
modify pfile
create spfile from pfile; (logged on as sysdba)
startup
0
 
crishna1Author Commented:
after trying it out couple of times, i figured it out , thanks a lot.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now