Database Administrator

When operating Oracle, if Oracle cannot be started or stopped normally, or Oracle import/export command execution is incorrect, It is usually caused by table space problems in Oracle instances. The following solution is taken from the network and is

Start-> All Programs-> Oracle Business Intelligence-> Welcome to Oracle bi ee, go to the obiee Welcome page, click Oracle BI Interactive Dashboards can enter the Dashboards logon page. When you click the Oracle BI Interactive Dashboards link, the

First, create a physical standby database. Reference:   After creating a physical standby database, it is best to create your own spfile Stop the redo application on the physical standby Database:Alter database recover managed STANDBY database

Error message: Oracle@www.bkjia.com ~ $ Emctl start dbconsole TZ set to PRC Enter the Configuration file./u01/app/oracle/product/10.2/db_1/Solaris/j2ee/OC4J_DBConsole_localhost.localdomain_orcl not found. Solution: Method 1 (recommended): Use dbca

Oracle 10g In EM Use Web To manage databases and related services. However EM Based on the prompts from colleagues and the actual experience of the author, I have summarized the relevant questions and hope to help related fans:    ( 1 ) After the

The latest MySQL version 5.5.11 requires cmake compilation and installation. It is estimated that this method will be used in later versions. Some installation methods are found on the internet and some are incorrect, record the installation steps

To achieve maximum performance, databases generally have a concurrency mechanism, but the problem is Data Access conflicts. To solve this problem, most databases Use Data Locking. There are two methods to lock data: Pessimistic lock and optimistic

Create table test ( NAME VARCHAR2 (2) ) Insert into test values ('test '); In Windows: In Windows, by default, VARCHAR2 (2) is equivalent to VARCHAR2 (2 BYTE). A Chinese Character occupies 2 bytes. In Linux: In Linux, by default, VARCHAR2

// In Oracle, we can view the object definition code from the data dictionary user_source (View;// Let's first look at the structure of the user_source View:Desc user_source;Name Type Nullable Default Comments-----------------------------------------

Special characters in Oracle & 1. SQL SERVER supports insertion. Update ezoffice. menuset Set righturl = '/defaultroot/InfoAction. do? Type = all & channelType = 0 & userChannelName = Information Management & userDefine = 0 & orderBy = date'

Previously, the RAC platform was installed on two nodes. The database version is 10.2.0.1. The purpose of this experiment is to upgrade the database version from 10.2.0.1 to 10.2.0.4. The upgrade package can be downloaded from Oracle metalink. This

Instructions before installation:1. SUSE 10 is SUSE 10.1 Professional Edition (32-bit)2. Install "Developer" software, such as gcc, when installing SUSE.3. Here, the Oracle 10g's version is 10.2.0.1(32bit, and the installation package is

When the client initiates a query to the server, a connection is established with the server. MySQL provides the maximum number of connections. Therefore, each time a connection is established successfully, when the server assigns a processing

This problem is caused by Oracle. One is that a dynamic execution statement appears in your program. In the process of dynamic execution, the object is invalid. The following program is still generated by static compilation. Its reference is still

I used SQL Server databases all the time. Recently, my company has a new project to use mysql databases, many of which are cross-Server access. SQL Server uses linked servers for cross-Server access, while mysql is implemented through the Federated

Insert into reports an exception when inserting a record into the table, prompting: ORA-00928: missing SELECT keyword (missing SELECT keyword) Cause: 1. For example, most of the online expressions are similar because the column names cannot be

In Oracle queries, if there is no sorting, but you want to route the information of a specific value in a column to the front, use the decode (field, 'field value', number) of oracle) For example, if you want to forward the result of name = 'zhang

If you want to send an email from Oracle before 10 Gb, you must use the utl_smtp and utl_tcp feature packages of oracle to package an email sender program and then use it. since 10 Gb, this process will become very simple. because oracle provides us

Prerequisites:Mysql must enable the binary log functionBinary logs record DML DCL DDL [Mysqld]Log-bin =/data/mysql-bin Time Point 1 Thu Dec 16 13:53:54 CST 2010Create a tableInsert some dataMysql> use test;Mysql> create table upl (id int, user

When using lomboz_eclipse 3.3 to connect to Oracle, you may encounter some troubles. Write down this process for your reference. 1. window --> show View --> other --> Connectivity --> Data Source Explorer 2. In the new Data Source Explorer window,