/root/.subversion
bettle: svn://172.17.40.66/cmdb svn://172.17.40.66/dbcm/trunk
sqlreview: git@172.19.14.39:dbadmin/sqlreview.git
opa-pallas: git@gitlab.lucloud.com:lu_cloud/ops-pallas.git
dpaacc: git@172.19.14.39:dbadmin/dpaacc.git
KOP: git@172.19.14.39:dbadmin/KOP.git
alter table dbcm.dev_tab_col add column sensitive_col varchar(100) DEFAULT NULL;
alter table dbcm.dba_tab_col add column sensitive_col varchar(100) DEFAULT NULL;
alter table dbcm.snap_tab_col add column sensitive_col varchar(100) DEFAULT NULL;
alter table dbcm.suit_tab_col add column sensitive_col varchar(100) DEFAULT NULL;
http://bettle.lujs.cn/changeset/2155/table/2297/index
http://bettle.lujs.cn/changeset/2155/table/2297/
/usr/local/bin/cnpm -> /usr/local/lib/node_modules/cnpm/bin/cnpm
# Generated by NetworkManager
domain localdomain
search localdomain
nameserver 192.168.225.2
sudo /sbin/dhclient
Stgpwd@810
Stgpwd@810
Stgpwd@810
npm install -g @vue/cli >> npm run serve 〉〉 npm run build
[fsevents@^1.2.7] optional install error: Package require os(darwin) not compatible with your platform(linux)
[32/32] @vue/cli-ui@^4.2.3 installed at node_modules/_@vue_cli-ui@4.2.3@@vue/cli-ui
Stgpwd@810
http://192.168.225.185:8080/?_token=0566687995ae4a75a657a61f4b8118e1
http://192.168.225.185:8080
http://172.28.10.6:8080/?_token=0566687995ae4a75a657a61f4b8118e1
?_token=cb392ff7cf0349838bc5a3ec013b958c
/home/CyberAdmin/vue-element-admin-master.tar.gz
https://www.google.cn/intl/zh-CN/chrome/
/DATA1/projects/python/dpaacc
sqlreview running:
/wls/virtualenv/ai_python3_virtualenv/bin/pip install whitenoise
/wls/virtualenv/ai_python3_virtualenv/bin/python /DATA1/projects/python/sqlreview/manage.py runserver 0.0.0.0:8005
scp -r CyberAdmin@172.23.25.203:/wls/applications/ /DATA1/projects/python/
scp -r /DATA1/projects/python/dpaacc CyberAdmin@172.19.14.40:/wls/applications/
scp -r CyberAdmin@172.19.14.40:/wls/applications/ /DATA1/projects/python/
scp -r /DATA1/projects/python/dpaacc CyberAdmin@172.19.14.40:/wls/applications/
tar -zcvf Desktop/lgh_dpaacc.tar.gz /DATA1/projects/python/dpaacc
scp -r Desktop/lgh_dpaacc.tar.gz CyberAdmin@172.19.14.40:/wls/guohui/
mysql execute error: 1044 (42000): Access denied for user \\‘mysqladmin\\‘@\\‘%\\‘ to database \\‘zssmydata\\‘
/DATA1/projects/python
/wls/data2/my3501/bin/mysql -umysqladmin -pmysqladmin
/wls/virtualenv/lufax-virtualenv/bin/python /wls/applications/dpaacc/manage.py runserver 0.0.0.0:8003
/wls/virtualenv/lufax-virtualenv/bin/python /wls/applications/dpaacc/manage.py runserver 127.0.0.1:8003
/wls/virtualenv/dbcm-virtualenv/bin/python /wls/applications/dbcm/apps/manage.py runserver 0.0.0.0:8001
/wls/virtualenv/dbcm-virtualenv/bin/python setup.py install
/wls/virtualenv/lufax-virtualenv/bin/celery worker -A dpaacc -c 2 --workdir /wls/applications/dpaacc -Q dpaacc -l DEBUG -n worker_dpaacc.%h
git clone git@gitlab.lucloud.com:lu_cloud/ops-pallas.git
coreapi in /DATA1/virtualenv/supervirsord-virtualenv/lib/python2.7/site-packages (2.3.3)
/DATA1/projects/python/dbcm/api/webservice/http_factory_add_schema.py
Oracle分区表清理
MySQL分区表清理
MySQL系统变量修改
Oracle的parameter参数调整
select name,ISSYS_MODIFIABLE from v$system_parameter where ISSYS_MODIFIABLE!=‘FALSE‘ order by 2;
MySQL软件安装
MySQL实例搭建
/wls/dbadmin/install/mysqlserver
aaOUkAfmP82AZVNg
SELECT DISTINCT CONCAT(‘User: ‘‘‘,user,‘‘‘@‘‘‘,host,‘‘‘;‘) AS query FROM mysql.user;
mysql -h172.23.31.148 -P3501 -udpaa_dml -pdpaa_dml
curl -H "Content-Type:application/json" -X POST -d ‘{"method": "TEST","call_type": "SYNC"}‘ "http://127.0.0.1:8000/service/http_service_v2?username=liangguohui&secret_key=2d2c2d4aa4c1a026a7dfdaf9cb321234"
u‘20190801151231682439‘
/wls/virtualenv/dbcm-virtualenv/bin/python /wls/applications/dbcm/apps/manage.py runserver 0.0.0.0:8000
import pdb;pdb.set_trace()
zhengque: /wls/virtualenv/dbcm-virtualenv/bin/python /DATA1/projects/python/dbcm/manage.py sync_schema_tenant_relation_to_cmdb
zhengque: /wls/virtualenv/dbcm-virtualenv/bin/python /DATA1/projects/python/dbcm/manage.py sync_test
/wls/virtualenv/lufax-virtualenv/bin/python /DATA1/projects/python/dpaacc/manage.py debug_sync_dbsearch
/wls/virtualenv/ai_python3_virtualenv/bin/python /DATA1/projects/python/sqlreview/manage.py test_xxw
/wls/virtualenv/dbcm-virtualenv/bin/python set_up.py install
24f5a3845a581112e12654e6ebe931a44cc64e6c71b78ed7011d5d3591b18ad3
Connecting to 172.168.71.55:22...
import pdb;pdb.set_trace()
class Command(BaseCommand):
help = ‘It is a fake command, Import init data for test‘
def add_arguments(self, parser):
parser.add_argument(‘-t‘, ‘--task_id‘, dest=‘task_id‘, default=False, help=‘task_id‘)
def handle(self, *args, **options):
# if len(args) != 1:
# print("请输入唯一参数：任务号!")
# exit(1)
task_id = options.get(‘task_id‘)
sql_retry(str(task_id).strip().lower())
sqlplus system/sqlrush
col TABLESPACE_NAME for a50;
col FILE_NAME for a50;
set line 500;
SQL> SELECT TABLESPACE_NAME,FILE_NAME FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = ‘LGHDATA‘;
SELECT FILE_ID,TABLESPACE_NAME,FILE_NAME,ONLINE_STATUS,USER_BLOCKS FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = ‘LGHDATA‘;
SELECT FILE_ID,TABLESPACE_NAME,FILE_NAME,ONLINE_STATUS,USER_BYTES FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = ‘LGHDATA‘ and FILE_NAME like ‘%/wls/%‘;
a = ‘2017-10-18 22:17:46‘
b = ‘2017-10-19 22:17:40‘
print a > b
toolkit/domain/schema/table/management
pef_prod_pur_stat_ctrl pef_prod_pur_stat_ctrl
88c1d9a4-be51-11e9-8b94-000c29e6e026
select /*+ rule */ df.file#,df.rfile#,df.name,ts.name as tablespace_name,
df.status,df.bytes/1024/1024 as "size(M)"
from v$datafile df,v$tablespace ts
where df.ts#=ts.ts# and ts.name=upper(‘LGHDATA‘)
order by df.name;
curl -H "Content-Type:application/json" -X POST -d ‘{"uuid_id": "3082f8f6-639e-4beb-b625-5d13b049f6a8","req_id": "3082f8f6-639e-4beb-b625-5d13b049f6a8","bettle_name": "wwl_test",
"bettle_release_date": "2019-02-20","comments": "templateCreate","app": "EXT-APP","app_branch": "DEV_20180101","area":"lufax","creator": "liangguohui067","member": "yuwanjun230,lisihao308","sql_files":[{"sql_exec_user": "accdata","sql_comments": "模板表","db1_dml": "UPDATE msc_job_config SET updated_at=sysdate, updated_by=‘CHENDE840‘ WHERE job_name = ‘deleteProductIndexMinutely‘ and job_group = ‘lsearch_jobs‘; update msc_job_switch set updated_at=sysdate, updated_by=‘CHENDE840‘ where switch_name=‘JOB_CONFIG_DIRTY‘;","db1_dml_sum": "5ffd70499790e85906e9a490e18ef36f","db2_dml": "UPDATE msc_job_config SET updated_at=sysdate, updated_by=‘CHENDE840‘ WHERE job_name = ‘deleteProductIndexMinutely‘ and job_group = ‘lsearch_jobs‘; update msc_job_switch set updated_at=sysdate, updated_by=‘CHENDE840‘ where switch_name=‘JOB_CONFIG_DIRTY‘;","db2_dml_sum": "5ffd70499790e85906e9a490e18ef36f"}]}‘ "http://127.0.0.1:8002/service/webrequest_v2?username=qaadmin&secret_key=a909d58eb889090ec9a372d5a20ba53d&method=create_bettle"
curl -H "Content-Type:application/json" -X POST -d ‘{"method": "TEST", "call_type": "SYNC"}‘ "http://127.0.0.1:8002/service/webrequest_v2?username=qaadmin&secret_key=a909d58eb889090ec9a372d5a20ba53d"
curl -H "Content-Type:application/json" -X POST -d ‘{"area": "xtttttt", "zone": "LufaxC", "schema_name": "cldxttrsmydata", "rnd_user": "cldxttrsmyrnd", "instance_type": "MYSQL", "opr_user": "cldxttrsmyopr"}‘ "http://172.19.14.38:9000/service/webrequest_v2?username=rcsys&secret_key=3146cbe38c09967008a0299b76a6d15c&method=add_schema"
"area" -> "xtttttt"
"zone" -> "LufaxC"
"schema_name" -> "cldxttrsmydata"
"rnd_user" -> "cldxttrsmyrnd"
"instance_type" -> "MYSQL"
"opr_user" -> "cldxttrsmyopr"
curl -H "Content-Type:application/json" -X POST -d ‘{"uuid_id": "3082f8f6-639e-4beb-b625-5d13b049f6a8","req_id": "3082f8f6-639e-4beb-b625-5d13b049f6a8","bettle_name": "wwl_test",
"bettle_release_date": "2019-02-20","comments": "templateCreate","app": "EXT-APP","app_branch": "DEV_20180101","area":"lufax","creator": "liangguohui067","member": "yuwanjun230,lisihao308","sql_files":[{"sql_exec_user": "accdata","sql_comments": "模板表","db1_dml": "UPDATE msc_job_config SET updated_at=sysdate, updated_by=‘CHENDE840‘ WHERE job_name = ‘deleteProductIndexMinutely‘ and job_group = ‘lsearch_jobs‘; update msc_job_switch set updated_at=sysdate, updated_by=‘CHENDE840‘ where switch_name=‘JOB_CONFIG_DIRTY‘;","db1_dml_sum": "5ffd70499790e85906e9a490e18ef36f","db2_dml": "UPDATE msc_job_config SET updated_at=sysdate, updated_by=‘CHENDE840‘ WHERE job_name = ‘deleteProductIndexMinutely‘ and job_group = ‘lsearch_jobs‘; update msc_job_switch set updated_at=sysdate, updated_by=‘CHENDE840‘ where switch_name=‘JOB_CONFIG_DIRTY‘;","db2_dml_sum": "5ffd70499790e85906e9a490e18ef36f"}]}‘ "http://127.0.0.1:8002/service/webrequest_v2?username=qaadmin&secret_key=a909d58eb889090ec9a372d5a20ba53d&method=create_bettle"
‘d41d8cd98f00b204e9800998ecf8427e‘
[(u‘admin‘, 1, 1), (u‘shenhaiming804‘, 6, 1), (u‘shm‘, 2, 1), (u‘yangyun620‘, 11, 0)]
1 6 2 11
1 6 2 8
curl -H "Content-Type:application/json" -X POST -d ‘{"task_id": "3812","method": "TABLE_OFFLINE","offline_type": "table_rename","call_type": "SYNC","instance_name": "t003","instance_path":"source ~/.bash_profile_t003","address": "172.23.31.149","schema_table_list":[{"STUDY":["STUDENTS_2","STUDENTS_5"]}]}‘ "http://172.19.14.40:8000/service/http_service_v2?username=liangguohui&secret_key=2d2c2d4aa4c1a026a7dfdaf9cb321234"
curl -H "Content-Type:application/json" -X POST -d ‘{"method": "ORACLE_CREATE_SCHEMA","call_type": "SYNC","instance_name": "t003","address": "172.23.31.149","schema_name":"ppidnvvgdata","datafile_path":"/opt/oracle/diag/"}‘ "http://127.0.0.1:8000/service/http_service_v2?username=liangguohui&secret_key=2d2c2d4aa4c1a026a7dfdaf9cb321234"
select username from all_users where username=‘PPIDNKVSDATA‘;
ORA-00257: archiver error. Connect internal only, until freed.
curl -H "Content-Type:application/json" -X POST -d ‘{"method": "ORACLE_CREATE_SCHEMA","call_type": "SYNC","instance_name": "t003","address": "172.23.31.149","schema_name":"ppidngpbdata","datafile_path":"/opt/oracle/diag/"}‘ "http://127.0.0.1:8000/service/http_service_v2?username=liangguohui&secret_key=2d2c2d4aa4c1a026a7dfdaf9cb321234"
{"content": "{\"oprpassed\": \"XgK5IpEXcDQVp24Q\", \"rndpasswd\": \"I87361847217102d\", \"datapasswd\": \"a8Zl83676dx3748F\"}", "message": "\nbettle add schema failed:[request bettle add schema fail HTTPConnectionPool(host=‘127.0.0.1‘, port=8002): Max retries exceeded with url: /service/webrequest_v2?username=dpaa&secret_key=a909d58eb889090ec9a372d5a20bgh56&method=ADD_SCHEMA (Caused by NewConnectionError(‘<requests.packages.urllib3.connection.HTTPConnection object at 0x7effdb19c490>: Failed to establish a new connection: [Errno 111] Connection refused‘,))]", "method": "ORACLE_CREATE_SCHEMA", "call_type": "SYNC", "result": "SUCCESS"}
ORACLE_CREATE_SCHEMA:
curl -H "Content-Type:application/json" -X POST -d ‘{"method": "ORACLE_CREATE_SCHEMA","call_type": "SYNC","instance_name": "dbats","address": "31.99.72.21","schema_name":"ppidnackdata01","datafile_path":"/opt/oracle/data1/dbats/"}‘ "http://31.67.72.39:8000/service/http_service_v2?username=dpaa&secret_key=0ec7503e714001d19f8828f368b68784"
MYSQL_CREATE_SCHEMA:
20200102
curl -H "Content-Type:application/json" -X POST -d ‘{"method": "MYSQL_CREATE_SCHEMA","call_type": "SYNC","port": "3366","address": "31.67.72.21","schema_name":"ppidnubdmydata01"}‘ "http://31.67.72.39:8000/service/http_service_v2?username=dpaa&secret_key=0ec7503e714001d19f8828f368b68784"
celery&redis:
tablespace_datafile = os.path.join(self._datafile_path, "{0}01.dbf".format(data_user))
/opt/redis/bin/redis-cli -h localhost -p 6379 -a redis1
/wls/virtualenv/lufax-virtualenv/bin/celery worker -A dpaacc -c 2 --workdir /wls/applications/dpaacc/apps -Q dpaacc -l DEBUG -n worker_dpaacc.%h
ORACLE_ADD_TABLESPACE & add_new_file:
curl -H "Content-Type:application/json" -X POST -d ‘{"task_id": "3812","method": "ORACLE_ADD_TABLESPACE","call_type": "SYNC","tablespace_handle_list":[{"add_type":"add_file_cap","instance_name": "t003","tablespace_name":"LGHDATA","ip": "172.23.31.149","file_path_list":["/wls/oracle/diag/lghhdata98.dbf","/wls/oracle/diag/lghhdata99.dbf"],"file_size":"8"},{"add_type":"add_new_file","instance_name": "t003","tablespace_name":"LGHDATA","ip": "172.23.31.149","file_path_list":["/wls/oracle/diag/lghhdata98.dbf","/wls/oracle/diag/lghhdata99.dbf"]}]}‘ "http://127.0.0.1:8000/service/http_service_v2?username=liangguohui&secret_key=2d2c2d4aa4c1a026a7dfdaf9cb321234"
ORACLE_ADD_TABLESPACE & add_file_cap:
curl -H "Content-Type:application/json" -X POST -d ‘{"task_id": "22236","method": "ORACLE_ADD_TABLESPACE","call_type": "SYNC","add_type":"add_file_cap","instance_name": "dbats","tablespace_name":"DBADATA","ip": "31.99.72.21","file_path_list":["/opt/oracle/data1/dbats/lghhdata03.dbf","/opt/oracle/data1/dbats/lghhdata04.dbf"],"file_size":"8"}‘ "http://31.67.72.39:8000/service/http_service_v2?username=dpaa&secret_key=0ec7503e714001d19f8828f368b68784"
table_backups_and_rename:
curl -H "Content-Type:application/json" -X POST -d ‘{"task_id": "22236","method": "TABLE_OFFLINE","offline_type": "table_rename","call_type": "SYNC","instance_name": "dbats","instance_path":"source ~/.bash_profile_dbats","address": "31.67.72.21","schema_table_list":[{"LGHDATA":["TEST1","TEST2"]}]}‘ "http://31.67.72.39:8000/service/http_service_v2?username=dpaa&secret_key=0ec7503e714001d19f8828f368b68784"
table_drop:
curl -H "Content-Type:application/json" -X POST -d ‘{"task_id": "22236","method": "TABLE_OFFLINE","offline_type": "table_drop","call_type": "SYNC","instance_name": "t003","instance_path":"source ~/.bash_profile_dbats","address": "31.67.72.21","schema_table_list":[{"LGHDATA":["TEST1","TEST2"]}]}‘ "http://31.67.72.39:8000/service/http_service_v2?username=dpaa&secret_key=0ec7503e714001d19f8828f368b68784"
table_rollback:
curl -H "Content-Type:application/json" -X POST -d ‘{"task_id": "22236","method": "TABLE_OFFLINE","offline_type": "table_rollback","call_type": "SYNC","instance_name": "t003","instance_path":"source ~/.bash_profile_dbats","address": "31.67.72.21","schema_table_list":[{"LGHDATA":["TEST1","TEST2"]}]}‘ "http://31.67.72.39:8000/service/http_service_v2?username=dpaa&secret_key=0ec7503e714001d19f8828f368b68784"
http://30.99.161.67:4440/api/14/job/002df29a-811c-416c-a7b2-7efe5c61cb40/executions?authtoken=G41rXGAaBqQMYpHp3NAVAmOwkjq5v7Bk
/wls/virtualenv/lufax-virtualenv/bin/celery worker -A dpaacc -c 2 --workdir /DATA1/projects/python/dpaacc -Q dpaacc -l DEBUG -n worker_dpaacc.%h
/wls/virtualenv/lufax-virtualenv/bin/celery worker -A dpaacc -c 2 --workdir /DATA1/projects/python/dpaacc -Q web -l DEBUG -n worker_web.%h
/wls/virtualenv/lufax-virtualenv/bin/celery worker -A dpaacc -c 2 --workdir /DATA1/projects/python/dpaacc -Q runtime -l DEBUG -n worker_runtime.%h
vim redis.6379.conf
940 cd ../
941 ll
942 bin/redis-cli --help
943 bin/redis-cli -p 6739 -a redis1
944 bin/redis-cli -p 6379 -a redis1
945 ll /wls/virtualenv/lufax-virtualenv/bin/celery
946 ll /DATA1/projects/python/dpaacc
947 /wls/virtualenv/lufax-virtualenv/bin/celery worker -A dpaacc -c 2 --workdir /DATA1/projects/python/dpaacc -Q dpaacc -l DEBUG -n worker_dpaacc.%h
948 /opt/redis/bin/redis-cli -p 7379 -a redis1
949 /opt/redis/bin/redis-cli -p 6379 -a redis1
950 /opt/redis/bin/redis-cli --help
951 /opt/redis/bin/redis-cli -h localhost -p 6379 -a redis1
952 /wls/virtualenv/lufax-virtualenv/bin/celery worker -A dpaacc -c 2 --workdir /DATA1/projects/python/dpaacc -Q dpaacc -l DEBUG -n worker_dpaacc.%h
/opt/redis/bin/redis-cli -p 6379 -a redis
18 ps -ef |grep redis
19 kill 17287
20 /opt/redis/bin/redis-server /opt/redis/conf/redis.6379.conf
21 /opt/redis/bin/redis-cli -p 6379 -a 111
22 vim /opt/redis/conf/redis.6379.conf
23 vim /opt/redis/bin/redis-cli -p 6379 -a redis1
24 /opt/redis/bin/redis-cli -p 6379 -a redis1
25 /opt/redis/bin/redis-cli -p 6379 -a r
26 /wls/virtualenv/lufax-virtualenv/bin/celery worker -A dpaacc -c 2 --workdir /wls/applications/dpaacc -Q dpaacc -l DEBUG -n worker_dpaacc.%h
/wls/virtualenv/lufax-virtualenv/bin/celery worker -A dpaacc -c 2 --workdir /wls/applications/dpaacc -Q dpaacc -l DEBUG -n worker_dpaacc.%h
dictionary update sequence element #0 has length 1; 2 is required
name ‘false‘ is not defined
‘R_20190802_954‘
ssh -o StrictHostKeyChecking=no wls81opr@172.19.14.40
/wls/virtualenv/lufax-virtualenv/bin/python lu_install_my57.py -i1 172.23.31.146 -i2 172.23.31.147 -i3 172.23.31.206 -i4 172.23.31.207 -p 3502 -d testmy01p.lufax.storage
ssh -o StrictHostKeyChecking=no wls81opr@172.19.14.40 ‘cd /wls/dbadmin/install/mysqlserver/; /wls/virtualenv/lufax-virtualenv/bin/python lu_install_my57.py -i1 172.23.31.146 -i2 172.23.31.147 -i3 172.23.31.206 -i4 172.23.31.207 -p 3502 -d testmy01p.lufax.storage‘
curl -H "Content-Type:application/json" -X POST -d ‘{"method": "MYSQL_INSTALL","call_type": "SYNC","task_id":"3812","host1": "172.23.31.146","host2": "172.23.31.147","host3":"172.23.31.206","host4":"172.23.31.207","port":"3503","dns":"testmy01p.lufax.storage"}‘ "http://127.0.0.1:8000/service/http_service_v2?username=liangguohui&secret_key=2d2c2d4aa4c1a026a7dfdaf9cb321234"
MYSQL_INSTALL:
curl -H "Content-Type:application/json" -X POST -d ‘{"method": "MYSQL_INSTALL","call_type": "SYNC","task_id":"22236","host1": "31.67.74.29","host2": "31.67.74.30","host3":"31.99.74.29","host4":"31.99.74.30","port":"3548","dns":"zzhmy01p.lufax.storage"}‘ "http://31.67.72.39:8000/service/http_service_v2?
username=dpaa&secret_key=0ec7503e714001d19f8828f368b68784"
curl -H "Content-Type:application/json" -X POST -d ‘{"method": "ORACLE_TABLESPACE_DATAFILE_PATH_CHECK","call_type": "SYNC","ip": "172.23.31.149","instance_name": "t003","tablespace_name":"lghdata"}‘ "http://127.0.0.1:8000/service/http_service_v2?username=liangguohui&secret_key=2d2c2d4aa4c1a026a7dfdaf9cb321234"
curl -H "Content-Type:application/json" -X POST -d ‘{"method": "MYSQL_INSTALL","call_type": "SYNC","task_id":"22236","host1": "30.67.72.21","host2": "30.67.73.21","host3":"30.99.72.19","host4":"30.99.73.19","port":"8888","dns":"dbatsmy01p.lufax.storage"}‘ "http://31.67.72.39:8000/service/http_service_v2?
username=dpaa&secret_key=0ec7503e714001d19f8828f368b68784"
curl -H "Content-Type:application/json" -X POST -d ‘{"task_id": "3812","method": "ORACLE_ADD_TABLESPACE","call_type": "SYNC","add_type":"add_new_file","instance_name": "t003","tablespace_name":"LGHDATA","ip": "172.23.31.149","file_path_list":["/wls/oracle/diag/lghhdata88.dbf","/wls/oracle/diag/lghhdata89.dbf"]}‘ "http://127.0.0.1:8000/service/http_service_v2?username=liangguohui&secret_key=2d2c2d4aa4c1a026a7dfdaf9cb321234"
curl -H "Content-Type:application/json" -X POST -d ‘{"method": "ORACLE_ADD_TABLESPACE","call_type": "SYNC","add_type":"add_file_cap","instance_name": "t003","tablespace_name":"LGHDATA","ip": "172.23.31.149","file_path_list":["/wls/oracle/diag/lghhdata08.dbf","/wls/oracle/diag/lghhdata09.dbf","/wls/oracle/diag/lghhdata10.dbf"],"file_size":"8"}‘ "http://127.0.0.1:8000/service/http_service_v2?username=liangguohui&secret_key=2d2c2d4aa4c1a026a7dfdaf9cb321234"
curl -H "Content-Type:application/json" -X POST -d ‘{"task_id": "3812","method": "ORACLE_ADD_TABLESPACE","call_type": "SYNC","add_type":"add_new_file","instance_name": "t003","tablespace_name":"LGHDATA","ip": "172.23.31.149","file_path_list":["/wls/oracle/diag/lghhdata88.dbf","/wls/oracle/diag/lghhdata89.dbf"]}‘ "http://172.19.14.40:8000/service/http_service_v2?username=liangguohui&secret_key=2d2c2d4aa4c1a026a7dfdaf9cb321234"
curl -H "Content-Type:application/json" -X POST -d ‘{"task_id": "3812","method": "ORACLE_ADD_TABLESPACE","call_type": "SYNC","add_type":"add_file_cap","instance_name": "t003","tablespace_name":"LGHDATA","ip": "172.23.31.149","file_path_list":["/wls/oracle/diag/lghhdata70.dbf","/wls/oracle/diag/lghhdata71.dbf"],"file_size":"8"}‘ "http://172.19.14.40:8000/service/http_service_v2?username=liangguohui&secret_key=2d2c2d4aa4c1a026a7dfdaf9cb321234"
2019-07-22:
curl -H "Content-Type:application/json" -X POST -d ‘{"task_id": "3812","method": "ORACLE_ADD_TABLESPACE","call_type": "SYNC","tablespace_handle_list":[{"add_type":"add_file_cap","instance_name": "t003","tablespace_name":"LGHDATA","ip": "172.23.31.149","file_path_list":["/wls/oracle/diag/lghhdata110.dbf","/wls/oracle/diag/lghhdata111.dbf"],"file_size":"8"},
{"add_type":"add_new_file","instance_name": "t003","tablespace_name":"LGHDATA","ip": "172.23.31.149","file_path_list":["/wls/oracle/diag/lghhdata110.dbf","/wls/oracle/diag/lghhdata111.dbf"]},
{"add_type":"add_file_cap","instance_name": "t004","tablespace_name":"ppidnlghdata","ip": "172.23.31.150","file_path_list":["/wls/oracle/diag/lghhdata100.dbf","/wls/oracle/diag/lghhdata101.dbf"],"file_size":"8"},
{"add_type":"add_new_file","instance_name": "t004","tablespace_name":"ppidnlghdata","ip": "172.23.31.150","file_path_list":["/wls/oracle/diag/lghhdata100.dbf","/wls/oracle/diag/lghhdata101.dbf"]}]}‘ "http://127.0.0.1:8000/service/http_service_v2?username=liangguohui&secret_key=2d2c2d4aa4c1a026a7dfdaf9cb321234"
2019-09-29:
curl -H "Content-Type:application/json" -X POST -d ‘{"task_id": "3812","method": "ORACLE_ADD_TABLESPACE","call_type": "SYNC","tablespace_handle_list":[{"add_type":"add_file_cap","instance_name": "t003","tablespace_name":"LGHDATA","ip": "172.23.31.149","file_path_list":["/wls/oracle/bin/lghhdata1002.dbf","/wls/oracle/bin/lghhdata1003.dbf"],"file_size":"16"},{"add_type":"add_new_file","instance_name": "t003","tablespace_name":"LGHDATA","ip": "172.23.31.149","file_path_list":["/wls/oracle/bin/lghhdata1002.dbf","/wls/oracle/bin/lghhdata1003.dbf"],"file_size":"8"}]}‘ "http://127.0.0.1:8000/service/http_service_v2?username=liangguohui&secret_key=2d2c2d4aa4c1a026a7dfdaf9cb321234"
curl -H "Content-Type:application/json" -X POST -d ‘{"task_id": "22236","method": "MYSQL_PARAMETER_MODIFY","call_type": "SYNC","handle_list":[{"address":"172.23.31.149","parameter_dict":{"connect_timeout":"10","wait_timeout":"28800"},"port": "3501"},{"address":"172.23.31.150","parameter_dict":{"connect_timeout":"10","wait_timeout":"28800"},"port": "3501"}]}‘ "http://127.0.0.1:8000/service/http_service_v2?username=liangguohui&secret_key=2d2c2d4aa4c1a026a7dfdaf9cb321234"
原文：https://www.cnblogs.com/lghlxy/p/12559646.html