Database Administrator

ORA-12154: TNS: unable to resolve the specified connection identifier resolved I believe that people who have used Oracle databases must have encountered the "ORA-12154: TNS: unable to resolve the specified connection identifier" error, I would like

Detailed analysis of high-availability Redis service architecture construction Memory-based Redis should be the most commonly used key-value database in various web development businesses. We often use it to store user login states (Session storage)

How to install Redis using yum in CentOS 1. Because the official CentOS yum source does not contain Redis, We need to install a third-party yum source. Here we use the epel repository of Fedora. Yum install epel-release You will be prompted to

MySQL official source cannot be started after direct yum upgrade from 8.0.3 to 8.0.4 Server Environment: CentOS 7.4.14 Problem: MySQL cannot be started normally View logs 2018-02-23T02: 10: 08.371209Z 0 [System] [MY-010116]/usr/sbin/mysqld (mysqld 8.

Oracle knowledge collection: monitoring and checking Oracle databases I sorted out some basic Oracle knowledge and shared it with you. 1. How to monitor and check Oracle databases Sqlplus '/as sysdba' Manually generate an oracle database

How to convert a json data key-value pair into a dictionary without quotation marks? json quotation marks Zookeeper recently met a website, and the returned data is disgusting. It is very troublesome to use regular expressions or other methods to

HP-UNIX installation Oracle PHCO-40381, hp-unixphco-40381First, we need to identify the HP processor.View machinfo The product number of pa-risc is set to rp, and the product number of itanium is set to rx. Different products need to download

Library cacheHandle stores the lock and pin information. In addition, both the Library cache handle and child cursor have lock and pin. These are called library cache lock and library cache pin. Library cachelock/pin is used to control concurrent

Original article address: Stairway to SQL Server Indexes: Level 2, Deeper into Nonclustered Indexes This article is part of the SQL Server Index advanced series Stairway to SQL Server Indexes. The first level introduces non-clustered indexes in SQL

Mysql master-slave synchronization error solution: This article is fromLinux O & M training for Old BoysSummary of internal teaching plan contentFAQ: Question 1: mysqldump: Got error: 1556: You can't use locks with log tables. When the old boy took

Installation and configuration After you reinstall DB2 in Linux, you cannot create an instance of DB2INST1, prompting that the instance already exists. Solution:Delete the/var/db2/v81 directory and recreate the instance; Cause analysis:Before you

For a system with massive data volumes, the performance bottleneck will eventually fall on the database. At this time, hardware upgrades and program optimization are powerless, A simple query may also impose a heavy burden on the database. Grid

If you have moved data from or out of SQL Server, you can now use the data transmission service tool of Microsoft or Microsoft. DTS is an ETL Tool (abbreviated for extraction, transmission, and loading). It allows database administrators to create a

With the SQL Server event probe tool, you can use a captured trace to collect important information about the Server. With the Index Tuning Wizard, ITW, Index OPTIMIZATION Wizard, and correct general Index information, this trail can help you debug

A database is a shared resource used by multiple users. When multiple users access data concurrently, multiple transactions can access the same data simultaneously in the database. If concurrent operations are not controlled, incorrect data may be

I made a C # And Oracle system, and it was really troublesome to install an Oracle client on each client. So I searched the internet and checked whether there was a method for not installing the client, oracle has long thought of this problem. He

1. Migration Method Introduction: Exp/imp: This is also the most commonly used and simplest method. It is generally based on the application's owner level for export and import. Operation Method: Create the owner and tablespace in the new database,

The statement for creating a user with Complete Oracle Database User management and data import and export is as follows: CREATE USER IDENTIFIED BY DEFAULT TABLESPACE TEMPORARY TABLESPACE

OOP concepts in Oracle:Object Type, variable array, nested table, object table, and object view. Object Type: Advantages: 1) it is easier to interact with object applications written in Java and C ++. 2) easy to obtain. An object type request can

NetApp FilersIt is certified by Oracle, Sybase, DB2, and other large database vendors and has been widely used by Fortune 1000 companies to enhance and simplify data storage and read performance. NetApp Filers complies with the standard hardware and