Database Administrator

ORA-12514 error troubleshooting when connecting to Oracle Recently, Oracle 11 GB in windows has been used for testing. ORA-12514: TNS: The Listener currently cannot identify the Service requested in the connection Descriptor I searched the internet

Problems caused by Online usage of index creation in Oracle In the local test database, the original space is insufficient. As a result, a table is created with more than 6 million records and you want to create an index. The physical segment has

Oracle index Suppression Preface: in many cases of Oracle Database optimization, you can increase the database performance by adding indexes. However, in some cases, DBA cannot do anything about it, because all the indexes have been created, but the

Reconstruction after physical DG slave database corruption Because the data is rebuilt, the data files, log files, and dump files in the physical slave database that were rebuilt in the original DG Environment can be deleted. Remember that the

Handle irregular Oracle listening exceptions Environment:Operating System: SunOS 5.10Database Version: Oracle RAC 11.2.0.3.0There are two databases on the host, with node 1 of a RAC located on the host, and another database. The reason why the

Enable audit for a table in Oracle (audit) Oracle databases enable standard auditing using the audit_trail Parameter Its Parameters include the following: NONE: Audit disabled OS: The audit information is summarized in the system. For Linux, the

Query and delete sessions in Oracle Query and delete sessions in Oracle1. query the current session SQL> select username, sid, serial # from v $ session where username is not null;Username sid serial #-------------------------------------------------

Troubleshooting of abnormal shutdown of MySQL Slave (pt-slave-restart) The following three methods are used to handle abnormal shutdown of MySQL Slave.You can also use the pt-slave-restart command of percona-toolkit.The

SSRS Fields cannot be used in page headers or footers, ssrsfooters Problem Environment: SSRS 2005 report development   The following error occurs when you try to use the Data Set field in the Page Header:   The value expression for textbox

[Translated from mos] The asm archive path is full, mosasm The asm archiving path is full. Reference Original:ASM Archive destination is full. (Doc ID 351547.1) Applicable:Oracle Server-Enterprise Edition-Version: 10.1.0.2 to 11.1.0.7This problem

Common SET commands in ORACLE and common SET commands in ORACLEZookeeper 1 SET TIMING ON Description: displays the SQL statement running time. The default value is OFF. It is used in SQLPLUS and the time is accurate to 0.01 seconds. That is, 10 ms.

Optimize database indexes and database Indexes This article mainly describes how to create and use indexes. We will not go into details about why indexes are used, what benefits are brought about by indexes, and the classification of indexes, for

DRP Oracle_11g database installation, drporacle_11g I don't know if you are confused like this or that when installing the Oracle database. Today, I will take a look at the installation process of the Oracle database as a summary to facilitate

How to import SQL Server excel and SQL Server excel -- Importing data from an Excel file to a SQL database is simple. Use the following statement: /* ===================================================== =============================*/-- if the

Let you know software development in advance (36): How to expand data table fields ?, Software Development Field Part 1 Database SQL language How to expand data table fields?   Abstr] Communication Software often deals with databases. Expansion of

MySQL calculation field, mysql Field Calculated Field The tables in the database are stored by columns, but sometimes the information the client wants is a combination of several columns or the sum value. This combination or summation action can

Mysql forgets the root password and mysql forgets the root password.1. stop MYSQL. Open the DOS window in CMD and enter net stop mysql.2. In the CMD command line window, enter the MYSQL installation directory, for example, E: \ Program Files \ MySQL

MySQL sorting: select order by, mysqlorder SELECT and order by are combined for sorting: The products table is as follows: A is sorted by product name column: B is sorted by multiple columns. The default sorting order is ascending:

Set up Oracle10G (5) for RAC in AIX to install oracle and set up listening. racoracle10g Establish a series of RAC instances under AIX Set up Oracle10G (5) for RAC in AIX to install oracle and set up listening Environment Node Node 1

MySQL search: WHERE, mysql search where You can use the where condition to search by specifying a Search Condition in MySQL. In a SELECT statement, data is filtered based on the conditions specified in the WHERE substatement. The WHERE substatement