Oracle Database 18.3.0 Installation On Premises Windows

Description:-

In this article we are going to see On-Premise Oracle Database 18c (18.3) for Windows server 2012 R2  installation.

Click here to download Oracle 18c installation software.

Step 1:- Click create and configure a single instance database

Step 2:- Click Server class

Step 3:- Click the type of installation

Step 4:- Select the Database edition you want to install

Step 5:- Use a virtual account 

Step 6:- Provide the base directory.

Step 7:- select the database type as General Purpose

Step 8:- Provide Global database name and system identifier.

Step 9:- Check Memory and Character sets.

Step 10:- Select the storage location for datafiles

Step 11:- If you need EM control,specify the below details otherwise uncheck it. 

Step 12:- If you need database is in archivelog mode,Enable Recovery option.

Step 13:- Provide passwords for SYS and system user

Step 14:- Check the Summary window and Click Install

Step 15:- Finally click the close button

Step 16:- Check the database name and status.

 

Catch Me On:- Hariprasath Rajaram

LinkedIn:                  https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:                 https://www.facebook.com/HariPrasathdba
Facebook Group:   https://www.facebook.com/groups/894402327369506/
Facebook Page:      https://www.facebook.com/dbahariprasath/?
Twitter:                     https://twitter.com/hariprasathdba

Oracle 18c Datapump-ADD_FILE Parameter

ADD_FILE :

ADD_FILE  is used to add a new additional dump file to the currently running job.

[oracle@18c ~]$ expdp hari/oracle directory=test_dir dumpfile=hari_data.dmp logfile=hari_data.log schemas=hari filesize=500k

Export: Release 18.0.0.0.0 - Production on Wed Aug 22 00:05:36 2018
Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Starting "HARI"."SYS_EXPORT_SCHEMA_04": hari/******** directory=test_dir dumpfile=hari_data.dmp logfile=hari_data.log schemas=hari filesize=500k
^C
Export> ADD_FILE=hari_data1.dmp

Export> STATUS

Job: SYS_EXPORT_SCHEMA_04
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Job heartbeat: 10
Dump File: /u01/empdata/hari_data.dmp
size: 512,000
bytes written: 49,152
Dump File: /u01/empdata/hari_data1.dmp
size: 512,000
bytes written: 4,096

Worker 1 Status:
Instance ID: 1
Instance name: prod18c
Host name: 18c.localdomain.com
Object start time: Wednesday, 22 August, 2018 0:05:44
Object status at: Wednesday, 22 August, 2018 0:05:46
Process Name: DW00
State: EXECUTING

 

Catch Me On:- Hariprasath Rajaram

Telegram:https://t.me/joinchat/I_f4DhGF_Zifr9YZvvMkRg
LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter: https://twitter.com/hariprasathdba