how to install 19c database

By ukmodak | June 6th 2022 12:23:03 PM | viewed 263 times

requirement: must install jdk(other wise database will not connect )

Create a folder d:\app\oracle_19c_home

download and extract zip on on the location: d:\app\oracle_19c_home

double click on setup.exe file

softwate automatically install in the following location:

oracle base:d:\app\
software location:d:\app\oracle_19c_home\oradata

1) select software only

2) select single instance

3) go to start->oracle_19c_home ->database configuration and assistant

4)


global database name(SID):orcl
administrator pass:#admin_111111
administrator cpass:#admin_111111
create a container database->plugable database name:commonpdbs

5)



password manager:
sys:
user:sys 
pass:sys

system:
user:system 
pass:system

6 go to start->oracle_19c_home ->configure and migration Net configuration assistent double click

7 next->next -> no-> finish

8 To check listener go to rum-> cmd->lsnrctl status

9 if not run go to rum-> cmd->lsnrctl start

Database installation complete. now run the following command to know verious info:

cmd>sqlplus /nolog  or  sqlplus

sql>conn sys/sys as sysdba

or 

cmd>sqlplus

sql>user:sys as sysdba

sql>pass:sys

sql>show pdbs;    // to show odbs

sql>alter session set container=commonpdbs;    // set plagable database

alter pluggable database open;  // select plagable database open

sql>select ora_database_name from dual;// to show odbs

sql>select tablespace_name from dba_tablespaces;   // to show table space name

sql>show parameter sga;    // to check memory use;

sql>select COMP_ID, STATUS from DBA_REGISTRY where COMP_ID='APEX';    // to check apex is install or not

10. set environment variable: to connect toad:

ORACLE_HOME:d:\app\oracle_19c_home
TNS_ADMIN:d:\app\oracle_19c_home\network\admin

update listener.ora in the location:d\app\...\admin\ as follows:

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.12.5)(PORT = 1521))
    )
  )

update sqlnet.ora in the location:d\app\...\admin\ as follows:


# This file is actually generated by netca. But if customers choose to 
# install "Software Only", this file wont exist and without the native 
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES = (NTS)

update tnsnames.ora in the location:d\app\...\admin\ as follows:


orcltns=
 (description=
   (address_list=
     (address = (protocol = TCP)(host =192.168.12.5)(port = 1521))
   )
 (connect_data =
   (service_name=orcl)
 )
)
bONEandALL
Visitor

Total : 18980

Today :9

Today Visit Country :

  • Germany
  • Singapore
  • United States
  • Russia