Скачать или смотреть How To Create Oracle Database 11g Manually || IN HINDI

How To Create Oracle Database 11g Manually || IN HINDI

1) Source the environment variables.

pwd
/u01/app/oracle/product/11.2.0/dbhome_1/dbs

set environment variables

export ORACLE_SID=TEST
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export PATH=$ORACLE_HOME/bin:$PATH

2) Create pfile for the new database which is to be created and create directory structure at OS in pfile.

cd $ORACLE_HOME/dbs
pwd
/u01/app/oracle/product/11.2.0/dbhome_1/dbs

$ cat initTEST.ora

*.audit_file_dest='/u01/app/oracle/admin/TEST/adump'
*.audit_trail='db'
*.compatible='11.2.0.4.0'
*.control_files='/u01/app/oracle/oradata/TEST/control01.ctl','/u01/app/oracle/oradata/TEST/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='TEST'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=TESTXDB)'
*.log_archive_dest_1='LOCATION=/u01/app/ valid_for=(all_logfiles,all_roles) db_unique_name=TEST'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_format='%t_%s_%r.arc'
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS'


3) Create SQL script for creating a database.

$cat create.sql
CREATE DATABASE TEST
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/u01/app/oracle/oradata/TEST/redo1.log' SIZE 500M,
GROUP 2 '/u01/app/oracle/oradata/TEST/redo2.log' SIZE 500M,
GROUP 3 '/u01/app/oracle/oradata/TEST/redo3.log' SIZE 500M
DATAFILE
'/u01/app/oracle/oradata/TEST/system.dbf' size 100m,
'/u01/app/oracle/oradata/TEST/usr04.dbf' size 10m
sysaux datafile '/u01/app/oracle/oradata/TEST/sysaux.dbf' size 100m
undo tablespace undotbs
datafile '/u01/app/oracle/oradata/TEST/undo.dbf' size 50m
CHARACTER SET US7ASCII
;

4) Start the database in nomount stage and run the script.

$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Fri Dec 22 12:54:30 2017

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to an idle instance.

startup nomount
ORACLE instance started.

Total System Global Area 221331456 bytes
Fixed Size 2251856 bytes
Variable Size 163578800 bytes
Database Buffers 50331648 bytes
Redo Buffers 5169152 bytes


@create.sql

Database created.


5) Run catalog.sql and catproc.sql scripts to create dictionary views.

&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&

Please find below playlist link for creation of oracle databases on Linux on VirtualBox

   • Database Creation  

Please find below the playlist link for the installation of Oracle Database 11g Release 2 on Linux.

   • Database software installation  

#oracle11gr2databasecreationonlinuxstepbystep
#howtoinstalloracle11gonoraclelinux
#howtoinstalloracle11gonlinuxwithGUI
#installoracle11gonLinuxVirtualbox
#howtoinstalloracle11gonLinuxserver
#howtoinstalloracle11gonlinuxstepbystep
#oracle11gr2installationonlinuxstepbystep
#howtocreateoracledatabase11g
#howtosetuporacledatabase11g