Database Administrator

The Helper sorted out the following knowledge about Oracle databases in Linux for your reference! Installing Rose for Linux Oracle Install oracle 9.2.0.04 [Oracle @ whdata1 install] # cd Disk1 [Oracle @ whdata1 Disk1] #./runInstaller 1. The

In the actual working environment, if you Truncate several data dictionary tables in the database during operation, the database will no longer be available, this article will give a detailed explanation of a related case. The example is as follows:

Recently, I found that the connection to the database in the new column is very slow. I log on to the MySQL database. Mysql> show processlist; | 20681949 | unauthenticated user | 10.10.4.193: 52497 | NULL | Connect | Reading from net | NULL | | 20

I have forgotten the default sysman password when I use a three-tier Oem. Do I need to reconfigure the database? Of course it is not that troublesome. This article provides a simple method to restart the sysman password. Environment:Oracle

I remember when I got the WIKI website during my internship, the time displayed on the server was Greenwich Mean Time (eight hours slower than Beijing time, data collection on the Internet has not been resolved. Later, I found some information on

There are many formatting tools in the Oracle database to improve the readability of the results. Our database design and software development are well-rounded. For example, it is an employee salary table in the employee salary management module.

Oracle listener log file (usually called listener. log) is a plain text file whose size keeps increasing. On a production Oracle Server, DBA checks the file daily, such as checking whether the listener has an abnormal stop, whether there is a

Oracle announced the donation of data integrity code to Linux kernel. The Code was developed by Oracle and Emulex in cooperation and has been accepted by 2.6.27 kernel. The Code adds metadata to the static and transmitted data to monitor whether the

Basically, mysql has two major problems.1. There is no problem starting mysql for the first time. After you perform some operations on mysql, especially after deleting some accounts in mysql, you will encounter such problems when you restart mysql.#/

Confusion between space and empty string query in MySQL In MySQL, if the value of an Element in a string-type field is a null string or space, a problem may occur during query. Execute Java code Select * from table where Element = ''or Java code

When you create a unique constraint before creating a primary key constraint, if you use a common method to delete the primary key constraint, the unique constraint index will not be deleted, which is a PROBLEM of Oracle 10 Gb. This article uses an

The first time I came into contact with the Server version of Linux: Ubuntu Server 12.04, it was also the first time I installed binary mysql with command lines. It took two days and one night to get started. Leave for memo! First download the

1. When using Oracle, Oracle can run normally by starting OracleServiceORCL and OracleOraDb11g_home1TNSListener; 2. To allow hosts on the LAN to access your oracle database, you must start the oracleora81homemanagermentserver service. 3. Oracle

Oracle Bug 6136074 encountered at work, a bug of 10203, is the first time this problem was encountered. On 10.2.0.3, a bug may cause compilation or view failure. The failure may not only result in unavailability of the current view or process, but

Recently, the system has to "scale down" because I don't want to say much about it. It is a very troublesome thing because we need to compress and store data. It has nothing to do with the operating system. It mainly refers to Oracle Data. Oracle

1. Create a TNS string:Zqxt =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP) (HOST = 132.97.172.186) (PORT = 1521 )))(CONNECT_DATA =(SERVICE_NAME = ora11g)))2. query the tablespace SQL of remote data: 1) select distinct 'select

Today I found that an Oracle Test Library character set is incorrect, the original character set is UTF-8, the correct character set should be ZHS16GBK, because the UTF-8 is the superset of ZHS16GBK, can not be modified, can only re-build the

Xtrabackup is an open-source project of percona. It supports hot backup of innodb, XtraDB, and MyISAM (locks the table)The MyISAM storage engine locks tables and is also very depressing because Innodb and MyISAM storage engines are used online,

Delete Oracle 11g R2 in Linux 6.4 Close DatabaseSQL> shutdown [immediate] Stop Listener[Oracle @ ora920 oracle] $ lsnrctl stop If an application service exists, stop the application service first.[Oracle @ ora920 oracle] $

Objective: To migrate an Oracle database from one machine to another machine (the same as a linux platform) and set it to a different path and Instance nameSource end:ORACLE_BASE =/u01/app/oracleORACLE_HOME =/u01/app/oracle/product/10.2.0/db_1ORACLE_