pfile spfile静态和动态修改配置参数

来源：互联网发布：vmware mac镜像下载编辑：程序博客网时间：2024/04/29 10:18
由于时间的关系，就不一一说明啦，
SQL> conn /as sysdba已连接。SQL> shutdown immediate数据库已经关闭。已经卸载数据库。ORACLE 例程已经关闭。SQL> startup pfile='c:\init.ora'ORACLE 例程已经启动。Total System Global Area  612368384 bytes                                       Fixed Size                  1250428 bytes                                       Variable Size             167775108 bytes                                       Database Buffers          436207616 bytes                                       Redo Buffers                7135232 bytes                                       数据库装载完毕。数据库已经打开。SQL> show parameter open_cursorsNAME                                 TYPE        VALUE                          ------------------------------------ ----------- ------------------------------ open_cursors                         integer     300                            SQL> show parameter open_cursorsNAME                                 TYPE        VALUE                          ------------------------------------ ----------- ------------------------------ open_cursors                         integer     300                            SQL> shutdown immediate数据库已经关闭。已经卸载数据库。ORACLE 例程已经关闭。SQL> startup pfile='c:\init.ora'ORACLE 例程已经启动。Total System Global Area  612368384 bytes                                       Fixed Size                  1250428 bytes                                       Variable Size             167775108 bytes                                       Database Buffers          436207616 bytes                                       Redo Buffers                7135232 bytes                                       数据库装载完毕。数据库已经打开。SQL> show parameter open_cursorsNAME                                 TYPE        VALUE                          ------------------------------------ ----------- ------------------------------ open_cursors                         integer     200                            SQL> alter system set open_cursors=200  2  SQL> show parameter open_cursorsNAME                                 TYPE        VALUE                          ------------------------------------ ----------- ------------------------------ open_cursors                         integer     200                            SQL> shutdown数据库已经关闭。已经卸载数据库。ORACLE 例程已经关闭。SQL> startupORACLE 例程已经启动。Total System Global Area  612368384 bytes                                       Fixed Size                  1250428 bytes                                       Variable Size             201329540 bytes                                       Database Buffers          402653184 bytes                                       Redo Buffers                7135232 bytes                                       数据库装载完毕。数据库已经打开。SQL> show parameter open_cursorsNAME                                 TYPE        VALUE                          ------------------------------------ ----------- ------------------------------ open_cursors                         integer     300                            SQL> alter system set open_cursors=200 scope=spfile;系统已更改。SQL> show parameter open_cursorsNAME                                 TYPE        VALUE                          ------------------------------------ ----------- ------------------------------ open_cursors                         integer     300                            SQL> alter system set open_cursors=200 scope=both;系统已更改。SQL> show parameter open_cursorsNAME                                 TYPE        VALUE                          ------------------------------------ ----------- ------------------------------ open_cursors                         integer     200                            SQL> create spfile from pfile  2  SQL> shutdown immediate数据库已经关闭。已经卸载数据库。ORACLE 例程已经关闭。SQL> create spfile from pfile  2  /文件已创建。SQL> create pfile from spfile  2  /文件已创建。SQL> startupORACLE 例程已经启动。Total System Global Area  612368384 bytes                                       Fixed Size                  1250428 bytes                                       Variable Size             201329540 bytes                                       Database Buffers          402653184 bytes                                       Redo Buffers                7135232 bytes                                       数据库装载完毕。数据库已经打开。SQL> show parameter spfileNAME                                 TYPE        VALUE                          ------------------------------------ ----------- ------------------------------ spfile                               string      C:\ORACLE\PRODUCT\10.2.0\DB_1\                                                  DATABASE\SPFILEORCL.ORA        SQL> shutdown immediate数据库已经关闭。已经卸载数据库。ORACLE 例程已经关闭。SQL> startupORACLE 例程已经启动。Total System Global Area  612368384 bytes                                       Fixed Size                  1250428 bytes                                       Variable Size             201329540 bytes                                       Database Buffers          402653184 bytes                                       Redo Buffers                7135232 bytes                                       数据库装载完毕。数据库已经打开。SQL> show parameter spfileNAME                                 TYPE        VALUE                          ------------------------------------ ----------- ------------------------------ spfile                               string      C:\ORACLE\PRODUCT\10.2.0\DB_1\                                                  DBS\SPFILEORCL.ORA             SQL> Spool off
截图按顺序如下：