Skip to content

Instantly share code, notes, and snippets.

@freddenis

freddenis/rename_a_dg_21

Created July 22, 2016 00:04
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save freddenis/82b0523844cd84f5250785d56d0c8cfe to your computer and use it in GitHub Desktop.
Save freddenis/82b0523844cd84f5250785d56d0c8cfe to your computer and use it in GitHub Desktop.
Download ZIP
Raw
rename_a_dg_21
myclusterdb01:oracle \) asmcmd
ASMCMD> pwset --asm +DATA/orapwASM
ASMCMD> exit
myclusterdb01:oracle \)
SQL> create pfile='/tmp/ASMpfile.ora' from spfile ;
File created.
SQL> create spfile='+DATA' 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