Oracle

Case 1: How to know which stage the current database is in sql> select Instance_name,status from V$instance; instance_name             STATUS ----------------------------- --------------------------- orcl                      

Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the following sources, otherwise, the legal responsibility to pursue copyright.Deep Blue Blog:http://blog.csdn.net/huangyanlong/article/details/43926321First

Refer to the official documentation (download along with the database file)Oracle®databaseQuick Installation Guide10gRelease 2 (10.2) for Linux x86-64The official documentation describes the installation using a graphical user interface. However,

I am borrowing to recommend others The purpose is to learn dbms_scheduler create chain type of job, as for executable type of job I have been in introduced. The following to the online related:Oracle CHAIN, which is a chain, connects a bunch of

Used to learn. NET connection to a database, it also makes a variety of connection configurations. Now, while using Java to manipulate Oracle, there are also some operations. Here's a summary.1.JDBC_ODBC Connection DatabaseThis method requires an

Oracle Express Edition 11g was installed today, but after the installation is complete, unable to open the database home page is: 127.0.0.1:8080,baidu,google on the internet for how long, various methods used, such as modifying the port number, etc.,

Recently encountered a case:Status: HP-UX operating system, Oracle 10.2.0.4 RAC, MCSG mode, 2 OCR and 3 voting disk each correspond to one LV in the same concurrent volume groupPurpose: To mirror shared storage, the technology used is HP's own HP

--Create Target library dblinkcreate database link target library connect to account identified by "password" using ' IP Address: port/target library '; --Query created Dblinkselect owner,object_name from dba_objects where object_type= ' DATABASE

Yesterday in the middle of the night to install a rh5+oracle version, during the encounter a few things, stated as follows, as the basis. 1. Before installation, you need to configure the kernel parameters, can refer to the Oracle Official document

Original address: http://yanwushu.sinaapp.com/oracle_extract_year_month_day_valu/Previously, the To_char (Timefield, ' YYYY ') method was used to get the year field value in the date. The efficiency of this method is certainly not high, in order to

Add Standby LogMain Library parameter file:crm.__db_cache_size=8254390272crm.__java_pool_size=33554432crm.__large_pool_size=33554432Crm.__oracle_base= '/u01/app/oracle ' #ORACLE_BASE set from environmentcrm.__pga_aggregate_target=3288334336crm.__sga_

Plsql connecting Oracle requires local installation of Oracle client (download in the attachment): After downloading the file, put it in any directory, for example D:\instantclient_10_2 Modify the Tnsnames.ora file, the first line to fill

Oracle Scheduler Chain usage I am referring to other people's articles to learn about dbms_scheduler to create a CHAIN-type JOB. As for EXECUTABLE-type jobs, I have introduced how to . the following is an introduction to the Internet: The Oracle

OracleRAC rebuilding OCR and Votedisk   Environment:OS: redhat 5.8DB: Oracle 10.2.0.5 raw device We need to develop the habit of backing up ocr and votedisk frequently. However, ocr and votedisk can be rebuilt without backup. It is like a control

Quick creation of DBLink SQL statements in oracle When dblink is created normally, you need to enable the listener on the target end, configure tns on the source end, and then check the configuration of the target database GLOBAL_NAMES. This is a

Oracle Study Note: Tablespace and Data Files, oracletablespace 1. how to create a tablespace that employs the most common features 1 create tablespace tb_name #create bigfile tablespace tb_name2 datafile ‘/u01/dbfile/orcl/tb_name.dbf’3

Automatic backup script for Oracle databases in Windows @ Echo off echo ============================================ ================= echo in Windows environment, the Oracle database's automatic backup script echo 1. use the current date to name

Log File mode in oracle There are two log modes in oracle Database: Non-archive log mode and archive log mode. In the oracle database system, to prevent the contents of log files from being overwritten during cyclic use, the oracle System Copy and

Oracle merge into usage, oraclemerge 1. Use of merge Merge is a very useful feature. It is similar to merge into in DB2 and insert into on duplicate key in Mysql. Merge into is a new feature that appears after Oracle 9i. In simple terms, it can be a

[ORACLE] processing of oracle time objects 1.1 Use of oracle date objects (1) Create A date Field For example, Create table foo_7 (d1 date ); (2) Use the to_date function to insert a date object. To_date ('string', 'string' format ') For