NAV: SLTechnology News&Howtos > Database >

• 

  Cold standby of Oracle Database

  1. Writing backup script A backup mechanism implemented by operating system commands: cp and scp1.1 query the location of all files (data files, control files, parameter files, redo log files, password files) SYS@orcl11g > select name f

  2022-06-01 12:24:17 Views: 247
• 

  OGG upgrade runs ggsic newspaper Unable to find library & # 39. Libclntsh.so.11.1

  Our system is Oracle 10.2.0.5 for hp-ux ia64 11.31 established in 2009. At present, we need to create number verification. After successful docking, the old system is abolished, and the synchronous replication software used is Oracle Goldenga.

  2022-06-01 12:24:17 Views: 245
• 

  Cursor_sharing of the Oracle parameter

  Introduction to Cursor_sharing: this parameter is used to tell Oracle when cursors can be shared, that is, SQL reuse. The Cursor_sharing parameter has three values that can be set: 1), EXACT: generally speaking, the exact value is

  2022-06-01 12:24:17 Views: 212
• 

  Master-slave replication problem sharing of mysql5.7.19 version

  Today, learning to build mysql 5.7.19 version of MySQL master-slave replication encountered some holes, specific sharing: mysql's master-slave server is completed by cloning a virtual machine, resulting in uuids, like the need to modify the auto.cnf file on the slave.

  2022-06-01 12:24:17 Views: 220
• 

  Black Pot Man of mysqldump backup and recovery

  The company has lost data in the database these days, so we went to the operation and maintenance department to restore the database, but our engineer, after executing the restore command, prompted a syntax error and did not restore the database. Specific reason: due to syntax error during backup or specified directory does not exist, but in backup

  2022-06-01 12:24:16 Views: 202
• 

  MySQL master copy (detailed description of picture and text)

  First, to achieve the principle of master master replication, that is, data can be changed in both MySQL hosts, and the other host will also make corresponding changes. Smart, you may have figured out how to make it happen. Yes, it would be nice to merge the two master-slave replicas organically. It's just that we need to note when we configure it.

  2022-06-01 12:23:47 Views: 205
• 

  Oracle plsql 64-bit 32-bit connection is not open, unable to resolve various error ultimate solutions

  First of all, cancel the login, enter the pl/sql interface-tools-preferences, and secondly, you need to set the environment variable (add an ORACLE_HOME and modify the path in the original path, which is not modified, mainly to let everyone know why the environment variable is set). You are logging in.

  2022-06-01 12:23:46 Views: 226
• 

  MySQL master-slave synchronous deployment

  Master-slave synchronous deployment of 1, two mysql databases of the same version, one as the master database, and one as the master library to open binlog from the library master library to add log-bin=mysql-bin and server-id=1 to the [mysqld] module in the configuration file, be sure to make sure that the two

  2022-06-01 12:23:46 Views: 242
• 

  ORA-39097 ora-39065 ora-12805 error

  Today, when checking the automatic backup, I found that many databases were reported wrong. I hastened to check it. I had been reporting an error all the time, and I didn't know what the specific situation was. First check the error content ORA-39097 ora-39065 ora-12805 these three errors. Went to Google.

  2022-06-01 12:23:43 Views: 213
• 

  Sql date type

  Declare @ datetime datetime = Current_Timestamp, @ date date = Current_Timestamp, @ tim

  2022-06-01 12:23:43 Views: 205
• 

  Oracle for windows uses NFS remote backup to report errors O/S-Error: (OS 1326)

  Test windows database server version: windows server 2012R2 test windows NFS server version: windows server 2008R2 test oracle database version: oracle

  2022-06-01 12:23:43 Views: 273
• 

  Eleventh, MySQL trigger

  MySQL triggers, like stored procedures, are a piece of program embedded in MySQL. A trigger is an action triggered by time, including INSERT, UODATE, and DELETE statements. If a trigger is defined, when the database executes these statements

  2022-06-01 12:23:42 Views: 264
• 

  MongoBD Learning (2) client connection

  The mongo client is started by bin/mongo 0 and helps root@adela-vm:/opt/mongodb_simple#. / bin/mongo-- helpMongoDB shell version:

  2022-06-01 12:23:42 Views: 205
• 

  Fault handling of ORACLE 12C ORA-00312 redo

  1. Describe DB version: 12.1.0.2system version: 7.02, process 1, error report, the instance will be terminated abnormally as soon as the database is started: ORA-00312: online log 3 thread 1:'+ DATADG/ORC

  2022-06-01 12:23:42 Views: 268
• 

  MyCAT Source Code Analysis of Database Middleware-- Construction of debugging Environment

  Follow * * Wechat official account: [Taro's back-end cabin] * * benefits: RocketMQ / MyCAT / Sharding-JDBC list of all source code analysis articles RocketMQ / MyCAT / Sharding-JDBC

  2022-06-01 12:23:36 Views: 214
• 

  Remember the ORA-09925: Unable to createaudit trail file error in the process of building DG

  Today, when I was doing Oracle DG and writing initorcl, after the modification, sqlplus could no longer log in and kept reporting ERROR:ORA-09925: Unable to createaudit trail fileL.

  2022-06-01 12:23:23 Views: 279
• 

  Oracle series: (23) synonyms

  What is a synonym [Synonym] (1) for objects with longer names (tables, views, indexes, sequences,... ) subtract, replace synonyms with aliases (1) shorten the length of object names (2) facilitate access to other users' object creation corresponding to the salgrade table

  2022-06-01 12:23:23 Views: 230
• 

  Oracle RAC application PSU

  1. Either RMAN or expdp can be used to back up the database. 2. Backup software directory (node1/2) tar-czvf / u01/grid.tar.gz / u01/app/11.2.0/grid-- exclude=

  2022-06-01 12:23:23 Views: 290
• 

  CentOS 6 install mongoDB

  MongoDB installation and configuration step 1, go to mongoDB official website to download mongoDB database download version according to your operating system, mongoDB such as: mongodb-linux-x86_64-3.2.10.tgz step 2, install

  2022-06-01 12:23:23 Views: 280
• 

  Analysis of the difference between create table as and like in MySQL

  This article mainly introduces the difference between create table as and like in MySQL, and analyzes the specific differences and main uses of them with examples. Friends who need them can refer to them as follows: for the method of copying the same table structure of mysql, there are c

  2022-06-01 12:23:12 Views: 232