oracle 查询 adg 状态,Oracle 11gR2 RAC/ADG状态监测

# -*- coding:utf-8 -*-

import cx_Oracle

import codecs

from pprint import pprint

import csv

import time

import re

import binascii

import os

import sys

import logging

import string

import datetime

"""

定时更新系统时间：

# crontab -l

30 * * * * /usr/sbin/ntpdate 192.168.89.200

创建数据库表

create table checkadg (

id number(10) primary key,

dt varchar2(20) not null

);

初始化第一条记录

insert into checkadg1 values (1,'2018-12-18 20:50:14');

创建新用户

SQL> create user checkadg identified by checkadg1234;

User created.

修改用户密码

SQL> alter user checkadg identified by chkeck123456;

User altered.

赋予访问权限

SQL> grant connect,resource to checkadg;

Grant succeeded.

赋予