Database Administrator

Common ErrorsError 1: Use SID = 'sqcx 'to create an automatic instance RMAN-00569: ==================== error message stack follows ==========================RMAN-00571: ========================================================== =====================

Background The architecture of Oracle Apps is very complex and many technologies (or services) are used ). For example, Apache Web server, Apache Jserv, Forms Listener servlet (or forms server), and so on, each service has its own configuration file.

When multiple instances run on the same server, the concept of instance cage is introduced from Oracle 11gr2 to avoid mutual impact between instances. Instance cages can limit the CPU resources used by database instances. To use an instance cage,

What are the differences between the following three SQL statements for join queries? SELECT * FROM film JOIN film_actor ON (film. film_id = film_actor.film_id)SELECT * FROM film JOIN film_actor USING (film_id)SELECT * FROM film, film_actor WHERE

DUPLICATE Overview The rman duplicate command can be used to create a copy database (DuplicateDatabase) based on the backup of the target database (TargetDatabase) while retaining the target database ). This copy can be exactly the same as the

Environment:OS: Red Hat Linux As 5DB: Oracle 10.2.0.4 Generally, the character set is selected during installation. to modify the character set of the database, we recommend that you recreate the database (EXP/EXPDP export before importing ),

Using RMAN to fix the issue based on time points, the strange thing is that, after setting nls_date_format, you cannot log on to RMAN?Symptoms: C:> set NLS_DATE_FORMAT = 'yyyy-MM-DD HH24: MI: ss' C:> rman nocatalog target rman/rman @ test Recovery

1 create or replace procedure stored PROCEDURE name2 IS3 BEGIN4 NULL;5 END;　　Row 1:Create or replace procedure is an SQL statement that notifies the Oracle database to CREATE a stored PROCEDURE called skeleton, and overwrites it if it exists;Row

For Oracle 10 GB: 1. If you do not remember the password of sys, you can change the password as follows: (1) Open cmd, enter sqlplus/nolog, and press Enter. (2) Enter "conn/as sysdba "; (3) Enter "alter user sys identified by new password;" (the new

Oracle retrieves data for a certain period of time: Sysdate + 1 is plus a day, sysdate +/-(1/48) is plus/minus half an hour Select count (*) from table_name where table_name.date between to_char (sysdate-1/48, 'yyyymmdd HH: Mi') and sysdate Date

1. Create a function in Oracle Create[Or Replace]FunctionFunction_name [(Parameter_name [In|Out|In Out] Type [,...])] Retutn type Is|As Begin Function_body; End; Note: The function must return values.Or replace: If the function already

Recently encountered a problem in the project, and the current affairs of updating expired data were not rolled back. The transaction configuration was carefully checked before and after, and the problem was not found. Finally, after one-step

Expdp export simple notes 1. To create an accessible Oracle directory, you must grant the oracle: oinstall permission.[Root @ oracle/] # chown-R oracle: oinstall/data1 2. Switch to an oracle user[Root @ oracle/] # su-oracle 3. Create an expdp

Deferred_segment_creation causes EXP-00003New features in version 11G. To avoid wasting resources, creating a non-partitioned empty table will delay the creation of segment, including the table-related objects LOBS and indexes.Explanation of

1. Create a data table CREATETABLETEST ( ID NUMBERNOT NULL ,NAMEVARCHAR2 (20 BYTE)NOT NULL , BOSS_ID NUMBER ,CONSTRAINTTEST_PKPRIMARYKEY ( ID ) ENABLE ); ID indicates your employee code BOSS_ID indicates the code of the superior

Code 16014 After checking, the system finds that the disk space is full. Therefore, the redundant disk space is deleted and the problem is temporarily solved. The problem will occur again after half an hour. After analysis, the size of the recovery

Mysql5.5 master-slave replication of triggers, functions, storage engines, and events. I. There are three modes for MySQL master-slave replication. 1. binlog_format = row: the log records each row of data in the modified form (record page), and then

Cause: For non-important files, it usually does not cause the instance to crash. Oracle will take these damaged data files offline and make their content inaccessible, but the rest of the database should be open. Damaged important data files can

Oracle 10 Gb or above password failureOracle em cannot log on. My own problems are summarized as follows: Two of them may have invalid passwords.1. sysman2. dbsnmpSYSMAN and DBSNMP are different from Oracle's EM.DBSNMP is a user used in the Oracle

1. First install the mysql database (install the database by default) Yum install mysql * Ii. Modify the mysql configuration file The configuration file installed by default in mysql of CentOS series is in/etc/my. cnf Modify my. cnf as follows: vi