<> 獵頭職位:
安徽: 合肥,杭州,蘇州：誠聘java架構(gòu)師相關(guān)文章:
Oracle總結(jié)生成spfile[sid名].ora文件Oracle之DBA入門二推薦圈子:
JAVA 3T更多相關(guān)推薦Oracle Install
interactive: ./runInstaller
SQL*Plus
sqlplus /nolog
connect / as sysdba
startup
------------------
Review:
select * from dual;
Managing an Oracle Instance
Objectives:
Create and manage initialization parameter files
Start up and shut down an instance
Monitor and use diagnostic files
Initialization Parameter Files
connect / as sysdba
startup
Two types of parameters:
Explicit: Having an entry in the file
Implicit:
sqlplus /nolog
conn / as sysdba
startup
!
ps -ef | grep oracle
desc v$parameter;
col name format a20
col value format a30
-- 查參數(shù)
show paramter pga_ag;
env | grep ORACL
------------------------------------
Chapter 3
Managing an oracle Instance
SID : Site Identifier
create spfile from pfile;
Strings xx | more xx
Modify Parameters in SPFILE
alter system set parameter=value
<comment="text"> <deferred>
<scope="memery|spfile|both">
<sid='sid|*'>
SPFILE vs PFILE
SPFILE is better than PFILE!
Startup Command Behavior
Order of precedence:
spfileSID.ora
Default SPFILE -> spfile.ora
initSID.ora ( is a PFILE)
Default PFILE -> ???
startup pfile = $oracle_home/dbs/initDBA1.ora
Who can start the DB?
SYSDBA, SYSOPER
Starting Up a Database
shutdown -> nomount -> mount -> open
startup nomount;
alter database db01 mount;
alter database db01 open;
startup [formce] [restrict] [pfile=<file_name>]
open <read {only|write[recover]} | recover> <database_name>]
alter database db01 open read only;
sqlplus /nolog
conn / as sysdba
startup mount;
alter database nomount; // error
alter database open;
Restricted Model
startup restrict
alter system enable restricted session;
conn / as sysdba
create user boobooke identified by bbk;
grant connect, resource to boobooke;
sqlplus boobooke/bbk@oracle9ivm
quit
alter system enable restricted session;
sqlplus boobooke/bbk@oracle9ivm // error
desc v$session;
select saddr,sid,serial# from v$session;
select sid, serial#, username from v$session;
alter system kill session '15,6';
Read-Only Model
startup mount
alter database open read only;
shutdown imediate
startup mount;
alter database open read only;
sqlplus boobooke/bbk@oracle9ivm
Shutting Down the Database
Close a Database -> Unmount a Database -> shut down an instance
Shutdown mode:
abort, immediate, transactional, normal
----------------------
Diagnostic Files
alertSID.log
show parameter dump
