Introduction Database Management Performing Routine DBA Procedures Preparing a Database for Production Performing Backup and Recovery Installation and Configuration Installing Oracle on Unix Installing Oracle on Windows NT Installing Oracle on VMS Creating a Parallel Oracle Database Network Management Confirming Network Availability Confirming Net8 Connectivity Verifying Net8 Name Resolution Configuring Net8 Clients Configuring Net8 Clients to Use LDAP Configuring Net8 Clients to Use Oracle Names Configuring Net8 on the Server Configuring Multi-Threaded Server Tracing Client Connections Tra...
Cài Oracle cần như sau:
1. Tạo 2 Groups: đặc tên là oinstall và dba
2. Tạo 1 User account tên là: oracle
(note: Đúng ra đặt là Tí Tèo gì củng được, nhưng conventional, thấy thiên hạ cài Oracle hay đặt là vậy.)
Login as root, run: �
# groupadd oinstall
# groupadd dba
# useradd -m -g oinstall -G dba oracle
Tạo password cho user: oracle
# passwd oracle
Changing password for user oracle.
New UNIX password:
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
Before a database is created, the UNIX environment must be configured and the Oracle9i server must have already been installed.
Four environment variables must be set: ORACLE_HOME, ORACLE_SID, PATH, LD_LIBRARY_PATH.
ORACLE_HOME is the full path to the top directory in which the Oracle9i Server is installed. The directory for ORACLE_HOME should be supplied by the person who installed the server, usually the UNIX administrator or the DBA.
ORACLE_SID is a user-definable name assigned to an instance of a database.
Oracle Applications DBA Field Guide provides scripts, notes, guidelines, and references to guide you safely through the crucial day-to-day administration tasks that fall within your jurisdiction. This includes configuring, monitoring, performance tuning, troubleshooting, and patching. This book contains tips, techniques, and guidance for administering the highly complex Oracle E-Business Suite running Oracle9i or Oracle10g on UNIX or Linux servers—all in an easy-to-read and quick-to-navigate format....