Database Administrator

Use the new Oracle RAC 11gR2 feature renamedg to change the diskgroup name Environment Description:AIX7.1 + dual-node Oracle Rac 11.2.0.3 Because this Rac is not installed by your own department, it is installed by the Development Department and is

Install MySQL 5.1.7 in RedHat Linux 5 Install MySQL 5.1.7 in RedHat Linux 5 [Root @ bkjia ~] # Cd/home/app/mysql[Root @ bkjia mysql] # ls -- ExtractMySQL-community-5.1.73-1.rhel5.i386.rpm-bundle.tar[Root @ bkjia mysql] # tar-xvf MySQL-community-5.1.7

Oracle not exists equivalence statement Not exists can be changed to left join + is null. It can be seen that the execution plan is the same before and after rewriting, and the resource consumption is the same, which means it is equivalent. SQL>

[Monogdb] MongoDB log system, monogdbmongodb I remember a friend who was checking mongodb logs a few days ago may not be able to locate the problem. Today, the system will talk about mongodb's log system. Mongodb has four types of logs. These are

OGG capture process stopped (OGG-01028), oggogg-01028 due to shift of archived logsThe user recently reported that the crawling process of OGG deployed on RAC Node 1 has been stopped for several days. You want to troubleshoot the problem and restore

Use pt-heartbeat to monitor master-slave replication latency and pt-heartbeat master-slave MySQL master-slave replication is an important part of the MySQL high-availability architecture. It can be used to achieve load balancing, high availability

Oracle profile query, oracleprofileDefinition of zookeeper configuration file SELECT profile_option_name configuration file name, user_profile_option_name user configuration file name, description, hierarchy_type hierarchical structure type,

Clean up junk tables for oracle 10G and oracle10 G An Oracle O & M experience that I learned and worked on is a pitfall step by step. Cause: a set of systems that have been running for five years have been slow to be reflected by customers in the

When a windows client is added to a domain, an error occurs: the DNS name does not exist. When a windows client is added to a domain, an error is reported: the DNS name does not exist. The specific error is as follows: -------------------- Note:

Notepad ++ changes the font size and color and notepad font size Many of my friends are new to notepad ++ and do not know where to set the font or how to set it.Tools/Raw Materials Notepad ++ Method/step Click Settings and select language

Mysql number generation, mysql number 1. Serial Number Generation Method DELIMITER $ create definer = 'root' @ 'localhost' FUNCTION 'get _ workno' () RETURNS varchar (45) CHARSET utf8BEGINDECLARE newWorkNo varCHAR (45 ); DECLARE currentDate varCHAR

At the beginning of oracle, Scott's account was locked. scottlock 1. First, you need to unlock the Scott account and enter alter user scott account unlock. Then, a prompt is displayed, indicating that the scott account has expired and the password

If the Java language in the backend JSP file operates the JGeometry object provided by Oracle Spatial, spatialjgeometry Write down a flow account and record how to solve this problem that has plagued you for a long time. At that time, I thought I

Use lvm-snapshot to back up the mysql database and lvm-snapshotmysql Prerequisites: Transaction logs and data files must be on the same volume; Before creating a snapshot volume, you must request the Global lock of MySQL. After the snapshot is

Oracle 11g system automatically collects statistics, oracle11g--- 11 GB is from Monday to Friday-Saturday-SELECT w. window_name, w. repeat_interval, w. duration, w. enabledFROM dba_autotask_window_clients c, dba_scheduler_windows wWHERE c.

MySQL database environment and simple operations, mysql database environment **************************************** ****************************************************** Original works, from the "Xiaofeng residual month xj" blog, welcome to

Mysql com. mysql. jdbc. StatementImpl $ CancelTask Memory leakage problem and solution, mysqljdbc Recently, I have been responsible for the maintenance and construction of the company's SMS gateway. As the company's business develops, the reliance

Hive UDF implementation and HiveUDF implementation Hive's own Query Language HQL can complete most of the functions, but in special needs, you need to write your own UDF implementation. The following is a complete case. 1. Compile UDF in eclipse①

Oracle instr function, oracleinstrSyntax:Instr (fatherstr, sonstr [, start_position [, matchtimes])Fatherstr: parent string, which is used to locate the position of the substring.Sonstr: string to be searched in fatherstr.Start_position: the start

Oracle Instanc Client installation command tool, oracleinstancPrerequisites 1. Linux RHEL 6.X X86_64 Operating System 2. Oracle-related files (same OS) can be obtained from the server where the Oracle server is installed)Software Download Download