mit dba

Original linkAbsrtact: Not accumulate Kuibu not even thousands of miles, want to become a qualified database administrator, first of all should have solid basic knowledge and problem processing ability. This article refers to the pivotal official

Sync time Cp/usr/share/zoneinfo/asia/shanghai/etc/localtimeCrontab-e0-59/10 * * * */usr/sbin/ntpdate us.pool.ntp.org | Logger-t NTPNtpdate us.pool.ntp.orgHwclock-wTo set a local DVD as a source: Mkdir/mnt/cdromMount/dev/cdrom/mnt/cdrom#添加本地源 Cat >

I tried to install Oracle11gR2 under CenOSs5.5 in VMware. I thought it was simple, but I found many problems. I tried to install Oracle 11g R2 under CenOS s5.5 in VMware. I thought it was simple, but I found many problems. I tried to install

I tried to install Oracle 11g R2 under CenOS s5.5 in VMware. I thought it was simple, but I found many problems. Installation steps: 1. check the corresponding rpm package It doesn't matter if the check is complete. It will check the installation of

Background of Appearance:The company does a Redis-related project where MySQL stores a lot of statistics. such as client-reported data, redis instance data, application data, machine data and so on. Every day in the report, collection, due to the

1. Create a table spaceInstructions for exporting Oracle data:ExpJDs/JDs@192.168.99.199/Orclfile=C:\JDS.DMP owner=JDS Instructions for importing Oracle data: Imp ZCL/Zcl@127.0.0.1:1521/Orclfile=C:\jds.dmp Full=y--1th Step: Create a temporary table

SqlThe statement can be divided into the following3Categories.?Ddl（Data Definition Languages) Statements: Data definition languages, which define different data segments,The definition of database objects such as databases, tables, columns, indexes,

Oracle Default database userWhen a new database is created, Oracle automatically creates 3 database users for us.1.sys User: SYS user is a super User in Oracle. All data dictionaries and views in the database are stored in the SYS mode (what is the

A few days ago the teacher arranged a task to import a 50G dmp file into our Oracle server. Because I practiced this before, I thought it was a relatively simple thing.Just try to use the Plsql directly to the server guide AH. Log in to the server

mysql5.7 adds the SYS system database, which provides a quick overview of the system's meta-data. This library does make it easy for DBAs to discover a lot of information about a database, and it can help to solve performance bottlenecks. This