Database Administrator

Why didn't Oracle RAC Opatch go to Rac database home during auto? First explain the environment:Operating System: AIX 7.1Oracle version: Oracle Rac 11.2.0.3I used the 11.2.0.3.9 patch set before and it was not officially used for Rac installation,

Application of Naive Bayes algorithm in spam filtering, Bayesian Spam I recently wrote a paper on Big Data Classification (SPAM: My tutor reminds me every day), so I borrowed several books on big data from the library. Today, I read spam in "New

For the first time, I installed DB2 on Linux. I have referenced a lot of online resources, But I mainly used "detailed steps for installing DB2 version 8.1 in Linux ".At the same time, I kept a record of my problems for learning. VMWARE uses VMware

WAS cluster series (7): Build a cluster: Step 5: Install WAS patch and cluster was Check the "Task Manager" before installation. If a java Process exists, disable it and disable WAS services. Find the WAS Update Wizard startup item in the Start Menu,

Second, understanding database three paradigm, understanding database paradigm Understanding the database paradigm is of great help to design a rational database. Based on my understanding of the database paradigm and specific examples, this article

Remember a bizarre TNS-12545 TNS-12560 TNS-00515, tns-12545tns-12560 Recently, reportDB listeners cannot be started with the system, which is a strange phenomenon. Because the listener of another instance on the server can be started normally, it is

1. OverviewThe Oracle EM11g database needs to be migrated. The main steps are as follows: 1. Disable OMS 2. Back up the current database and restore it to the new server. 3. Update OracleEM OMS database connection Configuration 4. Start OMS This

Migrate SQL server data to mysql and sqlmysql The newly added project is just getting started, and many technologies have not yet been finalized. Originally, the team lead decided to use SQL server. These days they have been busy designing

Similarities and differences between Oracle Enterprise Edition, Standard Edition, and other versions, oracle Enterprise Edition For different development and deployment environments, Oracle divides the same series of Oracle databases into four

Postgresql database import and export, postgresql Import and ExportExport a remote database 1. Export the threshold table structure and data to the file threshold. SQL from the database monitor on the remote database IP Address: pg_dump -t threshold

SQLite tutorial (5): database and transaction, sqlite tutorial I. Attach database: The attach database statement adds another DATABASE file to the current connection. If the file name is ": memory:", we can regard it as a memory DATABASE, and the

Data Control Language DCL) Data Control Language (DCL) is a statement used to set or change database user or role permissions. These statements include GRANT, DENY, REVOKE, and other statements. By default, only members of sysadmin, dbcreator,

When dbca deletes OracleserviceXXX in windows, the following error occurs: dim-00014 Cannot open the Windows NT Service Control Manager, cadmanagercontrol When dbca deletes OracleserviceXXX in windows, the following Error occurs: dim-00014 Cannot

Atitit. Oracle 9 10 11 12 new features attilax summary, oracle12c New Features New Features of atitit. Oracle 9 10 11 12 1. ORACLE 11G new feature 1 1.1. oracle11G new feature 1 1.2. Audit 1 1.3. 1. Audit Overview 1 1.4. Others (mostly management

[Translated from mos] Use config. sh/config. bat to configure or re-configure GI,From How to Configure or Re-configure Grid Infrastructure With config. sh/config. bat (Document ID 1354258.1)Applicable:Oracle Database-Enterprise Edition-Version 11.2.0

Oracle technology _ 5 minutes will use stored procedure _ simple example of stored procedure (including loop, condition, add and modify query, parameter input, variable assignment, java call, etc.), oracle_5 Example business functions: 1. query the

It takes only 6 minutes to scan a 166G table from an oracle full table, and oracle166g How can I maximize the cpu usage? How to quickly scan a large table. If a large table has a primary key, count (*) takes the primary key. oracle only needs to

Logon database Tiger causes the slave uard to be not synchronized. tigerdataguard When the slave uard upgrades the CPU, it finds that the master and slave databases cannot be synchronized and the log reports an error. Therefore, the script "@

What is Database Links? First, we will explain its role: to allow users to access another remote database through one database. The Database Link stores the connection information of the remote Database. As shown in: Scott can query the emp table

To ensure data consistency, Oracle uses the UNDO record to retrieve database data, oracle always enables users to only view submitted data or data at a specific time point (select statement time point), and the UNDO record will be stored in the