Oracle spfile example
来源:互联网 发布:歌曲修改软件 编辑:程序博客网 时间:2024/05/16 05:04
导读:
Oracle Tips by Burleson Consulting
Don Burleson
The following is from the bestselling book Oracle 10gGrid &Real Application Clusters- Oracle10gGrid Computing with RAC. You can order it directly and save 30% here:
The Oracle spfile is a binary representation of the text0based init.ora file. By default, a new Oracle9i database will be working on a pfile, so the spfile must be created from the pfile at the SQL prompt.
The spfile is created using the CREATE SPFILE statement; this requires connecting as SYSDBA.
Connect system/manager as sysdba;
CREATE SPFILE FROM PFILE;
This command creates an spfile in a non-default location ($ORACLE_HOME/database). However, you can fully-qualigfy the path name is the 揷reate spfile statement:
CREATE SPFILE='/u01/admin/prod/pfile/file_mydb.ora'
FROM
PFILE=/u01/admin/prod/pfile/initprod.ora';
Warning - After an spfile is created, when you bounce the database you may encounter an error. To get around this, you have to reconnect as SYSDBA and use the STARTUP command.
The addition of the spfile has changed the search path for the Oracle startup deck. Oracle9i now uses the following path:
Search for the spfile$ORACLE_SID.ora file in the default location,
Look for the spfile.ora; and
Search for the pfile by name init$ORACLE_SID.ora.
Specifying SCOPE in parameters
Once you have an spfile, you can change any initialization parameter with the 揳lter system command. However, there is an important SCOPE parameter that you need to understand.
The SCOPE parameter has three values MEMORY, SPFILE and BOTH. Let抯 look at an example of each:
Alter system set db_2k_cache_size=100m SCOPE=SPFILE;
If you want to make a change to a parameter in the spfile without affecting the current instance, you can do so using the SCOPE=SPFILE option of the ALTER SYSTEM statement. This is useful when you want to make a change starting from the next startup and not for the current instance.
Alter system set db_2k_cache_size=100m SCOPE=MEMORY;
In the example above, the SCOPE=MEMORY tells Oracle9i to make the change for the life of the instance, and to change it back to the default value the next time the database is bounced.
Alter system set db_2k_cache_size=100m SCOPE=BOTH;
When you specify SCOPE=BOTH, the change will be made immediately, and Oracle will also make the change permanent, even after the database is bounced.
Need Oracle training?
Get Oracle training from a practicing Oracle expert
Get custom training designed to fit your needs
Conveniently offered at your workplace, anywhere in the USA
BC Oracle training offers some of the USA's most respected Oracle experts and authors. Why spend thousands on cookie cutter Oracle classes when you can have the personalized attention of a real Oracle guru? Just call now:
本文转自
http://www.dba-oracle.com/tips_oracle_spfile_example.htm
Oracle Tips by Burleson Consulting
Don Burleson
The following is from the bestselling book Oracle 10gGrid &Real Application Clusters- Oracle10gGrid Computing with RAC. You can order it directly and save 30% here:
The Oracle spfile is a binary representation of the text0based init.ora file. By default, a new Oracle9i database will be working on a pfile, so the spfile must be created from the pfile at the SQL prompt.
The spfile is created using the CREATE SPFILE statement; this requires connecting as SYSDBA.
Connect system/manager as sysdba;
CREATE SPFILE FROM PFILE;
This command creates an spfile in a non-default location ($ORACLE_HOME/database). However, you can fully-qualigfy the path name is the 揷reate spfile statement:
CREATE SPFILE='/u01/admin/prod/pfile/file_mydb.ora'
FROM
PFILE=/u01/admin/prod/pfile/initprod.ora';
Warning - After an spfile is created, when you bounce the database you may encounter an error. To get around this, you have to reconnect as SYSDBA and use the STARTUP command.
The addition of the spfile has changed the search path for the Oracle startup deck. Oracle9i now uses the following path:
Search for the spfile$ORACLE_SID.ora file in the default location,
Look for the spfile.ora; and
Search for the pfile by name init$ORACLE_SID.ora.
Specifying SCOPE in parameters
Once you have an spfile, you can change any initialization parameter with the 揳lter system command. However, there is an important SCOPE parameter that you need to understand.
The SCOPE parameter has three values MEMORY, SPFILE and BOTH. Let抯 look at an example of each:
Alter system set db_2k_cache_size=100m SCOPE=SPFILE;
If you want to make a change to a parameter in the spfile without affecting the current instance, you can do so using the SCOPE=SPFILE option of the ALTER SYSTEM statement. This is useful when you want to make a change starting from the next startup and not for the current instance.
Alter system set db_2k_cache_size=100m SCOPE=MEMORY;
In the example above, the SCOPE=MEMORY tells Oracle9i to make the change for the life of the instance, and to change it back to the default value the next time the database is bounced.
Alter system set db_2k_cache_size=100m SCOPE=BOTH;
When you specify SCOPE=BOTH, the change will be made immediately, and Oracle will also make the change permanent, even after the database is bounced.
Need Oracle training?
Get Oracle training from a practicing Oracle expert
Get custom training designed to fit your needs
Conveniently offered at your workplace, anywhere in the USA
BC Oracle training offers some of the USA's most respected Oracle experts and authors. Why spend thousands on cookie cutter Oracle classes when you can have the personalized attention of a real Oracle guru? Just call now:
本文转自
http://www.dba-oracle.com/tips_oracle_spfile_example.htm
- Oracle spfile example
- Oracle spfile example
- Oracle 9i spfile
- Oracle学习,spfile
- ORACLE spfile and pfile
- Oracle spfile与pfile
- Oracle Spfile 與Pfile..
- oracle spfile pfile 使用
- oracle pfile和spfile
- oracle spfile pfile小结
- oracle spfile 和 pfile
- ORACLE PILE 与 SPFILE
- oracle数据库spfile损毁
- pfile and spfile in oracle
- oracle spfile&pfile 的作用
- oracle spfile和pfile小结
- Oracle服务器参数文件-----spfile
- [Oracle] pfile和spfile总结
- Google解密携手宏达电:确保Android一炮打响
- ASP.net组件编程中的两种事件编写方法
- 《福布斯》:微软的印度未来
- WMS(JBuilder+oracle)系统移植问题及解决过程
- Postcard:简单的音乐贺卡制作
- Oracle spfile example
- 百度声明:从未答应屏蔽三鹿负面
- 抚顺小吃之旅-http://bbs.fushun.cc(转自抚顺论坛)
- 本周Web2.0小工具推荐[2008-09-13]
- 汇编指令: 根据www.olanguage.org提供的汇编资料整理. 转自万一
- 精通ASP.NET中弹出窗口技术
- PHP WAMP创建虚拟目录
- Linux内核模块编程
- ASP.NET操作IIS中的虚拟目录