how to uninstall oracle 11g

Tags: OracleOracle Database 11g Some important initialization parameters (i)Initialize parameter file locationD:\app\Administrator\admin\orcl1\pfile\init.oraInit.ora1, Diagnostic_destIn 11g, there is a new structure for storing diagnostic information called the Automated Diagnostics repository (AUTOMATICD Diagnostic Repository ADR).Specify the directory location with some parameters, such as $ORACLE_BASE/DI

SQL> select * from v $ version; BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit ProductionPL/SQL Release 11.2.0.1.0-ProductionCORE 11.2.0.1.0 ProductionTNS for Linux: Version 11.2.0.1.0-ProductionNLSRTL Version 11.2.0.1.0-Production Sometimes there is a background wait event: db file async I/O submit This w

How to manually delete an Oracle 11g database in Linux The following steps teach you how to manually delete an Oracle 11g Database in a Linux environment. I installed the Oralce 11G database on CentOS 6. Use SQLPlus or other command line tools you like to log on to the data

After migrating the data of a test system from Oracle 10 Gb to 11 GB, I heard the developers say that they failed to execute an SQL statement to create an index, but it can be executed normally in 10 Gb. This index is a function index with duplicate columns. It may be incorrect and this index is not useful. Therefore, you have never paid attention to this index. I felt quite interesting, so I tried it myself: 1. First, let's look at the

Tags: Oracle 11g ASM Installation1. Oracle 11g InstallationSlightlyFor detailed procedures, please refer to:Http://blog.sina.com.cn/s/blog_7c5a82970101excf.html2. Install the ORACLEASM packageRPM-IVH oracleasm-support-2.1.7-1.el5.x86_64.rpm oracleasmlib-2.0.4-1.el5.x86_64.rpm oracleasm-2.6.18-164.el5-2.0.5-1.el5.x86_64

Oracle 11gThe clientLinuxThe configuration process is a little bit difficult, but as long as we configure step by step, there is nothing. This article describes how to configure the Oracle 11g client on Linux. First download several compressed packages from OTN, for: http://www.oracle.com/technology/software/tech/oci/instantclient/index.html, And then according t

Tags: 11g hand-built libraryCreate a password fileCD $ORACLE _home/dbsOrapwd file=orapwogg02 password=oracle entries=5Mkdir-p $ORACLE _base/flash_recovery_areaMkdir-p $ORACLE _base/admin/$ORACLE _sid/adumpMkdir-p $

Label:1. Download Oracle 11g R2 for Windows version: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.htmlThese include two compressed packages: Win64_11gr2_database_1of2.zip,win64_11gr2_database_2of2.zip2, unzip two compressed packets into the same directory, namely "database", and then click the "setup.exe" file under the extracted directory:3. In the Configure Security Update

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

The mongoel DG technology uses redo log transmission and application to ensure consistent data on the standby end and the primary end. In this process, Redo Transport and Redo Apply are two core actions. Redo Transport transmits the Redo Log information to the Standby end and waits for the Apply operation. Redo Apply is to execute these log applications and change the Standby data to achieve consistency. The following experiment uses alert log to observe the situation where a pair of Primary and

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

very much. This article reprint must be kept here: http://blog.csdn.net/huangyanlong/article/details/39436195 Deep Blue blog:Http://blog.csdn.net/huangyanlong **************************************** **************************************** ******************* [Description] When installing oracle software, beginners often lack some packages before installation, so some "errors" will be prompted during the installation process, and sometimes ignore th

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

In the 64-bit Windows 8 Enterprise Edition environment, we connected the oracle11g server for two days. We will share the process for your reference. Local Environment: 1. SERVER: Oracle 11g R2 64-bit, installation path E:/org12 Download: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html 2. Client: (1) Instant Client, lightweight, installation path E:/oracle11/Clie

Oracle 11g EM Dbconsole reconstruction tutorial, 11 gdbconsole Overview: You can use command lines and graphical interfaces to manage the daily management of oracle databases. command lines include commands such as sqlplus, srvctl, and crsctl, the graphic interface includes 10 Gb EM dbconsole, 11 gb em dbconsole, grid control centralized management, and EM expre