Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2003

    Question Unanswered: init.ora file identification

    Whenever some instance is up (imean startup has been issued and databse is up) how can I identify which init.ora file was used by that instance.
    I ask this because in 9i we also have spfile in adition to pfile.
    So if some instance is up then which file was used by the instance for its parameters??
    Was it the pfile or the spfile ??
    How can I find this.

    I have one database named PROD but its init file is initbgatod1.ora
    After searching the contents of the initbgatod1 file i realised that this is the init file for the PROD instance.

    How can i find this information when the database is up from the database itself as to which file was used tin the startup ??

  2. #2
    Join Date
    Nov 2003
    Rotterdam, Netherlands
    in my knowledge, its not possible to findout.
    By default, the init files should be in DATABASE directory.
    the name should be init<<SID>>.ora

    otherwise u cannot know.
    Thats why normally, for starting up and shutting down, we use scripts..


  3. #3
    Join Date
    Nov 2002
    9i uses spfile by default if existing

  4. #4
    Join Date
    Nov 2003
    Prior to 9i

    the initfiles exist on /orabin/dbs with the name init<sid>.ora.

    When u issue a startup on svrmgrl oracle will look in that directory to find the init file, or u can issue a startup pfile=<path><initfile.ora>

    In 9i by default oracle will use the spfile in the /orabin/dbs dir or u can issue startup spfile=<path><spfile> or if you want to start with the initfile startup pfile=<path><initfile>

Posting Permissions

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