Database Administrator

To understand the Oracle architecture, you must first understand two basic concepts: databases and instances. I. Databases A database is a collection of data. Whether the database adopts a relational structure or an object-oriented structure, the

It is often used in the NT environment to convert a MySQL database to an SQL Server database or to a MySQL database. After using MySQL ODBC, you can use the SQL Server 7 management tool or the MySQL management tool. You can also use other management

Password Complexity is an important aspect for IT auditors to check whether a system is secure. IT policies often point out that the password should have a minimum length and contain a mix of uppercase letters, lowercase letters, numbers, and

Some work needs to be done after installing msyql using the mysql binary installation package1. Set the password/usr/local/mysql/bin/mysqladmin-uroot-p password newpassword2. Copy the startup script/usr/local/mysqlsupport-files/mysql. server

The procedure is as follows:Software environment:1. Windows 2000 + Oracle 8.1.62. ORACLE installation path: C: \ ORANTImplementation Method:You can use the following statement:Select user_name, SQL _textFrom v $ open_cursorWhere sid in (select sid

The following method can be used to solve the garbled problem:1. Set phpMyAdminLanguage: Chinese simplified (zh-utf-8)MySQL Character Set: UTF-8 Unicode (utf8)MySQL connection verification gbk_chinese_ci2. When creating a databaseSet it to

Steps 1-7 below are for the root user 1. hardware environment requirements Check content Minimum value Check command reference Physical memory 512 M # Grep MemTotal/proc/meminfo Swap space 1.0 GB or 2 times memory size # Grep SwapTotal/proc/meminfo /

I. Summary ① MySQL features Efficient and stable, open source code, multi-user support, multithreading, openness, extensive application support, transaction processing, big database processing, high flexibility, security permission and password

In many cases, we need to terminate all Oracle processes ). When the database is "locked" and you cannot enter Server Manager to terminate the database, you can use the kill command in UNIX to terminate all Oracle processes. This is one of the

Oracle 10gR2 in Solaris 10 is automatically started upon startup 1. Modify the/var/opt/oracle/oratab file. The following dbstart and dbshut start the database based on the file: Orcl:/opt/oracle/product/10.2: Y 2. Modify the $

1: Add the following configuration to tomcat_home/solr/config/solrconfig. xml: data-config.xml     2: Create the data-config.xml file in tomcat_home/solr/config/(in the same directory as solrconfig. xml), add the following content     3: Add the

Today, the development database has created an index online for more than one hour. An error is returned when an index is deleted after it is forcibly canceled. Re-create the index will tell you that the index already exists, drop index will tell

This morning, a stored procedure has been written for many times. It can be easily written, reported for various errors, various confusions, and searched on the Internet, I did not mention the ending answer provided on the Forum. Let's take a look

Background description:Create a catalog database in the rman environment. Problem:The following error message is displayed when you register a catalog database on the target machine: RMAN> register database; PL/SQL package RMAN. DBMS_RCVCAT version 1

SQL * Plus: Release 11.2.0.1.0 Production on Mon Feb 18 15:42:14 2013 OS: Linux node 2.6.32-200.13.1.el5uek #1 SMP Wed Jul 27 21:02:33 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux Due to application requirements, some user passwords cannot expire, and

Introduction:---Oracle Statspack was introduced from Oracle8.1.6 and immediately became a powerful tool used by DBAs and Oracle experts to diagnose database performance. Through Statspack, we can easily determine all the bottlenecks of the Oracle

Not long ago, because the developer truncate an important table, he found us and made an exception recovery to restore the table.The following is an experiment I did on the vm afterwards. It is completely replicated. Of course, you can also set the

Script file:Backup. shRq = 'date' + % Y % m % d % H % m''Su-Oracle-c "exp zjhk/zjhk_123 owner = zjhk file =/home/oracle/zjhk _ $ rq. dmp" Cron is a linux scheduled execution tool that can run jobs without human intervention. Since Cron is a built-in

MySQL 5.6 brings us the memcached fof innodb api. The main advantage is that we can read and write the MEMCACHED plug-in through the most familiar SQL statements. I will not introduce installation and configuration. If necessary, visit the official

Oracle Auto-start configuration in Linux (I) modify the value of/etc/oratab to Y. [Root @ Rocky ~] # Cat/etc/oratab Orcl:/u01/app/oracle/product/10.2.0/db_1: Y (Ii) Modify ORACLE_HOME_LISTNER of dbstart to point it to $ ORACLE_HOME [Root @