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

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

Check whether the system is started with pfile or spfile.Select isspecified, count (*) from v $ spparameter group by isspecified;If true exists in isspecified, the specified configuration is performed with spfile.If all values are false, pfile is

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

You need to enable user permissions in Ubuntu7.10 and bind them to the mysql local machine. 1. Open the user permission under the command line: grant all privileges on drupal. * to user@192.168.1.80 identified by 'user-password '; On the

1. mysql remote connection is slow or cannot be connected at all 2. log on to the mysql console locally and show processlist. Many processes are displayed, similar | 145 | unauthenticated user | 61.129.57.158: 1672 | NULL | Connect | NULL | login |

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

Select for update knowledge An application that sends an email will fetch unsent emails from the database and send the emails each time slice. After the application succeeds, it will change the mail ID in the database to "sent. This application is

/*** 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

Let's first look at the Python connection MySQL code: #! /Usr/bin/env python#-*-Coding: UTF-8-*-# This statement tells python to use UTF-8 Encoding#===================================================== =======================================

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

Rman is a problem for beginners, but it is also true for me. So here I will summarize the problems I encountered during the use of rman and provide a solution. I hope to give some valuable experience to those dishes that are the same as me.  1. The

Problem description: Oracle error 1691 is reported when data is imported through imp today. ORA-01691: Lob segment MID. SYS_LOB0000032765C00002 $ unable to scale through 1024 (in tablespace MID) Cause of the problem: I searched for it on the

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

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

In this case, you have previously copied and restored all files under/u01/app/Oracle. to delete an existing database, it is found that the delete database option in dbca is gray. But there is actually a database, so I suspect that the configuration

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

The MySQL master-slave replication structure is based on the mysql bin-log. The slave database receives the bin-log incremental information of the master database by opening the IO process and saves it to the local relay log, then, the incremental