Skip to content

Navigation Menu

Appearance settings

View all features
- BY COMPANY SIZE
  Enterprises
  Small and medium teams
  Startups
  Nonprofits
- BY USE CASE
  App Modernization
  DevSecOps
  DevOps
  CI/CD
  View all use cases
- BY INDUSTRY
  Healthcare
  Financial services
  Manufacturing
  Government
  View all industries
View all solutions
- EXPLORE BY TOPIC
  AI
  Software Development
  DevOps
  Security
  View all topics
- EXPLORE BY TYPE
  Customer stories
  Events & webinars
  Ebooks & reports
  Business insights
  GitHub Skills
- SUPPORT & SERVICES
  Documentation
  Customer support
  Community forum
  Trust center
  Partners
View all resources
- COMMUNITY
  GitHub SponsorsFund open source developers
- PROGRAMS
  Security Lab
  Maintainer Community
  GitHub Stars
  Archive Program
- REPOSITORIES
  Topics
  Trending
  Collections
- ENTERPRISE SOLUTIONS
  Enterprise platformAI-powered developer platform
- AVAILABLE ADD-ONS
  GitHub Advanced SecurityEnterprise-grade security features
  Copilot for BusinessEnterprise-grade AI features
  Premium SupportEnterprise-grade 24/7 support
Pricing

Appearance settings

You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session.

Dismiss alert

Agnivo102
Database_Architect

Repository navigation

Code
Issues
Pull requests
Actions
Projects
Wiki
Security and quality
Insights

19. Running some linux commands in new system

Jump to bottom

Agnivo102 edited this page Oct 14, 2026 · 1 revision

Wiki pages Pages 64

Home
1. Create Github Account
10.Linux(Find, Backup Script)
11. Database (Introduction, SQLPUS, Login, Objects, DQL (Select), Pipeline Operator)
12. SQL(where, and, or, in, sorting(order by), string comparison (like), functions(sum, max, min, upper, lower))
13. SQL Commands (between, functions (length, initcap, instr, rpad, lpad, concat, replace, round, trunc, nvl, to_date, to_char, extract, last_day, add_months), date formats, sysdate)
14. SQL (group by, multilevel query)
15. SQL(Join)
16. SQL, DDL(Create, Alter, Truncate , drop), DML (Insert, Delete, update), TCL (Commit, Rollback), Script in sql
17. SQL(Auto‐generated Column, Foriegn Key Constarint, View)
18. Create a Virtual Machine with Linux OS
19. Running some linux commands in new system
2. Cloud Server
20. Install oracle database into Linux Virtual Machine
21. Oracle Database Architecture (IMPORTANT)
22. (Important) Oracle Database Architecture (Starting process, parameter file, system views)
23. (Important) Oracle Database Architecture (PGA, SGA)
24. (Important) Oracle Database Architecture (Redolog File Architecture (Groups, Members), Instance Recovery (SMON), Creating a member group, Adding a member, Archive log)
25. (Important)Oracle Database Architecture (Oratab file, Control Files, creating a new control file)
26. (Important) Oracle Database Architecture (Data files, Tablespace, Database)
27. (Important) Oracle Database Architecture (Tablespace (Deleting, Changing status (offline, online)), Undo tablespace, Temp tablespace, Default Values (Undo tablespace, Temporary Tablespace), Undo management (Auto), Deleting a data file, Creating a big data file)
28. (Important) Oracle Database Architecture (Users (Show, Create, Delete), Privileges (types (System, Object), Show privileges, Granting a privilege, revoking a privilege ))
29. (Important) Oracle Database Architecture (Automated Script for Granting and Revoking Privilege, Role (Creating a role, Granting and Revoking privileges to it, Droping a role))
3. Cloud Server Login
30. Oracle Database (profile, script for granting every privilege for another user)
31. Oracle Database (Profile (Parameters, Creating a profile))
32. Networking
33. Install oracle database without the dbca graphical interface:
34. Listener (Creating, Starting), TNSName, Connecting to a database in another system using Listener and TNSName, Deleting a Database
35. Manual database creation without the dbca
36. Latch and Lock, Fixing a locked query due to incomplete transaction
37. Kernal, Data Dictionary, Data blocks types in Database buffer cache
38. Shutdown Types, Checkpoint, Alert Log
39. Backup(Hot Backup using RMAN tool (Full Database, Dtatabase with Archive log, Individual Datafile, Individual Tablespace ) Backup, Seeing all backups available (available, expired), Restoring Datafiles if it gets deleted (System, Sysaux, Undo, Users, User defined)), Deadlock Situation
4. Change Appearance in puTTY:‐
40. Incremental Backup (Differential, Cumulative), Restoring all the datafiles along with control file
41: Restoring database from backup in different locations in different machine:
42: Database Clone
43. Incomplete Recovery, Backup Script
44. Recap
45. Logical backup (Full Database, Schema, Table, Tablespace)
46. Logical backup(Single Query or in row basis), Logical Backup Restoration using ImpDp (schema, tablespace, full database (in a different server))
47. RMAN in Details:
48. Undo Management in Details:
49. Oracle Restore and Complete Recovery:
5. Introduction to Linux (pwd, mount point, cd,, ls, mkdir, touch)
50. Revision and some new things (high water mark, unused block skipping(image copy, backup set), restore validate, structure of an extent)
51. Multi Tenant Database
52. Oracle Full and Incremental Backups
53. Oracle Data pump Logical Migration
54. Interview (making spce for tablespace, invalid objects, how views can become invalid, drop vs delete vs trancate, user details stored in, scenarios(cold backup from rman, what to check when a user can;t connect to the database, what to check when a user can;t insert), start database without parameter files and using RMAN, user connection to database (PMON), PGA(sorting area funtionality), if temp tablespace gets missing)
55. Container Database, Pluggable Database practicals(show the PDBs, open PDB, close PDB, CDB name, change session to PDB, restricted mode, change name of a PDB, unplug a PDB, drrop a PDB, commn user, specific user of a PDB)
56. Introdcution to Production Database, Archive Log Monitoring(Getting more space by deleting previous unedded archive log files or increasing the FRA size), File System Monitoring(deleting audit trail files, trace files, trm files), Session independent jobs(how to run)
57. Hardware types(Disk tape), Backup Policy, Tablespace Monitoring, Process parameter monitoring, Transaction Monitoring(Oratop)
58. Database Version, Bugs, How oracle gives support, My oracle support, Patching Theory
59. Patching Practical
6. Linux (Absolute path, Relative path, Read mode, Write mode, Append mode, Timestamp modification, Redirecting output to a file, Copying, Moving, Renaming, Deleting, Word Count) Commands(cal options, , cat options, cp options, mv options, rm options, wc options)
60. Patching of 33859214 Logs:
61. Linux Filesystem(EXT4, XFS, BTRFS), Logical Volume Manager(LVM), Logical Volume, Increasing space inside a VM, Creating a new logical Volume, Increasing the existing LV Storage
7. Permission
8. Linux commands(hostname, uptime, ifconfig, grep, | , vi options (:x, :wq, esc : o, esc : O, esc : s, esc : %s)):
9. Linux Commands. ( su, sudo, ownership change, script, processes )
ASM
Patching Logs

Clone this wiki locally

Footer

© 2026 GitHub, Inc.

Footer navigation

Terms
Privacy
Security
Status
Community
Docs
Contact

You can’t perform that action at this time.