oca 11g

Delete Oracle 11g R2 in Linux 6.4 Close DatabaseSQL> shutdown [immediate] Stop Listener[Oracle @ ora920 oracle] $ lsnrctl stop If an application service exists, stop the application service first.[Oracle @ ora920 oracle] $ ORACLE_HOME/Apache/bin/apachectl stop Delete the installation directory[Root @ ora920/root] # rm-rf/opt/oracle/ Delete files under/usr/local/bin[Root @ OracleTest/root] # rm/usr/local/bin/dbhome[Root @ OracleTest/root] # rm/usr/loca

A small problem with the auto-scaling feature of Oracle 11g partitions, oracle11g It is very convenient to use the automatic partition Extension function in Oracle 11g, but it also brings about a problem, that is, after the export and import, the table creation statement is changed. Here is an experiment: SQL> select * from v $ version;BANNER------------------------------------------------------------------

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 wait is related to oracle's asynchronous io. T

Using rman for cross-database and cross-server migration10g server: 192.168.182.20.oracle 10.2.0.1.0 RHEL 4 32bit 11g Server:Server 192.168.182.131 OEL5.8 _ 32 Oracle 11.2.0.1.0 32bit[Oracle @ oelr5u8-1 admin] $ uname-Linux oelr5u8-1.localdomain 2.6.32-300.10.1.el5uek #1 SMP Wed Feb 22 17:22:40 EST 2012 i686 i686 i386 GNU/LinuxSYS @ PROD> select * from v $ version; BANNER--------------------------------------------------------------------------------O

Why cannot I enable ADG for Oracle 11g slave database? Today, we have encountered a strange problem, but there is an essential cause and effect behind the strange phenomenon.During an Environment check in the afternoon, it was found that the standby database was in the mount stage. This was a 11gR2 database, and it was a waste of time without ADG. I felt too much to do this.So I tried to start the open stage and found that the status was always read o

In Oracle 11g, use sysdba to connect to ASM.SQL> conn/as sysdbaSQL> alter diskgroup DATA mount;Alter diskgroup DATA mount*ERROR at line 1:ORA-15032: not all alterations saved medORA-15260: permission denied on ASM disk groupORA-15260: permission denied on ASM disk groupInform the permission to be rejected.[Root @ rac1 ~] # Su-grid> $ Sqlplus/as sysdbaSQL * Plus: Release 11.2.0.1.0 Production on Thu May 3 15:28:20 2012Copyright (c) 1982,200 9, Oracle.

Oracle 11g PL/SQL function result cache, oracle11g Two experiments have been conducted to simulate the Oracle Performance Diagnosis art. The book says that if you don't need RELIES_ON, then the changes to the objects on which the function depends will not result in the invalid result cache operation (result_cache RELIES_ON (test1, test2). The test proves that this operation is incorrect. The function f1 () does not use RELIES_ON, however, changes in t

In Oracle 11g, the lock mechanism is further enhanced, mainly reflected in the following three aspects: Serializing Locks Locking Tables Explicitly Sharing Locks Serializing Locks Some people also generalize this feature into DDL Wait options. In a Prod Database, DBA tries to change the table named SALES and add a column of TAX_CODE to it. This is a common task. When you execute an SQL statement similar to the following: 　 SQL> alter table sal

Solution for Oracle 11g forgetting SYS and SYSTEM passwords Oracle 11g forgets the SYS and SYSTEM passwords. The answer is simple: change the password! 1. First, log on to the SYS account using the operating SYSTEM authentication method and change the SYSTEM account password. $ Sqlplus/as sysdba SQL * Plus: Release 11.2.0.4.0 Production ction on Fri Mar 20 14:23:41 2015 Copyright (c) 1982,201 3, Oracle. All

Error Caused by Oracle 11g import to 10g Environment Introduction Old Environment New Environment Operating System: RedHat5.8 64-bit Redhat6.4 64-bit Database Version: Oracle 10.2.0.4 64-bit Oracle 11.2.0.4 64-bit Background: The old database rac was built based on oracle10g and has been running for several years. Now, the front-end application is ready to be upgraded. Considerin

New Features of Oracle 11g-HM (Hang Manager) In this article, we will introduce the new features of Oracle 11g-hang Manager. We need to note that HM only exists in the RAC database. When we diagnose database problems, we often encounter database/process hang problems. For hang problems, there are two common causes. Deadlock (cycle ). For such hang, the problem will always exist unless the loop is broken. A

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 database. The login user isSysdba* Enter the following command to different file paths: Sele

Oracle 11g column-to-row listparts It is a little difficult to switch between the first 11g of Oracle, and it is very simple after 11g. Currently, a test table records the approval information of a document. The id is the primary key of the Approval Information, the sheet_id is the foreign key, and the id of the document, remark indicates the approval content. On

Oracle 11g Silent Installation Software + manual database creation Because it is a secondary jump + remote operation, the GUI cannot be used and cannot be directly installed on the GUI. Use silent software installation + manual database creation to complete the requirement. 1. Install the Oracle software in silent mode and configure the listener 2. manual database creation 3. check whether all components meet the requirements. 1. Install the Oracle so

New Features of Oracle 11g: User rename Oracle Data is constantly changing during project development. Therefore, we need to regularly import the development database to the test database. The common practice is "trilogy :" 1. Export data from exp in the Development Library 2. Delete the Test Database User 3. Use imp to import exported data to the Test Database Today, my colleague asked me if I could keep my previous users, for example, changing the u

Oracle 11g replica uard creation in ORA-01665 resolution, dataguardora-01665Oracle 11g fails to restore the standby control file when creating data guard. When I mount standby database, tell me that the control file is not a standby control file and the information is ORA-01665: control file is not a standby control file ".The control file is generated using rman in the master database.Backup current contro

From Oracle 12c Backup (EXPDP) package, restore to 11g, think all know there will be compatibility issues. Sure enough, the error: ORA-39142: Version number 4.1 (in the dump file "fork. EXPDP") incompatible Like Later learned that in the 12C backup, you should specify version information, such as I want to guide the 11g library (specific version of 11.1.0.6.0, open Sqlplus can see), then version=11.1.0.

The example in this article describes Java's approach to Oracle 11g RELEASE2 based on JDBC. Share to everyone for your reference. Specifically as follows: The JDBC connection for Oracle 11g Release 2 appears to be different if you receive the following exception:Listener refused the connection with the following error:ora-12505, Tns:listener does no currently know of SID given in C Onnect Descriptor.Then y

Tags: Session set EPO BSP Ongl important tips title IDTJob required, installed Oracle 11g, an error occurred while importing the backup data on other machines:IMP-00019: Deny row due to ORACLE error 12899IMP-00003: Encountering ORACLE error 12899ORA-12899: Column "ZHENG". " D_dic "." Dicexplain "value is too large (actual value: 140, Maximum: 100)This data sheet structure is injected directly, not at all. Later on the Internet to know the original is

Nothing's going on today. Installed Oracle database, but in this process encountered a lot of problems, here want to share with you.At first I installed the Oracle 12c, but this installation does not matter, Ann me a full half a day is not well, in the configuration of Security window there is no time, the current user does not have access to the temporary folder permissions, at that time, Baidu has a lot of online tutorials also has not been resolved, including online said the sharing of C-disk