How to locate pfile in oracle?

Asked by Wilma

Report
in progress 87
8 Answers 193 views

Leave a reply to Wilma : locate pfile in oracle


Answers ( 8 )

  1. Helen

    SCPT 47: Oracle Storage Parameters: PCTFREE and PCTUSED :

    how to locate pfile in oracle

    Ratings : 18 %   

      
  2. Gilles

    You can change parameter settings in the SPFILE file only by using Oracle Enterprise Manager or ALTER SYSTEM (...) The SPFILE for the ASM instance cannot be
    Read More

    Ratings : 59 %   

      
  3. Bill

    Create Standby Control File: (...) $ cp $ORACLE_BASE/oradata/orabase/control02.ctl /u02/oradata/orabase/control02.ctl $ vi $ORACLE_HOME/dbs/initorabase.ora
    Read More

    Ratings : 11 %   

      
  4. Vorll

    Search for the spfile$ORACLE_SID.ora file in the default location, 2: Look for the spfile.ora; and 3: Search for the pfile by name
    Read More

    Ratings : 30 %   

      
  5. Old Christopher

    Process to check alert log in oracle :

    how to locate pfile in oracle

    Ratings : 67 %   

      
  6. Paély

    The pfile and spfile is a initialization parameter files in Oracle. (...) is a server parameter file in Oracle. The spfile by default locate under the database folder
    Read More

    Ratings : 68 %   

      
  7. Old Oliver

    Finding Tr ace Files. Trace files are stored in the Automatic Diagnostic Repository (ADR), in the trace directory under each ADR home. To help you locate individual
    Read More

    Ratings : 63 %