Oracle

1: Backup Oracle Database2: Backup control files to trace (in case you need to create a new control file) The code is as follows Copy Code sql> ALTER DATABASE backup Controlfile to trace; Database altered. Sql> Oradebug

Patch InformationC:\users\xifenfei>e:\oracle\product\11.2.0\dbhome_1\opatch\opatch lspatches17977915; WINDOWS DB BUNDLE PATCH 12.1.0.1.3 (64bit): (17977915) Session 1Xifenfei_cdb$root@sys> show

Article Author: kj021320 Source of information: Evil Octal Information Security team (www.eviloctal.com) Note: This article starts I.S.T.O technical team, after the original creator friendship submits to the evil Octal information Security Team

OCR and voting Disk backups in Oracle RAC are described in my blog: oracle RAC Common maintenance tools and commands , and now take it separately to make a note, because OCR and voting disk Is too important for a RAC system.Oracle RAC Common

The Oracle job has timed execution and can perform its own tasks at a specified point in time or at some point in the day.First, query the system job, you can query the view --related views SELECT * from Dba_jobs; SELECT * from All_jobs;

Oracle stored procedure Basic syntax stored procedure1 CREATE OR REPLACE PROCEDURE Stored procedure name2 is3 BEGIN4 NULL;5 END;Line 1:Create OR REPLACE PROCEDURE is an SQL statement that notifies the Oracle database to create a stored procedure

Disclaimer: The recent installation of the kilo version of OpenStack found that there were very few existing web tutorials and that most of the tutorials did not install successfully, So write this tutorial. The installation of OpenStack is

I. Data definition language DDL1. Create tablespace : creat tablespace lyy datafile ' c:/app/lyy.dbf ' SIZE 10M; (Create a 10M tablespace and store it in the C-drive app folder)Delete Table space: Drop tablespace lyy;2. Create User and empower:

1. Start and connect the OAGOAG when connecting, except not select analysis, the others are selected, and then launch the gateway instance and NodeManager.The command is as follows: /$OAG _home/apigateway/posix/bin/startinstance-n

After installing Oracle, there are several ways to manage the database in Oracle, first of all, landing on the web version of the interface: Https://localhost:1158/em, this way to manage too many things, it is a little inconvenient to use, The

Dry Oracle 047 Article 12 when the issue, experience GROUP BY statement. So encounter GROUP by Rollup,decode,grouping,nvl,nvl2,nullif,ratio_to_report wait a minute.1. decode and If...then,case...when ... This kind of flow data statement is nearly

Oracle Report Viewer and how to view Oracle reports today the leader raises a question about how to view the Oracle report output, how to set the default viewer for the browser when copying files? Looked for a night also did not solve the problem,

Regarding this content, actually launches st_geometry from ArcSDE9.2 to let the user feel very attractive, and especially after ArcSDE9.3, the user uses the SQL operation St_geometry more and more, But this is always the case when configuring Oracle

1. Clear TasksPrepare a RHEL5 PC to act as a San device, a SAN (both as a DNS and timing system)Prepare two RHEL5 PCs to act as RAC nodes, R1 and R2Install RAC on ASM disk, including OCR, voting, library2. Modify kernel parameters and shell

People doing database development or management often want to create a large number of test data, there will be tens of thousands of things, if one entry, it will waste a lot of time, this article describes how Oracle in a SQL to quickly generate a

Dblink detailed 1. Create the Dblink syntax: CREATE [public] DATABASE link link CONNECT to username identified by password USING ' ConnectString ' Description 1) Permissions: The account that created the database link must have the system

A very standard sample code for connecting Java to the Oracle database, oracle sample code The most basic Oracle database connection code (only for Oracle11g ): 1. Right-click Project-> build path-> Configure build path, select the third item

Solution to Oracle 11g installation in Windows 7, oracle11g Many DBAs are still in Oracle 9i or 10g, probably because of the price of Oracle 11g. This article will explain how to install Oracle 11g in Windows 7, and hope you can see some new

Oracle Data Import/Export, oracle Data Import and Export Import and Export Oracle Data imp/expFunction: Oracle Data Import/Export imp/exp is equivalent to oracle data restoration and backup. In most cases, you can use Oracle data import and export

Some friends feedback database startup run after a little time, then automatic crash, let us help find the reason, through analysis is because the smon process triggers ORA-600 13013 caused database exceptionsAlert Log error messageThu Aug 4 18:39:44