Oracle

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

The following scripts can be used to check for huge line numbers:--PO requisitionsSELECT * from Po_requisition_lines_all where line_num > 1000000000;--PO LinesSELECT * from Po_lines_all where line_num > 1000000000;--Receiving supplySELECT * from

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

ASMSupportRolling Upgrades, forASMhit Patchsets or migrate to a new version you can use the rolling upgrade method to provide a higher levelthe lower level of high availability. Note that in order to use ASM's rolling migration special, the ASM

PL/SQL Developer is an integrated development environment that specializes in developing applications for Oracle databases. At the same time, PL/SQL is a procedural languageCalled the process SQL language (procedural language/sql). PL/SQL is an

1. Profiles and UsersOnly one profile can be assigned to a user at a time. Profile:? Control resource consumption?      Manage account status and password invalidation Note: The profile can enforce resource throttling only if Resource_limit is set

Zookeeper 1. The year-end settlement process in the Oracle general ledger application is included in the program during the enabling/disabling process. When the user starts the first period of the New Year, the "gloire" Process in the program during

This article will introduce some functions in Oracle that are similar to SQL Server ISNULL functions. Due to project requirements, you need to convert SqlServer to Oracle. Some Views in SqlServer use the ISNULL function. After finding out, the

I don't know much about oracle. Today, a friend said that oracle creates a job. I thought it was a job. As a result, oracle creates a job, let me introduce how to create a job instance in oracle. I. Simple Test of the job creation process case:1.

Differences between Oracle sys and system users, sysdba and sysoper system permissions, and sysdba and dba roles Differences between sys and system users 1) The most important difference is that the importance of stored data is different. Base

VB. NET is still quite common, So I studied the VB. NET transmission tablespace. Here I will share it with you, hoping it will be useful to you. Two databases (ltdb and epras). The tsts tablespace user ts (including two data files) is exported from

Personally, I like Oracle very much. In actual work, I also like Oracle Database optimizer experience and lessons. Let's discuss this in detail! If you are a loyal fan of Oracle Database optimizer optimization, do not miss it. There are three types

What we want to introduce today is the operating language (DML) for Oracle to use FIRALL to process some non-consecutive arrays and execute relevant data in PL/SQL loops) in fact, it is a very time-consuming task, because every cycle needs to be

The following articles mainly describe how to efficiently Delete duplicate data from Oracle databases.) We all know that due to the rapid economic development, the enterprise scale is also growing rapidly, the related information and data volume are

Today we will mainly introduce you to the interpretation of common Oracle Raw types. We all know RAW, which is very similar to CHAR. We declare it in Oracle RAW (L ), L is the length, in the unit of correlation bytes. It is used as the maximum 2000

The Oracle service port has many problems. The following describes how to open the Oracle service port on the firewall. It is helpful for you to learn about the Oracle service port. To enable the Oracle client to connect to an Oracle server

Introduction: Oracle DatabaseIt is a kind of relational database management system that is favored by users. to make good use of Oracle databases, we need to have a clear understanding of Oracle database backup and recovery for a long time, first,

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

Solaris X86-64 ORACLE 11.2.0.3.8 patch:Correct steps:1. patch for BUG6880880 and OPATCH2. Patch 11.2.0.3.8 for BUG16902043 I feel like I have to practice it. I think it's easy to get things done. I think you should be careful if you have any

PL/SQL subprograms include functions and procedures. The function here refers to the user-defined function, which is different from the system function. A subroutine is a PL/SQL block that completes a specific function. It is universal and can be