DBAsupport.com Forums - Powered by vBulletin
Page 1 of 5 123 ... LastLast
Results 1 to 10 of 50

Thread: init.ora file location

  1. #1
    Join Date
    Jun 2004
    Location
    Montreal, Quebec, Canada
    Posts
    178

    Unhappy init.ora file location

    Hello,

    I read that I need to increase the SESSION and/or the MAX_LOGIN_SESSION parameter located on my Linux Server in the Oracle 9i init.ora file to avoid some problems.

    1) Where can I find the database init.ora file ?
    (under $ORACLE_HOME ??)

    PT

  2. #2
    Join Date
    Jul 2003
    Posts
    323
    Believe me if someone here tells you you may not learn much - relax and try the Linux find cmd. for it and your knowledge will definitely increase !!




  3. #3
    Join Date
    Apr 2003
    Location
    Gourock, Scotland
    Posts
    102
    Usually in $ORACLE_HOME/dbs, buut it may be linked elsewhere. Try:

    find / -name 'init*.ora'

    to find all references. We all start somewhere!
    If I have to choose between two evils, I always like to choose the one I haven't tried yet.

  4. #4
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    remember to create spfile to permanently modify the configuration parameter.

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    why do you need an spfile to store something permanently

  6. #6
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    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?

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    i dont user an spfile, all changes I make in the init.ora are permanent.

    So why do I need an spfile to make things permanent

  8. #8
    Join Date
    Feb 2003
    Location
    London
    Posts
    170
    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.

  9. #9
    Join Date
    Jun 2004
    Location
    Montreal, Quebec, Canada
    Posts
    178

    Cool Comments

    Hello,

    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.

    This is why I was asking this questions.

    Any suggestions ???

    Regards,

    PT

  10. #10
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    Originally posted by davey23uk
    i dont user an spfile, all changes I make in the init.ora are permanent.

    So why do I need an spfile to make things permanent
    I'd rather start my database by using STARTUP instead of the 3 commands:STARTUP NOMOUNT PFILE=..., ALTER DATABASE MOUNT, ALTER DATABASE OPEN.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width