点击(此处)折叠或打开
-
vi initorcl.ora
-
-
spfile='/u01/app/oracle/10g/dbs/spfileorcl.ora'
- log_archive_dest='/u01/app/oracle/archivelog1/' #这行修改了spfile中出错的参数，因为这里的参数会优先于spfile被读取
点击(此处)折叠或打开
- startup pfile='$ORACLE_HOME/dbs/initorcl.ora'
- alter system set log_archive_dest='/u01/app/oracle/archivelog1/' scope=spfile;
- shutdown immediate
详见：http://blog.csdn.net/leshami/article/details/5784736
这里还介绍了如何阅读spfile文件
点击(此处)折叠或打开
- strings spfileorcl.ora