# oratk_web

**Repository Path**: lweik/oratk_web

## Basic Information

- **Project Name**: oratk_web
- **Description**: oratk 工具
针对数据库高效运维的实用性工具
- **Primary Language**: Python
- **License**: GPL-3.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 11
- **Forks**: 5
- **Created**: 2020-11-30
- **Last Updated**: 2025-08-20

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# oratk_web

#### 介绍
oratk 工具
针对数据库高效运维的实用性工具

#### 软件架构
python django 框架

#### 安装教程

##### 1、下载镜像(地址:阿里云，大小:3.6G)

``
   docker pull crpi-vxawflg2o3sg9l7z.cn-hangzhou.personal.cr.aliyuncs.com/liwk_oratk/oratk:v1
   ``
   
##### 2、启动容器

``
         docker run -d -it  -p 8888:8000  -p 8886:3306 --name='oratk'  [镜像ID]   /bin/bash
   ``
   
##### 3、访问
``
   http://服务器ip:8888
   ``
#### 账号密码信息
``
网站登入:  root/1111aaaa
``

``
数据库:    root/suksi0AIhs8y   django_oratk/django_oratk(项目)
``

``
ora脚本上传docker:  
        127.0.0.1(ip)  22(port) root/suksi0AIhs8y(用户/密码）
``


#### 功能说明
##### 1、不好用功能
``
"ora自定义查询" 只是一个简易的查询框,还没有丰富内容，有时间会整改
``

``
"监控配置"、"监控记录" docker化后不能用，有时间会整改
``

##### 2、ora 脚本
``
ora 脚本是由业界知名 oracle优化专家 <老虎刘> 编写的oracle运维脚本,目前具有 168个命令参数
``


``
ora 脚本有专利保护,该项目不含 ora 脚本,如果需要使用 ora 脚本请正规渠道获得
``


#### 使用图例
项目主要图
![Image text](readme_png/overview.jpg)
![Image text](readme_png/user_info.jpg)
![Image text](readme_png/inst_info.jpg)
![Image text](readme_png/host.jpg)
![Image text](readme_png/appgmr.jpg)
![Image text](readme_png/ora_custom_query.png)
![Image text](readme_png/ora_query1.jpg)
![Image text](readme_png/ora_query2.jpg)
![Image text](readme_png/ora_query3.jpg)
![Image text](readme_png/query_point.jpg)
![Image text](readme_png/switch_redo_point_1.jpg)
![Image text](readme_png/switch_redo_point_2.jpg)
![Image text](readme_png/switch_redo_point_3.jpg)
![Image text](readme_png/oratk_tool_query_1.jpg)
![Image text](readme_png/oratk_tool_query_2.jpg)
![Image text](readme_png/oratk_tool_shell.jpg)
![Image text](readme_png/oramgr.jpg)
![Image text](readme_png/session_1.jpg)
![Image text](readme_png/session_2.jpg)
![Image text](readme_png/tabspace_1.jpg)
![Image text](readme_png/tabspace_2.jpg)
![Image text](readme_png/plan_1.jpg)
![Image text](readme_png/plan_2.jpg)
![Image text](readme_png/logmnr_1.jpg)
![Image text](readme_png/logmnr_2.jpg)
![Image text](readme_png/logmnr_3.jpg)
![Image text](readme_png/awr_ash_11.jpg)
![Image text](readme_png/awr_ash_12.jpg)
![Image text](readme_png/awr_ash_13.jpg)
![Image text](readme_png/archery_1.jpg)
![Image text](readme_png/archery_2.jpg)
![Image text](readme_png/sqlldr.jpg)
![Image text](readme_png/check_1.jpg)
![Image text](readme_png/check_2.jpg)
**awr样式巡检报告**
![Image text](readme_png/report_new.jpg)
![Image text](readme_png/cron_1.jpg)
![Image text](readme_png/cron_2.jpg)
![Image text](readme_png/cron_3.jpg)
![Image text](readme_png/cron_4.jpg)
![Image text](readme_png/exec_info.jpg)
![Image text](readme_png/sms_info.jpg)



#### 联系方式
```shell
email: lwk0727@163.com
    v: Liwk09071327
```
#### 参与贡献

1.  Fork 本仓库
2.  新建 Feat_xxx 分支
3.  提交代码
4.  新建 Pull Request


#### 特技

1.  使用 Readme\_XXX.md 来支持不同的语言，例如 Readme\_en.md, Readme\_zh.md
2.  Gitee 官方博客 [blog.gitee.com](https://blog.gitee.com)
3.  你可以 [https://gitee.com/explore](https://gitee.com/explore) 这个地址来了解 Gitee 上的优秀开源项目
4.  [GVP](https://gitee.com/gvp) 全称是 Gitee 最有价值开源项目，是综合评定出的优秀开源项目
5.  Gitee 官方提供的使用手册 [https://gitee.com/help](https://gitee.com/help)
6.  Gitee 封面人物是一档用来展示 Gitee 会员风采的栏目 [https://gitee.com/gitee-stars/](https://gitee.com/gitee-stars/)