Oracle

Windows Registry Editor Version 5.00[-hkey_local_machine\system\currentcontrolset\services\oracleoradb11g_ Home1tnslistener][-hkey_local_machine\system\currentcontrolset\services\oraclemtsrecoveryservice][-hkey_local_

This error often occurs with Oracle data after an illegal shutdown:Exp-00056:oracle Error 1033 appearsOra-01033:oracle initialization or shutdown in progressUser:Password:This is clearly not a way to start the database, but the database service can

A full English error occurred after booting Tomcat: ORACLE DATABASE 10g EXPRESS EDITION LICENSE AgreementTo use this license, you must agree to all of the following terms (by either clicking the Accept button or installing and Using the

How the Windows environment recovers (Oracle 11g Grid) OCR voting corrupted clustersAfter the Oracle 11g OCR can be placed on the ASM disk, and ASM boot relies on OCR and Votedisk, so the loss of OCR or Votedisk will cause cluter not start

Sql> select * from V$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.1.0.7.0-64bit ProductionPL/SQL Release 11.1.0.7.0-productionCORE 11.1.0.7.0

One, the Oracle log mode is divided into (Logging,force logging,nologging)The default is logging, which is recorded in the Redo log, force logging is forced to log logs, nologging is to minimize the log. Force logging can be set at the database

ASM Single point of failureIt is often the user's best practice to ask how to avoid an ASM single point of failure. As with other file systems or volume managers, the failure of an ASM instance can cause the RDBMS instance running above to be

After a long time to learn to create an Oracle tablespace, so share with you, after reading this article you certainly have a lot of gains, hope this article can teach you more things.1. Query the free space first Select

There are two ways to ensure the security of the database, one is through the access control mechanism of the privilege, that is, to prevent the occurrence of security events through the pre-control, and the other is database audit, that is, to make

Recently there was a project with Oracle interaction that I was using ADO to do.First, the database connected to the East record, the old memory is not good ah!The operation is as follows:Connection string so that you can not configure the

Introduction: In MyBatis, when you want to insert data in Oracle, return the primary key value, not the number of inserted bars ...Environment: MyBatis 3.2, Oracle, Spring 3.2SQL Snippet in XML Configuration: select U_user_info_seq. Nextval as

PL/SQL Basic Entry table partitioningPL/sql:Process Language(Procedure Language)and structured language(StructuredQuery Language)The combination of the programming language, is theSQLextensions that support multiple data types, such as large objects

about insert all and insert First One, unconditional INSERT allIi. Conditions INSERT AllThree, conditions INSERTFirstInsert ... SelectInserting records into multiple tables with the Insert Select implementationOne, unconditional INSERT all-----------

When using Oracle, we can use the EM (Enterprise Manager) provided by Oracle to manage our databases more conveniently. However, sometimes our em cannot be connected. There are many reasons for this problem, such as incorrect hostname configuration

Oracle11g RAC construction in linux (III)2. Configure the installation environment (node1 and node2) to create a group, user, directory, and modify permissions (node1 and node2) to create a group, user, and initial password on node1. Create a group:

Oracle recommends that you back up OCR when you adjust the cluster, such as before adding or deleting nodes. You can use export to back up to a specified file. If replace or restore is performed, we recommend that you use the cluvfy comp ocr-n all

There are three methods for ORACLE backup and recovery: (1) Data Pump (expdp/impdp) (2) Cold backup (3) RMAN backup In terms of classification, (1) and (2) are collectively referred to as "cold" backup and (3) as "hot" backup. Data Pump and

Post: original address http://blog.csdn.net/panys/article/details/3838846 Archive log is fullORA-00257: How to Handle archiver error. Connect internal only, until freed error 1. Log On with the sys userSqlplus sys/pass @ tt as sysdba 2. Check the

Oracle, paging, and stored procedure are combined to create a paging stored procedure using PL/SQL. 1. Declare a referenced cursor [SQL] view plaincopyprint? 01. create or replace package cur_ref_type02. as -- is or as can be used03. type cur_ref is

Basic PL/SQL entry-Table Partitioning PL/SQL: a programming Language combined with a Structured Language (Structured Query Language). It is an extension of SQL and supports multiple data types, such as large objects and Collection types, you can use