init and password file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: init and password file

  1. #1
    Join Date
    Jul 2004
    Location
    Pakistan
    Posts
    46

    init and password file

    hi
    i m creating a new database with the name "test"..when we issue the command of startup, by
    default it checks the initifile with the name "inittest.ora" if "spfileinit.ora" at
    $ORACLE_BAST/product/9.2.0.1.0/dbs....i want to ask that can we change this default
    location??if yes then how will i tell oracle that check for inittest at that specific
    location not on the default location...
    same question is for the passowrd file....i mean how can we have a passowrd file with the
    different then default name and how can we relocate it...
    on windows its very simple...we just neet to edit registry variable but how on linux
    Regards
    Salman Ahmed Qureshi
    Lahore, Pakistan

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    On linux/unix it is even simpler. Just create a symbolic link in ORACLE_HOME/dbs to your init.ora file.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  3. #3
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    startup pfile='full path of parameter file'

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

  4. #4
    Join Date
    Apr 2002
    Location
    Phoenix, AZ
    Posts
    175
    I am not sure about init* files. But you can place Tnsnames.ora and Listener.ora in /etc.

    Can you try the same for init* files and post back?
    Sridhar R Patnam

  5. #5
    Join Date
    Jul 2004
    Location
    Pakistan
    Posts
    46
    well
    we can place TNSNAMES.ORA etc to any location because e have TNS_ADMIN environment variable
    but how init
    ???
    Regards
    Salman Ahmed Qureshi
    Lahore, Pakistan

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    as was previously said, put the init file anywhere you want and have a softlink to oracle_home/dbs

    Or in all your startup scripts have startup pfile=...

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