OracleDBABook9iCaseforJD.doc

Requirements of Oracle DBA worldwide USA AUS Install Oracle 10g Versions of Oracle Oracle Release Date Characteristic Oracle 1 1979 Assemble Language Oracle 2 1980 ? Oracle 3 1981 C Language Oracle 4 1984 Oracle 5 1986 Oracle 6 1988 Oracle 7 1993 Oracle 8 1997 Oracle 8i 1999 Java Language Oracle 9i 2001 Memory 512M Oracle 10g 2004 Memory 1G Oracle 11g 2007 Memory 2G / Orient Cluster and Distributed System Installation on Window XP 1、Uninstall (if necessary) (1) Stop all the Oracle services (2) Use Oracle Universal Install to remove installed Oracle products (3) Remove the items from registry and Oracle directory Use regedit to backup registry Remove nodes: HKEY_CLASSES_ROOT\ORA*,ORCL* Remove node: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE Remove nodes: HKEY_LOCAL_MACHINE\SYSTEM\CURRENTCONTROLSET\SERVICES\ORACLE* Restart Computer or Log off Remove Oracle main directory 2、Install Close all firewall and anti-virus software Copy all the setup files to the disk root directory such as C:\, approximately 650M. Run setup.exe || 2*45 Users、Resources、Rights、Role Users Definition: Users VS Scheme SQL SELECT USERNAME, PASSWORD from DBA_USERS; Management: SQL Connect system/system; SQL CREATE USER Programmer IDENTIFIED BY Suffering default TABLESPACE USERS; SQL Grant connect, resource to programmer; SQL Connect programmer/suffering; SQL Create table TEST(a varchar2(20)); SQL Connect system/system; SQL Alter user Programmer account lock; SQL Alter user Programmer account unlock; SQL DROP USER Programmer CASCADE; || 2*45 Resources Definition: PROFILE Password and Resource limit Management: SQL Create Profile … Rights System Rights and Objects Rights System Rights Definition Access to the system resource such as Create Session, Create/Drop user System Rights Management SQLGRANT CREATE SESSION TO Programmer; SQLREVOKE CREATE SESSION FROM Programmer; Objects Rights Definition A privilege to operate an object such as select on dept; Objects