Skip to content

An Oracle DB frontend application built using NextJS and shadcn components to offer modern and interactive UI, it manages: users, roles, privileges, RMAN operations, security(TDE, VPD, Auditing), performance optimization and finally Oracle High Availability.

Notifications You must be signed in to change notification settings

zachary013/oracle-frontend

Repository files navigation

Oracle Manager Dashboard

A modern, feature-rich Oracle database management dashboard built with Next.js

Next.js Oracle License

📑 Table of Contents

🌟 Features

User Management

User Management Interface

Comprehensive user administration interface allowing you to:

  • Create, modify, and delete user accounts
  • Set and manage user quotas
  • Monitor account statuses and login attempts
  • Manage password policies and expiration

Role Management

Role Management Interface

Efficient role-based access control:

  • Create and manage roles
  • Assign roles to users
  • Define role hierarchies
  • Set role-specific privileges

Privilege Management

Privilege Management Interface

Fine-grained control over user and role privileges:

  • Grant and revoke system and object privileges
  • Manage administrative privileges

Security

Security Dashboard

Advanced security features including:

  • Virtual Private Database (VPD) configuration
  • Transparent Data Encryption (TDE) management
  • Comprehensive audit trail and reporting
  • Security policy enforcement

Backup & Recovery

Backup & Recovery Interface

Robust RMAN integration for:

  • Scheduling and managing backups
  • Monitoring backup status and history
  • Performing recovery operations
  • Configuring backup policies

Performance

Performance Dashboard

Real-time performance monitoring:

  • CPU, memory, and I/O utilization
  • Active session history
  • Wait event analysis
  • Tablespace usage and growth trends

Query Optimization

Query Optimization Interface

Advanced tools for query performance:

  • SQL tuning advisor
  • Execution plan analysis
  • Index recommendations
  • Statistics management

High Availability

High Availability Dashboard

Ensure maximum uptime with:

  • Data Guard configuration and monitoring
  • Failover management and testing
  • Load balancing visualization

🤝 Contributing

Contributions are welcome! Please feel free to submit a Pull Request. For major changes, please open an issue first to discuss what you would like to change.

Contributors

📝 License

This project is licensed under the MIT License - see the LICENSE file for details.

🙏 Acknowledgments

  • Oracle Database documentation and community
  • Next.js framework and community
  • All contributors who have helped with the project

📞 Support

If you have any questions or need support, please open an issue in the GitHub repository.

About

An Oracle DB frontend application built using NextJS and shadcn components to offer modern and interactive UI, it manages: users, roles, privileges, RMAN operations, security(TDE, VPD, Auditing), performance optimization and finally Oracle High Availability.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages