ۼ : 06-02-21 17:36
۾ :
ȸ : 5,545
|
PFILE(Ķ ) initSID.ora
- Ŭ ϴµ ʼ Ķ͵ ǵǾ ְ, Ŭ ʼ Ķ Ǿ
- text ü ͷ
- PFILE Ķ ϱ ؼ ͺ̽ ϰ ٽ ؾ Ѵ.
- PFILE ġ
UNIX : $ORACLE_HOME/
Windows NT/2000 -> %ORACLE_HOME%\database
Ķ Ȯ ɾ
SQL>connect sys/manager as sysdba
SQL> show parmater Ķ
SQL> select name, value from v$parameter where upper(name) like %DB%;
SPFILE(Sever Parameter File)
- Oracle 9i ߰
- ALTER SYSTEM ͺ̽ ߿ Ķ ְ, ٽ ʾƵ Ķ ȴ.
- Binary
- Ʈ ġ PFILE
ALTER SYSTEM SET Ķ=氪 SCOPE=BOTH
scope=memory : ¿ Ķ 氪 ְ, ͺ̽ ٽ ۵Ǹ .
scope=spfile : 泻 spfile Ǹ ¿ ʴ´.
Static ĸ 쿡 ַ Ǹ static Ķʹ ͺ̽ ߿ ϴ ٽ ݿ ʴ´.
scope=both : ¿ Ķ 氪 ݿǰ, spfile ݿǸ, ͺ̽ ٽ Ŀ ݿ Ķ ȴ.
SQL>create pfile=\ϸ from spfile=\ϸ
SQL> CREATE PFILE='D:\oracle\ora92\database\INITORACLE.ORA'
FROM SPFILE='D:\oracle\ora92\database\SPFILEORACLE.ORA'
SQL>create spfile=\ϸ from pfile=\ϸ
SQL> CREATE SPFILE='D:\oracle\ora92\database\SPFILEORACLE.ORA'
FROM PFILE='D:\oracle\ora92\database\INITORACLE.ORA'
[ Խù ڴԿ 2006-02-28 09:41:36 ڷ - Solaris() ̵]
|
|