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