oracle创建只读的账号以pfile或者spfile启动时showparameterpfile的不同结果

普通启动:SQL> show parameter pfileNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------spfile                               string      /u01/app/oracle/product/11.2.0                                                 /dbhome_1/dbs/spfilesingle1.or a以pfile启动SQL> startup nomount pfile=/home/oracle/pfile.oraORACLE instance started.Total System Global Area  413372416 bytesFixed Size                  2253784 bytesVariable Size             314575912 bytesDatabase Buffers           92274688 bytesRedo oracle账号Buffers                4268032 bytesSQL> alter database mount;Database altered.SQL> alter database open;Database altered.SQL>    show parameter pfile;NAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------spfile                               stringSQL>that's the difference. 
此条目发表在oracle metalink账号分类目录,贴了标签。将固定链接加入收藏夹。