Database Administrator

I have just studied Linux and are still studying OCI. After calling OCI to connect to the database a few days ago, I tested it with the example provided by Oracle. I can read data normally (in English), so I can rest assured that I can switch to

I. How to completely delete the old version of Oracle 1. Run DBCA in cmd and delete the Oracle instance here;2. Find the Universal Installer under the Oracle subdirectory in the Start \ Program and run it to uninstall the Oracle software;3. Go to

In the past two days, I have studied the problem of garbled Characters During MySQL upgrade and finally solved the problem that has plagued me for a long time. Here I will record it and the previous articles have been updated. Change the server that

Reprinted 1: Today, the company's network has been adjusted, resulting in the original fast connection to the mysql server, the connection speed is very slow. The previous tens of milliseconds of connection now takes nearly five seconds. After the

Installing Oracle in a Linux system is a headache, and its complexity far exceeds that of installing the Linux operating system. If oracle is successfully installed, some Linux technologies are also mastered. This article describes how to install

1. After remotely logging on to and running./runInstaller, the graphic interface is disconnected. DISPLAY = Local IP: 0.0Export DISPLAY Okay. 2. If the network configuration of Oracle Startup Check fails, it is always displayed as not executed (it

I have been depressed for many days. By default, the database mysql installed in mandriva is faulty. The problem is more than two connections. Let's talk about it now. 1) install mysql: sudo urpmi mysql 2) Run mysql-uroot. [mysql] ERROR 2002 (HY000):

Databases are the main part of Linux applications. Major databases on Linux include: Oracle, Sybase, DB2, Informix; Free Software databases: MySQL, PostgreSQL, and Msql. Commercial database As commercial databases have good technical support, I

As database technology becomes more and more widely used, the increasing number of database users and the increasing sensitivity of data content make database security more important. To prevent unauthorized viewing and modification of data in the

View the maximum number of processes in Oracle:SQL> select count (*) from v $ session # Number of connectionsSQL> Select count (*) from v $ session where status = 'active' # number of concurrent connectionsSQL> show parameter processes # maximum

There are a variety of ways to delete duplicate data on the Internet. Oracle has never seen such a method:  Delete from prod_grid_incWhere rowid in (SELECT B. row_id2FROM (select rowid row_id2,A .*,Row_number () over (partition by a. prod_id order

Users who bought the commercial version can use commercial backup tools to back up the MYSQL database. I will demonstrate how to back up and restore the database. This includes full backup and Incremental backup. Backup Method Full: Mysqlbackup --

In the previous article "using Sqoop for data exchange between MySQL and DHFS systems", we mentioned that sqoop allows data exchange between RDBMS and HDFS and supports importing data to HBase from mysql, however, direct import from HBase to mysql

Select SQL _text from v $ SQL where hash_value in (select SQL _hash_value from v $ session where sid in (select session_id from v $ locked_object )) Check Methods for database deadlocks I. Database deadlock When the program is executed, click OK or

Oracle 11g installation prerequisite check all failed, unable to install, display the reason for NA and SolutionWhen installing Oracle, even if the Java environment has been installed in advance, run the installation as Administrator to enable the

When you manually restore the database, sometimes you need to go to the SQL * Plus prompt and the operating system prompt. It is cumbersome to switch back from the RMAN prompt. In fact, RMAN provides us with some simple SQL statements and PL/SQL

After I installed Oracle 11g rac, why ??? Garbled characters are as follows:[Oracle @ db ~] $ Sqlplus/as sysdba SQL * Plus: Release 11.2.0.1.0 Production on Thu Dec 20 13:40:46 2012 Copyright (c) 1982,200 9, Oracle. All rights reserved. ??? :Oracle

The Linux script has not been written for a long time. Suddenly there is a need to write a bash shell script to initialize Oracle users and tablespaces. Make a record for future Query Call method:./user. sh

I. Software preparation 1. Oracle linux installation package 2. Putty 3. WinSCP Ii. Operating System Configuration 1. network configuration (red indicates the change content) Cd/etc/sysconfig/network-scripts Vi ifcfg-eth0 The changed file is: DEVICE

Step 1: Try to delete sqlplus using the SQL command. If the deletion is successful, everything is fine! However, if you want to delete a session with a deadlock through a command line or using an Oracle management tool, oracle will only mark the