Wednesday, 11 November 2020

How TO Install DBS Out of ASM with Oracle Restart Enabled Single Instance


Note:
We will create hmdb database environment with recommended Path
 
$ vi  hmdb.env

# for oracle
 
TMP=/tmp;
TMPDIR=/tmp;
 
ORACLE_BASE=/u01/app/oracle;
ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1;
ORACLE_SID=hmdb;
ORACLE_HOSTNAME=oda12.oracle.com;
ORACLE_UNQNAME=hmdb;
TZ=Etc/GMT-5;
LD_LIBRARY_PATH=$ORACLE_PATH/lib:/lib:/usr/lib;
PATH=$ORACLE_HOME/bin:$PATH;
EDITOR=vi;
CLASS_PATH=$ORACLE_HOME/Jre;
export TMP TMPDIR ORACLE_BASE ORACLE_HOME ORACLE_SID ORACLE_HOSTNAME ORACLE_UNQNAME TZ PATH EDITOR LD_LIBRARY_PATH CLASS_PATH
 
$dbca

Select : Create Database

Click : Next

Global Database Name: hmdb

Storage Type: File System

Database File Location: {ORACLE_BASE}/oradata

Fast Recovery Area: :{ORACLE_BASE}/fast_recovery_area

Database Character Set: AL32UTF8

Administrative Password: Admin_6677

Confirm Password: Admin_6677

[Uncheck] Create As Container Database

Click: Next

Click: Finish



Click: Close

Note: 

Oracle Restart Enabled option automatically configure when you will create database through DBCA Utility.

 Completed.

Note: My Future Post Will Linked with this Post.

No comments:

Post a Comment