Listen Software Solution "How to" Series 4: Create a database

Listen Software Solution "How to" Series 4: Create a database

Planning Database File Location

Three sets of repel the log file, there are two member files each group

File structure for creating data files

Manually create a database

1. Set the unique instance name and database character set

2. Set the operating system variable

(UNIX) Oracle_Home Oracle_sid Oracle_Base ORA_NLS33 PATH

(NT) ORADIM80 -NEW -SID U16 -INTPWD password -startmode auto -pfile Oracle_Home / Database / Initu16.ora

You Must Decide The Sid, Password, And Create The Parameter File (Initu16.ora) SET ORACLE_SID = U16 SET LOCAL = 2: U16

Statement 1: Make U16 a current SID

Statement 2: Cover Local Environmental Variables

3. Prepare parameter files

Use init.ora as a parameter file template

DB_NAME = Database identifier (up to 8 characters)

Control_files = the location of three control files

DB_BLOCK_SIZE = Size of Database Block (You cannot modify after the database is created)

4. Create a password file

5. Start instance

Startup nomount pfile = initu16.ora

6. Create a database

Manually created from Server Manager

CREATE DATABASE "U16" MAXLOGFILES 6 MAXLOGMEMBERS 6 MAXDATAFILES 30 MAXLOGHISTORY 100 ARCHIVELOG LOGFILE GROUP 1 'E: /DATA/U16/GROUP1/log1a.rdo' SIZE 200K, 'E: /DATA/U16/GROUP1/log1b.rdo' SIZE 200K GROUP 2 'E: /DATA/U16/group2/log2a.rdo' size 200k, 'E: /DATA/U16/group2/log2b.rdo' size 200k group 3 'E: /DATA/U16/group3/log3a.rdo 'Size 200k,' E: /DATA/U16/group3/log3b.rdo 'size 200k datafile' E: /DATA/U16/DataFiles/system01.dbf 'size 30m Charac Ter SET WE8ISO8859P1; View Database State Select Name, Created, Log_Mode from V $ Database; View Thread Select Status, Instance from V $ Thread;

View Data File Select Name from V $ DataFile;

View log file Select Member from V $ logfile;

View Control Document Select Name from V $ ControlFile;

Test system creation status SELECT FILE_NAME FROM DBA_DATA_FILES where TABLESPACE_NAME = 'System';

View Database User Select Username, Created from DBA_USERS;

7. Run the script to generate a data dictionary and complete the previous creation steps

Create a data dictionary Catalog.sql Generate the object CATPROC.SQL8 used by PL / SQL. Maintenance Reversation Log File

Determine the archive State Select log_mode from v $ database;

Determine the automatic archive available Select Archiver from V $ Instance;

Add a new log file group ALTER DATABASE Add logfile ('c: /data/log3a.rdo', 'E: /DATA/Log3b.rdo') Size 200k;

View log file information SELECT * from V $ log_file;