Database Administrator

Oracle recycle bin recyclebin Racle10g Recycle Bin 1> what is Recycle Bin? In fact, Recycle Bin is only a data dictionary table that stores the drop object. Therefore, you can use the following statement to query information in the recycle

Oracle limits the number of connections and PROFILE of a user Today, a colleague called to limit the number of connections of a user, which can be achieved through the Oracle PROFILE file. 1. View resource_limit parameters: SQL> show parameter

Database ORA-00600 of a provincial telecommunications industry company [15160] Systems: HP-UX B .11.31 RAC: YES Database Version: 10.2.0.4 1. Background : 39dbrac database Node 2, found a lot of ORA-600 errors in the alert Log, the analysis is the

Oracle ASM introduction and installation of Linux5.2 + Oracle10g + ASM Process 1) The reason for ASM (Automatic Storage Management: ASM is a new feature in Oracle 10g R2 to simplify the management of Oracle databases. It is a volume manager provided

Linux MySQL dump program crashes. Follow the three simple steps below to easily solve the problem. 1. For Linux mysql dump, ensure that the directory where Coredump is stored exists and the process has write permission on the directory. The

1. Start and Stop a database 1. Start the database 1.1 log on. XX-laptop :~ $ Sqlplus "scott/tiger as sysdba" The following Connection database information is displayed: SQL * Plus: Release 10.2.0.1.0-Production on Mon Aug 9 15:30:16 2010 Copyright (

RMAN is a backup and recovery tool provided by Oracle. It can be used to back up and restore database files, archive logs and control files. It can also be used to perform full or incomplete database recovery. RMAN can be controlled by the command

ORA-00911: Invalid character error, invalid ora-00911 character ORA-00911: Invalid character error -- caused by a minor error in the compilation environment   Implementation of a function script statement, compile, there is a ORA-00911 error, at

Chapter 1 Securing Your Server and Network (4): Use the virtual service account, chaptersecuringSource: Workshop Without the consent of the author, no one shall be published in the form of "original" or used for commercial purposes. I am not

[INS-20802] Oracle Database Configuration Assistant failed, ins-20802assistant 1. Error cause [INS-20802] Oracle Database Configuration Assistant failed 2. Error cause 3. Solution Please help me. This error is always reported when ORACLE is

Hanganalyze 3 analysis summary (test ),Hanganalyze 3 analysis summaryOne is session-level:Alter session set events 'immediate trace name HANGANALYZE level ';One is the instance level:ORADEBUG hanganalyze One is the cluster scope:ORADEBUG

[Translated from mos] after removing the trace file from the OS, how can I find the trace file content ?, MostraceAfter removing the trace file from the OS, how can I find the content of the trace file? Reference Original: How to Find the Content

Football and oracle series (4): from Brazil to Germany, think of the different RAC topology comparison !, OracleracFootball and oracle series (4): from Brazil to Germany, think of the different RAC topology comparison! Preliminary review: I was

Oracle blocking (blocked), blocking Blocking is a common situation for DBAs. especially poor application design blocking can cause serious performance degradation until the database crashes. For DBA, it is necessary to know how to locate the system

Original blog link address: Database open error ORA-01555: snapshot too old During his honeymoon in Dongguan today, a student said that the test library he managed had a problem and could not be opened. Let's first look at the problem:

Profit Return shopping http://www.bbuy8.com Shopping rebates are justified, but the rebates are not high. (1)SQL State: 42831 [Error Code:-542, SQL State: 42831] DB2 SQL Error: SQLCODE =-542, SQLSTATE = 42831, SQLERRMC = BATCH_NO, DRIVER =

Project Development Plan (GB856T--88)1 Introduction 1.1 Writing Purpose A project development plan is a preliminary plan for determining the project to be developed. You need to have a rough understanding of the conditions required during the

Introduction to the high availability of a replica set The replica set achieves high availability through automatic failover. When the master node fails, the slave node can be elected as the master node, and this process is automatically performed

Install Oracle 10g RAC with 64-bit redhat4.8_64 under VMware-simple script I. Preparations 1. System Information [Root @ r4r4o10n1 ~] # Uname- Linux r4r4o10n1 2.6.9-89.EL #1 Mon Apr 2010:edt 2009 x86_64 x86_64 x86_64 GNU/Linux VM: vmware workstation9

After the rac has been installed some time ago, You need to verify whether the Rac is correctly installed and how to start and close the Rac. Start learning Rac today and record your notes again! First: Verify RAC: Verification listening: Node