Database Administrator

Oracle 11.2.0.2 solve INS-35354 when RAC is installed When installing an Oracle 11.2.0.2 RAC database today, the INS-35354 problem occurs: Because the GI of 11.2.0.2 has been successfully installed, and all the status of the Cluster is normal, this

Install MongoDB on CentOS7 Install MongoDB on CentOS7 1. Connect to the CentOS7 server through SecureCRT; 2. Go to the/usr/local/directory:Cd/usr/local 3. Create the tools directory in the current directory:Mkdir-p tools 4. Go to the tools directory:

MySQL defines the exception and exception handling methods, and MySQL defines the handling methods In MySQL, specific exceptions must be handled. These exceptions can be associated with errors and general process control in subprograms. Defining

Detailed examples of PHP operations on MongoDB databases (add, delete, modify, and query) (6). mongodb DatabasePHP operations on mongodb:Modules are required for PHP to operate mongodb.Official website can download: http://pecl.php.net/package/mongo

Oracle goldengate bi-directional active-active configure 1. Install the golden gate software. After creating the installation directory, decompress it under the directory. (Both the source and target are executed)Note: We recommend that you use

It may be an ignored update Statement (update technique) or an update statement Well, I 've written a simple article again, and I hope you will not be enlightened. This time I want to talk about the update statement in SQL. Speaking of this, there

Repeat the library cache lock wait event in Oracle 11 GB, 11 glibrary From the example below, we can see that re-Compilation of objects in the production database will lead to library cache lock, so we should try to avoid compiling objects during

ORACLE converts data between milliseconds and dates, and oracle converts data between milliseconds. Convert millisecond to date SELECT TO_CHAR(1406538765000 / (1000 * 60 * 60 * 24) + TO_DATE('1970-01-01 08:00:00', 'YYYY-MM-DD HH:MI:SS')

1. Result Set Caching description   For instructions on the Oracle official website, refer: 7.6 Managing the Server and ClientResult Caches Http://docs.oracle.com/cd/E11882_01/server.112/e16638/memory.htm#BGBCABED   1.1 Overview You can enable

[Mysql] After windows is reinstalled, mysql and "Access denied for user 'root' @ 'IP'" are restored. mysqldenied Mysql databases are actually green software and can still be used after the system is reinstalled. 1. Reload the system and keep the

How to convert Access to SQL database, and convert access to SQL database First of all, I am talking about the conversion between ACCESS2000 and SQL2000, and I have not tried any other products yet. I hope you can experiment more and there is

ADO. NET database access technology, ado.net Database Access 1. Definitions of ADO. NET ADO. NET comes from the COM Component Library ADO (ActiveX Data Objects), is a new generation of Microsoft. NET database access model, which is currently used by

1. Import CSV data The content of the user.csv file is as follows: _ Id, name, ageObjectID (4eed9f9ca939118694cf05e4), "ming", 10ObjectID (4ef1f3cf3bd18218e6bdfa31), "lisi", 20   You can import the data in user.csv to the user set of the localdb

The server Load balancer of the Oracle RAC server distributes new connection requests to the node with the smallest load based on the number of connection loads of each node in the RAC. When the database is running, the PMON process of each node in

MySQL encoding format. mysql modifies the encoding format. I. Problem Introduction When mysql is installed, the encoding format is configured as UTF-8. Therefore, mysql character_set_client, character_set_connection, character_set_database,

1. First, you must understand what an execution plan is? An execution plan is a query solution made by the database based on the statistics of SQL statements and related tables. This solution is automatically generated by the query optimizer, for

What is the close method of java. SQL. Connection? (take MySQL as an example), connectionclose Reprinted please indicate the source:Http://blog.csdn.net/aheeoheehahee/article/details/42641601 I would like to send this article to a programmer who has

I. background DB2 joint database is a special form of distributed database management. In the federated database system, you can use an SQL command to send command requests to multiple data sources. Before copying data between DB2 and non-DB2

The following example shows how to use a MySQL client to install a new user. These examples assume that the permission has been installed by default. This means that, in order to change, you must be on the same machine that MySQL is running, you

Database partitioning is one of the key functions required by each database. Almost all Oracle databases use the Partition Function to improve query performance. The Oracle 11g Partition Function simplifies the daily management and maintenance of