Database Administrator

If you have installed Oracle9I and then installed ORACLE10G, you can use TOAD or PLSQL Developer When you select a tool, the SERVICES Service of 9I Database is blocked. So how can we make two ORACLE databases coexist peacefully? Let's take a look

The Helper house sorted out several methods circulating on the Internet to crack the mysql root Password: Method 1 Use phpmyadmin, which is the simplest. Modify the user table of the mysql database, but do not forget to use the PASSWORD

MySQL suddenly becomes unavailable. In the end, it is found that there is no space for/var in Linux, and the usage rate is 100%. No way, you can only move the database file to another partition. After moving the data file to another partition in

Principle:In Linux, MySQL Databases belong to/var/db/mysql or other directories. A directory is a database. Therefore, you can obtain the database size by checking the directory size to determine whether the capacity has exceeded the limit. If the

Problem description: mysqlcc is installed in Federo8 but garbled characters appear after the database is opened. However, as far as I know, mysqlcc supports GBK Simplified Chinese. This problem does not occur in windows. At first, I suspected

Sometimes the database is damaged due to power loss or other reasons. We can use the MySQL command to quickly fix all databases or specific databases. For example Check to optimize and fix all databases: # Mysqlcheck-A-o-r-pEnter password:Database1

If Oracle is installed first, and tomcat is installed again, open the default tomcat (TEST) webpage: http: // localhost: 8080. An oracle "fliggy" is displayed in the test result ", without the apache "cat ". generally, the current tomcat port is 8081

Installation environment: RedHat Chmod 755 mysql-5.0.45.tar.gz# Tar-zxvf mysql-5.0.45.tar.gz-C/usr/src/# Mysql-5.0.45/cd/usr/src/#./Configure -- prefix =/usr/local/mysql -- with-charset = gbk -- localstatedir =/usr/local/mysql/data# Make# Make

/*** Modify the session storage mode to Mysql Aboc QQ: 9986584*/ Class Session { // Expiration timePrivate $ _ LEFT_TIME = 1440; Public function open (){ } Public function close (){} /*** Read*/Public function read ($ sessid ){$ SQL = "select data

It is useful for configuring MySQL Databases today. Download the latest phpMyAdmin MYSQL manager, Decompress the package and obtain a phpMyAdmin directory (you can change the name to ensure security, otherwise your FTP password must be strong) Find

Install MySQL on Fedora 10 Create group/user:$/Usr/sbin/groupadd mysql$/Usr/sbin/useradd-c "MySQL Software Owner"-g mysql$ Passwd mysql Install mysql$ Su$ Yum install mysql-devel mysql-server mysql-administrator Start the server$/Etc/init.

I recently studied MySQL 5.6 and found that I cannot log on to MySQL with a blank password after installation. The installation process includes the following sentence: A random password has been set for the MySQL root USER! You will find that

The mysql official website began releasing various versions of the 5.6 series starting in May,. the mysql series versions have been comprehensively refined, the following is a sharing record of the mysql5.6.10 source code installation process

We know that there are two types of Oracle block clearing: 1: fast commit cleanout ); 2: delayed block cleanout ); There is an overhead space (overhead) at the beginning of the database block, which stores a transaction table for the block. For each

Error Report: SQL error: ORA-01688: Table JINRILOG. USEROPERATELOG partition P1 cannot be extended through table space JINRILOG 01688. 00000-"unable to extend table % s. % s partition % s by % s in tablespace % s" * Cause: Failed to allocate an

Summarize and organize yourself: 1. Check the registry, Oracle_Home under HKey_LocalMachineSoftwareOracle. If not, change it to correct; 2. uninstall ODP. net (or uninstall ODT. net, ODT contains ODP, ODT is. net is an integrated plug-in for

I. Concepts Hibernate and Apache OJB: "one-stop" ORM Ibatis: A "semi-automated" ORM implementation. That is to say, ibatis will not automatically generate SQL Execution for programmers at runtime. The specific SQL needs to be compiled by the

Control File ExperimentA maximum of 8 control files and at least 1 are mutual images. If the control file is lost, the database cannot be shut down normally and cannot be started.// Add a control file. The original control file must be added. Note

Environment setup Machine descriptionMaster 190: 192.168.1.190 (enable binlog, server-id = 1)Slave 191: 192.168.1.191Slave 192: 192.168.1.192MySQL 5.5.29 and Percona XtraBackup 2.06 are installed on all the above three machines. Create a new Slave

It's not really good to read the doc carefully. SQL> shutdown immediateThe database has been closed.The database has been detached.The Oracle routine has been disabled.SQL> startup mountThe ORACLE routine has been started. Total System Global Area 10