Total Pageviews

Tuesday 3 March 2015

SPSET to update spfile path

If the spfile path in GPNP profile is incorrect , you can start the ASM instance as follows:

To check the spfile location is gpnp you can use the command as below:

[grid@node1 peer]$ /data01/app/11.2.0/grid_11204/bin/gpnptool.bin getpval -asm_spf -p=profile.xml -o-
+DATA/node-cluster/asmparameterfile/registry.253.866681801


1. Create a pfile with one line in it that identifies the path to the spfile

Create a pfile $ORACLE_HOME/dbs/pfileasm.ora with entry :

SPFILE='+DATA/asm/asmparameterfile/asmspfile.ora'

2. Start up the instance using the init pfile :

SQL > Startup pfile='$ORACLE_HOME/dbs/pfileasm.ora' ;

3. After the instance is started you can update the spfile location using SPSET command using ASMCMD :

ASMCMD > spset +DATA/asm/asmparameterfile/asmspfile.ora

1 comment:

  1. Jadwal Cockfight SV388 2 Maret 2019 di Situs Judi Sabung Ayam Online Melalui Agen Resmi Taruhan Sabung Ayam Live Asli Thailand.

    Judi Sabung Ayam - Sabtu, Aceh 2 Maret 2019 – Kami Selaku Agen Sabung Ayam 2018 Akan Memberikan Informasi Mengenai Jadwal Cockfight SV388 2 Maret 2019.

    Untuk Info Lebih Lanjut Bisa Hub kami Di :
    wechat : bolavita
    line : cs_bolavita
    whatsapp : +628122222995
    BBM: BOLAVITA

    ReplyDelete