Database Administrator

Operating software environment: CentOS 4.4, TSM5.3.2, Oracle 10G Environment: One broken PC, P3 900 Mhz, M memory, 40 Gb hard drive One obsolete hp dat 40 tape drive N DDS3 and DDS4 tapes that do not know many teenagers Reference books: IBM Tivoli

Today, Xiao Qiu said that there was a problem with running Dotcms In Ubuntu. I also tried it and found that there was always a problem that the table Dotcms could not be found. the group _ problem exists in my database. However, I found that this

Restore the MySQL administrator password in Linux 1. Send the kill command to the mysqld server to disable the mysqld server (not kill-9). files storing process IDs are usually stored in the directory/var/lib/MYSQL of the mysql database. # Killall-

Starting from 10 Gb, Oracle provides more efficient Data Pump (expdp/impdp) for Data import and export. The old exp/imp can also be used, but it is not recommended. Note: expdp/impdp AND exp/imp are incompatible. In other words, exp exported files

I received an email this morning and saw the failed rman recovery email sent by Master. The content is as follows:   The data has been decompressed. Under/orabak/Oracle_bak However, an error is always reported when the backup file is read during

One switch command1 switch command usageUpdate the data file name to the data file name specified during image copy under rmanUpdate the data file name to the name specified by the set newname command. 2. Prerequisites for using the switch

1. RMAN login and exit command: Method 1: $ rman nocatalog directly enters rman to back up data in a non-catalog mode. Do not use nocatalog.Rman> connect target/connect to the target database requires configuring the Oracle operating system login

Recently, it was found that the size of the sid_ora_xxxx.trc file in the diag/.../trac/directory is 11 mb and the number of similar files is large. As a result, 8 GB hard disk space is occupied. Another colleague said that his DG had no such problem.

Static registration is used before Dynamic Registration of Oracle Listener. The so-called static registration refers to reading listener when an Oracle instance is started. the configuration in ora is then registered to Listener. It has two main

Install Oracle 11g single-instance database on Linux under vmvm 1. Environment and pre-installation plan: Virtual Machine and OS are as follows Environment: VMware Wordstation ACE version 6.0.2 Operating System: OracleLinux-R5-U8-Server-i386-dvd

There is enough reason to continue using MySQL or switch from MySQL to MariaDB. Performance tests on the MariaDB blog. MariaDB is a branch of MySQL source code. After realizing what Oracle will do for MySQL, MariaDB is separated (MySQL has been

Sometimes, we need to connect to the Oracle database through SQL Server to obtain the data of the Oralce database. Instead of program conversion, you can directly create such a link in the SQL Server Enterprise Manager. Step 1: Open SQL server

Lab environment, Oracle 11gR2 standalone test data software and database upgrade, operating system Linux6.3Oracle version 11.2.0.1 upgrade package 11.2.0.3After the database software and database are upgraded successfully, the following error is

1. MYSQL login Error[Oracle @ bys2 mysqlogg] $ mysql-u root-pEnter password:ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: YES)In this case, use mysql-u root to log on without a password.Password re-change: Use the

1. Close the database completely. 2. Close the database and modify the server parameter file to use Oracle Managed Files (OMF ). 3. edit and execute the following RMAN Script: startup nomount; restore controlfile from '/u1/c1.ctl'; alter database

It has been several years since the Oracle flash back zone was launched at 10 GB and continues until now. Oracle flash back is prepared for RMAN. Although aside from it, we can also perform database backup and recovery, Oracle is strongly

Recently, my colleagues reported that the database could not perform some data dictionary queries. An error occurs even when you query dba_users. From the error log, all are some error information of the data dictionary, and the user data is OK.

Who determines the number of Hive maps or the number of MAPREDUCE maps? Inputsplit size, how is the inputsplit size calculated? This is the key to adjust the number of maps.Hadoop provides the Inputformat interface to describe the format of input

When the application redo log is started, the redo log is canceled when the application is disabled:8.1 Starting Up and Shutting Down a Physical Standby Database This section describes the SQL * Plus statements used to start up and shut down a

8.3 Managing Primary Database Events That Affect the Standby Database8.3 Managing the master Database can Affect the Events of the slave Database To prevent possible problems, you must be aware of events on the primary database that affect a standby