ORACLE基本技能方法.pptVIP

;主要内容;Oracle 数据库的基本结构;Oracle 服务器;Password file;Oracle 实例;Oracle Database;Oracle server;数据库空间==〉表空间（由一个或多个数据文件组成）?存放 数据对象（表、索引、函数、、、） ==〉segment==〉extent;服务器进程;服务器进程;服务器进程;后台进程;后台进程;ARCn: Archiver CJQ0: Coordinator Job Queue background process Dnnn: Dispatcher LCKn: RAC Lock Manager–Instance Locks LMDn: RAC DLM Monitor–Remote Locks LMON: RAC DLM Monitor–Global Locks LMS: RAC Global Cache Service Pnnn: Parallel Query Slaves QMNn: Advanced Queuing RECO: Recoverer Snnn: Shared Server;临时表空间中的空间管理;临时表空间中的空间管理;临时表空间中的空间管理;临时表空间中的空间管理;使用 SPFILE 作为初始化参数文件;初始化参数文件;;数据库的启动关闭;spfiledb01.ora;PFILEinitSID.ora;SPFILEspfileSID.ora;创建 SPFILE;创建 SPFILE;SPFILE 内容示例;检查当前是否使用了 SPFILE;修改 SPFILE 中的参数;STARTUP 命令;使用 Profile 加强数据库安全;使用 Profile 加强数据库安全;User;Password Management For greater control over database security, Oracle password management is controlled by database administrators with profiles. : Account locking: Enables automatic locking of an account when a user fails to log in to the system in the specified number of attempts Password aging and expiration: Enables the password to have a lifetime, after which it expires and must be changed Password history: Checks the new password to ensure that the password is not reused for a specified amount of time or a specified number of password changes Password complexity verification: Performs a complexity check on the password to verify that it is complex enough to provide protection against intruders who might try to break into the system by guessing the password;Set up password management by using profiles and assigning them to users. Lock, unlock, and expire accounts using the CREATE USER or ALTER USER command. Password limits are always enforced. To enable password management, run the utlpwdmg.sql script as the user SYS.;账号锁定 ; 参数值 ;Password 历史;Password 校验;用户定义的 Password 函数;Password 校验函数 VERIFY_FUNCTION;CREATE PROFILE grace_5 LIMIT FAILED_LOGIN_ATTEMPTS 3 PASSWORD_LOCK_TIME UNLIMITED PASSWORD_LIFE_T