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

相关文章
|
5月前
|
关系型数据库 MySQL 数据安全/隐私保护
问题:ERROR 1819 (HY000) Your password does not satisfy the current policy requirements
问题:ERROR 1819 (HY000) Your password does not satisfy the current policy requirements
37 0
|
6月前
|
安全 关系型数据库 MySQL
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements问题处理
【5月更文挑战第8天】ERROR 1819 (HY000): Your password does not satisfy the current policy requirements问题处理
92 2
|
6月前
|
安全 关系型数据库 MySQL
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
41 2
|
关系型数据库 MySQL 数据安全/隐私保护
|
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...
1258 0