NAV: SLTechnology News&Howtos > Database >

• 

  Problems with automatic stop and unable to start of oracle monitoring service

  Description: the monitoring service is inexplicably terminated and must be started manually. There are a lot of information about this problem on the Internet, to sum up, there are the following points: 1, the address uses the hostname, and the problem can be solved by modifying the Host file and monitoring file. 2. Firewalls do something wrong. 3. The optimization function of security software is at fault. 4 、

  2022-06-01 21:15:20 Views: 218
• 

  An example of log file switch (archiving needed) waiting event

  First, environment description Oracle 11g RAC second, problem description customer execution batch processing can not be completed for a long time. 3. Problem handling process 1. Check the waiting event SQL > select inst_id,event,count (*) from gv$

  2022-06-01 21:15:19 Views: 283
• 

  The solution of invalid up and Down Keys in sqlplus

  Environment: centos 6.0_x64oracle version: 11g step: wget http://utopia.knoware.nl/~hlub/rlwrap/rlwrap-0.30.tar.gztar zxv

  2022-06-01 21:15:19 Views: 240
• 

  JDBC

  Notes for batch insertion: add a conn.setAutoCommit (false) when you create a new Connection, add a stat.addBatch () after each row of data is assigned, and finally stat.executeBatch ()

  2022-06-01 21:15:19 Views: 248
• 

  Mongodb CRUD Action-INSERT

  / mongod2018-04-15T18:52:36.352+0800 I CONTROL [initandlisten] MongoDB starting: pid=36578 port=

  2022-06-01 21:15:18 Views: 299
• 

  Mysql (1) addition, deletion, modification and query of Mysql database

  Mysql database addition, deletion, modification, query and addition: create database DBname charset gbk; deletion: drop database DBname; change: alter database DBname char

  2022-06-01 21:15:15 Views: 286
• 

  Redis installation configuration 3.2.9

  Install, download, extract, compile: # wget http://download.redis.io/releases/redis-3.2.9.tar.gz# tar xzf redis-3.2.9.tar.gz# c

  2022-06-01 21:15:15 Views: 277
• 

  Row lock of InnoDB transaction lock-insert unique secondary index duplicate key locking case

  1. Table structure CREATE TABLE `t3` (`id` int (11) NOT NULL, `id2` int (11) DEFAULT NULL, `id3` int (11) D

  2022-06-01 21:15:12 Views: 240
• 

  MySQL authorized users and password recovery settings

  MySQL password recovery and setting 1. Stop the MySQL service program. two。 Skip the authorization table to start the MySQL service program skip-grant-tables (added in the configuration file) 3. Reset root password (update user record) 4. Restart in a normal manner

  2022-06-01 21:15:11 Views: 229
• 

  Oracle 12c R2 silent installation

  1. Enlarge the switching partition dd if=/dev/zero of=/tmp/mem.swap bs=1M count=4096/sbin/mkswap / tmp/mem.swap/sbin/swapon / tmp

  2022-06-01 21:15:08 Views: 302
• 

  Recommend dozens of books for DBA study

  The following dozens of books are read by individuals in four years, which are very helpful to work and study, and are recommended to you.

  2022-06-01 21:15:08 Views: 221
• 

  The OGG mgr process could not start problem resolution

  When migrating the database, there is a strange problem. When running in ogg, the start mgr interface prompts mgr to be running, but use the info all command to check the mgr process or stop status, and then go to the dirrpt directory to check the mgr process.

  2022-06-01 21:15:07 Views: 256
• 

  12c Cannot Start Database Due to Flashback Enabled

  Delete all flashback logs in simulated failure scenario, restart database instance 1, delete flashback logs ASMCMD [+ datadg/orcl] > cd flashbackASMCMD [+ datadg/orcl/flashback] >

  2022-06-01 21:15:07 Views: 239
• 

  NoClassDefFoundError:....KeyedObjectPoolFactory

  When java configures JDBC, there is an error using connection pooling NoClassDefFoundError: org/apache/commons/pool/KeyedObjectPoolFactoryException in

  2022-06-01 21:15:07 Views: 259
• 

  AOF data persistence (theory)

  Persistence principle: AOF binaries have better persistence than RDB. Redis appends every write command received to the end of the file through the write function, similar to msyql's binlog. When redis is restarted, it will be guaranteed by re-executing the file.

  2022-06-01 21:15:06 Views: 242
• 

  SPH00000562 found that the carry-over was 90% less.

  -- check whether the carryover quantity is incorrect select shqjzhshl,cwjcsl+cksl-bqrsh,bqrsh-cksl, from ymjzhk where spid='SPH00000562' or

  2022-06-01 21:15:06 Views: 224
• 

  MongoDB fragmentation (Cluster)

  Basic environment: due to the shortage of resources, there are only three virtual machines, and only two replicaSet are made. The configuration of each machine is as follows: 10.10.1.55 this machine installs Primary1,configServer1 and Arbiter110.

  2022-06-01 21:15:06 Views: 251
• 

  Grid mutual trust failure in rac environment of HP system

  [grid@node01 grid] $/ home/grid/grid/runcluvfy.sh stage-pre crsinst-n node1,node2-fixup-verbose first

  2022-06-01 21:15:05 Views: 290
• 

  Oracle10g flash database (Flashback Database)

  The emergency switching exercise of the disaster recovery system should be done in production, and the disaster preparedness terminal is built by OGG. Since the production library is larger than 10 T, I do not want to reinitialize the disaster recovery library after the drill. The production library version is 10.2.0.4, so I think of the new feature flashback databas of 10g.

  2022-06-01 21:14:35 Views: 257
• 

  Oracle manual hot standby

  Sys@newtestCDB > archive log list;Database log mode Archive ModeAutomatic archival EnabledArchive des

  2022-06-01 21:14:35 Views: 221