Install oracle 21c on Oracle Linux Step by Step


// Set the network config type as bridge in your vm machine


//select network adapter

//select allow all 


//Login as root


//ping your dns response


# ping 8.8.8.8


// check your ip address which you configure in enp0s3 card when linux setup


// in my case I use 192.168.0.114 as manual ip with gateway 192.168.0.1 and dns 8.8.8.8


# ip address show


// Check your redhat version


# cat  /etc/redhat-release


//check your hostname


# uname -a


// check disk space


# df -h


// Install oracle 21c preinstallation package (Below command will help in oracle user creation and package installation)


# yum install -y oracle-database-preinstall-21c


# id oracle


// Set Oracle password: 


# passwd oracle


// Create required directories for oracle 21c software and datafiles and archivelog


# mkdir -p /u01/app/oracle/product/21c/db_1/


# mkdir -p /u01/app/oracle/oradata/


# mkdir -p /u01/app/oracle/FRA/


# chown -R oracle:oinstall /u01/


# chmod -R 775 /u01/


// Set .bash_profile i.e. environment variables.


$ su - oracle

oracle passwd


$ vi .bash_profile


// Add the following line in .bash_profile


export TMP=/tmp

export TMPDIR=$TMP

export ORACLE_BASE=/u01/app/oracle

export DB_HOME=$ORACLE_BASE/product/21c/db_1

export ORACLE_HOME=$DB_HOME

export ORACLE_SID=orcl

export ORACLE_TERM=xterm

export BASE_PATH=/usr/sbin:$PATH

export PATH=$ORACLE_HOME/bin:$BASE_PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib


// Reload .bash_profile


$ . .bash_profile


// Go to oracle home directory


$ cd $ORACLE_HOME


//Check your present working directory


$ pwd


// open another terminal as root


// Add below entries in the end of file in  /etc/security/limits.conf file which will define limits


# vi /etc/security/limits.conf


oracle soft nofile 1024


oracle hard nofile 65536


oracle soft nproc 16384


oracle hard nproc 16384


oracle soft stack 10240


oracle hard stack 32768


oracle hard memlock 134217728


oracle soft memlock 134217728


// Disable firewall on server from root user


# systemctl stop firewalld


# systemctl disable firewalld


// see the disk partition again


#df -h


// Now go to host windows down load winscp from internet


// Install winscp


// Open winscp


Click on new session


Select session=scp

Host name=192.168.0.114 (your machine ip which configuared in your Ethernet card enp0s3)

Port=1522


Username=oracle


Passwd=oracle


// Click login button


// it will connect to your host to server oracle user panel


// after connect create a directory name  sf_21c_soft with all permission graphically


// then drag n drop LINUX.X64_213000_db_home.zip from host drive to /home/oracle/sf_21c_soft in server


// now open a new terminal


// su -


root passwd


#  cd /home/oracle/sf_21c_soft


#  ls -lrt


# cp LINUX.X64_213000_db_home.zip /u01/app/oracle/product/21c/db_1/


// wait until copy complete after complete give permission


# chown -R oracle:oinstall /u01/


# chmod -R 775 /u01/


// After copy complete 


// download and run putty


// open a putty ssh terminal via your server ip in my case 192.168.0.114 with un:oracle pw:oracle


// after login successful with putty in oracle user


$ cd $ORACLE_HOME


$ ls -lrt


$ unzip LINUX.X64_213000_db_home.zip


// after unzip login to linux server as oracle user 


open a terminal


$ cd $ORACLE_HOME


$ ls -lrt


// set DISPLAY


$  DISPLAY=:0.0; 


$  export DISPLAY


$ ./runInstaller


Complete the step of installation


select single instance database

server class 


skip 


netca 


and dbca script

 

finish


Oracle Enterprise Manager Database Express URL: https://rodb:5500/em


Create listener using netca utility 


open a terminal


$ netca


Create database using dbca utility


open a terminal


$ dbca


create database


select automatic configuaration


finish


========================check database installation perfection================

open a new terminal


$ lsnrctl status (if running then dont nedd to start or stop)


$ lsnrctl stop (if running then stop if needed )


$ lsnrctl start(if not running then startif needed)


minimise the terminal


open a another terminal 


SQL > 

sqlplus /nolog


conn sys as sysdba 


SQL > show con_name;


SQL > show pdbs;


SQL > alter session set container=orclpdb


SQL > alter pluggable database orclpdb open;


====================create schema user using pluggable db====================


SQL > 

create user dms identified by dms default tablespace USERS quota unlimited on USERS ;


SQL > grant connect, create session, imp_full_database to pmis_local ;


All are set now

Happy database operation...

enjoy !!

Comments

Post a Comment

Popular posts from this blog

Image
  Jasper Server and studio complete installation step by step   Step -1   Download 1. jaspersoft studio 2. jasperserver from official TIBCO website   Step-2   Install jaspersoft studio Install jasperserver   Step 3   Jasper Report Integration   First Check your System Environment Variable (For Windows same as linux)   Right clock on: This PC/My Computer icon ->Properties ->Advance System ->Advance ->Environment Variable ->System Variable ->select Path ->edit ->new ->C:\Windows\SysWOW64 ->move up under C:\Windows\System32 position ->apply ok ->ok   Install JDK latest version (if not installed)   again add jre path to environment variable   Right clock on: This PC/My Computer icon ->Properties ->Advance System ->Advance ->Environment Variable ->System Variable ->select Path ->edit -...
Read more

Oracle apex login page beautification Tutorial

Image
  Oracle apex login page beautification Tutorial Script: 1. First create or modify your login page 2. Change login page template as go to page level property -> Appearance -> Template Options -> set template page layout as split 3. Download a background image from freepik.com 4. upload this background image in your apex application shared folder: 4. Add the below javascript code to your login page -> page level -> inline -> paste the code Javascript code: .t-PageBody--login form#wwvFlowForm{ background:url( #WORKSPACE_FILES #Capture.jpg); background-repeat:no-repeat; background-Size:cover; } Span.t-Login-logo{ background-image : url( #WORKSPACE_FILES #logo_learn_oracle.png); background-Size :cover; width :75px; height :75px; } .t-Login-region{ position:relative; width:400px; --height:300px; margin:0Auto; background:rgba(165, 145, 145, 0.3); padding:20px 22px; border:1px solid; border-top-color: #fbce4a ; border-l...
Read more
  Manual Scrollable Master Detail Page in Oracle Apex part-1 Step -1 create a page classic Report Page (All Employees) using this sql query : select aa.ID, aa.FAST_NAME||' '||aa.MNAME||' '||aa.LNAME "Full Name", aa.FATHER_NAME, aa.MOTHER_NAME, aa.JOINING_DATE, aa.NID, AA.TIN, aa.EMAIL, aa.PASSPORT, aa.MOBILE, (SELECT CASE WHEN NVL (DBMS_LOB.getlength (EMPLOYEE_IMAGE), 0) = 0 THEN NULL ELSE '<img width="80px" src="' || APEX_UTIL. get_blob_file_src ('P16_EMPLOYEE_IMAGE', ID) || '" />' END FROM EMPLOYEE_BASIC where id=aa.id) AS PICTURE from EMPLOYEE_BASIC aa Step-3 add a button called CREATE as level (New Employee) In Button Behaviour property redirect this page to form page (Page 23). Step-4 In form Page: *in ...
Read more