oracle 11g

Label:Environmental Status:Two virtual hosts A and b:1. A machine has installed ASM storage for Oracle 11g instance reference: Http://www.cnblogs.com/jyzhao/p/4332410.html 2. b machine installed system, configuration and directory structure are consistent with a machine/U01 + 3 ASM DiskDG Deployment Planning: Primary Standby Host Jy-db Jy-dbs

Install ORACLE 11g R2 on CentOS 5.5. Tutorial 1: prerequisites 1. Prepare CentOS. First, what is the most important: partition is the most important. Obviously, the larger the partition, the better, especially the larger the SWAP space, at least 2 GB. Second, for beginners, there are two points to note. First, it is best to install the software in full compliance; second, remove the firewall, SElinux, and s

Background:The physical memory of the master and slave machines is doubled. After the memory is expanded, You need to modify the memory parameters related to the database, including the database and operating system. After doubling the memory size of the backup machine, modify the relevant memory parameters and start the database to the backup machine for two days. If no problem exists, then, double the physical memory of the previous host to switch the database to the slave host. The reason for

1. automatic Installation selected during installation. Because the user name and password have been forgotten for a long time, I have tried several default user names and passwords (The table contains the default user name and password ), the user name and password are all invalid. Finally, you have tried dbsnmp/dbsnmp, prompting you to be locked;2. Log On With sqlplus/as sysdba. The prompt is displayed.3.SQL> alter user dbsnmp account unlock;User altered.SQL> alter user dbsnmp identified by db

Oracle upgrades from 10g to 11g detailed steps database old version: 10.2.0.4 Database new version: 11.2.0.2 OS Version: Solaris 10 Reference Documentation: Complete checklist for Manual upgrades to 11GR2 [ID 837570.1] Part I-Installing 11GR2 software The installation of the software here is not explained in detail, you can refer to the appropriate documentation. Here is to note: If you want to 11gr2

The project team needs to install Oracle on a remote HP minicomputer. The hardware information of the system is as follows: The software information is as follows: 1. Download the correct Oracle Installation version HP-UX can run on HP's own processor PA-RISC and Intel's Itanium (anteng) processor Oracle official site for HP-UX

Tags: oracle oracle 11g Redhat DatabaseFor beginners who want to learn Oracle, see the veteran. Operating System Information: VBox virtual machine software version: Install the required software: Required Software:Http://pan.baidu.com/s/1mgl8kzu Specific installation steps:A. Create a new virtual machine and install

After the CentOS system is installed, you can start the installation of Oracle 11g. First, you must make some preparations. Use commands to create an Oracle account and corresponding user groups Create a folder and grant the Oracle user permissions, as shown in the commandUse the root account to make a series of chan

This morning, I completed the task I proposed for myself yesterday. I finally finished reading PDF files online. At the same time, I solved new problems and added the hand-shaped cursor to control translation. The modification of batch video conversion was not done, mainly because I attended an introduction lecture on Oracle Spatial 11g in the afternoon. Oracle

How to fix the standby database after ORACLE 11G replica uard Failover, and restore uardfailoverProblem scenarios after failover:Due to the failover test, a standby database has been changed to the primary database. How can I change this new primary database (the original standby database) back to the standby database?Both are primary, p1, and p2. How can I set one primary database 1 to p1, And the other pr

authentication delay Ah, will be stuck in the database, the user is not connected up. Go to block the password delay verification: sql> ALTER SYSTEM SET EVENT = ' 28401 TRACE NAME ' CONTEXT FOREVER, Level 1 ' SCOPE = spfile; System altered. Sql> create Pfile from SPFile; File created. Sql> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. Sql> startup

Redhat 7 oracle 11g Silent Installation step tutorial, redhat11g I. Preparations before installation 1. Modify the Host Name sed -i "s/HOSTNAME=localhost.localdomain/HOSTNAME=oracledb.01/" /etc/sysconfig/network 2. Add the host name to correspond to the IP address vim /etc/hosts Append at the end: 192.168.0.71 oracledb.01 3. Disable seLinux sed -i "s/SELINUX=enforcing/SELINUX=disabled/" /etc/selinux/confi

Modify the ORACLE installation directory $ORACLE _home/ctx/lib/ins_ctx.mkWill ctxhx: $(CTXHXOBJ) $(LINK_CTXHX) $(CTXHXOBJ) $(INSO_LINK)Modified to: ctxhx: $(CTXHXOBJ) -static $(LINK_CTXHX) $(CTXHXOBJ) $(INSO_LINK) /usr/lib64/libc.aThen click Retry to pass Install the Oracle times Error error in invoking target ' agent NMHS ':Er

Oracle's official SQL Developer comes with Oracle migration Workbench. What is Oracle SQL Developer? On the official page, this is how it is presented: Oracle SQL Developer is a free and fully supported graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug

Use BBED for Oracle 11g Compilation Environment: RHEL 6.4 + Oracle 11.2.0.4 1. Copy the missing file 2. Compile BBED 3. BBED Test Reference 1. Copy the missing file Several related files are missing in 11g, but we can actually copy the related files from 10g to the corresponding directory of

permissions, permission levels for the directory 755Step Three: Initialize parameters-- This step is to complete the initialization of the parameter file creation$ cd $ORACLE _home/dbs-- in this directory to hold the database initialization parameter file, we need to create in this directory a Pfile file$ VI Inithyl.ora-- Initialize parameter name is Init Plus SIDIn memory_target=900m--11g, memory manageme

How to export an empty table in Oracle 11g Because of the new features created by the delay segment of Oracle 11g, Oracle does not allocate data segments when there is no data insertion, leading to exp being unable to export the empty table of the

Some ASP. NET + Oracle 11G systems write and learn essays, including Oracle's "rownum" and "sequence serial number 」. (6) Oracle rownum, equivalent to the select top of other databases Oracle does not support the select top syntax. to retrieve the maximum or minimum records, you must use the rownum keyword and subque

The Oracle Database 11g has enhanced the DataGuard function in many aspects, so it is difficult to describe it in detail. Therefore, here I will introduce some feature enhancements that I am most interested in. Backup Oracle Database 11g has enhanced the Data Guard function in many aspects, which is difficult to descri

Tags: Oracle Enterprise Manager 11g Start-stop1. See if components are installedCol Comp_name for A40Select Comp_name,version,status from Dba_registry;Comp_name VERSION STATUS---------------------- --------------------------- -------------------------------OWB 11.2.0.4.0 VALIDOracle Application Express 3.2.1.00.12 VALIDOracle Enterprise Manager 11.2.0.4.0 VALIDOLAP Catalog 11.2.0.4.0 VALIDSpatial 11.2.0.4.0