Database Administrator

This article summarizes many common MySQL commands on the network and describes the process in detail. 1. Connect to MySQL Format: mysql-h host address-u user name-p User Password 1. Example 1: connect to MYSQL on the local machine. First, open the

I was entrusted by my friends these two days and asked me to help him write a User Authentication System Using the MySQL database. Of course, I had to spend one night off and write a very simple PHP program. It may be too simple and prone to errors

Oracle DBA Interview Questions By B G1. How many memory layers are in the shared pool?2. How do you find out from the RMAN catalog if a participant archive log has been backed-up?3. How can you tell how much space is left on a given file system and

Based on Oracle's dependence on the platform, this article uses the NT platform as an example to describe some features of Oracle on the NT platform, and provides an Oracle System Optimization idea.Currently, Oracle is developing rapidly as a

Recently I encountered a very troublesome problem. I used the company software to view the backup data.The Oracle version is 9204, and the corresponding backup version is available now. Use the company's products to open the backup data. because the

Method 1:Log on to the MySQL Server using the MySQL Adminstrator GUI Tool, but the Server returns the error message Host '60-248-32-13.hinet-ip.hinet.net 'is not allowed to connect to thisMySQL serverThis is because of permission issues. The

Using foreign key in Mysql is not as simple as Oracle and access. The following describes the issues that should be paid attention to during use:Step 1: Create a tableFirst, open the command line window, enter the Mysql bin directory, select the

I believe that you will often encounter this kind of requirement. You can use the id/name of a staff member to obtain a list of all its employees (including non-subordinate employees, it may take a while to implement this function using java, but it

Recently in the use of swingbench encountered a ORA-01157 fault, the following is the specific description and solution. 1. Fault-- ORA-01157 fault occurred when querying view dba_data_filesSQL> select file_name, tablespace_name from dba_data_files

In conjunction with this article on connecting PHP to the Oracle database, this time, combined with the rrdtool drawing tool, to draw some custom monitoring charts, although Oracle's EM has been perfect, however, you may not be able to monitor

1. ORA-01403 in Stored Procedure: no data found Error In the stored procedure, select field name into variable from table name where .........; An error with ORA-01403: no data found occurs if the query is empty Test Table: Create table TEST_TABLE(T_

Error: ./Ggsci: error whileloading shared libraries: libnnz10.so: cannot open shared object file: No suchfile or directory. Problem Analysis: Obviously, the above error is reported because libnnz10.so of the library file is required when the./ggsci

Problem description: After Oracle 11g is installed, the following prompt is displayed when Eclipse is started: Version 1.3.1-01 of the JVM is not suitable for this product. Version 1.4.1 or greater is required. (Version 1.3.1-01 of JVM is not

Installing mysql using yum saves many steps for installing the source code package, but sometimes the problem that mysql cannot be started when mysql service is started after yum is packaged with mysql is reported as follows: can't connect to local

1. download the latest MongoDB version 2.2.2 from the official website. Click the mongodb download link, or open the terminal and enter a command such 2. After the download is complete, find the directory where the downloaded file is stored and

The installation of the MySQL database is described below: the versions of the two databases must be consistent.   Primary Database: 192.168.0.43 Slave Database: 192.168.0.53 Modify the configuration file of the primary database: Open the logbin log

In Oracle 10 Gb database, if you need to transfer the data files of one disk group in the ASM instance to another disk group. You can migrate data using a traditional file system or table space-level copy.For example, if there is a database sdb and

1. create necessary Directories D: \ app \ Administrator \ admin \ jxg12_20104350121 2. Create a database file storage directory under oradata D: \ app \ Administrator \ oradata 3. Create the initialization parameter file D: \ app \ Administrator \

Premise: the master-slave structure is in place, and the master database is not configured with persistence. Configure AOF from the slave database. (The master database is used for backup and write services, and the slave database is used to provide

The reset log option is used when the database is opened for the first time in the following cases: 1. Incomplete recovery 2. Backup control file-based recovery 3. create controlfile... RESETLOGS The primary role of log resetting is to Discard