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;
I know the above steps are wrong, please give me the correct order and correct syntax