Oracle

If the database is not backed up, the Oracle database startup error occurs after the server starts due to an accidental power outage.1. The database does not open the archive mode2. No backupSolution: 123456789101112131415161718192021222

There are a lot of friends who are confused about the 4 IPs when configuring Oracle 11GR2 RAC, this article explains here.Open a/etc/hosts file for a RAC nodeCat/etc/hosts# public IP192.168.1.138rac1.localdomain Rac1192.168.1.139rac2.localdomain RAC2

Use the features provided by PL SQL to restore Oracle data quickly and back up.1 Export all user objects such as stored procedures, triggers, sequences, and so on. BackupIn the PL/SQL Developer menu tools (tools) and export user Objects (export

Flashback Flashback query (undo) SELECT * FROM table_name as of timestamp To_timestamp (' 2008-03-03 12:00:00 ', ' yyyy-mm-dd hh24:mi:ss '); SELECT * FROM table_name as of SCN 123456; Flashback table (undo, Restore table to a point in time, block

The usual working machine is openSUSE 13.1. After replacing it with Oracle JDK, the INTELLJ interface became invisible, did not want to debug and then uninstalled the Oracle JDK and reinstalled the OPENJDK.[Uninstallation of Oracle JDK]1. Query

When a user wants to access data from another database table across a local database, the local database must have the dblink of the remote database created, and the Dblink local database can access the data in the Remote database table as if it

Some time ago in an SSH project, using sequence in Oracle as the primary key generation strategy for the object table, the step size of the sequence is configured in the database, but when the test is run, the step size of the primary key ID is

It was suddenly discovered today that the"not equal to operator" in Oracle ignores null .For example, query comm is not equal to 300 of the records, I will take it for granted where comm! = 300It is expected to return a record containing null that

1.DownloadInstantclient_11_2.zipPL/SQL2.Unzip the instantclient_11_2.zip to the appropriate folder,For example: E:\oracleclient\instantclient_11_2,--------------------------------------------------------------------------------Write a Sqlnet.ora

PL/SQL Connect Oracle Database 1, Brief introductionUse PL/SQL to connect to a remote Oracle database without installing an Oracle database.2. Detailed steps:A) Install PL/SQL and install OracleClient based on your operating system (not related to

The Oracle10grac configuration of EM, originally a very simple thing, but it took a long time, recorded, Memo.The first is to report the following error:[[email protected] admin]$ emca-config dbcontrol dbstarted emca at 9:06:47 amem Configuration

TransactionsAs the basic unit of logical processing, it is composed of one or more SQL statements for database operations . Of course, there is a good application for non-database operations, such as a restore point set on a computer. The basic

1. Create a temporary table spaceCREATE Temporary tablespace test_tempTempfile ' C:\oracle\product\10.1.0\oradata\orcl\test_temp01.dbf 'SIZE 32MAutoextend onNEXT 32M MAXSIZE 2048MEXTENT MANAGEMENT LOCAL; generally starting from the second step, you

Direct Path ReadIn 11g, a full table scan may use the direct path read method, bypassing buffer cache, so that the full table scan is physical read.In 10g, all are read by GC buffer, so there is no problem with direct path read.The possible reasons

Flashback query ( flash back ) principleBased on the undo information, Oracle uses the undo data, similar to the consistent read method, to place the table at a point in time ( or SCN) before deletion to retrieve the data.Flashback query ( flash

11g use one parameter to set the password case sensitivity, below to do an experiment:C:\Documents and Settings\guogang>sqlplus Gg_test/[email Protected]_ggSql*plus:release 10.2.0.1.0-production on Monday August 4 17:54:19 2014Copyright (c) 1982, 200

Install Oracle 10g graphic tutorial in redhat 4, -- Note: This article only installs Oracle and does not create a database. I. Install a readhat4 System in the Virtual Machine Ii. IP Address Allocation The configured IP address is as follows: 3.

Oracle data comparison (DBMS_COMPARISON) Today is. I feel ashamed to have received an invitation from csdn to apply for a blog expert. I have never been able to write anything since I changed my job. Today, one of my colleagues posted a data

ORACLE learning notes-add data function updates and oracle learning notes 1. Add data /* Add data */insert into STU values ('stu0004', 'zhao yi', 18, 1, "kc0004"); insert into STU (STU_ID, STU_NAME, STU_AGE, STU_SET) values ('stu0013', 'Storage 11',

Repair of oracle11gASM Disk Head damage (asm repair 2)-- Compile KFED[Oracle @ rac2 lib] $ cd $ ORACLE_HOME/rdbms/lib[Oracle @ rac2 lib] $ pwd/U01/app/oracle/product/10.2.0/db_1/rdbms/lib[Oracle @ rac2 lib] $ make-f ins_rdbms.mk ikfed[Oracle @ rac1 ~