Oracle

Oracle database instance startup, strictly should be the start of the instance, the database is only loaded after the instance is started. The Oracle data startup process is divided into Several different steps, in the different boot process, we

Description The official recommended migration to the same version, such as: 10.2.0.1 (32) migrated to 10.2.0.1 (64). Upgrade to 10.2.0.5 (64). First, the environment introduction Source Library Operating system version: OEL5.8 32bit Database

A lot of the time, do Oracle DBA us, when the application administrator to inform us that the application is now slow, the database is very slow, when we go to the database to do a few examples of select also found the same problem, sometimes we can

In some scenarios, if there are problems with the host in the RAC environment, such as hardware failure, we need to store the startup database as soon as possible, and restore the business, then we need to migrate the previous RAC environment to the

Data Schema Primary: The code is as follows Copy Code hostname    databasename    unique_dbname   INSTANCE_NAME RAC1                  orclpd                            orclpd                              ORCLPD1 rac2  

In exchange for a number of systems and finally the use of CentOS installation Oralce successful, I also refer to the web of a lot of information and Oracle's official documents 1, download Oracle, I choose here is the 11GR2 version, download down

Method One, install Oracle client Download Instant-client Installer to website Http://www.oracle.com/technetwork/database/features/instant-client/index-097480.htmlTake Redhat 32bit For example, where you choose to download instant Client for Linux

Blocking is a common scenario for DBAs, especially where poor application design blocking can cause severe performance degradation until the database crashes. For DBAs, it is necessary to know how to navigate to what is blocking the current system,

The Oracle tutorial you are looking at is the Oracle Pl/sql introductory case practice. We have already learned the basics of pl/sql programming, and this article will combine a case to deepen understanding of these knowledge points. A Case

(1) DES encryption function Create or Replace function encrypt_des (p_text varchar2, P_key varchar2) return varchar2 is v_text varchar2 (4000) ; V_ENC varchar2 (4000); Raw_input RAW (128); Key_input RAW (128); Decrypted_raw Raw (2048); Begin

LOB types are divided into BLOBs and CLOB two: BLOBs-binary large pair images (Binary Large Object), which are used to store text-throttling data (such as programs, images, audio, video, and so on). CLOB, a character-type large pair (Character Large

Step One: Enter the client shell fulong@fbi008:~$ sqoop.sh Client Sqoop Home directory:/home/fulong/sqoop/sqoop-1.99.3-bin-hadoop200 Sqoop shell:type ' help ' or ' \h ' for help. Sqoop:000> Set server--host FBI003--port 12000--webapp Sqoop

This is a set of Windows RAC environments, as well as an environment that previously dealt with a performance failure caused by a row cache lock. Here is a record of the process: 1 for the one-hour AWR collection and analysis, first of all, from

This error is rather strange, setting Autotrace is a sp2-0611 and ORA-942 error. Version 11.2 for Linux x86-64: Sql> CONN Test/test is connected. sql> SET Autot TRACE An error occurred while collecting statistics ORA-942 sp2-0611: Error while

Oracle has actually introduced this feature in 11.1.0.6, but there are bugs in 11.1.0.6. Here is a brief introduction to the Remap_table feature in 11.2. Look at a simple example: Sql> select * from V$version; BANNER -----------------------------

Summary The 4th method of dynamic SQL uses Sqlda (the SQL Descriptor area) and Oracle to Exchange data to perform SQL statements that do not know the number and type of select table entries or virtual input host variables until the program is run.

A major feature of the 10g data Guard is the introduction of the Log_archive_config parameter, which may cause the archive path to be disabled if this parameter is missing. See other people set up data guard encountered this problem, then feel more

The process of storing a picture file, any development tool can store the picture text in the database by calling the procedure. Detailed steps: Microsoft Windows 5.00.2195 [Version] (C) Copyright 1985-2000 Microsoft Corp. C:\Documents and

Recently saw a lot of people talk about TNS or database can not log in and so on, simply summed up the following dongdong. First of all, Oracle's network structure, to complex to say can add encryption, LDAP and so on. There is no discussion here,

Some time ago in a migration of data pump and exp, found that the difference in efficiency is quite large. Here is an example of a simple comparison. This article discusses the most important factors that affect the performance of data pump imports.