Database Administrator

Install MySQL 5.0.22 in openSUSE 11.1 1. Open mysql5.0.22http: // download.mysql.cn/download_file/gz/5.0/mysql-5.0.22.tar.gz 2. The downloaded file is named mysql-5.0.22.tar.gz. 3.copy the downloaded mysql5.0.22.tar.gz file to the/usr/local

Data Files in Oracle databases have a feature that allows you to set whether to go offline. If you set the data file to offline, the database cannot read the data file. The database can read contents only when files are online. Therefore, changing

Chinese characters are garbled during Oracle Installation on LinuxAt the beginning, it was relatively time-consuming and can only be installed in English. After repeated trials and sorting, the oracle Chinese garbled characters in linux can be

1. Create a special table to save the statistics of each table:Exec dbms_stats.create_stat_table ('s38', 'fys '); 2. Import the statistical information of each table to the ks38.fys table;Exec dbms_stats.export_table_stats ('s38', 'tcl _

-- Alert. log has the following warning logs: Errors in file/u01/app/Oracle/admin/ESUITE/bdump/esuite_rvwr_23296.trc:ORA-19809: limit exceeded for recovery filesORA-19804: cannot reclaim 18055168 bytes disk space from 85899345920 limit -- View the

Oracle performance has been optimized over the past few days and some information has been found online. Sometimes you need to export all the table, view, sequence, trigger and other information of a user. The following SQL statement can select the

1. Check whether the system information meets the Oracle installation requirements.Df-k | grep tmp # & gt; 521 MMore/proc/meminfo | grep MemTotal # & gt; 512 MBMore/proc/swaps #> 1024 MBMore/proc/sys/kernel/sem #> = 250 32000 100

There are some differences between Fedora 18 and earlier versions, so it cannot be the same as before. Use # Yum install mysql-server mysql After the installation is successful, start the mysql service and use # Systemctl start mysqld.

OutlineI. Log ClassificationIi. Log details Note: MySQL version, Mysql-5.5.32 (different versions of mysql variables are different) I. Log ClassificationError LogQuery logsSlow query logBinary logRelay logTransaction LogRolling logs Ii. Log details1.

I. MySQL replication: MySQL replication introduction: The ddl and dml operations of the master database on the master server are uploaded to the slaves server through binary logs, and these log files are re-executed on the master server, in this way,

I checked alert log and found the following error: View alert log: Fri Aug 2 07:13:33 2013 Errors in file/u01/Oracle/admin/eptdb/bdump/eptdb1_j002_961_4.trc:ORA-00600: internal error code, arguments: [ktspNextL1: 4], [], [], [], [], [], [], [],

Use shell scripts to configure Oracle Installation Requirements 1. Configure yumYum-y install libXpYum-y install libaio 2. Modify the SID in the chprofile file as needed 3. rps-ivh rlwrap-0.30-1.el5.i386.rpm 4. Run the script # Save the following

If you use dbca to create a single-instance database in the Oracle 11g RAC environment, Oracle automatically registers it to the default port 1521 and listener. In most cases, we use non-default listeners and non-default listening ports. In the

I have been working on this for a few days. It was possible to install mysql in the source code of Ubuntu 12.04 following the tutorials on the official website step by step, but mysql won't work after installing Python-MySQLdb, when it is started,

Environment Description:Operating System: RedHat 5.3 64bitOracle version: 10.2.0.1 SID: search6 After the database is installed today, after you create a database through dbca, the following error is reported during the time when you start and

// Oracle calls Java to delete system files // Create a java sourceCreate or replace and compile java source named filetoolAsPublic class filetool{Public static void del (String filename){Java. io. File f = new java. io. File (filename );If (f.

Objective: To back up a user database at every night in CentOS 6.4: Use the scheduled task mechanism in linux and run the crontab command to export the database using the exp tool; then, let crontab call exp regularly to implement automatic backup.

Environment: Oracle 10g 10.2.0.4 on SUSE 11 + Oracle Data GuardNote: Standby DB is regularly read-only for statistics every morning, and then continues synchronization.Fault symptom:Run the copy datafile command to report the RMAN-10006 error.As

Recently, when I was using redis Master/Slave, I did the following two things: 1. You want to analyze redis master-slave operations. All write operations are performed on the master node, and all read operations are performed on the master node. 2

Create an Oracle DBlink1. You must use the database administrator to grant the otcts user the permission to create dblink. Grant create database link User_nameWith admin option; Commit;   2. Create a DBLinkCREATE PUBLIC DATABASE LINK