- 博客(351)
- 资源 (3)
- 收藏
- 关注
RSS订阅原创 ./runcluvfy.sh stage -pre crsinst -n `hostname` -verbose -method root
grid:Cluvfy Fail with PRVG-11250 The Check “RPM Package Manager Database” Was Not Performed (Doc ID 2548970.1)./runcluvfy.sh stage -pre crsinst -n hostname -verbose -method root Node Name Running? Status -------
2021-12-11 14:47:47
577
原创 oceanbase 数据库上所有的数据字典表
oceanbase 数据库上所有的数据字典表MySQL [oceanbase]> show tables;+------------------------------------------------+| Tables_in_oceanbase |+------------------------------------------------+| CDB_CKPT_HISTORY
2021-08-24 10:28:25
1530
原创 influxdb-python 安装
[root@sdw3 tools]# cd influxdb-python[root@sdw3 influxdb-python]# lltotal 64-rw-r--r-- 1 root root 9499 Apr 25 21:44 CHANGELOG.md-rw-r--r-- 1 root root 85 Apr 25 21:44 dev-requirements.txtdrwxr-xr-x 3 root root 52 Apr 25 21:44 docsdrwxr-xr-x 2 ro..
2021-04-26 00:14:20
1554
7
原创 Starting Grafana
[root@tc03 bin]# /usr/local/grafana/bin/grafana-server &[1] 3155[root@tc03 bin]# INFO[05-28|00:42:01] Starting Grafana logger=server version=7.0.1 commit=ef5b586d7d branch=HEAD compiled=2020-05-26T16:05:56+0800INFO[05-28|00.
2020-07-25 09:05:51
245
原创 /usr/local/grafana/bin/grafana-server
[root@tc03 bin]# /usr/local/grafana/bin/grafana-server &[1] 3155[root@tc03 bin]# INFO[05-28|00:42:01] Starting Grafana logger=server version=7.0.1 commit=ef5b586d7d branch=HEAD compiled=2020-05-26T16:05:56+0800INFO[05-28|00:4
2020-05-27 15:41:08
264
原创 gpinitsystem
[gpadmin@master1 ~]$ gpinitsystem -c /home/gpadmin/conf/gpinitsystem_config -h /home/gpadmin/conf/seg_hosts -s master2 -B 620200506:16:44:06:005974 gpinitsystem:master1:gpadmin-[INFO]:-Checking conf...
2020-05-06 16:51:02
464
原创 gpdeletesystem
[gpadmin@master1 ~]$ gpdeletesystem -d /data/master/gpseg-120200505:20:47:07:006791 gpdeletesystem:master1:gpadmin-[INFO]:-Checking for database dump files...20200505:20:47:07:006791 gpdeletesystem:...
2020-05-05 23:01:19
310
原创 gp 6.4.0 初始化数据库
[gpadmin@sdw1 conf]$ gpinitsystem -c /home/gpadmin/conf/gpinitsystem_config -h /home/gpadmin/conf/seg_hosts20200310:19:42:04:024409 gpinitsystem:sdw1:gpadmin-[INFO]:-Checking configuration parameters...
2020-03-10 11:44:30
630
原创 gp 6.1.0 pxf 连接 hadoop
在hadoop端执行：[cloudera@quickstart ~]$ cat /tmp/pxf_hive_datafile.txtPrague,Jan,101,4875.33Rome,Mar,87,1557.39Bangalore,May,317,8936.99Beijing,Jul,411,11600.67San Francisco,Sept,156,6846.34Paris,N...
2019-12-15 22:06:08
1672
2
原创 gpadmin 执行 ./gpccinstall-6.0.0
Would you like enable SSL? Yy/Nn (Default=N)Please choose a display language (Default=English)1. English2. Chinese3. Korean4. Russian5. Japanese2INSTALLATION IN PROGRESS...*********...
2019-12-04 23:39:14
425
原创 最新的 Greenplum 6.0 中文文档
最新的 Greenplum 6.0 中文文档可以登陆Greenplum中文社区文档频道(https://greenplum.cn/docs 或https://greenplum.cn/gp6/)访问。
2019-12-02 10:52:28
4338
原创 ORA-28040: No matching authentication protocol exception
参考：https://stackoverflow.com/questions/24100117/ora-28040-no-matching-authentication-protocol-exception/33675384SQLNET.ALLOWED_LOGON_VERSION=10SQLNET.ALLOWED_LOGON_VERSION_CLIENT=10SQLNET....
2019-12-02 10:36:48
170
原创 gpexpand -a -d 10:00:00
postgres=# select * from gpexpand.status; status | updated -------------------+---------------------------- SETUP | 2019-11-27 10:06:20.833248 EXPANSION ...
2019-11-27 10:38:51
410
原创 6.1.0 gpstate -f
gpstate -f20191124:18:33:44:007686 mdw100:gpadmin-[INFO]:-Starting gpstate with args: -f20191124:18:33:44:007686 mdw100:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 6.1....
2019-11-24 18:36:34
264
原创 oracle 19c ADG 配置删除归档策略
RMAN> show all;using target database control file instead of recovery catalogRMAN configuration parameters for database with db_unique_name TCYANG are:CONFIGURE RETENTION POLICY TO REDUNDAN...
2019-10-18 17:39:43
913
原创 Oracle 19c dgmgrl 配置
DGMGRL> show database verbose tcyang_stbDatabase - tcyang_stb Role: PRIMARY Intended State: TRANSPORT-ON Instance(s): tcyang Properties: DGConnectIdentifier ...
2019-10-18 17:29:05
777
转载 [转]linux awk命令详解
[转]linux awk命令详解原文链接 :http://blog.chinaunix.net/uid-23302288-id-3785105.htmlawk是行处理器: 相比较屏幕处理的优点，在处理庞大文件时不会出现内存溢出或是处理缓慢的问题，通常用来格式化文本信息awk处理过程: 依次对每一行进行处理，然后输出awk命令形式:awk [-F|-f|-v] 'BEGIN{}...
2019-05-15 20:09:37
185
原创 CLSRSC-507: The root script cannot proceed on this node
问题描述：[root@testdb02 dev]# /oracle/app/12.1.0/grid/root.shPerforming root user operation.The following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /oracle/app/...
2019-04-05 18:50:11
2190
5
原创 单实例打PSU 27734982 （180717）
oradb19:/tools/PSU/27734982$$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./Oracle Interim Patch Installer version 11.2.0.3.15Copyright (c) 2018, Oracle Corporation. All ri...
2018-10-31 10:23:22
609
原创 SunOS swcrm1 5.10 Generic_150400-61 sun4u sparc SUNW,SPARC-Enterprise 10194190
[grid@swcrm1 10194190]$ opatch apply -oh /oracle/11.2.0/grid -local /oracle/soft/10194190Oracle Interim Patch Installer version 11.2.0.3.19Copyright (c) 2018, Oracle Corporation. All rights reserv...
2018-08-25 23:15:00
926
原创 11.2.0.4.170717 ojvm 28317183
[oracle@swcrm1 28317183]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./Oracle Interim Patch Installer version 11.2.0.3.19Copyright (c) 2018, Oracle Corporation. All righ...
2018-08-25 20:34:29
475
原创 solaris 5.10 root.sh
root@swcrm1 # /oracle/oraInventory/orainstRoot.shChanging permissions of /oracle/oraInventory.Adding read,write permissions for group.Removing read,write,execute permissions for world.Changing gr...
2018-08-24 13:15:59
477
1
原创 solaris 11.2.0.4 DB PSU 180717
[oracle@swboss-rpt1 28317183]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./Oracle 中间补丁程序安装程序版本 11.2.0.3.19版权所有 (c) 2018, Oracle Corporation。保留所有权利。PREREQ sessionOra...
2018-07-26 23:37:17
439
原创 ing lsdg
ASMCMD> lsdgState Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files NameMOUNTED EXTERN N 512 4096 1048576 ...
2018-07-22 13:19:52
233
原创 centos 6.9 11.2.0.4.180717 OJVM PATCH SET UPDATE
swbilling2:/home/oracle$$ORACLE_HOME/OPatch/opatch lspatches27441052;OCW PATCH SET UPDATE: 11.2.0.4.180417 (27441052)27734982;Database Patch Set Update : 11.2.0.4.180717 (27734982)OPatch succee...
2018-07-22 11:52:55
1201
原创 centos 6.9 DB PSU
root@swbilling1:/root#/oracle/product/11.2.0/dbhome_1/OPatch/opatch auto /oracle/soft/27967757/ -oh /oracle/product/11.2.0/dbhome_1 -ocmrf /home/oracle/oracle_ocm.rsp Executing /oracle/11.2.0/grid/pe...
2018-07-22 09:39:12
349
原创 centos 6.9 11.2.0.4 PSU GI 27967757
#/oracle/11.2.0/grid/OPatch/opatch auto /oracle/soft/27967757 -ocmrf /home/grid/grid_ocm.rspExecuting /oracle/11.2.0/grid/perl/bin/perl /oracle/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /oracle/...
2018-07-22 00:24:18
603
原创 centos 6.8 11.2.0.4 DB PSU 180717
$ $ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /oracle/soft/11g/27726500Oracle Interim Patch Installer version 11.2.0.3.19Copyright (c) 2018, Oracle Corporation. All rights reserved.O...
2018-06-29 15:47:15
302
原创 mysql binlog分析
Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 9Server version: 5.7.19-log MySQL Community Server (GPL)Copyright (c) 2000, 2013, Oracle and/or its affil
2017-12-20 14:24:51
436
原创 expdp 问题和 ORA-00600: internal error code, arguments: [25027], [6], [0], [], [], [], [], [], [], [],
Export: Release 11.2.0.4.0 - Production on Thu Nov 30 17:12:48 2017Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.Connected to: Oracle Database 11g Enterprise Edition
2017-11-30 18:28:04
1852
原创 mysql 1236
root@localhost [(none)]>show slave status\G*************************** 1. row *************************** Slave_IO_State: Master_Host: 192.168.15.100
2017-11-27 12:56:11
2389
转载 ibrix_pv
https://support.hpe.com/hpsc/doc/public/display?docId=emr_na-c03001417&lang=zh-cn&cc=cn[root@host2 etc]# ibrix_pv -l -h host1 PV_NAME SIZE(MB) VG_NAME DEVICE RAIDTYPE RAIDHOST RAID
2017-11-01 14:33:22
394
转载 hugepages_settings.sh
#!/bin/bash## hugepages_settings.sh## Linux bash script to compute values for the# recommended HugePages/HugeTLB configuration# on Oracle Linux## Note: This script does calculation for all sha
2017-10-22 23:09:18
635
原创 How to disable DRM
How to disable DRM？10gR2以及以下版本 静态： _gc_affinity_time=0 _gc_undo_affinity=FALSE 或 动态： _gc_affinity_limit=250 _gc_affinity_minimum=10485760 11gR1以及以上版本 _gc_policy_time=
2017-10-17 14:52:03
382
原创 oracle rda
[18:14:56][oracle@tcyang rda]$ ./rda.sh -h[18:14:56]Usage: rda.pl [-bcdfilnvwxy] [-ABCDEGHIKLMPQRSTV] [-e edt] [-m dir] [-o out][18:14:56] [-p nam] [-s nam] [-t lvl] arg ...[18:14:56]
2017-10-14 21:49:16
1209
原创 Linux 内存使用情况检查
ps：其中rsz是是实际内存ps -e -o 'pid,comm,args,pcpu,rsz,vsz,stime,user,uid' ps -e -o 'pid,comm,args,pcpu,rsz,vsz,stime,user,uid' | grep oracle | sort -nrk5其中rsz为实际内存，上例实现按内存排序，由大到小$ top -u oracle
2017-10-10 17:31:01
384
1
原创 oracle 常用工具
TOP1 录像机OS WatcherTOP2 监视器oratopTOP3 快刀手 oraTop4 小保健：ORAchkTOP5 大保健：RDATop6 巨无霸：OEM CC
2017-10-10 11:50:16
294
原创 dba_hist_active_sess_history中sample_time的采样时间
set lines 200 pages 55col KSPPINM format a25col KSPPSTVL format a22select a.ksppinm, b.ksppstvl from sys.x$ksppi a, sys.x$ksppcv b where a.indx = b.indx and a.ksppinm like '_ash%';KSPPINM
2017-10-08 20:42:55
1468
1
转载 rac后台进程说明及一些概念
参考：http://blog.itpub.net/670493/viewspace-1024937/rac后台进程说明及一些概念1.GSD global services daemonGSD与rac的管理工具dbca srvctl oem进行交互，用来完成实例的启动关闭等管理任务。为了保证这些管理工具运行正常必须在所有的节点上先start gsd,并且一个G
2017-10-08 17:20:12
1582
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人