Database Administrator

Problem: [Oracle @ localhost install] $./runInstallerStarting Oracle Universal Installer...Checking installer requirements...Check operating system versions: Must be RedHat-2.1, redhat-3, redhat-4, SUSE-9 or UnitedLinux-1.0 passedAll installer

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,

1. first, SUSE and RedHat are different in the installation process. Some parameter files after installation are different. After SUSE is installed, the Oracle user, DBA, both groups are created by default. For ROOT, there is only. bashrc under its

For example, update table1 t1 set t1.name= (Select t2.name from table2 t2 where t2.age = 20) Cause of error: the subquery contains more than one record. If you want to update data in batches, You can nest the data, for example, the following SQL

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

An Oracle database of 10.2.0.1 is installed on aix6.1. If you want to enter 10.2.0.5pathc, an error is returned. The specific error was forgotten at the time. It probably means that the system process of some prompts will be ended. Later, I checked

Mysql supports ifFormat:IF (expr1, expr2, expr3)IF expr1 is TRUE (expr1 <>; 0 and expr1 <>; NULL), IF () returns expr2; otherwise, expr3 is returned. IF () returns a number or string value.For exampleSelect if (1 Output yes In addition, caseSelect

I. significance: We know that the database has at least two sets of online log files, which are recycled.The archive mode stores a copy of the file before the online log file is repeatedly reused (overwritten) to other locations, so that we keep all

Suddenly one day, good system error: ORA-01722 invalid number Environment: Oracle9 + JDBC access to the database. It was okay before. This error was suddenly found. Later I learned why 1. The following SQL statement is executed in the Code:

The installation of Oracle 11.2 rac on vmware workstation 7 is very painful. Record the configuration of the Virtual Machine file: . Encoding = "GBK"Scsi1.sharedBus = "virtual"Disk. locking = "FALSE"DiskLib. dataCacheMaxSize = "0"DiskLib.

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

I believe everyone has encountered the lock table. I think everyone knows the unlock method, but the killing processes are sometimes low-level. We use stored procedures to implement this function, it becomes very simple. 1. Create a view to query

In archive mode, you may need to migrate some data from one disk group to another. In this case, we can use the "backup as copy" command to move the data file to the new disk group. Then, run the "set newname" and "SWITCH" commands to change the

User names and passwords are incorrect in batches, leading to library cache lock) Database VersionSQL> select * from v $ version; BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise

The table is rarely modified. You can create more indexes, especially read-only tables.There are many changes to the table, which need to be considered. 15% of the data below is suitable for index creation The index does Not contain null, so it is

Note:1. The runInstall commands of different versions may be different. The same commands may not be common among different versions. 2. because the Oracle software is installed and the Enterprise Edition, all preparations for early installation are

Fs. aio-max-nr = 1048576 It refers to the number of asynchronous IO requests that can be simultaneously owned. The value appears in the/etc/sysctl. conf file. The recommended value is: 1048576, which is equivalent to 1024*1024, or 1024 K. Fs.

Environment Description:OS: CentOS6.5 _ X64MASTER: 192.168.0.202BACKUP: 192.168.0.203VIP: 192.168.0.2041. Configure two Mysql master-master Synchronization[Root @ master ~] # Yum install mysql-server mysql-y[Root @ master ~] # Service mysqld

Environment:Platform: RedHat EnterPrise 5.8 X86_X64Database: Oracle EnterPrise 11.2.0.3Cluster software: Oracle grid 11.2.0.3 Fault symptom:An archive failure occurs in the database, and an instance of one node is HANG dead. The log information is