The connection with Oracle database in Java application
Author: 洪建
In the Java EE application development, the application and the database connection establishment is one of the problems that we often encounter. Here I talk about connecting Oracle
Using virtual box to install Rhel 6.2+oracle 11g, you need a Rhel installation disk (VERYCD) and a Linux installation package that is downloaded on the Oracle Web site, where two of the 11g installation packages end in zip. The installation process
Guide:
Timed hot Backup (EXP) for an Oracle database can usually be implemented in two ways, one in the Oracle database
Implemented by using the task Queue Manager provided by it (Job queue), or by using the operating system's timed execution
The Oracle database configuration file refers to files that the system needs to load when booting to the "Nomount" phase, also known as Pfile or SPFile, but Pfile and SPFile are different files.The different database configuration files are
Check that the database state is correctA. Check to see if the Oracle instance is started.> Ps-ef|grep OracleThe query to the information containing the "INOMC" keyword indicates that the instance was started.If you do not start, you need to start
SYS and SYSTEM user differences
1 The most important difference, the importance of storing data is different
SYS the base tables and views of all Oracle's data dictionaries are stored in the SYS user, which is critical to the operation of Oracle and
First, flash back technologyTo enable the database to recover quickly from any logical misoperation, Oracle exits the flash back technology. This technology can restore the data of row-level and transaction-level, reduce the time of data recovery,
(1) Select the most efficient table name order (valid only in the rule-based optimizer):The Oracle parser processes the table names in the FROM clause in a right-to-left order, and the FROM clause is written in the final table (the underlying table,
When Oracle 11g is exported using export, the empty table cannot export 11g R2 with a new feature. When the table does not have data, no segment is allocated to save space.
Solution:
1. Insert a row and then roll back to generate a segment. This
Operating System: win7 64-bit
ORACLE: 11gr2 32-bit
However, the following errors occur continuously in the Alert Log:
Mon Feb 06 14:38:22 2012
Oer7451 in load indicator: Error code = OSD-04500: Illegal option specified
O/s-error: (OS 1) function
Oracle 11g real-time SQL monitoring
Oracle,In-depth analysis of Oracle,Reading Notes April 9 th, 2010Author: dbtan | [indicate the source and author information in hyperlink form during reprinting]
Link:
Operate the table that triggers the trigger in the trigger, and use the Pragma autonomous_transaction option.
15.1 why cannot I roll back an audit using autonomous transactions?
Generally, when a trigger is used to prohibit operations such as table
What is lob?
Lob is a big object data type of the Oracle database. It can store strings of more than bytes, binary data, OS files, and other large object information. the maximum storage capacity. The root Oracle version depends on the size of the
1. Deferred segment creation description
Since Oracle 11.2.0.1, Oracle provides a new space allocation method: when creating a non-partition table, this table segment is not created immediately, instead, the segment is created only when the first
Document directory
Oracle pagination tips
Oracle pagination tips
Oracle tips by Vikas Rajan atrey
Also see these important notes on estimating the maximum results from a paginated Oracle SQL query.
Invariably while developing data intensive Web
In init. ora contains db_name, instance_name, and service_name. in the operating system, you must configure oracle_sid in listener. ora contains SID_NAME, GLOBAL_DBNAME, in tnsname. there are so many SERVICE_NAME and SID in ora that you are confused.
According to the ghost sub-requirements, the original use of Oracle alone to send and receive mail was abandoned (the previous article described the specific implementation), instead of using Oracle to call Java, and use javamail to implement the
In Oracle databases, a series of initialization parameters are used for database constraints and resource restrictions. These parameters are usually stored in a parameter file and read and load when the database instance starts.
Initialization
Oracle has high requirements on computer configuration, making it even worse for antique machines. My laptop was bought four years ago, with 512 memory and a Pentium m cpu. Now I can only run some lightweight software. After collecting information
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service