Polycro Academy: Oracle Database Creation

Polycro Academy

Pages

Home
Linux
Privacy Policy
About
Disclaimer
Contact
Terms and Conditions
Oracle DBA Master Bundle
Need Oracle DBA Help?

Oracle Database Creation

MBRKAIS

D:\MBR-DBS-DATA\MBRKAIS\{DB_UNIQUE_NAME}

E:\MBR-DBS-DATA\MBRKAIS\FAST_RECOVERY_AREA\{DB_UNIQUE_NAME}

Click Advanced Configuration

D:\MBR-DBS-DATA\MBRKAIS

E:\MBR-DBS-DATA\MBRKAIS\FAST_RECOVERY_AREA\

Older Post Home

Oracle Database

1. Oracle Basics

Oracle Database Architecture Instance vs Database SGA and PGA Background Processes Oracle Memory Structure Control Files Redo Logs Undo

2. Installation & Configuration

Oracle Software Installation Oracle Database Creation Listener Configuration Oracle 19c Installation

3. Database Administration

Startup and Shutdown Instance Management SPFILE and PFILE Archive Log Mode

4. Tablespaces & Datafiles

Tablespace Basics Check Tablespace Usage TEMP Tablespace UNDO Tablespace Add Datafile Resize Datafile

5. Users & Security

Create Oracle User Alter User Drop User Grant Privileges Revoke Privileges Oracle Roles

6. RMAN Backup & Recovery

RMAN Basics RMAN Database Backup RMAN Archive Log Backup RMAN Restore RMAN Recovery RMAN Duplicate

7. Data Pump

EXPDP Export IMPDP Import Data Pump PARFILE Schema Export & Import

8. SQL & Database Queries

Check Database Size Check Table Size Check Schema Size Check Database Sessions Check Invalid Objects

9. Performance & Monitoring

Oracle Performance Session Monitoring Blocking Sessions Wait Events AWR Reports

10. Troubleshooting

Alert Log Trace Files ORA Errors Database Issues

11. Migration & Upgrade

Oracle Upgrade Oracle Migration Oracle 12c to 19c Oracle Database 19c Upgrade

12. High Availability & DR

Oracle Data Guard Standby Database RMAN Disaster Recovery

Linux

1. Linux Basics

Linux Basics Linux File System Linux Directories Users and Groups File Permissions File Ownership

2. Linux Commands

Basic Linux Commands ls Command cd Command cp Command mv Command rm Command cat Command grep Command find Command tail Command head Command

3. File & Directory Management

Create Files Create Directories Copy Files Move Files Delete Files chmod Command chown Command

4. Disk & Storage

Disk Management df Command du Command mount Command umount Command Linux LVM

5. Processes & Services

Process Management ps Command top Command kill Command systemctl Command Linux Services

6. Linux Networking

Linux Networking ip Command ping Command netstat Command ss Command SSH

7. Users & Security

Create Linux User Delete Linux User User Groups sudo SSH Security

8. System Administration

System Administration Hostname Configuration Date & Time Environment Variables Cron Jobs Crontab

9. Logs & Troubleshooting

Linux Log Management journalctl /var/log Linux Troubleshooting

Need Oracle DBA Help?

Oracle Database troubleshooting, SQL, performance & DBA assistance

Ask Me on Fiverr

Oracle DBA Master Bundle

A practical collection of commonly used Oracle DBA commands for quick reference.

© 2026 Polycro Academy. All rights reserved.

Theme images by chuwy. Powered by Blogger.