Listen Software Solution "How to" series 4: Creating a Database

Create | solve | data | database
Listen Software Solution "How to" series 4: Creating a Database

Plan database File location

Three group replay log files, each group has two member files

Create a file structure for a data file


Create a database by hand

1. Set unique instance name and database character set

2. Set operating system variables

(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 the current SID

Statement 2: Overwrite local environment variables


3. Prepare parameter file

Using Init.ora as a parameter file template

Db_name= database identifier (up to 8 characters)

control_files= three location of control files

Size of the Db_block_size= database block (cannot be modified after database creation)

4. Create a password file

5. Startup instance

STARTUP Nomount Pfile=initu16.ora

6. Create a database

Create manually 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 ystem01.dbf '
Size 30M
CHARACTER SET we8iso8859p1;

View database Status
Select Name,created,log_mode from V$database;

View Threads
Select Status, instance from V$thread;

viewing data files
Select name from V$datafile;

viewing log files
Select member from V$logfile;

viewing control files
Select name from V$controlfile;

Verify System Creation Status
Select file_name from Dba_data_files
where tablespace_name= ' SYSTEM ';

View Database Users
Select Username, created from dba_users;

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

Create a data dictionary
CATALOG. Sql

Generating objects used by Pl/sql
Catproc. Sql
8. Maintenance of replay log files

Determine the status of the archive
Select Log_mode from V$database;

Make sure that automatic archiving is 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;

Viewing log file information
SELECT * from V$log_file;