How TO Install DBS Out of ASM with
Oracle Restart Enabled Single Instance
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
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