Oracle

InLinuxEnvironmentInstall oracle 10gIt is a daunting task, far more complex than installing the linux operating system. If oracle 10 Gb can be successfully installed, some linux technologies will be mastered at the same time. This article describes

Oralce DatabaseFaults encountered during the operation are very difficult and need to be solved in a timely manner. Otherwise, they will have a bad impact on everyone's work, this requires you to master some Oralce database disaster recovery methods.

Oracle DatabaseProgramSecurityThe performance objective is generally divided into two categories: one class that all users can execute, and the other class that only DBA can execute. In Unix, the configuration file set for the group is/etc/group.

In the VS2010 development environment, we recommend that you use a third-party plug-in to connect to the database.OracleConnection Tool. There are many third-party plug-ins, such as dotconnect for oracle,ODP. NETAnd so on. In this article, we use

Oracle DatabaseInEM Console ReconstructionEM startup error. The error code is as follows: C:\Documents and Settings\GAOYANG>set ORACLE_SID=rman    C:\Documents and Settings\GAOYANG>emctl start dbconsole     OC4J Configuration issue. D:\

This article mainly introducesOracle 10g isqlplusUseDBA accountNext, we will introduce them one by one. 1. vi. bash_profile Add Environment Variables export JAVA_HOME=$ORACLE_HOME/jdk  Save and exit. source .bash_profile  2. Switch

OracleDatabaseUnique ConstraintAndUnique IndexThe difference is what we will introduce in this article. When using TOAD to operate Oracle databases, we will notice four types of constraints when creating constraints: Primary Key, Check, Unique, and

In Oracle Database Operations, we often need to start or close some services to implement the functions we need. But the premise is that we must understandOracle Database ServicesIf you are not familiar with Oracle database services, it doesn't

InOracleIn the database, how do we checkCPU and PSU PatchesWhat about the installation? This article mainly introduces this part, hoping to help you. Normally, there are two methods: One is to log on to the database and check the DBA_REGISTRY_HIST

Oracle Database diagnostic tool RDARDA is short for Remote Diagnostic Agent. It is a tool used by Oracle to collect and analyze databases. Running this tool will not change any system parameters, the data collected by RDA is comprehensive, which

Tomcat 6.0+Oracle 10 GB Data source connection testThe process is what we will introduce in this article. Next let's take a look at this part of content, hoping to help you. The connection test procedure is as follows: 1. Copy the driver package \

Insert is a common statement in T-SQL. Insert INTO table (field1, field2 ,...) values (value1, value2 ,...) this form is essential for application development. However, during the development and testing processes, we often encounter situations

The following is a summary of Oracle locking policies:· Oracle only adds row-level locks to data when it is modified. Under normal circumstances, it will not be upgraded to block-level locks or table-level locks.· Oracle will never lock data if it

If the character set of the Server Client is improperly set in the Oracle database, the data stored in the database will not be properly saved, or the data in the database cannot be properly displayed in the customer segment, code corruption occurs. 

In windows, sqlplus is completely normal, but in linux, there is a problem with sqlplus Chinese display, always displaying "?", How can this problem be solved? The solution is as follows: In fact, it is easy to set exit sqlplus and set the

I. Problem description a project team calls and says there is a materialized view with more than 20 thousand entries in the source table, which is refreshed every 5 minutes, this causes a sudden increase in Oracle Database archive logs. Ii. Problem

Modify the maximum number of connections by default of 150 in oracle # sqlplus/nologSQL> conn/as sysdba SQL> show parameter processes; name type value =----------- ------------------------------ aq_tm_processes integer 1db_writer_processes integer

Today, I came into contact with the group by clause with the rollup clause (it's really ugly. I 've been in contact with ORACLE for a year or two before I know this usage ), the functions produced by the group by clause with the rollup clause are

Oracle TnsPing is correct, pl/SQL ora-12154 cannot resolve the resolution of the specified connection identifier to tnsnames in C: \ oracle \ ora92 \ network \ ADMIN \ SAMPLE. copy the ora file to C: \ oracle \ ora92 \ network \ ADMIN and try again!

Resolved ORA-28002: the password will expire within 1 days symptom Description: Login oracle 11g ERROR: ORA-28002: the password will expire within 1 days alarm information: ERROR: ORA-28002: the password will expire within 1 days Cause Analysis: In