NAV: SLTechnology News&Howtos > Database >

• 

  Related Technology of Oracle Database

  There is an Oracle company's Oracle database, mysql database, Oracle EBS12.2.6,OGG,RAC,DG and other related technical articles, please refer to the personal blog: https://www.youdba.com

  2022-06-01 08:30:16 Views: 228
• 

  Ssh-keygen secret-free login

  Ssh-keygen secret-free login ssh secret-free login experimental environment: centos6.5 [oracle@xuegod72 ~] $ssh-keygen key generation command Generating public/private r

  2022-06-01 08:30:10 Views: 273
• 

  Development performance Evaluation of OpenNMS and Zhihe Network Management platform

  With the increasingly large and complex structure of the network system, it is necessary for operators to use a set of network management system to manage the network conveniently and quickly. In order to better manage all kinds of equipment and facilitate troubleshooting in the network, the company needs a network management software that meets the needs. At present, there are many network management software on the market.

  2022-06-01 08:30:10 Views: 227
• 

  ORA-27125: unable to create shared memory segment

  Operating system environment: CentOS release 6.7 (Final) database version: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0

  2022-06-01 08:30:07 Views: 278
• 

  Redis (1) installation configuration

  About Redis Redis (REmote DIctionary Server) is an open source log-type Key-Value database written in ANSI C language, complying with BSD protocol, supporting network, memory-based and persistent, and mentions

  2022-06-01 08:30:06 Views: 277
• 

  Some tests on dynamic monitoring

  An experiment was done yesterday, and the environment is like this: establish a static listening port 1526 and a dynamic listening port 1521, and connect with two kinds of connection strings in tnsname. There is no problem for the static connection strings to connect directly, but the dynamic connection strings are later.

  2022-06-01 08:29:53 Views: 265
• 

  Mysql master-slave replication-- one master and one slave

  1. Start instances 3306 and 33072, and check the main database configuration [root@client 3306] # egrep "log-bin | server | sock" my.cnfsocket = / data/3306/mys

  2022-06-01 08:29:53 Views: 267
• 

  Delete all records in the table using the delete from table name; or use the truncate table table name

  Delete method: delete delete one item at a time. Truncate deletes the table directly and rebuilds the table. The transaction controls DML, while delete belongs to DML. If in a transaction, delete data, the data can be retrieved. Truncate delete

  2022-06-01 08:29:53 Views: 296
• 

  Configure mairadb using mysqladmin Management

  MariaDB database management system is a branch of MySQL and is mainly maintained by the open source community. The purpose of licensing MariaDB with GPL is to be fully compatible with MySQL, including API and the command line, making it an easy replacement for MySQL. Mysql

  2022-06-01 08:29:53 Views: 209
• 

  Cache penetration problem

  one。 Cache penetration (a large number of requests for data cache misses): cache penetration refers to querying a data that must not exist, because the cache misses, and for fault tolerance, if the data cannot be found from the storage layer, it is not written to the cache. This will cause this non-existent data to go to the storage layer every time.

  2022-06-01 08:29:40 Views: 233
• 

  AIX file system expansion

  1. The utilization rate of BAK space and log space of target C server has exceeded 80%. It is planned to apply for file system expansion 1, application / sybase expansion 2, application / tran expansion solution: 1. / sybase file system uses local disk space to expand capacity; 2.

  2022-06-01 08:29:32 Views: 215
• 

  Primary and primary replication in passive mode

  Master-master replication in passive mode means that two servers have the same status, but one of them is read-only, and only one server is written in the business. Method, add read-only=1 to the configuration of one of them: benefit: if the server for writing fails, it can quickly switch to the

  2022-06-01 08:29:32 Views: 290
• 

  Mariadb utility feature 1 kill user xxx

  Practicality in operation and maintenance work, we often encounter when we need to kill a user, MySQL does not have the function of direct Kill user, but mariadb has this function for a long time, which is really so sweet and of high practical value. two。 Let's get to work, tough.

  2022-06-01 08:29:17 Views: 220
• 

  Oracle alias case-solution

  Today, when you do the treeview of bootstrap, you are required to input node ID id, parent node ID pid, text text, but the executed sql aliases are all uppercase, so the problem code of how to lowercase the alias of orcl is as follows: SELECT T.F

  2022-06-01 08:29:17 Views: 298
• 

  Installation of redis under linux

  Installation environment: linux:centos6.9 64-bit redis version: redis-4.0.2.tar.gzRedis installation redis official website address: http://www.redis.io/ the latest version is 4.0.21

  2022-06-01 08:29:17 Views: 210
• 

  Create database instance silently by DBCA

  Several Oracle databases of the development environment have been installed in the past two days, of which version 11.2.0.4 and version 12.2.0.1 are also available. Due to the complexity of the network environment, there is no way to install it using a graphical interface, so we can only install it silently. I have written about silently installing the database before.

  2022-06-01 08:29:07 Views: 273
• 

  Redis installation

  Yum install-y wget gcc make tclwget http://download.redis.io/releases/redis-3.0.2.tar.gztar zxvf re

  2022-06-01 08:29:07 Views: 281
• 

  Springmvc Classic tutorials (2)

  Springmvc tutorials Series Best tutorials in springmvc History (2) Best tutorials in springmvc History (1) Best tutorials in springmvc History (3) Best tutorials in springmvc History (4) one, integrate mybatis for better

  2022-06-01 08:29:07 Views: 226
• 

  How oracle modifies individual user passwords that never expire

  The password expiration rule of Oracle is managed by Profile. By default, there is only one Profile (DEFAULT) in the system, and the password expiration rule of this profile is 180 days. All users use the profile of this DEFAULT.

  2022-06-01 08:29:07 Views: 217
• 

  Dealing with the problem of connecting predis to redis sentinel

  There are three web servers for load balancing. One of them failed to connect to redis. The error message is as follows: Predis Fatal Error: No sentinel server available for autodis

  2022-06-01 08:29:06 Views: 217