DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: doubt about parameter files?

Threaded View

  1. #5
    Join Date
    Mar 2010
    Posts
    35

    Wink

    C:\Users\4i-Admin>sqlplus /nolog
    SQL*Plus: Release 10.2.0.1.0 - Production on Wed Mar 17 11:44:12 2010
    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    SQL> conn sys as sysdba
    Enter password:
    Connected to an idle instance.
    SQL> create spfile from pfile;
    File created.

    SQL> create pfile from spfile;
    File created.

    OR

    SQL> create pfile='C:\oracle\product\10.2.0\db_1\admin\sos\pfile\initsos.ora'
    2 from
    3 spfile='C:\oracle\product\10.2.0\db_1\database\spfilesos.ora';

    File created.

    i hope this will work.
    Last edited by davey23uk; 03-17-2010 at 03:50 AM.

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