Database Administrator

During Oracle database management, tables are often locked due to unreasonable operations on data tables. The following describes how to find which tables are locked by which users, and how to unlock: 1. Find the locked table: Select object_name,

Compared with other databases, Oracle Data has the primary feature of introducing tablespaces. This article describes the Oracle tablespace. Oracle Database pioneered the design concept of tablespace, which makes an indelible contribution to the

Environment: NavicatforMysql8.2 + MySQL Sever 5.1 Problem: Garbled characters occur when exporting SQL statements from the MySQL database. Solution: Method 1: Change the database encoding to a UTF-8. Database --------> right-click -------->

Apps schema: it does not own any tables. For table data in each independent Schema, there must be a synonym under the Apps schema. The default password for apps is "apps ". For more information about the Apps Schema, see [flip] Why call it Apps and

Location of the warning log File alert _ + asm. log of the Oracle 11g ASM instance:ORACLE_BASE/diag/asm/+ ASM/trace/Opt/app/oracle/diag/asm/+ ASM/trace Location of the warning Log File alert_oradb1.log of the oracle 11g

Starting from 11.2.0.2, Redundant Interconnect with Highly Available IP (HAIP) was added to the cluster software Grid Infrastructure (GI) of Oracle to achieve high availability and load balancing for the private network of the cluster.Before 11.2.0.2

1 MySQL Cluster MySQL Cluster is a highly practical and redundant MySQL version suitable for distributed computing environments. It uses the NDB Cluster Storage engine and allows multiple MySQL servers to run in one Cluster. This storage engine is

How CSS works Before understanding the Brain Split processing process, it is necessary to introduce the working framework of Oracle RAC Css (Cluster Synchronization Services: Oracle rac css provides two background services: Group Management (GM)

Symptom Submit a request and find that almost all Concurrent managers are in No Manager status, and Phase is Inactive.Solution The lifecycle of a Concurrent Request contains different phases (Phase): Pending, Running, and Completed, and may have

When user dbname is used, the speed is slow and the following message is displayed: Mysql> use dbnameReading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with- Then it is stuck

The following statement can be used to obtain the statements for deleting all tables, indexes, and sequences of Oracle... Select 'drop table' | table_name | ';' | chr (13) | chr (10) from user_tables; -- delete tablesSelect 'drop view' | view_name |

[Oracle trusted uard] switch Switchover using the Broker-role in a trusted uard Environment I. Environment Introduction Data Guard environment: Primary Database: oracle10.2.0.5.0OS: RedHat 4.4Host Name: sourceIP Address: 192.168.10.101Database SID:

Testing in Ubuntu 12.04Possible missing library libaio1 Tar xvf Downloads/mysql-cluster-gpl-7.1.3-Linux-x86_64-glibc23.tar.gz Ln-s mysql-cluster-gpl-7.1.3-Linux-x86_64-glibc23/usr/mysqlc Mkdir my_cluster/ndb_data my_cluster/conf 1. mgm

RHEL5 enables and disables Oracle database instances in two steps: Step 1: Start the listener; Step 2: Start the database instance. I. How to start a database instance 1. Go to sqlplus to start the instance[Oracle @ RedHat ~] $ Su-oracle -- "switch

The differences between AS and IS in Oracle and their usage are basically the same. As and is are synonyms set by ORACLE for convenience. When to use 1. When creating a stored PROCEDURE (PROCEDURE)/FUNCTION (FUNCTION) and a custom type (TPYE) and

1. Instructions for use: 1. After this script is used as a partition, partitions are automatically added at regular intervals. (For tables that are automatically partitioned, you must manually divide the partitions first)2. Every 15 days, the timer

1. primary serverConfirm it is master: primarySelect database_role from v $ database; Alter database commit to switchover to physical standby with session shutdown;Shutdown immediate;Startup nomount;Alter database mount standby database; 2.

U RMAN create database 1. Prepare the environment2. the username of the Oracle OWNER applied for in the DBA group on the machine where the database is created must be the same as that of the oracle owner of the original database.2. Install the

Cause: If the online redo log file is reused, the loss of a member in the log file will not cause the database to stop, but the alarm log will write a message indicating the problem. Solution: Method 1: If you can tolerate the downtime, you can

Database Management Tool SQL * PlusStart SQL * PLUS   Cmd-> sqlplus/nolog Conn system/manager   View table structure by Desc table name Column name for 9999 format Column Column name for a99 format   List to view the instructions in the cache; Del