📋Steps in this guide1/8

SETUP ORACLE 18C DATABASE - STEP BY STEP DBACLASS

Recently Oracle has released its Oracle 18c in premise version.(previously it was only for oracle cloud). This release has lot of new features, which need to to be explored. So let’s start with Oracle binary installation and database creation. Download the Oracle software from oracle website.(DOWNLOAD LINK) Copy the software to your server and unzip […]

oracle clusteringintermediate

by OracleDba

13 views

Overview

Recently Oracle has released its Oracle 18c in premise version.(previously it was only for oracle cloud). This release has lot of new features, which need to to be explored. So let’s start with Oracle binary installation and database creation. - Download the Oracle software from oracle website .( DOWNLOAD LINK ) Copy the software to your server and unzip them. Note – Here our OS is Linux.

Section 2

2 . Start the runInstaller select option 1 , as we will install database binary and database creation at a time. 3. Select server class.

Section 3

4. Select Advanced Install 5. Select Enterprise Edition: 6. Mention oracle base

Section 4

7. Select configuration type(we did General purpose) 8. Specify DB and SID name: 10. Provide memory settings:

Section 5

11. Select character set details: 12. Specify database file location : 13. Specify Recovery Area settings:

Section 6

14: specify administrative passwords: 15. Select groups for different database-related roles 16. Review the Summary details:

Section 7

Chose Install and monitor, If it asks for script execution with root privilege, do the same and proceed further. Our oracle 18c database is ready. Well, not much difference from Oracle 12c installation and setup(Except the screen 1 ). MORE ON ORACLE 18C: Display sql_id of the sql, using set feedback in oracle 18C – New feature

Code/Command (click line numbers to comment):

select instance_name,VERSION,VERSION_FULL,status ,EDITION ,DATABASE_TYPE from v$instance;

INSTANCE_NAME    VERSION           VERSION_FULL      STATUS       EDITION DATABASE_TYPE
---------------- ----------------- ----------------- ------------ ------- ---------------
ORA18C           18.0.0.0.0        18.3.0.0.0        OPEN         EE      SINGLE

Section 8

Oraversion Utility In Oracle 18c – New Feature SET ROWLIMIT In Oracle 18C – New Feature

Comments (0)

Please to add comments

No comments yet. Be the first to comment!