Oracle

As described earlier, Oracle provides two ways for database-level replication: A, Maintain_global B, Pre_instantiation_setup, Post_instantiation_setup Maintain_global is suitable for small and medium-sized database creation, while

After a new Oracle 11g RAC is installed, do you know what caused the CRSD on the second node to fail to start? The error message is Crs-4535:cannot communicate with Cluster Ready Services. Its specific error message also needs to see the Crsd.log

I. Several types of log files in Oracle Redo log files--> online redo logs Archive log files--> archive log Alert log files--> alarm logs Trace files--> tracking log User_dump_dest--> User tracking log Backupground_dump_dest--> Process trace

Just passed OCP last exam, from the training to review and complete the exam for a total of one months, the whole process is very compact also very nervous, very lucky or passed the exam, also not in vain this month's hard. First is the training,

This paper uses Oracle 11g Dataguard broker Switchover Test 1. Using Dataguard Broker Test switchover 1 Main Library situation Sql> select Open_mode,database_role,db_unique_name from V$database; Open_mode Database_role Db_unique_name -----------

The main function of library cache is to store user-submitted SQL statements, SQL statement-related parse tree (parse tree is the representation of all objects involved in SQL statements), execution plan, user-submitted PL/SQL program block

Client an Oracle suddenly when the machine, because the business start-up, the customer subconscious reboot the server, the system is up, ready to switch to Oracle users to start the database, can not SU switch, it is really to add to the

Use VBox to simulate storage migration environments, os:rhel5.9,db:oracle 10.2.0.4 RAC ASM 2Nodes. ASM uses extern redundancy, which does not use ASM's rebalance functionality, and OCR and Votedisk are stored in raw. Migration includes Controlfile,

This error frequently occurs in Oracle data after an illegal shutdown: Exp-00056:oracle Error 1033 appears Ora-01033:oracle initialization or shutdown in progress User: Password: This is obviously the database does not have the means to start,

ORADBI was developed on the basis of Oracle OCI (Oracle Invoke interface), supporting databases such as Oracle8i, 9i, 10g, and so on. According to Oracle's introduction: OCI is so reliable that every SQL statement in an Oracle database is executed

Experimental environment: SOURCE End: ip:192.168.40.10 Database:oracle 11.2.0.1.0 ORCL os:oel5.6 Ogg:fbo_ggs_linux_x86_ora11g_32bit Target side: ip:192.168.40.128 database:10.2.0.1.0 ORCL os:oel5.6 Ogg:fbo_ggs_linux_x86_ora11g_32bit First

Oracle_ Single Function _ number function 1.abs (x) To get the absolute value of X 2.ceil (x) Used to get the smallest integer greater than or equal to X 3.floor (x) Used to get the largest integer less than or equal to X 4.mod (X,y) The

The maximum number of partitions that can be allowed in a table has not been much cared for before. If you don't check the document, is there a quick way to get the results? At that time, manual is 11.2 environment, so first thought of the interval

Two days ago, I wrote an article about a series of regular functions such as length to handle LOB types, and someone mentioned in the blog reply that using length is more efficient than dbms_lob. GetLength Low, here's a simple test. Create a test

On the itpub saw someone raise this question, can use the data pump to export a query result. In fact, the data pump really has this function. Establish a simple test environment: sql> CREATE TABLE T1 2 (ID number, NAME VARCHAR2 (30)); Table

It is very important to develop database applications and choose a good database. This article compares SQL Server with Oracle, DB2 three kinds of database from some aspects, provides some reference for you to choose the database. Open SQL Server

Crystal Report version is 8.5 Stored procedures are: create or replace package pkg_test4astype v_cursor is ref cursor;end pkg_test4;/create or replace procedure pro_test4(P_CURSOR in out pkg_test4.v_cursor)assqlstr varchar2(3000);beginsqlstr

For example, the database administrator now needs to have the Oracle database System Monitor itself. Automatically alert the database administrator when the CPU usage of the server is reached, or automatically remind the database administrator, etc.

Today, a development library can not start, sent over an error to see the log file is damaged (see), and then said the cause and the cause. Said the server was out of power and then did not start up again. Today someone used to think about dealing

--Login RmanRman Target/Rman Target Sys/passworkRman Target sys/passwork nocatalog (control file mode)Rman Target sys/passwork Catalog (Restore directory mode)--View parametersShow All--Modify Save DaysChange the number of days that backup