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!!
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!!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Anand, Satya,
Thanks a lot , will try this and let you know how it goes.
Thanks a lot , will try this and let you know how it goes.
ASKER
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 )
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 )
ASKER
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?
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?
sorry about the prev post....
create pfile
shutdown
modify pfile
create spfile from pfile; (logged on as sysdba)
startup
create pfile
shutdown
modify pfile
create spfile from pfile; (logged on as sysdba)
startup
ASKER
after trying it out couple of times, i figured it out , thanks a lot.
Static Init parameters will need a database bounce back .