Database Administrator

Oracle 11 Client installation file: Download the following files from www.oracle.com: Oracle-instantclient-sqlplus-11.1.0.1-1.i386.rpm Oracle-instantclient-basic-11.1.0.1-1.i386.rpm 1> install the oracle 11 client in Linux # Rpm-ivh

I wrote something in my blog on Ubuntu for the first time. I haven't updated it for a long time. Come here today. The first thing we need to consider when installing Oracle-xe-client is whether the swap partition is large enough,This system does not

After a whole day, I got more information by referring to n. Finally, I got it !!!!!!! To separate MySQL installation programs from data files in Linux, the first problem is the configuration during installation, . /Configure -- prefix

This section describes how to install, configure mysql-data1.mytest.com, and mysql-data2.mytest.com In Ubuntu. Install MySQL Install the MySQL server on both the mysql-data1 and the mysql-data2: $ Sudo apt-get update install mysql-server During

MySQL does not have a flashback mechanism for Oracle. After you execute drop table xxx, this table is permanently deleted. You can only recover from the backup. If you do not have a backup, then you can only cry. This article provides a way of

I have installed the Oracle 10 Gb database on a Linux Virtual Machine. How can I access the remote plsql? I have created an orcl instance. How can I connect the remote plsql to my instance? Use TCP to configure the TNSNAMES. ORA file to support

(1) Check whether MySQL 3306 is open to the outside world. By default, MySQL does not provide the external access function. The method is as follows: 1 ~ # Netstat-an | grep 3306 2 tcp 0 0 127.0.0.1: 3306 0.0.0.0: * LISTEN It can be seen from the

Today, with the help of the instance for configuring Oracle database connection, we will learn one way to read xml files (other reading methods will be introduced later)-using dom4j + xpath. Dom4j is an open-source XML parsing package produced by

This version still does not solve the problem that dynamic libraries cannot be compiled. What are the nerves of MongoDB? It turns out that the two bypass methods will not work either. Only static databases are used. Download and compile the latest

Project Background: The original database server runs on the HP DL388G7 server with 32 GB memory. Due to business growth, the memory is tight, and server hardware faults occur from time to time. As a single instance and single server, spof is

To test how to store video files in mysql DATA, we do not recommend that you store them directly, because migration is troublesome and prone to problems. The following is only a test function, importing jpg, png, and other images is similar. Create

Reference data is not available for verifying prerequisites on this operating system distributionVerification cannot proceed Run runcluvfy. sh in the environment before installing grid on Oracle linux 6.4. the following error is reported: [Oracle @

MySQL initial Account Management The initial MySQL account is as follows: [Root @ lx16 ~] # Mysql-u rootMysql> select host, user, password from mysql. user;+ ----------- + ------ + ---------- +| Host | user | password |+ ----------- + ------ + ------

After the environment is set up, enter the command proc in the terminal If the following error message is displayed: [Oracle @ oracleserver ~] $ ProcProc: error while loading shared libraries: libclntsh. so.10.1: cannot open shared object file: No

-- ======================================-- Oracle listener log configuration and management-- ====================================== The Oracle listener is a server program used to listen to all requests from the client and provide database

After half a month of configuration and learning about the physical standby database of Oracle replicaset uard, although the version uses Oracle 11g (11.2.0.3), the configuration process still applies to Oracle 10g. During the last 10 dataguard

Postgresql has added the External table access function since 9.1. This function allows the database to directly read files other than the database, such as csv or text files. DML is not supported for the moment. Postgresql has various plug-ins that

1. Compare the size function SIGN Sign (x) or Sign (x) is called a symbol function. Its function is to take a certain number of symbols (positive or negative ):When x> 0, sign (x) = 1;When x = 0, sign (x) = 0;When x X can be a function or computing

Rowid is literally interpreted as a row ID. In Oracle, rowid is the fastest and most effective way to locate records. So how does rowid locate the record in oracle? And why is it the most effective way? With these problems, let's unveil the mystery

The Oracle Database Import and Export tool can use exp/imp, but this is an earlier tool. This document describes how to use the data pump expdp/impdp tool. Create a Data Pump directory To use the data pump, you must first create a directory Create