Database Administrator

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

1. Oracle startup stepsLog On As an Oracle user and enter the following commandSqlplus/nologConn/as sysdbaStartupQuitLsnrctl start2. An error occurs when the Oracle database is started at startup.ORA-01102: cannot mount database in Exclusive

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

Import java. io. BufferedReader;Import java. io. File;Import java. io. FileInputStream;Import java. io. InputStream;Import java. io. InputStreamReader;Import java. io. OutputStream;Import java. io. Reader;Import java. io. Writer;Import java. SQL.

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

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

A few days ago, the only annual event in the Chinese Database field was held in Beijing at the 2011 database technology conference hosted by Shengtuo media's IT168 website, ITPUB, IXPUB, and ChinaUnix China's three major enterprise-level technical

After the installation is complete (read the following link: Installing Oracle 10G R2 on CentOS 5.6), after you reactivate the instance, you will find that Oracle is not started on your own. This is normal, because Oracle Installation in Linux does