Monday, 30 March 2015

Create spfile from pfile



Create spfile from pfile




 
C:\Users\3130738>set path=D:\app\product\11.2.0\dbhome_2\bin;

C:\Users\3130738>set oracle_sid=abctest

C:\Users\3130738>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri Feb 13 12:48:41 2015

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount pfile='D:\app\product\11.2.0\dbhome_2\database\INITabctest.ora';
ORACLE instance started.

Total System Global Area  926969856 bytes
Fixed Size                  2181224 bytes
Variable Size             587204504 bytes
Database Buffers          331350016 bytes
Redo Buffers                6234112 bytes
SQL> sho parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string
SQL> sho parameter pfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string
SQL> create spfile from pfile='D:\app\product\11.2.0\dbhome_2\database\INITabctest.ora';

File created.

No comments:

Post a Comment

The purge process did not run because the Oprid configured to start the Process Scheduler did not have the required permissions to run the purge process.

  Purge process - Required permissions The PeopleSoft Oprid used to start the Process Scheduler, as defined in the Scheduler's psprcs.cf...