oracle job之前还可以自动执行，后来不能自动执行？ 通过ps -ef |grep ora_j查看oracle 的job进程，未发现相关的job进程；[oracle@ncb1dg ~]$ ps -ef |grep ora_joracle 13527 24508 0 15:13 pts/4
mysql远程连接时提示失败 [root@mysql ~]# /usr/local/mysql/bin/mysql -ubackup -p123456 -h 192.168.6.36Warning: Using a password on the command line interface can be insecure.ERROR 1045 (28000): Access denied for
ERROR 2006 (HY000) at line ***: MySQL server has gone away 对策 MySQLSQL ServerSQL.netWindows .原因分析： 1.执行批量的MYSQL语句，例如备份恢复的时候，时间过长。 对应：修改my.cnf中的wait_timeout和interactive_timeout变量 #对当前交互链接有效；mysql>se
ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_cr
一台linux下oracle DG搭建standby：物理Standby ····· 与primary 库结构一模一样，提供灾备,减少IO/CPU 占用 (灾难恢复高可用性)逻辑standby ····· 与primary 库结构不同(可以创建除primary库存在的索引..) (灾难恢复高可用性/业务需求#ddl/dml) 物理stand
通过rman备份不关库做dg 假设主库db_unique_name=orcl 备库db_unique_name=orcl21.主库归档目录，以oracle用户建立[root@orcl ~]# su - oracle[oracle@orcl ~]$ cd /u01/oracle/oradata/orcl/arclog/[oracle@orcl ~]$ mkdir prmlog&
单实例数据库多日志线程，搭建ogg,启动抽取进程时提示一下错误：ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, extjms.prm: The number of Oracle redo threads (2) is not the same as the number of checkpo
Copyright © 2005-2024 51CTO.COM 版权所有 京ICP证060544号
