Oracle

Oracle 11g-LockTarget:1. Understanding the concept of locking2. Mastering the use of select for update3. understand the meaning of different locksThe concept of Lock:1. A lock is a mechanism that the database uses to control concurrent access to

--**************** Basic Query ****************--query the last name of all employees-eliminate duplicate surnames-Create a query to display the unique job code in the Employees table-Create a query that displays the last name of each employee, The

Prerequisites: For OPENJDK and JDK differences and links, see this article anyway, remember that a word jdk is more complete and stable than openjdk.I am using openSUSE 13.1, the default is OPENJDK after installation, the following is the process of

Create a parameter stored function findempnameandsal (number), query number No. 7902 employee's name and monthly salary, "return multiple values, demonstrate the use of out"When 2 or more values are returned, an out symbol must be usedWhen 1 values

1. Official website Download:Instantclient-basic-win32-11.2.0.1.0.zipInstantclient-sqlplus-win32-11.2.0.1.0.zipInstantclient-odbc-win32-11.2.0.1.0.zipInstantclient-jdbc-win32-11.2.0.1.0.zip2. Unzip to the same folder. such as C:\OracleInstantClient_1

CREATE OR REPLACE FUNCTION f_trans_pinyin_capital (p_name in VARCHAR2) RETURN VARCHAR2 asv_compare VARCHAR2 (100); V_return VARCHAR2 (4000); FUNCTION F_nlssort (P_word in VARCHAR2) RETURN VARCHAR2 asbeginreturn nlssort (P_word, '

1 Tuning Design Architecture Design (rac/stand-alone), application design (module design, e-r model design) 2 Tuning applications Code tuning, applying storage object tuning 3-Piece Memory Data cache area, shared pool, redo log

Rediscover Oracle's Beauty Glogin.sqlWhen we first came into contact with Oracle, sometimes when you landed in a production environment, the following situation often occurred:[Email protected] app]$ Sqlplus/as SYSDBASql*plus:release 11.2.0.4.0

Process- -- database - ObjectProcess -Server -User - ObjectProcess -database -User - Schema - ObjectMySQL, Oracle, Db2Have not done Oracle multi-instance, DB2 is also just touching, plain understandingMySQL this way is very early most people

Oracle11g RAC construction in linux (9)8. Create an ASM warehouse Perform operations on the GUI [Root @ node1 ~] #Su-grid [Grid @ node1 ~] $Asmca // Create two disk groups: Data File disk groups and fast recovery disk groups [Grid @ node1 ~] $Cd/u01/

1. ASCII (C) Returns the corresponding decimal number of the first character of C in the ASCII code. Example: SQL> select ascii ('A') A, ASCII ('A') B, ASCII ('0') C, ASCII ('') D FROM DUAL; A B C D ---------------------------------------- 65 97 48 3

What OLR needs to know in oracle 11g GRID 1. Check the olr status:[Root @ vmrac1 ~] # Ocrcheck-localStatus of Oracle Local Registry is as follows:Version: 3Total space (kbytes): 262120Used space (kbytes): 2748Available space (kbytes): 259372ID: 93575

Oracle obtains all objects dependent on a package, including its sub-objects. A temporary table is used to record the nodes that have been traversed. At the same time, a number of layers are used to record the packages that have been traversed. High

Oracle11g RAC construction in linux (8)7. Install oracle software Install oracle directly in the graphic interface and operate on node1. On the virtual machine interface, directly switch to the oracle user: [Grid @ node1 grid] $Su-oracle

This error occurs because the host name and/etc/hosts file are inconsistent. You only need to write the host name and its IP address to the/etc/hosts file and then OK. Note that the name cannot contain underscores. In addition to modifying the

Oracle 11g ocr redundancy configuration During the 11g installation process, only one dg can be specified by default for storage: crs, votingHowever, oracle officially recommends that you configure the settings as follows: 1. When no image is

Introduction to Oracle elastic uard I. Basic principles of DataGuard When a transaction changes the data in the production database, the Oracle database records the change in an online redo log file. You can configure the log Writing Process in the

Repeat the case: Dbca database creation, SID: metro-metro with lower-case Instance name when manual database creation ...... [Oracle @ org54 ~] $ Export ORACLE_SID = METRO -- manually inject SID because no environment variable is set[Oracle @ org54 ~

Possible causes and solutions for ORA-27302: failure occurred at: skgpspawn3 Symptom: Mon May 26 07:08:58 GMT + 08:00 2014 Process startup failed, error stack:Mon May 26 07:08:58 GMT + 08:00 2014 Errors in file/oracle/app/admin/oracle10/bdump/oracle1

Establish Oracle11g RAC in linux (2)1. Test IP address occupation configured for the network before installation Go to windows, run cmd, and run the ping command to verify whether the network segment is occupied. Note: You can use any CIDR block.