Database Administrator

I. Oracle 9i has two undo management methods:AUM Automatic Undo ManagementMUN Manual Undo ManagementWe recommend that you use AUM.Undo segment is also called rollback segment. Ii. Three major functions of undo:1. provide Consistent Read2. roll back

In vim editing mode, the number of lines "sudo vi/etc/vim/vimrc" can be displayed. Add "set nu" to the opened file and save the settings and exit. Use: "vi. bash_history" to view the previously entered commands When compiling the database program

The auto-increment column here mainly refers to the auto-increment of the primary key id in a table. Unlike Mysql, Oracle cannot set the auto-increment column feature when creating a table in CREATE. Oracle must automatically add columns by creating

I haven't logged on to a database for a long time. When I log on, I will prompt that the password will expire and update it. C: \ Users \ Administrator> sqlplus/nolog SQL * Plus: Release 10.2.0.1.0-Production on Sunday July 17 14:23:25

Summary of Oracle transmission tablespace migration data Note: users must be created before the tablespace is migrated. Otherwise, the migration will fail. Sometimes, we need to migrate relatively large data across platforms (10 Gb supports

I always wanted to deploy phppgamdin, But I encountered different problems when installing phppgamdin in RedHat and Windows. Because I am not familiar with the web stuff, I finally ended up failing. For details, see: On the weekend, I was suddenly

ROLLUP will gradually remove a field on the right from the right to the left Based on the field following group by, and gradually sum up, CUBE sums all the combinations of fields after group. CUBE eg1: SELECT department_id, job_id, SUM (salary)

Test environment: OS: RedHat 5.5 DB: Oracle11g Logminer is integrated with oracle as a related log analysis tool. We can use this tool to clearly analyze the changes of all things in related logs and archive logs, in addition, you can accurately

Today, a colleague wrote to me: "I mistakenly dropped a stored procedure: P_IPACCHECK_NC about 10 minutes ago. The source code of this stored procedure is not backed up on my local machine, please recover. Thank you"  This recovery is very easy,The

Run ps-ef | grep ora _ to check that no Oracle process is found.Entering the database boot encountered a ORA-01261: ORA-01262: error. $ Sqlplus "/as sysdba" SQL * Plus: Release 10.2.0.1.0-Production on Tue Dec 15 08:25:22 2009 Copyright (c) 1982,2

JDK is often installed and some configuration files are edited when you install a web server in Linux. how to configure the configuration? Let's start the basic operations: 1. Install JDK: (1) download the jdk-1_5_0_04-linux-i586-rpm.bin from SUN,

Pfile The pfile (ParameterFile) file is a text-based parameter file that contains database configuration parameters. Oracle 9i creates a pfile for each database during installation. The default name is "init + routine name. ora", which is a text

The most important task for a database administrator is to ensure that the database does not lose data. The redo and revoke mechanisms ensure that the database will never have a commit error no matter what operations the DBA has performed. However,

Errors that occur when a user is authorized: # Sqlplus/as sysdba SQL> grant sysdba to sys_user_admin;Grant sysdba to sys_user_admin * ERROR at line 1: ORA-01994: GRANT failed: password file missing or disabled SQL> show parameters pass NAME TYPE

1. Exception HandlingA warning and error in pl/SQL is called an exception. Exceptions include compilation exceptions and running exceptions. 2. Exception ClassificationSystem exceptionCustom exception 3. Abnormal Structure ExceptionWhen... then.. 4.

The following is an example and description of creating an auto-incrementing sequence for a field in an Oracle table. /* ===================================================== ======================================= *//* Set auto-increment sequence:

ASH usageSQL>@? /Rdbms/admin/ashrpt. SQL Current Instance~~~~~~~~~~~~~~~~DB Id DB Name Inst Num Instance-------------------------------------------450641661 SUBSDB 1 subsdb Specify the Report Type~~~~~~~~~~~~~~~~~~~~~~~Enter 'html' for an html

1. Patch preparation There are four main points:1) use Telnet to log on to the application server and check the Unix server type. Currently, there are three types of server (ibm aix, SUN Solaris, and hp ux.2) view the version number of the program

1. Environment DescriptionMysql manager node: 192.168.0.1MysqlServer node: 192.168.0.100Mysql node: 192.168.0.160Mysql node: 192.168.0.161Note: At least four servers are required for the mysql cluster. We recommend that you add five more MySQL

In this lab, the spfile and pfile are recovered when the database is lost in both open and shutdown conditions. Oracle @ aoracle dbs] $ rman target rman_user/rman_user; Recovery Manager: Release 10.2.0.1.0-Production on Thu Dec 8 19:21:38