Oracle

This article mainly introduces the installation of Oracle database and the creation of database in silent way. Create users, user groups and environment settings and graphical installation is the same, the specific setting of the way please refer to

Database mirroring is the movement of database transactions from one database to another in a different environment. A mirrored copy is an alternate copy that cannot be accessed directly, and is used only in the case of error recovery. Oracle

Oracle databases are very different from MSSQL data operations, but there are analogies in mirroring operations. This article is about how MSSQL database mirroring is implemented in Oracle databases, and what differences exist between them. First,

What is CPU/PSUThe full name of the Oracle CPU is critical Patch Update, where Oracle releases a security patch package for each quarter of its products, usually to fix security risks in the product.The full name of the Oracle PSU is patch Set

Oracle The Process Memory: In addition to the SGA (System Global area), the Oracle process also uses the following three global zones: The Process Global area (PGA) The User Global area (UGA) The call Global area (CGA) A lot of people don't

Most WEB applications today need to adopt at least some basic security policy. For example, a Web site that provides password-protected content, only Web sites with admin backend, blogs and personal magazines, E-commerce sites, intranet, and so on.　　

An outline that is roughly written in the optimization content of the physical design and logical design of the DB, mainly physical design, logical design introduction of the content is not much, the outline of the physical structure design and

Oracle RAC also has ha (high availiablity) and lb (loadbalance). And its high availability is based on failover (failover). It means that the failure of any node in the cluster will not affect the user's use, the user connected to the failed node

Ii. Manual implementation of TSPITR Oracle supports creating its own helper instances for Tspitr. You can also use the manual tspitr to complete the failed automatic Tspitr operation. First, the steps listed in the previous preparation phase are

When we use a database, always want the content of the database is reliable, correct, but because of computer system failures (including machine failure, media failure, misoperation, etc.), the database may also be damaged, then how to recover data

In Java, System.currenttimemillis () takes the number of milliseconds from 1970-01-01 00:00:00.000 to the current time, a long value.This value is now accessed in a table in the Oracle database and needs to be converted to a readable date

Introduction: This article was written because one of my students recently set up a RAC cluster in the company, but the sequence and principle of its start-up and shutdown is not particularly clear, I also found in teaching work a lot of students

Under RHEL7, when you install Oracle database, you have the ability to select XFS files, such as the following:Requirements for installing Oracle Database 12.1on RHEL7 or OL7 64-bit (x86-64) (document ID 1961997.1)Requirements for installing Oracle 1

Oracle-based application system many performance problems are caused by poor application SQL performance, so, SQL performance optimization is very important, analysis and optimization of SQL performance we generally look at the SQL implementation

Native environment Win10 64-bit system, vs2013 32bit version, Oracle installed on the machine including the server and the client are 64bitWhen testing a. NET connection to an Oracle database, there is always the above exception, looking for a

[Oracle]sqlplus Start parameter description# su-oracle [Grid]Usage 1:sqlplus-h | -V-H[ELP]:Displays the syntax and usage of the Sql*plus command, and then returns control to the operating system.-v[ersion]:Displays the version number of the Sql*plus,

Oracle 's system is too large. For those who have just started to learn, it is inevitable to have some sense of how to start. After a semester of learning , we have a deep understanding of Oracle Learning and have learned some of the main knowledge

There are two ways to create an Oracle-based geodatabase:1. Know the Oracle Administrator password and create it directly with the ArcGIS client's Create Enterprise Geodatabase tool2, do not know the password of SYS, but in Oracle created the SDE

Prior to the project because of the need to use the Oracle database, due to limited time to start learning from the foundation, and Oracle operation of the command interface is too unfriendly, so found the PL/SQL developer This very useful software

Development tools: VS2010+ORACLE11 Client +winformPrompt for error when running locally: BadImageFormatException is raised when attempting to load the Oracle client library. This problem occurs if you are running in 64-bit mode with the 32-bit