Database Administrator

1. su-Oracle is not required. It is suitable for use without a DBA password. You do not need a password to enter the sqlplus interface.2. sqlplus/nolog, sqlplus system/manager, or./sqlplus system/manager @ ora9i;3. SQL> connect/as sysdba; (as

Oracle uses a variable-length storage method to store number data. Each number value is stored in the database in the form of scientific Notation: one byte is used to store the symbol/index, and up to 20 bytes are used to store the ending number.

When debugging the Oracle EM service on the local machine, the following interface is often displayed: "the security certificate of this website is faulty ". You often directly click "continue to browse this website (not recommended)" to enter the

Table creation statementDeclareV_ SQL varchar2 (32767 );BeginV_ SQL: = 'create table test (';For I in 1 .. 500 loopV_ SQL: = v_ SQL | 'name' | I | 'varchar2 (2000 ),';End loop;V_ SQL: = substr (v_ SQL, 1, length (v_ SQL)-1 );V_ SQL: = v_ SQL |

In daily applications, there is often a need for data changes in Audit, or data that needs to be tracked for data synchronization. (The most common applications, such as data synchronization in a data warehouse, need to synchronize data changes to a

1. By default, Oracle log files are recorded in the $ ORACLE/rdbms/log directory. [Oracle @ oracle log] $ pwd/Home/oracle/product/10.2.0/db_1/rdbms/log The log file is (alert _ ): [Oracle @ oracle log] $ ll Total 848 -Rw-r -- 1 aaa 962 06-20

The "SQL" Mark written in the implicit cursor. For example, SQL % ROWCOUNT indicates that the implicit cursor has several rows of records. The explicit cursor is customized by the developer, you can also use C1 % ROWCOUNT to indicate the number of

After modifying the template website locally, the database files under phpmyadmin have also changed. When you transfer the website to another place, you need to export the current SQL file and restore it.   When restoring data in Linux, do not

Oracle EBS R12.1.1 on Oracle Linux 64 5.7 The dependency package selects only the oracle-validated-1.1.0-14.el5, and no other dependency package verification is performed. 1. All http-related services fail to be verified in the last step. 1.1 run

Currently, ASM instances are widely used in both rac and single-instance database environments. This article mainly introduces the management of ASM instances in Oracle 11.2.0.3, including the following:1: view the status of the ASM disk and disk

1. Use mysqldump to back up mysql logically, and use binary log backup for Incremental backup. 2. Use lvs snapshots to achieve almost full hot backup from the physical point of view, and use binary log backup for Incremental Backup 3. Use percona's

Expired Oracle user logon password Modification 1. Check the user's proifle, which is generally default: SQL> SELECT username, PROFILE FROM dba_users; 2. view the password validity period settings of the specified profile (such as default: SQL>

I tried to install Oracle 11g R2 under CenOS s5.5 in VMware. I thought it was simple, but I found many problems. Installation steps: 1. check the corresponding rpm package It doesn't matter if the check is complete. It will check the installation of

Oracle 11g realbench 2 (11.2.0.1) reports an error when exporting an empty table. After checking the cause, it turns out that an optimization was made in this version. During table creation, no storage space is allocated. The storage space is

Data Integrity Overview 1. entity integrity An object is an object in the world. Every row in RDBMS represents an object. Entity integrity means that every entity can be differentiated. Therefore, entity integrity is generally achieved through

The following is a test on how to configure the db console in Oracle 10 Gb. EM is usually used too much and is not familiar with it. Test environment: OS: SOLARIS 10, DB: 10.2.0.1 1. EMCA Creation $ Emca-config dbcontrol db-repos create Started

Operating system version: 64-bit Linux Database Version: Any Version Problem description An error is reported when the database is started after the database parameters are modified. SQL> startup nomount ORA-27102: out of memory Linux-x86_64

Oracle conn protocol adapter error-Solution C: \ Documents ents and Settings \ administrator> set oracle_sid = myoracle C: \ Documents ents and Settings \ administrator> sqlplus/nolog SQL * Plus: Release 10.2.0.1.0-Production on Wednesday December 26

I. Hardware requirements1. Check physical memory requirements (> = 256 MB)[Root @ CentOS ~] # Grep MemTotal/proc/meminfoMemTotal: 1554748 kB 2. Check Virtual Memory RequirementsRAM 1-2 GB: swap 1.5 * RAMRAM 2-16 GB: swap = RAMRAM> 16 GB: swap 16

After Oracle 11g r2 is installed and the database is created, start em and report OC4J_DBConsole_source_ora11g not found error. em cannot start. [Oracle @ source ~] $ Emctl start dbconsole Enter the Configuration