redhat 6用udev设置multipath盘的权限

1

Posted on by

   在操作系统redhat 6上,重启multipath服务,盘的权限就变root了,需要用udev绑定设置权限。

查看设备

[root@oradbca ~]# dmsetup ls 
data01  (253:2)
crs03   (253:3)
VG0-LV_ROOT     (253:6)
crs02   (253:1)
crs01   (253:0)
data03  (253:5)
data02  (253:4)

 

配置参数

[root@oradbca ~]# cat /etc/udev/rules.d/12-dm-permissions.rules 
ENV{DM_NAME}=="crs01", OWNER:="grid", GROUP:="asmadmin", MODE:="660", SYMLINK+="iscsi/oraasm-$env{DM_NAME}"
ENV{DM_NAME}=="crs02", OWNER:="grid", GROUP:="asmadmin", MODE:="660", SYMLINK+="iscsi/oraasm-$env{DM_NAME}"
ENV{DM_NAME}=="crs03", OWNER:="grid", GROUP:="asmadmin", MODE:="660", SYMLINK+="iscsi/oraasm-$env{DM_NAME}"
ENV{DM_NAME}=="data01", OWNER:="grid", GROUP:="asmadmin", MODE:="660", SYMLINK+="iscsi/oraasm-$env{DM_NAME}"
ENV{DM_NAME}=[......]

查看全文

GoldenGate cannot acquire password for jmxUser

0

Posted on by

版本:

Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100 
Linux, x64, 64bit (optimized), Oracle 10g on Oct  4 2011 23:50:20

 

  在启动agent的时候,报密码不对,报错如下:

2014-06-18 14:50:33  WARNING OGG-01689  Oracle GoldenGate Manager for Oracle, mgr.prm:  Thread: agentRegistration, Message: MBeansContainerImpl.java::::::1266 javax.security.sasl.SaslException: DIGEST-MD5: cannot acquire password for jmxUser in realm : monitorservice.
2014-06-18 14:51:33  WARNING OGG-01689  Oracle GoldenGate Manager for Oracle, mgr.prm:  Thread: agentRegistration, Message: MBeansContainerImpl.java::::::1266 javax.security.sasl.SaslException: DIGEST-MD5: cannot acquire password for jmxUser in realm : monitorservice.
2014-06-18 14:52:33  WARNING OGG-01689  Oracle GoldenGate Manager for Oracle, mgr.prm:  Thread: agentRegistration, Message: MBeansContainerImpl.java::::::1266 javax.security.sasl.SaslException: DIGEST-MD5: c[......]

查看全文

GoldenGate Error loading function jvm from JNI_GetCreatedJavaVMs

0

Posted on by

版本:

Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100 
Linux, x64, 64bit (optimized), Oracle 10g on Oct  4 2011 23:50:20

 

ogg在配置monitor agent时报错:

2014-06-18 14:38:59  INFO    OGG-00983  Oracle GoldenGate Manager for Oracle, mgr.prm:  Manager started (port 7809).
2014-06-18 14:38:59  INFO    OGG-01227  Oracle GoldenGate Manager for Oracle, mgr.prm:  Waiting for connection on port 7809 ..
2014-06-18 14:38:59  INFO    OGG-01338  Oracle GoldenGate Manager for Oracle, mgr.prm:  mgr: The Network Server service was started successfully.
2014-06-18 14:38:59  INFO    OGG-01338  Oracle GoldenGate Manager for Oracle, mgr.prm:  mgr: The Java VM service was started successfully.
2014-06-18 14:38:59  INFO    OGG-01338  Oracle GoldenGate Manager for Oracle, mgr.prm:  mgr: The ProcessManager service was started successfully.
2014-06-18 14:38:59  INFO    OGG-01338  Oracle GoldenGate Manager for Orac[......]

查看全文

postgres Synchronous replication 搭建

0

Posted on by

     Synchronous replication 其实就是同步复制,即意味着直到被主服务器和复制服务器均接收完事务时,事务才会返回给应用程序。这点就确保了即便在主服务器永久下线的情况下,任何已提交事务的数据都不会丢失。

    其实同步搭建和异步搭建只需要在主库上和备库上新增一个配置文件就可以了。

    异步同步搭建链接:postgres streaming replication 搭建

 

主库:

在postgresql.conf配置文件中新增:

synchronous_standby_names = 'mydb_standby'

 

备库:

在recovery.conf 配置文件修改:

primary_conninfo = 'host=192.168.1.11 port=5432 user=repuser password=repuser  keepalives_idle=60 keepalives_interval=5 keepalives_count=5'
​修改成
primary_conninfo = 'host=192.168.1.11 port=5432 user=repuser password=repuser application_name=mydb_standby keepalives_idle=60 keepalives_interval=5 keepalives_count=5'

注意:

      若开启同步复制,若一个 standby 节点 crash ,而又没有其它standby 节点顶上,那么主库上的所有操作将会被 HANG 住,直到备库恢复;主库才恢复正常,如果是很重要的业务,建议至少配置两个 standby 节点,提高高可用性。

 

 

 

postgresql 密码文件pgpass配置

0

Posted on by

远程备份或者登录时总要手工输入密码,导致效率很低。

postgresql可以通过密码文件来实现”无钥验证“。

在用户的根目录下,需要创建一个.pgpass文件,并将权限设置为0600,就可以实现了。

 

文件的格式如下:

hostname:port:database:username:password

 

演示:

1.psql登入

[postgres@oradbca ~]$ cd
[postgres@oradbca ~]$ touch .pgpass
[postgres@oradbca ~]$ vi .pgpass 
192.168.1.11:5432:postgres:postgres:postgres
[postgres@oradbca ~]$ chmod 600 .pgpass 
[postgres@oradbca ~]$ psql -h 192.168.1.11 -p 5432 -d postgres -U postgres
psql (9.3.4)
Type "help" for help.

postgres=# 

 

2.pg_dump备份

pg_dump -d postgres -h 192.168.1.11 -p 5532 -U postgres >back.dmp

 

3.pg_basebackup同步

在使用pg_basebackup时需要在.pgpass中增加一行 replication类型的

192.168.1.11:5432:replication:repuser:repuser

[postgres@oradbca ~]$ pg_basebackup -D /u01/pgdata -Fp -Xs -v -P -h 192.168.1.11 -p 5432 -U repuser
transaction log start point: 0/1A000028 on[......]

查看全文

第 4 页,共 12 页« 最新...234567...最旧 »