1 2 Previous Next 19 Replies Latest reply: May 16, 2012 8:14 AM by 566539 Go to original post RSS
      • 15. Re: Unable to start database using pfile
        415289
        How can i physically locate the file?
        connect with ASM by asmcmd and go this location by cd +AQADATA
        If I do this, I have to still locate the file under +AQADATA. How is that made possible?
        first locate the file and give the same path in srvctl modify cmd.

        or inplace of doing above can you first try this.
        locate current spfile path by srvctl config database -d DBNAME -a
        and create new spfile on same path

        CREATE SPFILE='+RACDG_DATA/racdb1/spfileracdb1.ora ' from PFILE;
        • 16. Re: Unable to start database using pfile
          566539
          The changes got reflected after a successful restart and with spfile.
          SQL> SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type" FROM sys.v_$parameter WHERE name = 'spfile';
          
          Init F
          ------
          SPFILE
          
          SQL> show parameter sga
          
          NAME                                 TYPE        VALUE
          ------------------------------------ ----------- ------------------------------
          lock_sga                             boolean     FALSE
          pre_page_sga                         boolean     FALSE
          sga_max_size                         big integer 2336M
          sga_target                           big integer 1008M
          SQL> show parameter pga
          
          NAME                                 TYPE        VALUE
          ------------------------------------ ----------- ------------------------------
          pga_aggregate_target                 big integer 0
          SQL> show parameter memory
          
          NAME                                 TYPE        VALUE
          ------------------------------------ ----------- ------------------------------
          hi_shared_memory_address             integer     0
          memory_max_target                    big integer 3G
          memory_target                        big integer 3G
          shared_memory_address                integer     0
          SQL>
          But I now see that spfile location is changed on node1 as below

          Node1
          SQL> show parameter spfile
          
          NAME                                 TYPE        VALUE
          ------------------------------------ ----------- ------------------------------
          spfile                               string      /u01/app/oracle/product/11.2.0
                                                           /db_1/dbs/spfileAQADEV1.ora
          Node2
          SQL> show parameter spfile
          
          NAME                                 TYPE        VALUE
          ------------------------------------ ----------- ------------------------------
          spfile                               string      +AQADATA/aqadev/spfileaqadev.o
                                                           ra
          I have been provided with additional memory on each node, which I want to add to SGA. When tried on Node1, following error message is displayed.
          SQL> ALTER SYSTEM SET MEMORY_MAX_TARGET=9G SCOPE=SPFILE;
          ALTER SYSTEM SET MEMORY_MAX_TARGET=9G SCOPE=SPFILE
          *
          ERROR at line 1:
          ORA-32000: write to SPFILE requested but SPFILE is not modifiable
          Edited by: satish_034 on May 16, 2012 6:09 PM
          • 17. Re: Unable to start database using pfile
            566539
            The problem is now ORA-32000.
            • 18. Re: Unable to start database using pfile
              anand prakash - oracle
              Hi,

              1. shutdown instance on node1
              2. On node1 , remove the spfile and have pfile mentioned spfile='+AQADATA/aqadev/spfileaqadev.ora'
              3. start the instance 1 --> also make sure in srvctl config database -d <db_unique_name> , spfile points to +AQADATA/aqadev/spfileaqadev.ora
              4. check show parameter spfile, should be same on both the nodes
              5. try and change the parameter you want.


              Anand
              • 19. Re: Unable to start database using pfile
                566539
                Node1
                SQL> SHUT IMMEDIATE
                Database closed.
                Database dismounted.
                ORACLE instance shut down.
                SQL> startup pfile='/home/oracle/aqadev.ora'
                ORACLE instance started.
                
                Total System Global Area 2438529024 bytes
                Fixed Size                  2215784 bytes
                Variable Size            2382364824 bytes
                Database Buffers           50331648 bytes
                Redo Buffers                3616768 bytes
                Database mounted.
                Database opened.
                SQL> create spfile='+AQADATA/aqadev/spfileAQADEV.ora' from pfile='/home/oracle/aqadev.ora';
                
                File created.
                
                SQL> SHUT IMMEDIATE
                Database closed.
                Database dismounted.
                ORACLE instance shut down.
                
                oracle@INBGEDV50:/u01/app/oracle/product/11.2.0/db_1/dbs> ls -ltr
                total 72
                -rw-r--r-- 1 oracle oinstall 2851 2009-05-15 13:35 init.ora
                -rw-r----- 1 oracle oinstall   42 2012-04-20 14:44 initAQADEV1.ora
                -rw-r----- 1 oracle oinstall   42 2012-04-20 14:44 initAQADEV2.ora
                -rw-r----- 1 oracle oinstall 1536 2012-05-02 15:01 orapwAQADEV
                -rw-r----- 1 oracle asmadmin 1536 2012-05-08 18:08 spfileAQADEV1.ora
                oracle@INBGEDV50:/u01/app/oracle/product/11.2.0/db_1/dbs> rm spfileAQADEV1.ora
                oracle@INBGEDV50:/u01/app/oracle/product/11.2.0/db_1/dbs> ls -ltr
                total 64
                -rw-r--r-- 1 oracle oinstall 2851 2009-05-15 13:35 init.ora
                -rw-r----- 1 oracle oinstall   42 2012-04-20 14:44 initAQADEV1.ora
                -rw-r----- 1 oracle oinstall   42 2012-04-20 14:44 initAQADEV2.ora
                -rw-r----- 1 oracle oinstall 1536 2012-05-02 15:01 orapwAQADEV
                
                SQL> startup
                ORACLE instance started.
                
                Total System Global Area 2438529024 bytes
                Fixed Size                  2215784 bytes
                Variable Size            2382364824 bytes
                Database Buffers           50331648 bytes
                Redo Buffers                3616768 bytes
                Database mounted.
                Database opened.
                SQL> show parameter spfile
                
                NAME                                 TYPE        VALUE
                ------------------------------------ ----------- ------------------------------
                spfile                               string      +AQADATA/aqadev/spfileaqadev.o
                                                                 ra
                1 2 Previous Next