Oracle

IamlaosongAlas, the real soil, used toad, has been using dbms_output.put_line debugging stored procedures, only feel inconvenient, with PL/SQL developer, or use this method, online search, just know can be single-step debugging. Learn to use PL/SQL

ReasonThe Oracle SQL Developer installed in Oracle 11g is 32-bit, and the java.exe we are assigning to him now is 64 bits, so this error can occur.Workaround1) Download Oracle SQL Developer x64 from the web and replace the original directory: D:\app\

Today, a strange problem has been found that the SRVCTL and Crs_start commands cannot start an Oracle RAC instance, but with Sqlplus it can start normally. The final reason for this is that the state of the database becomes disable in OCR, and this

Active session History ReportActive session HistoryV$active_session_ The history view provides information on extracting session activity at the instance level. The active session is sampled once per minute and stored in a circular buffer in the SGA.

Oracle ASM Error--ora-15031, ORA-15014System environment:Operating system: AIX 5.3.8Oracle:oracle 10GR2Failure phenomena:[[email protected] ~] $sqlplus  / as sysdbaSQL*Plus: Release 10.2.0.1.0  - production on thu jul 24 11:28:52 2014copyright  (c)  

Oracle ASM Error--ora-15033System environment:Operating system: AIX 5.3.8Oracle:oracle 10GR2 Symptom: sql> create diskgroup datafile  2      normal  redundancy    failgroup fg1 disk  '/dev/rlv_data1 '   3     4    failgroup fg2 disk 

Windows Registry Editor Version 5.00[-hkey_local_machine\system\currentcontrolset\services\oracleoradb11g_ Home1tnslistener][-hkey_local_machine\system\currentcontrolset\services\oraclemtsrecoveryservice][-hkey_local_

about several Oracle functions that handle the number of decimal places ()1. Take a few decimals roundedSelect round(1.2345,3) fromdual; Results:1.2352. Keep two decimal places, onlySelectTrunc1.2345,2) fromdual; Results:1.23SelectTrunc1.2399,2)

No Oracle cannot connect after booting,Turn around: http://blog.sina.com.cn/s/blog_4aeef1220100fmsr.htmlTNS-12560:TNS: Protocol Adapter errorMicrosoft Windows [version 5.2.3790](C) Copyright 1985-2003 Microsoft Corp.C:\Documents and

1. EnvironmentWin7 x64,oracle 11g r2,jdk6 x642. QuestionsThe first time you start Oracle SQL Developer will let us fill in the path of Java.exe, I found in the JDK installation directory of the bin Java.exe, but fill in the following error:3.

The cause of the problem arises:Insert into T_cluster_showresult (outhostname,domainlist,iplist,classify) VALUES ("2014512-7", "www.renren.com\ Twww.baidu.com "," 192.168.2.1 "," 2 ")The execution of this statement is unsuccessful, the error column

Oracle software itself is free, so anyone can download and install Oracle's database software from Oracle's official website, at a charge of license, which is software licensing, and if the database is for commercial use, it is necessary to purchase

The following article describes how to bind a variable to an Oracle SQL statement and how to use Oracle to execute an SQL statement to bind a variable, the following describes the relevant content of the article. 1. SQL * PLUS command for receiving

Today, we are mainly talking about the impact of Oracle's acquisition of sun. We all know that Oracle's acquisition of sun has already caused an uproar in the industry. It can be said that there are different opinions and opinions, some are bad. The

This article mainly introduces the differences between Oracle versions. From Oracle database-related products, from Oracle2.0 (no 1.0) to Oracle7.3.4, it is a relatively simple version of Oracle, starting with Oracle8, the identifier of a database

Oracle C #ImplementationOracle Text full-Text searchThe simple example is what we will introduce in this article ,. A simple example of using C # to implement full-Text retrieval of Oracle Text in. NET is designed to get a preliminary understanding

ORACLE External table Summary, ORACLE table Summary External table Introduction ORACLE External tables are used to access Text files (Text files) other than databases or ORACLE exclusive format files. Therefore, when an External table is created,

The prompt "the database status is currently unavailable may be because the database status is loaded or not loaded". The solution is that EM can be accessed normally after installation. After The customer changed The sys password, they boarded EM

The redolog switch has a full checkpoint or incremental checkpoint. There is a lot of information on the Internet, but it is not clear whether the full checkpoint or incremental checkpoint occurs when a log switch occurs. Some people say it is a

Oracle 11g Flashback Data Archive (flash back Data archiving) UNDO tablespace record rollback information although it can provide flash back query, but for a long time, this information will be overwritten. In fact, as long as the transaction is