Oracle

Recently helped a customer recover 6 sets of Oracle RAC, both ASM and version 10.2.0.4. Stay up for several days, almost vomiting blood.Here is a brief description of the recovery of one of the libraries, to share with you.Several of these have

Last night a friend consulted me, his database (win2008 11.2.0.1) appeared a large number of ora-00600[17059], the following error, so that help analyze the reasonsAlert Log ErrorSat Mar 19 21:31:02 2016Errors in File D:\app\administrator\diag\rdbms\

Database Host LoadThis obviously shows that the system load is high, and is still rising; in the top process, CPU is planned 100%top-16:25:39 up 123 days, 1:42, 4 users, Load average:46.19, 45.08, 43.93tasks:1469 Total, running, 1439 sleeping, 0

Data security is more and more important, not to say that your production database security, your data must be safe, Rman backup is also an important place to leak data, if someone else got your backup set, same as the intrusion of your production

How to use Oracle LOWER () and UPPER () functions A column returns rows that are case-insensitiveThis is a common practice to make columns case-insensitive to ensure that you want to return all rows. SELECT *From coursesWHERE LOWER

Enable In-memory FeaturesDatabase version 12.1.0.2 and above, inmemory_size parameter set to appropriate valueSql> SELECT * from V$version;BANNER con_id-------------------------------------------------------------------------------- ----------Oracle

Database version The code is as follows Copy Code BANNER con_id-------------------------------------------------------------------------------- ----------Oracle Database 12c Enterprise Edition release 12.1.0.1.0-64bit

Oracle Data Import Export IMP/EXP is equivalent to Oracle data restore and backup. The EXP command can export data from a remote database server to a local DMP file, and IMP commands the DMP file to be imported locally into a distant database server.

There are many kinds of database processing model of the hierarchy, can design the model according to own demand, of course, the simplest and easiest model is the so-called adjacency model. In this respect, other databases, such as Oracle, provide

The Oracle installation configuration tutorial is shared with you for your reference, the details are as follows 1, installation Oracle version: Oracle DatabaseG Release 2 (10.2.0.1) Download Address:

Recently arrived at the company to work, a general understanding of the company's process, found that the database is very badly needed to make up, the former school in some databases are SQL Server, as well as some increase, delete, change, check

1. Three modes of protection –maximum Protection Under maximum protection, you can ensure that the data from the library and the main library is exactly the same, and that the zero data loss. The transaction is completed at the same time on both

Basic Environment: Snow leopard10.6.2,oracle10.2.0.4 Open the Mac terminal and execute: Sudo-i Create oinstall groups and Oracle users, note that you need to ensure that the ID of the combined user does not conflict with existing

"Original ": http://blog.chinaunix.net/uid-23886490-id-3565998.htmlI. Pre-installation Preparation1. Memory and Swap requirementsAs for how swap is added, the following article will mention　　grep memtotal/proc/meminfogrep Swaptotal/proc/meminfo2.

1. Connect oracle8/8i/9i Database (thin mode)String path = Request.getcontextpath ();String basepath = request.getscheme () + "://" +request.getservername () + ":" +request.getserverport () +path+ "/";%>Connection string for OracleString url=

Introduction to 1.OCR Disks The problem with forgetfulness is that each node has a copy of the configuration information and the configuration information of the modified node is not synchronized. Oracle's solution is to put this configuration

This article mainly describes how to deal with the problem of bad blocks in the Oracle database, for the bad blocks produced on different objects, the method of processing will be different, this article will be a general introduction to these

An instance of the 11204 library on centos7.2 was crash, and the check alert was found as follows:wed sep 21 00:00:11 2016errors in file /apps/oracle/diag/rdbms/xberp/xberp/ Trace/xberp_ckpt_17537.trc:ora-27157: os post/wait facility removedora-27300

I. PL/SQL Developer Development ToolsPL/SQL Developer is an integrated development environment (IDE) for developing PL/SQL blocks, which is a standalone product, not a companion to Oracle.Second, PL/SQL IntroductionWhen developers use PL/SQL to

Almost forgot. In my last tutorial, I-tell-you-to-save Image/photo into Oracle database. But, there are another problem, how do I read and view it from Oracle database? Don ' t worry, it's very easy-to-do. Just follow these steps and you'll able to