Database Administrator

Today, our company needs to create an Oracle user for each customer. The requirement is about 300 Oracle users. There will be more in the future. It is difficult to create manually. I have found some methods that can be used in combination with the

When you first access RAC, You need to specify the location when creating a spfile, for example: Create spfile = 'xxxxx' from pfile; $ Oracle_HOME/dbs/init $ ORACLE_SID.ora The content is only shared with the spfile information in the disk. For

1. Mount the Backup Directory of the Backup Server 1. Create a backup file storage directory. catalog is not used here, so it must be the same as the backup directory path of the production database. Mkdir/prod/backup/ 2. Mount the Backup Directory

Unlike table scanning, index scanning only supports full table scans. Index scanning can be divided into the following types based on the actual situation: Unique index scan ). this scan occurs on the primary key or unique index. You can uniquely

The period-over-period ratio is the nth month of the year and the nth month of the year, or the nth month of the year. Create a test table, which is assumed to be a sales quantity table: Create table t (dt date, cnt number ); Insert some test data.

Mysql has a large number of character sets, from the client to the result set, from the server to the database to the table to the column, you can set character sets, flexible and powerful, but it is very prone to problems, if you do not understand

During routine database maintenance, we need to check the invalid object information in the database in time and re-compile the abnormal object. For various object types, see the following compilation method: Check the name of the generated Invalid

When the control file is corrupted for databases earlier than Oracle 11g, when we mount the database, there will be a significant ora-600 error, so it is easy to know the control file corruption error, however, oracle 11g R2, At that time, it was an

The query before Oracle 11g is as follows: Select d. value | '/' | lower (rtrim (I. instance, chr (0) | '_ ora _' | p. spid | '. trc 'trace_file_nameFrom(Select p. spidFrom sys. v $ mystat m, sys. v $ session s, sys. v $ process pWhere m. statistic

Environment:Oracle11g + IE9 Problem:Oracle Database ControlThe browser cannot log on Solution: Open your browser and enterURL:Https: // 127.0.0.1: 1158/emOrHttps: // localhost: 1158/em IfInternet Explorer cannot display the webpage, Follow these

1. Procedure for using a cursor (1) define a cursor Exec SQL DECLARE MY_CURSOR CURSOR ........ (2) Open the cursor Exec SQL OPEN MY_CURSOR; (3) read cursor Exec SQL FETCH MY_CURSOR INTO: MY_Stru; (4) Close the cursor Exec SQL CLOSE MY_CURSOR;

When do we need to use these two time periods? Let's briefly describe: If the monthly subscription product you purchased on April 9 is issued at the end of the month, you will be charged for 17 days. At this time, you should determine whether the

Conn sys/sys as sysdbaShutdown abort;Startup nomount;Select instance_name, status from v $ instance; Bringing the database to the mount statusSelect value from v $ spparameter where name = 'control _ files ';Alter database mount;The database Mount

The first time I installed MySQL on Linux (Ubuntu 10.10), I had to pay some twists and turns, and finally I had to figure out my ideas. Let's talk about how to install mysql in Ubuntu 10.10. The current mysql version is 5.5.20 and my system version

In daily maintenance work, users of a Database need to be migrated to another database. In this process, the same users and related permissions must be created in the target database, if the relevant user and permission information can be easily

Oracle EM Grid Control is a system management software that provides centralized monitoring, management, and lifecycle management for the entire Oracle IT architecture. The installation process is simple and easy to operate. In a customer

Oracle EBS Instance Cold Backup method (Cold Backup)1. Disable Oracle Application Server and DB Server2. SSH to Server using oracle users (Database Management Users)3. Create a backup directory4. Copy all the files in the DATA_TOP directory

Oracle 11g backup file imported 10g, *. dmp file imported to 10g encountered a lot of problems The following error occurs when I export data from 11 GB and then import the data to 10 Gb. IMP-00010: the exported file is not valid and the header

When backing up archive logs in Oracle databases, archive log files stored in the last few days are not deleted. For example: Backup archivelog all; Delete noprompt archivelog all completed before 'sysdate-7'; Save the archived logs for seven

Upgrading MySQL to 5.5.22 in Ubuntu 12.04 causes the original MySQL loading to fail. Solution: 1. completely uninstall the original MySQL Sudo apt-get remove mysql-server Sudo apt-get autoremove -- purge mysql-server Sudo apt-get remove