Oracle

A RAC concurrencyThe essence of RAC is a database running on multiple computers, the main task of which is that the database is transaction processing, and it solves the concurrency problem by distributed lock Management (DLM: Distributed lock

1. Types and Status of Oracle database clientsAt present, Oracle Database Maintenance management, usually using the client software: PL/SQL developer,sql* plus,toad,em, such as data management, maintenance and other operations. Most of these tools

Installation tutorials for oracle11g Unzip two zip files simultaneously, generate a database folder, go to the database folder, click Setup Remove the security update option and go directly to the next step

Win32 does not install Oracle clients using PLSQL1. Ready to work 1.1 download Plsqldev hack version softwareI use the plsqldev715 version here1.2 Download instantclient-basic-win32-11.2.0.1.0 Oracle official website Download 2. Plsqldev Installing 2

Oracle Notes (11) Build table, update, query comprehensive exercisesThere is a database of information about a student sports meeting, and the following tables are saved: Athlete Sporter (athlete number Sporterid, athlete name name, athlete

This blog post focuses on installing Oracle 11g in a CentOS environment. The system environment is CentOS7.2.Pre-installation Environment preparationTo install the required packages:Yum install binutils compat-libcap1 compat-libstdc++ gcc gcc-c++

About Instant client installation steps1. First download two installation package Instant/sqlplus on the official website, unzip the relevant files, and store the local pathwebsite

There are times when the requirements of the system are recorded in milliseconds (millisecond), and we are going to write the values in db, but if we want to use SQL to do time-range searches, there are a few things to do with the following (

Oracle 12cProblem:If ORACLE patch PSU 22191659 binary also upgrades the database dictionary through $oracle_home/opatch/datapatch-verbose.Next, the patch Super-patch PSU 25433980 binary is continued, but the $oracle_home/opatch/datapatch-verbose is

In Toad, the undo tablespace undotbs1 usage has reached 100%, but the strange thing is that the database does not hang and still works. The use of the EM View UNDOTBS1 table space provided by Oracle also achieves 78.8 In the previous article, we

No suitable driver found for jdbc:oracle:thin:@192.168.7.146:1521:oracleThe reasons for this error are mainly the following:1. URL configuration error (similar to the following)2. JDK version, JDBC version, and error caused by inconsistent database

1) ora-01653 error:You can see that inserts with two tables are affected, both in the Users table space. Use the following SQL to view Tablespace usage:SELECTA.tablespace_name "tablespace name", A.bytes/ 1024x768 / 1024x768"Tablespace size (M)",

--Build usersCREATE USER Szs identified by Szs DEFAULT tablespace nn_data01 temporary tablespace temp;--User empowermentGRANT connect,dba to Szs;GRANT CREATE synonym,create PROCEDURE,CREATE sequence,create session,create table,create trigger,create

1. Create a new tableCREATE TABLEYsb_log (ID Number(8)Primary Key not NULL, Tbdatevarchar( -)NULL, Tb_timevarchar( -) not NULL, Tblogvarchar( -) not NULL, Tbreorvarchar2( -)NULL, BSvarchar( -) not NULL );In Oracle, sequence is the so-called

In the Oracle database experiment will use some examples of schema such as: HR, OE, SH, etc., in the oracle11g version of DBCA when the direct tick sample schemas can install the sample schema, such as:650) this.width=650; "src="

The reason for this article is that there is no root permission on the company's servers, but you need to use Python to access Oracle, regardless of whether you use PIP to install components or to install Oracle's client. This article resolves the

Navicat Premium for Linux 64-bit remote Oracle database tutorial, navicatpremium If you are a friend of Desktop Linux who uses Oracle databases, they will think of Navicat. Although this little item is charged, it is really easy to use and has a

Oracle 11g R2 installation tutorial in Windows, oracle11gInstalling Oracle 11g R2 in Windows Oracle 11g has two major versions, one for R1 (Release 1) and one for R2 (Release 2, the version used in this tutorial is Oracle Database 11g Release 2 (11.

Oracle Database Change and backup database step tutorial, oracle backup tutorialOracle Database Change 1. Stop the Application Middleware involved/lock the oracle user alter user GWM_BL_UAT account lock View select username, account_status from

Instance code for Oracle 11g User Password modification and lock/unlock function, oracle11g 1. Run cmd.exe; 2. Enter sqlplus/as sysdba to connect to the database as a system administrator (sysdba) for database management. 3. After successful