Database Administrator

Troubleshooting of ORA-06502 errors reported by sqlplus Logon I recently encountered a sqlplus login error. I was wrong at the beginning of troubleshooting. I had to ask Master dbsnake for such a small problem, it solves the problem like "Mr. Luo

Resolving MySQL time conversion exceptions To connect to the MySQL database, an exception is thrown by default when the timestamp type with an operation value of 0 cannot be correctly handled:Java. SQL. SQLException: Cannot convert value '2017-00-00

The user smsdb in Oracle cannot log on to LOCKED (TIMED) A user created by smsdb to view the status LOCKED (TIMED) After unlocking, conn smsdb/password still reports an error and is locked again. It is found that the number of wrong logins reaches

MySQL accidentally deletes the InnoDB data file for restoration Error reproduction:Use rm-f ib * to delete data files and redo log files. At this time, the mysql process still exists and mysql can still be used normally. File recovery:1: Find the

MySQL 5.6.26 mistaken deletion of ibdata for restoration MySQL 5.6.26 mistaken deletion of ibdata for restoration [Root @ hank-yoon ~] # Ps-ef | grep mysqlRoot 1129 1 0 00:00:00 pts/0/bin/sh/export/servers/mysql/bin/mysqld_safe -- datadir

Summary of Datapump data migration practices Although a lot of data migration projects have been put into practice, some small differences may make a big difference in the entire data migration solution. Data is the core lifeblood of the system.

Install and configure PostgreSQL in UbuntuI. installation 1. Installation Use the following command to automatically install the latest version. Here, PostgreSQL is 9.5. sudo apt-get install postgresql After the installation is complete, the default

Install MySQL 5.7 On CentOS 1. Download mysql57-community-release-el6-8.noarch.rpm from mysql Official Website 2. Install the rpm downloaded in step 1 rpm -ivh mysql57-community-release-el6-8.noarch.rpm 3. After the installation is complete, we

Detailed description of mysqlbinlog Based on Log Recovery If a large number of binary logs are generated every day and these logs are not cleared for a long time, the disk space will be greatly wasted. Therefore, regular log cleaning is an important

Adjust the interval between snapshots generated by AWR I. DescriptionThe test environment often performs stress tests on the database. During the test process, the database is stable and burstable, because I am not very professional in the test, so

Oracle Database object_sequence A sequence is a database object used to automatically generate a unique sequence number. A sequence is a shared object. Multiple users can use the sequence number together.Generally, the sequence is applied to the

Redis Master/Slave replication failed (master_link_status: down) The master_link_status: down prompt is displayed when configuring redis master-slave replication today. First, open the redis. conf configuration file of slave and check whether the

Simple Backup Using impdp and expdp provided by Oracle At present, there is a need to back up the data in the production database to the backup machine at 23 o'clock every night. The database of the backup machine can be used directly the next day.

RAC local data file migration to ASM method-non-archive Mode Reference: How to migrate RAC local data files to ASM System Environment: rhel6.2 _ x64 + Oracle RAC11g Procedure:1. Non-archive ModeSQL> archive log list;Database log mode No Archive

MySQL dynamically creates and deletes a partition table Due to project requirements, I recently studied how to dynamically create and delete partition tables in the MySQL database. If all stored procedures are used, creating and deleting partition

Use dbms_transaction to obtain the transaction ID The most common way to find the current transaction ID and rollback segment is to execute the following SQLSQL> select xidusn, xidslot, xidsqn from v $ transaction, v $ session where saddr = ses_addr;

How to connect Java to the MySQL database How to connect Java to the MySQL database Download: mysql-connector-java-5.1.38.tar.gz Http://dev.mysql.com/downloads/connector/j/ Tar zxvf mysql-connector-java-5.1.38.tar.gz Decompress the package Bkjia @

Java calls the Oracle stored procedure and returns multiple result sets Oracle version: 11 GB The Oracle stored procedure uses a cursor to return data sets of multiple rows and columns: Create or replace procedure SP_DATA_TEST (/* P_ID in int, */--

Install the cx_Oracle module in Python If you want to access a remote Oracle database and do not want to install a few hundred megabytes of Oracle Client locally (also known as root), the python cx_Oralce module must rely on the Oracle Instant

Changing the Oracle user password will never expire Changing the Oracle user password will never expire 1. Check the user's proifle, which is generally default: SQL> SELECT username, PROFILE FROM dba_users; 2. view the password validity period