Database Administrator

ORA-01157 & ORA-01110 troubleshooting When starting the Virtual Machine Test Library today, the database reported a ORA-01157 and ORA-01110 error prompting that a data file could not be found. When I read the file name, I knew where the problem was.

ORA-00600 [kcratr_nab_less_than_odr] [Note] recently, the entire IT system was a bit lucky. First, there was a power outage in the data center. Recently, another accident occurred. The hard disk of a virtual machine broke down, resulting in the

Oracle 11g Database Password Expiration ORA-28002 Problem Solution Problem description and analysis: the user returns an error ORA-28002 upon logon, for example, prompting that the data will expire in 1 day. This is because the 11g password

Visibility and hiding of Oracle Indexes) Official Document: Making an Index Invisible An invisible index is ignored by the optimizer unless you explicitly set the OPTIMIZER_USE_INVISIBLE_INDEXES initialization parameter to TRUE at the session or

MySQL 5.6 uses GTIDs to build a master-slave Database Concept: What is GTIDS? (Global Transactions Identifier) is a new feature of MySQL5.6.5. When GTIDS is used, everything can be identified and tracked, whether committed on the Master or applied

How to Set foreign key constraints and the role of foreign keys in MySQL 1. The foreign key has two main functions: One is to allow the database to ensure data integrity and consistency through foreign keys. One is to increase the readability of the

Two Oracle deadlock solutions for instances About deadlocks in databases. If you encounter a problem in the application, you will not hesitate to transfer it to the DBA. However, from the current deadlock issue, it is basically the same as the

Tablespace online solution During the demonstration today, two sets of database software were installed on the virtual machine, Oracle 10g and 11g. We still encountered some unexpected problems during the demonstration of migration of common data

MySQL master-slave synchronization configuration records /**************** MySQL master-slave synchronization configuration records (5.1.17 and later versions) ********************/ Create a mybackup user on the master database. The user will

Redis maxmemory settings, redismaxmemory The maxmemory parameter of redis is used to control the maximum memory capacity available for redis. If the value of maxmemory is exceeded, the elimination policy is used to process keys in the expaire

A SQL skill that every programmer needs to understand. CHECK constraints are already quite good for data filtering. However, it still has some defects. For example, they are applied to the table, but sometimes you may want to specify a constraint,

279th questions, 053279 279. Identify the activities stored med as part of the Automatic SQL Tuning process in the maintenanceWindow? (Choose all that apply .)A. generating the SQL profileB. testing and accepting the SQL profileC. generating a list

450th questions, 053450 450. Which of the following are valid program types for a lightweight job? (Choose all that apply .)A. PLSQL_BLOCKB. EXECUTABLEC. JAVA_STORED_PROCEDURED. STORED_PROCEDUREE. EXTERNALAnswer:AD The following PL/SQL block

484th questions, 053484 484. Which steps are mandatory to enable Direct NFS?1. Mount all required file systems using the kernel NFS driver.2. Create an oranfstab file containing the attributes for each NFS server to be accessed using Direct NFS.3.

Create tablespaces, create tables, modify tables, authorize, and authorize ORACLE in oracleCreate a tablespace/* Divided into four steps *//* Step 2: create a temporary tablespace */Create temporary tablespace user_tempTempfile 'd: \ oracle \

Configure redis Internet access and configure redis access Environment Description InLinuxInstall the redis Service InWindowsThe xampp environment is installed in. For PHP running The PHP code is as follows: connect('192.168.1.4', 6379);

SQLDMO registration, sqldmo not registered When maintaining the personnel system, Shi Jie asked us a functional problem. Yellow Pages are reported during database backup. Then we need to find the cause and make a solution. At first, I started from

Mysql insert and front-end display garbled characters, mysqlinsert Recently, I have encountered the following problems on the server, Insert Chinese garbled characters in mysql, or display Chinese Characters in mysql normally, but jsp displays

Three major database design paradigms and three database paradigms In order to establish a database with low redundancy and reasonable structure, certain rules must be followed when designing the database. In relational databases, such a rule is

423rd questions, 053423423. Which of the following describes how a distributed resumable transaction behaves?A. The resumable setting on the initiating session determines the resumable conditions for the entireDistributed transaction.B. The