Database Administrator

Take a look at BIRT. I think of the previous company's use of Oracle BAM. At that time, I started to work on BAM by myself. from scratch, after learning something, I found that Oracle BAM was about to be used for application crash, almost tortured

MySQL version: Mysql5.5.19 (master) Mysql5.1.59 (slave) During replication from a lower version to a higher version, MySQL restarts repeatedly and a BUG message appears in the error log. Note: For synchronization from a lower version to a

EBS patching steps in Oracle On Demand (OOD) projects # Check if patch applied & count of invalid objects, create invalids table & replace 7777777 with patch numberSelect name, user from v $ database;Select BUG_NUMBER, LAST_UPDATE_DATE, success_flag

This is the case. One of my servers installed Oracle11gR201, And the grid Infrastructure and Database software were respectively installed by the Grid and oracle users. As a result, when using the dbca tool to create a Database, when the progress

1. MySQL exports local database data to a local file Mysql-A service_db-h your_host-utest-ptest Mysql> select * from t_apps where created> '2017-07-02 00:00:00 'into outfile/tmp/example .csv 2. MySQL exports remote database data to a local file

MySQL database itself provides the mysqldump command to back up data. Of course, we can also use other tools such as phpMysqlAdmin to back up the MySQL database. However, data corruption may occur when backing up a large amount of data. After all,

Add a script to monitor the slave database running status in the MYSQL master-slave synchronization configuration. The Code is as follows: #! /Bin/bash # Check MySQL Slave's Runnning Status # Crontab time00:10 MYSQLPORT = 'netstat-na |

A two-node Oracle 11g rac with the host names rac1 and rac2 respectively. The instance names are db4qg_1 and db4qg_2. The effect required is that the rac1 node starts the instance db4qg_1 and the rac2 node starts db4qg_2, but in actual operation, it

It is often encountered that, due to business needs, some summarized data needs to be apportioned to a pile of data according to certain principles.In fact, if the logic is clear, this type of program is better.This article focuses on using a simple

An error is reported when you use expdp today:ORA-39002: invalid operation.ORA-39070: Unable to open the log file.ORA-29283: invalid file operationORA-06512: at "SYS. UTL_FILE", line 475ORA-29283: invalid file operation The cause is as follows:SQL>

Oracle 11G: Generate PFILE file: create pfile = '/home/oracle/initorcl. ora' from spfile;Modify the value of *. memory_target = 536870912 in PFILE.Then restart the database from the new PFILE file to the NOMOUNT state.SQL> startup nomount pfile =

@ SequenceGenerator (name = "SQECagegory", sequenceName = "categoryDB", allocationSize = 1) ImportJavax. persistence. Entity; ImportJavax. persistence. GeneratedValue; ImportJavax. persistence. GenerationType; ImportJavax. persistence. Id;

1. Check the database version SQL> status; 1. net start mysql // start the mysql Service 2. net stop mysql // stop mysql Service 3. mysql-h host address-u user name-p User Password // enter the mysql database 4. quit // exit mysql 5. mysqladmin-u

I. What is Incremental backup? Incremental Backup backs up new data. If you have 10 Gb of data in a database, you can add 10 MB of data every day. The database must be backed up once every day. Do you need to back up so much data? We only need to

Execution Plan An execution plan is an action performed by an SQL statement running in Oracle in a certain order. You can use the explain plan for statement to view the execution plan. In the plsql developer tool, you can directly use the explain

1 Definition An executable tool used to analyze Oracle tracking files and generate clearer and more reasonable output results as needed 2 preferences F: \> tkprof Usage: tkprof tracefile outputfile [explain =] [Table=] [Print =] [Insert=] [Sys =]

Name Role Server (RHEL6.0) Server 1. prerequisites (1) decompress the compressed file [root @ localhost ~] # Unzip linux_11gR2_database_1of2.zip //Decompress the ZIP file package [root @ localhost ~] # Unzip linux_11gr2_database2

1. Set system parameters;The following Kernel Parameter settings are required for Oracle Database 10 GB.Generally, you can set the maximum shared memory to half the physical memory. If the physical memory is 2 GB, you can set the maximum shared

ORA-12519: TNS: no appropriate service handler found after Windows 2003 is upgraded to CentOS 5.7. Recently, the company upgraded its system from windows2003 Oracle10.2.0.1 to Centos5.7 x64 Oracle11.2.0.3 x64. Through optimization of the array and

ORA-39002: invalid operation.ORA-39070: Unable to open the log file.ORA-29283: invalid file operationORA-06512: at "SYS. UTL_FILE", line 475ORA-29283: invalid file operation Solution 1: Today, when I used IMPDP to import data, I encountered "ORA-3900