Oracle

The database version installed on my local machine is Oracle 11g R2. When I connect to the database today, the following error is reported: Oracle not available ORA-01034 ORA-27101-shared memory realm does not exist I found several solutions

The table's primary keys are all sequence, and the dataadpter update method is used. I don't know how the predecessors handled it. I am lazy as follows: Public void Update (oracledataadapter ADP, dataset DS) {// DS is obtained by DS. getchanges

Check the SQL statement of the deadlock 1. Select Sid, decode (Block, 0, 'No', 'yes') blocker, decode (request, 0, 'No', 'yes') WaiterFrom v $ lockWhere request> 0 or block> 0Order by block DESC; 2. Select BS. username "blocking user", BS.

As we all know, in 32-bit operating systems such as Win2k, the memory that the operating system can manage is 4 GB (Power (2, 32) = 4 GB), and the total memory used by Oracle is limited to 2 GB. Currently, most information systems can provide

Two solutions:1. Upgrade to 92052. Disable Automatic growth of Undo tablespace 3. to narrow down the current undo tablespace:-- Create an undo tablespace for a new small spaceCreate undo tablespace undotbs2 datafile 'C: \ oracle \ oradata \ eoffice

Problem: After the oracleorahome92tnslistener service is started, it will be automatically disabled, leading to database unavailability.Cause: the host name is changed after oracle is installed.Solution: Modify the D: \ oracle \ ora92 \ Network \

From: http://hi.baidu.com/andyloolu/blog/item/a64f0ed12cc10738960a165a.html In Oracle, you can define package variables. Many people are not very clear about the use of package variables. First, let's look at the following example: Create or

[Problem description] The prompt "Oracle not support parallel transaction" is displayed when you call Dal to execute the stored procedure and write data to the database" [Error cause]1. When a transaction does not end and starts another

Oracle Streams Advanced Queuing (AQ) is a robust and feature-rich message queuing system integrated with Oracle Database. when an organization has different systems that must communicate with each other, a messaging environment can provide a

How is the Oracle consistent gets calculated? 1. Single Table Scan SQL> execute show_space ('test1', 'wwj '); Unformatted Blocks ...... FS1 Blocks (0-25) ...... FS2 Blocks (25-50) ...... 1 FS3 Blocks (50-75) ...... FS4 Blocks (75-100) ......

DBAs often encounter unlocking Oracle users in their daily work. This article describes how to unlock Oracle users using the command line, you can use several simple unlock statements to complete this task. The specific process is as follows: Scott

I haven't written anything for a long time, because I haven't encountered any problems for a long time. Once and again, I think that Oracle's omnipotent paging is quite refreshing. Today I finally encountered a problem. Oracle can use SQL

There is a project in the company that uses SQL2000 as the transfer station, updates data from the source database server (SQL2000) to the target database server (oracle 10 Gb), uses the link database, and implements it through the storage process.

During the past two weeks, I have been busy with the migration of databases. When I did not do it, I felt it was very easy, but I was dumpfounded when I did it. This tangle, Here we will first talk about the problem:1. Database Table Structure

1. The case when expression has two forms: Copy codeThe Code is as follows: -- simple Case Function CASE sex WHEN '1' THEN 'male' WHEN '2' THEN 'female' ELSE 'others' END -- Case search function CASE WHEN sex = '1' THEN 'male' WHEN sex = '2' THEN

The following error is always reported when you manually configure the EM of Oracle11g: WARNING: ORA-00001: uniqueconstraint (SYSMAN. PARAMETERS_PRIMARY_KEY) violated ORA-06512: at "SYSMAN. EMD_LOADER", line4986 ORA-06512: atline1. No solution was

During the development process, you may often encounter some tests. At this time, you may want to understand the testing process and analyze the code Errors Based on the process. In this case, you need to use custom exceptions. For more information,

If a lock wait occurs, we may want to know who has locked the table and who has waited.The following statement can be used to query who has locked the table: Copy codeThe Code is as follows: SELECT/* + rule */s. username, Decode (l. type, 'TT',

When two concurrent transactions access the same row in the database table at the same time, there may be three problems: 1. Fantasy read: Transaction T1 reads a statement that specifies the where condition and returns the result set. At this time,

When running the program today, enter the SQL statement in Oracle: select * from USERS AsU, program error Input select * from USERS u to query the result normally. However, in SQL Server 2005, enter ''select * from USERSAsThere is no error in