spfile管理问题和启动

来源：互联网发布：淘宝上可靠的种子店编辑：程序博客网时间：2024/05/18 21:09

1.创建spfile

creatre spfile from pfile

2.修改spfile

alter system set parameter = value <comment='text'><deferred><scope=memory|spfile|both><sid='sid|*'>

3.创建pfile由spfile

create pfile from spfile

4.oracle启动顺序

spfileSIDefault spfile(spfile.ora->initSID.ora

指定pfile启动：pfile=$oracle_home/dbs/initDBA1.ora

5.oracle启动状态

startup nomount

alter database mount

alter database open

6.alertSID.log存放路径

SQL> show parameter background_dump_dest;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
background_dump_dest                 string      E:/ORACLE/PRODUCT/10.2.0/ADMIN
                                                 /ORCL/BDUMP
SQL>

7.user trace files路径

SQL> show parameter max_dump_file_size;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
max_dump_file_size string UNLIMITED
SQL> show parameter user_dump_dest;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
user_dump_dest                       string      E:/ORACLE/PRODUCT/10.2.0/ADMIN
                                                 /ORCL/UDUMP
SQL>

SQL> show parameter sql_trace;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sql_trace boolean FALSE

SQL> alter session set sql_trace = true;

会话已更改。