Changing an Init.ora Parameter

简介:
To change an init.ora parameter, follow these steps.
  1. Open the file called init<database_name>.ora. For example, if the database is called oraprod, then the file would be called initoraprod.ora. The file can be in a variety of places, but almost always somewhere in a subdirectory of the Oracle Installation directory on the server (also known as the ORACLE_HOME).
  2. Find the parameter that you wish to change. The parameter may not be in the file. If not, the default value is being used by Oracle. Add the parameter if it is not in the file and needs to be a non-default value.
  3. Comment out the line containing the current setting (in case the change needs to be undone). A line will be commented out (ignored by Oracle) if a pound sign (#) is placed at the beginning of the line
  4. Add a new line with the same parameter with the new setting.
 

Example

# Doubled db_cache_size from 30000000 on 5/4/2003, change made by Jeff Jones. # db_cache_size = 30000000 db_cache_size=60000000



本文转自maclean_007 51CTO博客,原文链接:http://blog.51cto.com/maclean/1277871

相关文章
|
6月前
|
SQL Oracle 关系型数据库
Oracle数据库启动时:ORA-00119: invalid specification for system parameter LOCAL_LISTENER;
Oracle数据库启动时:ORA-00119: invalid specification for system parameter LOCAL_LISTENER;
|
SQL 监控 数据库
ORA-32004: obsolete and/or deprecated parameter(s) specified
如果在启动数据库时遇到ORA-32004: obsolete and/or deprecated parameter(s) specified 错误,这个是因为数据库里面设置了过时或不推荐使用的参数,如下描述所示: SQL> ho oerr ora 3200432004, 00000, "obsol...
1263 0
|
数据安全/隐私保护
Give root password for maintenance(or type control -D to continue)
2017-09-30 18:12:08 1:错误如图,本来开机准备用一下虚拟机,就出现一个这,为啥记录一下呢,因为网上好多不是很靠谱。 原因可能是之前关闭虚拟机的时候不小心出现异常了: 2:解决办法:   个人根据自己的磁盘分区情况,进行修复即可; 解决方法,在鼠标停留的地方输入...
1837 0