Database Administrator

Instance Design 1. Function DesignA graduate Enrollment System developed by a university requires the design of PL/SQL programs to process the examinee's Score data, the processing logic is to automatically classify the candidates into admission,

The steps in this article have been verified in both virtual machines and servers. At the end of the article, I listed the solutions to the vast majority of problems encountered during the installation process. System and Oracle installation file

MySQL: UTF-8 character set Oracle: Al32UTF8 Steps: 1. Export csv format data from mysql. Set default_character_set = gbk during export; otherwise, garbled characters will occur. 2. upload to the linux Server (oracle Server) and replace \ r \ n

A php program is downloaded and runs normally on Windows. However, when running on Linux, the system prompts that the table does not exist. It turns out that MySQL is not case sensitive in Windows, so it is normal. However, in Linux, because MySQL

After the LAMP environment is set up in Linux, I want to link some of my websites to Linux. To ensure security, I need to set the root password in mysql (the default root password is blank) previously, the mysqladmin-u root-p password bixinnan

1. hardware configuration instructions:The swap partition of Fedora 14 must have at least 2048 MB; otherwise, a warning is reported during Oracle installation.2. software requirements1) dependent software packages to be installed or upgraded.Make-3.8

Kingdee EAS7.0 is deployed in the latest LINUX and Oracle 64-bit environments. The configuration is complex: RedHat ENTERPRISE 5.4X64 configure Oracle 11gR2 step overview: 1. decompress the oracle_installation package. Zip. Copy the second

In windows, you can set Oracle service to automatic in Computer Service Management. After Oracle is installed in Linux, Oracle will not start automatically if Linux is restarted, you can manually call the dbstart command to start the instance, but

Transactions and locks have the following features: A transaction is a unit of work, either completely or completely.Transactions ensure operation consistency and recoverabilityEach Transact-SQL statement can be a transaction.The actual transaction

I. How to expand the linux swap spaceA) Login as the root user B) Type following command to create 512 MB swap file (1024*512 MB = 524288 block size ):# Dd if =/dev/zero of =/swapfile1 bs = 1024 count = 524288 C) Set up a Linux swap area:#

I. EnvironmentServer1: 192.85.1.5Server2: 192.85.1.4Server3: 192.85.1.9 Ii. Cluster Solution1. Management node: server12. storage nodes: server2 and server33. SQL nodes: server2 and server3Upload the file

Operating System: CentOS 5.5 (1) install MySQL The most convenient way to install MySQL on this operating system is to use yum for installation: [Root @ localhost yum. repos. d] # yum install mysql-server (sometimes the network is slow, it will take

Install Ubuntu 10.10on Windows 7. download and run wubi.exe to install the software on any disk. Install Oracle in Ubuntu... Hard work! But it's okay! I found a lot of information and made a lot of detours. The summary is as follows: First,

RMAN retention policies are related to data integrity. Therefore, they are important and set based on user-defined data recovery tolerance. That is to say, based on the recovery needs, the user needs to retain data for several days, or the user

System Environment: Linux CentOS-6.4-64bit During the MySQL setup process, the default Root account can only be accessed from the local machine. If you want to access the MySQL database on Linux through other machines, you must make some

Because apache of this project is only used to download the function and install phpAdmin to find the database, and Mysql 5.6 has been installed before, it is directly installed using the yum command method during deployment. However, when using

You can use sqlplus to connect to an Oracle database and then use the database interactively. Another non-interactive method is to directly execute SQL commands through shell, which can be directly executed on the shell CLI port or through shell

A problem occurred on the contact marketing platform a few days ago. Ask a colleague to help solve the problem. The result is two days later and the problem is still not located.We still need to solve the problem near the Spring Festival. We have

1. Upgrade Grid Infrastructure1.1 prepare 1.1.1 software before Upgrade   Needless to say: Download, upload to server, decompress  1.1.2 create a new HOME for GI Mkdir-p/u01/app/11.2.0.4/grid Chown-R grid: oinstall/u01/app/11.2.0.4 Chmod-R

1. Full backup database, and the Backup Type is specified as backupset RMAN> backup as backupset database; Starting backup at 13-FEB-14Using channel ORA_DISK_1..... 2. Back up the users tablespace again and specify the Backup Type as backupset. RMAN>