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) ) )
Total : 27273
Today :9
Today Visit Country :