Database Administrator

Installing Oracle RAC on the AIX platform is a pitfall. I verified this again today because there are too many bugs! Record the problem because there are too many bugs! We strongly recommend and look forward to the development of Oracle RAC on the

To view database Parameters in Oracle EBS, go to System Administration> Oracle Applications Manager> Initialization Parameters.OrPath: System Administration> Oracle Applications Manager> System Configuration Overview> Database> Init. ora

We have previously introduced the virtual columns and read-only tables in the new Oracle 11g feature. Today we will introduce another new feature, the combined trigger. In earlier versions of Oracle, you can use the FOLLOWS keyword to control the

1. query all Oracle roles Select * from dba_roles; 2. Describes frequently used pre-defined roles, such as connect, resource, and dba. 1. connect has most of the permissions of General developers. In most cases, it is enough to assign the connect

Oracle 11g R2 returns a EXP-00011 error solution with EXP Export C: \> exp businessdata/businessdata file = dropcol. dmp tables = ACSTRULE, ARREARSCFG, role al_account, role al_account_his, INVOICE, INVOICE_HISTORY, role, RULCOCAP, STEVREAC Export:

In Oracle 11g version, full-Table serial scan may use direct path read instead of db file scattered read used in earlier versions, obviously direct path read has more advantages:1. reduces the use of plug-ins and avoids possible use of plug-ins2.

Requirements: If the field value is not a numeric or numeric string, update the field value'' 1. Function Method (batch release is not allowed ):[SQL] CreateOrReplaceFunctionIsNumber (p_in varchar2)ReturnBooleanAs I number; Begin I: = to_number

Q & A from a foreign SNS website Quora: Which of the three file systems XFS, ZFS, and ext3 can produce the best performance with MySQL? Domas Mituzas, a senior Database Expert from Facebook, gave his own answer. He believes that MySQL is the most

The output of this command shows that the duplicate command of Oracle RMAN is executed internally and has a deeper understanding of cloning.For demonstration of the previous steps, see: C: \ oracle \ product \ 10.2.0 \ client_1 \ BIN> rman target

DSG RealSync database real-time replication software A new generation of real-time heterogeneous heat disaster recovery-Oracle Database IT systems have been running for a long time. On the one hand, their functions are getting greater and greater,

Html code Android 2.3.3 Eclipse Version: 3.7.0 LogCat LogCat error message: 02-13 13:29:32.830: WARN/ActivityManager (62): Launch timeout has expired, giving up wake lock! 02-13 13:29:33.381: DEBUG/dalvikvm (17173): GC_CONCURRENT freed 771 K,

Preparations Install a Virtual Machine (VMware Workstation version 8. x or VMware Server Version 1. x) Install the Operating System (CentOS 5.x or CentOS 4.x) on the Virtual Machine) Create an Oracle user and copy the Oracle software to a directory

Managing Oracle clusterware (OCR)Oracle Clusterware places the configuration information of the entire cluster on shared storage. The information includes the list of cluster nodes, the ing between cluster database instances and nodes, and the CRS

1. Create an Oracle global temporary table. The Code is as follows:SQL code DECLARECntInt; Begin -- If the temporary table exists, delete it. SELECT Count(1)IntoCntFromUser_tablesWhereTable_name ='Templogsmshall _ session'; If cnt> 0THEN

1. Install sqoop Download sqoop-1.2.0.tar.gz (version 1.20 is compatible with Hadoop0.20) Put the hadoop-core-0.20.2-cdh3u3.jar, hadoop-tools-0.20.2-cdh3u3.jar into the sqoop/lib directory, the two jar packages are out of cloudera company, you can

Redis is a high-performance key-value database. The emergence of redis largely compensates for the shortage of keyvalue storage such as memcached, and can play a very good complementary role in relational databases. It provides Python, Ruby, Erlang,

This article mainly discusses the problems encountered during the entire RAC installation process and how to solve them. Error 1: Shared disk configuration issues. If the shared disk contains content, it may cause an error when executing root. sh

1. Architecture In Oracle 10g, the process for transmitting logs to the standby node database is ARCH and LGWR. (In 11g, LGWR is replaced by LNS, but I'm not sure if it is LGWR in 10g !) The slave node receives logs by using the log_archive_config,

The MERGE statement is a new syntax of Oracle9i, used to merge update and INSERT statements. The MERGE statement is used to query another table based on the connection conditions of one table or subquery. The join condition matching is updated, and

Premise: You have a database account for apps and want to know the password of a user. Because the password in fnd_user is encrypted, you cannot understand it. You can try the following method to view the user password. SQL>DescFnd_user;