Shulou(Shulou.com)06/01 Report--

11G rac the pfile error of the database created by spfile is as follows: SQL > create pfile='/u01/inittips1.ora' from spfile;create pfile='/u01/inittips1.ora' from spfile*ERROR at line 1:ORA-07391: sftopn: fopen error, unable to open text file. Execute SQL > create pfile='/u01/inittips1.ora' from spfile='+DATA/tips/spfiletips.ora';create pfile='/u01/inittips1.ora' from spfile='+DATA/tips/spfiletips.ora'*ERROR at line 1:ORA-07391: sftopn: fopen error, unable to open text file again. The same error is reported, so the permission to check the / U01 directory knows The problem is caused by permissions [root@tip01 oracle] # ls-ld / u01/drwxr-xr-x 3 root oinstall 4096 05-30 00:55 / u01 / [root@tip01 ~] # ls-ld / u01/app/oracle/drwxrwxr-x 7 oracle oinstall 4096 06-25 00:30 / u01/app/oracle/ attempts to create pfile under / u01/app/oracle/ directory can successfully create SQL > create pfile='/u01/app/oracle/inittips1.ora' from spfile='+DATA/tips/spfiletips.ora' File created.SQL > create pfile='/u01/app/oracle/inittips1.ora' from spfile;File created. According to the oracle official documentation, create a pfile with the following syntax Backing Up the Server Parameter FileOracle recommends that you regularly back up the server parameter file for recovery purposes. Do this using Oracle Enterprise Manager (as described in the Oracle Database 2 Day + Real Application Clusters Guide) or use the CREATE PFILE statement. There is only one line of code in the pfile under the $ORACLE_HOME/dbs directory in the For example:CREATE PFILE='?/dbs/initdbname.ora'FROM SPFILE='/dev/vx/rdsk/oracle_dg/dbspfile'RAC environment Specify the location of the database spfile [root@tip01 ~] # su-oracle [oracle@tip01 ~] $cd $ORACLE_HOME/ dbs [oracle @ tip01 dbs] $more inittips1.ora spfile=+DATA/TIPS/spfiletips.ora [oracle@tip01 dbs] $remember to use SQL > create pfile from spfile in the RAC environment so that the pfile content will be replaced and the spfile in the default ASM disk group will not be used when the database is rebooted

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.