Database Administrator

To understand the Oracle architecture, you must first understand two basic concepts: databases and instances. I. Databases A database is a collection of data. Whether the database adopts a relational structure or an object-oriented structure, the

I haven't used Oracle for a long time. I almost forgot to install an oracle9i today. I used svrmgrl to start the service. Then I found out after I checked it online, svrmrl is the startup method of oracle8. It will be different after oracle9i. Alas,

1. In SQL, single quotation marks (''') are strongly recommended for strings (''''). Although SQL/Index.html "> MySQL can also use double quotation marks ("), we recommend that you use single quotation marks to ensure consistency with SQL Server and

After Apache + MySQL + PHP is installed in linux, phpMyAdmin is an excellent database management software. 1. Extract // Because the current server software is installed under/opt/, which are/opt/apache,/opt/mysql,/opt/php, therefore, the root

The following is my last test record.Mysql versions later than 3.23.15 provide the database replication function. This feature allows you to synchronize two databases, master-slave mode, and mutual backup mode.The settings of the Database

I learned to learn mysql on my own initiative. Of course, I had to install mysql before learning. So I went to the website to find it. I found a lot of articles, but they were a long article, let me see this. When can I see it? It is also a

The default capacity of the mysql table is 4 GB. When loaddata is used, an error occurs when the file load 2 GB. However, if the myd file is 4 GB, I don't know what is going on. Expand the table capacity first. First check the table status: show

Install mysql in Linux. MYSQL address: http://dev.mysql.com/downloads/mysql/4.1.html Yi. Install mysql 4.1.21 # Groupadd mysql # Useradd-g mysql # Tar-zxvf mysql-4.1.21.tar.gz # Cd mysql-4.1.21 #./Configure -- prefix =/usr/local/mysql --

According to the step-by-step installation of mysql under Fedora7, some problems occurred while installing mysql in Fedora 8. After finding the cause, I finally solved the problem. Remember. I download the latest

In the Like Query of MySQL, we find that Chinese search is always hard-earned. We have found several solutions on the Internet. You can refer to the following: Method 1: The solution is to add the "binary" attribute to a field that contains

Combination 1: MySQL + PHP + Linux/FreeBSD/SolarisCombination 2: Oracle + PHP + Linux Combination 3: Oracle +. NET + WindowsCombination 4: MySQL +. NET + Windows Solution:Build a LAN with two computers. A dedicated server provides database support.

Today, we found that the impdp command has a special purpose. You can migrate one user of the database to the user of the database on another machine. If the target user does not exist, you can create the user accordingly. The command format is as

Hello everyone! Today, I sorted out the steps for creating a physical volume uard for Oracle10g according to the official documents: 1.1 enable force logging Mode Use the following statement to enable the force logging mode for the master database

Today, outln disappeared for no reason, and no information was deleted from the alter log in the background. Cannot be created again Create user outln identified by outln * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-18008

Let's take a look at the two sections in the Oracle official document: (1) Can I change the public hostname in my Oracle Database 10g Cluster using Oracle Clusterware? Hostname changes are not supported in Oracle Clusterware (CRS), unless you want

This type has never been met before. I learned that someone asked me yesterday and I only studied it.Later, we found that the Oracle Data dictionary used this data type in many places, such as the addr field of v $ process.What type is this? I have

1. rawtohex, hextoraw Rawtohex indicates to convert raw data to a hexadecimal string (nvarchar type, Typ = 1), and hextoraw indicates to convert a hexadecimal string to the raw type.Note: If the hextoraw parameter is a string, it will be treated as

In the past few days, I have encountered this problem in Oracle several times. The scenario is not the same (note: the unit of Y on the title is KB ): 1. insert into table1 values (...) select (...) from table2 :( it will occupy temp tablespace. If

Download the installation patch p8202632_10205_linux-x86-64.zip for Oracle RACs. Patches for clusterware and database are included in this patch. 1. Upgrade the clusterware package 1) Stop all resources first. crs_stop-all is not recommended.

Oracle databases are favored by more and more enterprises for their high reliability, security, and compatibility. Many database administrators are concerned about how to maintain excellent performance of Oracle databases. Based on my experience, we