Hpux mcsg oracle 10.2.0.4 rac for storage image, hpuxmcsgA recent case:Status quo: hp-ux operating system, oracle 10.2.0.4 rac, mcsg mode, two ocr and three voting disks correspond to one lv in the same concurrent volume group.Objective: To create
ORACLE 11G Data Guard role conversion, 11 gguard1. ORACLE login uard Role SwitchingDataGuard is now the mainstream disaster tolerance solution. Due to its strong adaptability to the network, it can adopt synchronous real-time transmission mode and
Hadoop 2.2, hbase0.94.18 cluster installation, hadoophbase0.94.18 Here we install three clusters: Cluster ip Address: 192.168.157.132-134 Master: 192.168.157.132 Slaves: 192.168.157.small-134 Hbase depends on zookeeper for self-installation. 1.
Mysql client data garbled, mysql client garbled Garbled characters appear when inserting Chinese data into mysql: Mysql> select * from test;+ ------ + ----------- +| Id | name |+ ------ + ----------- +| 1 | why does one fail? || 2 | too many threads?
How does one count the number of online users per hour ?, Count the number of online users The system has a table that records user logon and logout logs. Now, the number of online users is measured in an hour. This is a mathematical problem. Case 1:
[Introduction to database systems] ---- relational database (1), Introduction to Database Systems2.1 relational data structure and formal definition A relational database system supports relational models. A relational model consists of three
Use of packages in OracleUse in Oracle The main purpose of using a package is to modularize the program. The package can combine the relevant stored procedures, functions, variables, constants, cursors, and other PL/SQL programs, in this way, code
T_ SQL rowtype, t_sqlrowtype T-SQL formats: Declare Statement Begin Processing End -- complete Nvl function nvl (string, value ); Returns a string if the string is not empty. Returns the value if the string is null. Enter a job
MySQL date types: DATETIME, TIMESTAMP, and datetimetimestampThere are three types of dates in MySQL5: DATETIME, DATE, and TIMESTAMP, except that DATE is used to indicate a DATE without time and second, and the other two have time and second.
Database Operations-triggers, databases-triggers A trigger is a special type of stored procedure. Unlike a stored procedure, a trigger is triggered by an event and automatically called for execution, the stored procedure can be called by the name of
Mybatis executes the query statement and can query data in plsql, but cannot be found in the program. mybatisplsqlWhen you use mybatis to query statements today, the SQL statements output by the console can be correctly executed in plsql, but no
2015 Xin Xing MySQL tutorial Spring edition fourth optimization modeling, Xin Xing mysql After some time, the fourth tutorial of the xinxing MySQL tutorial in 2015 was finally completed. It was positioned as modeling optimization. For example,
How to disable the deadlock process in PostgreSQL, postgresql Process The PostgreSQL database used has no information. Google had to proceed. Finally, a solution was found in an English forum. As follows: 1. Retrieve the ID of the deadlock
Drop goldengate user times ORA-00604 ORA-20782 ORA-06512 problems resolved, ora065121. Problem SQL> drop user goldengate cascade; When Drop goldengate user, the ORA-00604 ORA-20782 ORA-06512 error is reported, the specific error content is as
Oracle cursor introduction, Oracle cursor IntroductionOracle cursor Introduction The PL/SQL cursor in Oracle stores the data queried in the database in the memory as a temporary table. The cursor can operate on the data stored in the memory, one or
Oracle 11g adds a control file to the ASM disk, 11 gasm A Control File is one of Oracle physical files. It records the database name, data File location, and other information. The importance of the control file is that the database will go down
Hot modification of Redis configuration parameters and redis configuration parameters Redis uses configCommand to hot modify configuration item parameters without restarting. RedisIt is recommended that you do not restart the instance. A restart
Linux mysql regular backup and compression, linuxmysql 1. Check whether the mysql BACKUP command works. Create a backup directory under the var directory and a mysql directory under the backup Directory to store mysql backup files Cd to
Redis persistence-RDB working principle and problems, redis-rdb Working principle of Redis persistent RDB mode: Redis persistent RDB mode. Redis uses the copy on write mechanism of the fork command. When a snapshot is generated, the current
Redis persistence-RDB and Redis persistence-RDBRedis provides a RDB persistence mechanism, that is, to write data set snapshots in the memory to the disk at a specified interval.Advantages of RDB:1. In this way, there is only one file to back up the