Database Administrator

Install Oracle on bare devices on AIX Recently, new systems have been released. I have not prepared documents for installing Oracle on AIX. I have prepared a document for future reference. The simple steps are omitted here. 1. view the system

EM database reconstruction manual deletion of Database Because the original database has been deleted, you need to use the listener when redoing the oem. At this time, the following error is reported: [Oracle @ localhost ~] $ Emca-repos recreate Jul

Optimize Oracle with full table Scan Today, development has met a very BT demand.Find all friends of a person, query all works of all friends, and sort them in reverse chronological order to obtain several records,Then associate the Work Comment

Oracle Study Notes: Use of the graphic management tool EM Use of common Oracle learning notes tools-EM Graphics Management Tool em Server 1 Ensure Listening Starts -----> grid Lsnrctl status Or Netstat-tunlp | grep 1521 If not Lsnrctl start 2.

The MySQL table is structured as an InnoDB type and restores data from the ibd file. The customer's machine system is shut down abnormally. After the restart, the mysql database cannot be started normally. After the system is reinstalled, the

Why MySQL transactions cannot be rolled back When using MySQL, if you find that the transaction cannot be rolled back, but the Hibernate, Spring, JDBC and other configurations do not have obvious problems, don't worry, first check whether the table

How to bypass the password settings of the Oracle listener How to bypass the password settings for Oracle listening: 1. Find the pid of the listening process and kill it.Ps-ef | grep tns [Oracle @ lixora admin] $ ps-ef | grep tnsRoot 9 2 0 Jul11? 00:

MySQL myisam solution for concurrent read/write Mysql myisam solves the problem of concurrent read/write. MyISAM is very efficient when reading operations are dominant. Once a large number of read/write concurrency occurs, the efficiency of MyISAM

CentOS 5.3 installation and configuration Oracle 10g Manual start and self-start service The following is a text description of the installation process on Oracle 10g, CentOS 5.3 1. Download and decompress 10201_database_linux32.zip to the database

Atitit. orm mapping cfg ing configuration (3) ------- hbnt one2maney cfg, atititorm Atitit. orm mapping cfg ing configuration (3) ------- hbnt one2maney cfg   1. Create list 1 2. Configure xml 1 3. Set and List configuration in Hibernate 1 4. Bag

Why does the SQL run very slowly when the COST is very small due to the misunderstanding of the execution plan ?, Execution Plan cost Reprinted please indicate the source: http://blog.csdn.net/guoyjoe/article/details/38321477   PM on March 31, My

[Oracle] User Creation and permission management, oracle permission management # Creating a user requires the administrator privilege SQL> create user lzz identified by lzz123; // a common user is created, but not unlocked # change the password for

Modify the MySQL database port number. Modify the configuration file when the database service starts. First, shut down the Database Service and modify the configuration file: When you modify the configuration file, there are several areas that

MySQL List partition (3), mysqllist Partition For details, see MySQL partition 1. Example: Here is my personal learning summary. How does mysql partition existing tables? I am also looking for a method. mysql has been able to partition

[Translated from mos] using the ggserr. log method cyclically in Oracle GoldenGate, oraclegoldengate Use ggserr. log cyclically in OGG: Reference Original:OGG How Do I Recycle The "ggserr. log" File? (Docid 967932.1) Applicable:Oracle

[Translated from mos] prohibit log writing to Sqlnet. log, Listener. log, and sqlnet. logWriting logs to Sqlnet. log and Listener. log is prohibited.Reference Original:How to Disable Logging to the Sqlnet. log and the Listener. log (Doc ID

[MySQL] Innodb parameter optimization, mysqlinnodb Innodb_buffer_pool_size The innodb_buffer_pool_size parameter is used to set the Innodb primary Buffer (Innodb_Buffer_Pool), that is, the primary cache space for caching user tables and index data,

In the linux oracle 10g/11g x64bit environment, goldengate automatically starts with the OS, x64bitgoldengateIn linux and oracle 10g/11g x64bit environments, goldengate automatically starts with the OS.Background description:Goldengate is installed

[Oracle] OGG error while loading shared libraries, sharedlibraries [Oracle @ jp ogg] $./ggsci ./Ggsci: error while loading shared libraries:/u01/app/oracle/ogg/libclntsh. so.11.1: cannot restore segment prot after reloc: Permission denied Disable

Chapter 1 Securing Your Server and Network (3): Use the managed service account, chaptersecuringSource: Workshop Without the consent of the author, no one shall be published in the form of "original" or used for commercial purposes. I am not