- 博客(13)
- 资源 (2)
- 问答 (1)
- 收藏
- 关注
RSS订阅原创 神通数据库安装
brcmd -O backup -d 实例名称 -u 用户名称 -p 密码 -P 端口 -t full -k file -f 备份文件.osrbk -b 8192 -c TRUE(是否压错，true为压缩)LTRIM(PATH,'
2024-01-22 15:14:38
1644
3
原创 keepalived+mysql多实例
wget https://www.keepalived.org/software/keepalived-2.2.7.tar.gzyum -y install libnl libnl-develyum -y install openssl-develtar xzvf keepalived-2.2.7.tar.gzcd keepalived-2.2.7./configure --prefix=/etc/keepalivedmakemake installcd /etc/keepal.
2022-03-14 09:44:07
206
原创 MYSQL多实例安装
给每个实例单独配置.cnfvi /db1/mysql3307/my3307.cnf[mysqld]basedir = /db1/mysql3307datadir = /db1/mysql3307/datasocket = /db1/mysql3307/mysql3307.socketuser = mysqltmpdir = /db1/mysql3307symbolic-links=0log-bin = /db1/mysql3307/mysql-bin.logpid-file = /d
2022-03-11 14:49:22
1481
原创 greenplum+gptext+gpcc安装
service NetworkManager stopsystemctl disable NetworkManagerservice iptables stopservice ip6tables stopchkconfig iptables offchkconfig ip6tables offsystemctl disable firewalldsystemctl stop firewalldvi /etc/selinux/configvi /etc/hosts vi /et...
2022-03-01 09:27:37
1388
原创 oracle dataguard安装
主备修改/etc/hosts127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4::1 localhost localhost.localdomain localhost6 localhost6.localdomain6192.168.31.24 nccorcldb1192.168.31.25 nccorcldb2主：修改listener.ora# listener.o...
2021-12-02 09:36:19
2428
原创 rac开归档
节点二shutdown immediate节点一show parameter recoveryarchive log listshow parameter clusteralter system set cluster_database=false scope=spfile;alter system set db_recovery_file_dest_size=2G scope=both;alter system set db_recovery_file_dest='+FRA's...
2021-11-18 08:39:06
598
原创 oracle dataguard
主备：修改/etc/hosts192.168.77.136 liumh192.168.77.137 liu修改listener.ora# listener.ora Network Configuration File: /u01/oracle/network/admin/listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER =(SID_LIST= (SID_DESC = ...
2021-11-16 16:57:54
1426
原创 mysql主从配置
master：vi /etc/my.cnf[mysqld]log-bin=mysql-binserver-id=1binlog-ignore-db = mysql,information_schema,sys,performance_schema,undologservice mysqld restartslave:vi /etc/my.cnf[mysqld]server-id=2service mysqld restartmaster:mysql > gr...
2021-11-15 10:11:52
645
原创 mysql安装
groupadd mysql #创建用户组mysqluseradd -r -g mysql mysql #创建mysql用户mkdir /usr/local/mysqlchown -R mysql.mysql /usr/local/mysql/ #改变目录的权限复制启动文件cp support-files/mysql.server /etc/init.d/mysqldchmod 755 /etc/init.d/mysqldcp bin/my_print_defaults /us..
2021-11-12 15:08:11
714
原创 Oracle单实例安装
yum install -y gcc-c++.x86_64yum install -y gcc.x86_64yum install -y libstdc++.i686yum install -y libaio-devel.i686yum install -y libaio-devel.x86_64yum install -y compat-libstdc++-33.x86_64yum install unixODBC.i686 -yyum install unixODBC.x86
2021-11-12 15:04:28
1784
原创 2021-10-26运维常用
--查看表空间SELECT a.tablespace_name,a.bytes total, b.bytes used, c.bytes free,(b.bytes*100)/a.bytes "%USED",(c.bytes*100)/a.bytes"%FREE" FROM sys.sm$ts_avail a,sys.sm$ts_used b,sys.sm$ts_free c WHERE a.tablespace_name=b.tablespace_name AND a.tablespace_name=
2021-10-26 10:53:07
336
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人