Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
myclusterdb01:oracle \) sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Sun May 1 18:10:03 2016
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ----------------------------------------------------------------
spfile string +DATAC1/mycluster/ASMPARAMETERFILE/registry.253.909092147
SQL> select instance_name from v$instance ;
INSTANCE_NAME
----------------
+ASM1
SQL> create pfile='/tmp/ASMpfile.ora' from spfile ;
File created.
SQL> create spfile='+RECO' from pfile='/tmp/ASMpfile.ora' ;
File created.
SQL>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment