when you start your db using nomount pfil=.... in 9i to alter your parameter file, it will only last until the db will be shutdown. In a
normal operation where in starting db with STARTUP would be fine without other parameters. SPFILE(server parameter file) needs to be updated with the new init.ora value to make that effect.
Or was my previous post was just somehow confussing?
hey ptreves, you have been installing a nd creating database for a long time now if I remember right. And usually the first thing anyone creating a database encounters is the init.ora file which you still seemed to have never seen. That's really bad froma dba point of view.
That is the file which defines most of the oracle parameters for your database.
Like Ken mentioned, you will find it in $ORACLE_HOME\dbs most probably as a link or you may find it under the \pfile directory wherever that has been created for you when you created the database using the database configuration assistant.
Thanks for all your comments and feedback.
Yes, I have been working on this migration project for about 2-3 months now. I have made a lot of progress. I succeeded in installing Oracle 9i Database on my Linux Server and installed Forms/Reports Services 10g on the same server and migrated my Forms/Reports application from 6i to 9i and deployed my WebForms over the Web. That part is pretty much workin after much sweet and tears and long hours.
However in order to deploy my WebReports over the Web, WebReports called from WebForms using Parameter Forms, I ran in to Report Services Errors such as: REP-50125, REP-51018 and REP-51019 in a reports trace file.
I have been reading related articles on metalink, that mention that I should increase the SESSION parameter in the database init.ora file.
I found that there was no SESSION parameter in my init.ora file so it must use default values. I tried to set the SESSION parameter to 9999, and restart my Oracle 9i database. However, this has not resolved my problems with the deployment of my WebReports.