oim 11g

. Before Oracle 11g, the temp table space was used, although it could be freed, but the amount of tablespace usage was shown to be 100%, you can use the following script to view the actual usage of each data file in the temporary tablespace: Set PageSize 50 Col Tablespace_name for A20 Col "tempfile name" for A42 Set Linesize 300 Select F.tablespace_name, D.file_name "Tempfile name", Round ((F.bytes_free + f.bytes_used)/1024/1024, 2) "Total MB", Roun

Problem:When Windows Server 2012 installs Oracle 11g, the installer complains that the [INS-13001] environment does not meet the minimum requirements. Analysis Reason:Winodws Server 2012 was not released when Oracle released 11g. Therefore, there is no Windows 2012 as a certified operating system in Oracle's setup program. Solution:The first method:The installation can be ignored directly. The second m

standby logfile thread 2 group size 50M, group size 50M, group size 50M; --DG related configuration (fal_client 11G has been deprecated, file_name_convert after testing only RMAN replication data used to convert paths, standby settings can) alter system set fal_server= standby sid= '*'; Alter system set Standby_file_management=auto sid= ' * '; Alter system set log_archive_config= ' dg_config= (ORCL, Orclbak) ' sid= ' *; Alter system set log_archive_d

Oracle 11G when exported with export, empty table can not guide 11G R2 has a new feature, when the table has no data, do not allocate segment to save space Workaround: Insert a row, and then rollback will produce segment. The method is to insert data in an empty table and then delete it, resulting in segment. When you export, you can export an empty table. Sets the Deferred_segment_creation parameter, wh

Tags: Oracle Linux Centos system operationsTroubleshooting remote inability to invoke graphics installationThe remote installation of the ORACLE-11G database cannot invoke a graphical workaround, as in the following error:WORKAROUND: Switch to the root user and execute the command:#xdpyinfo | grep Local//results as filtered out is localhost:11.0If you do not have this command, you need to install the desktop with YumCentos6/redhat6:yum groupinstall-y

Label:Environment Introduction: OS: both [[email protected] ~]# uname-a Linux java3 2.6.18-308.el5 #1 SMP Tue 20:06:06 EST. x86_64 x86_64 x86_64 Gnu/linux Main Library: Database version: 11.2.0.3.0 Two nodes of RAC node one: 192.168.15.26 node Two: 192.168.15.27 Standby database version: 11.2.0.3.0 IP 192.168.15.9 Repository installed only database software not built Specific steps: One: Install the database software on 192.168.15.9 This server, not much introduction. Second: Modify the main lib

Tags: Oracle 11g client Full Uninstall1. Disable Oracle Services: Enter Computer Management, in the service, find all services at the beginning of Oracle, right click to select Stop2. In the Start menu, locate Universal Installer, run Oracle Universal Installer, click Uninstall product3. in the Product List window, click Expand All, except oradb11g_home1, tick other items, click DeleteAfter uninstalling, then delete: oradb11g_home13. Press the Windows

Label:Oracle 11g 64-bit installation sqldeveloper is not open for workaround:1. Download the corresponding version of Sqldeveloper to the official website.2. Find the F:\app\Administrator\product\11.2.0\dbhome_1\sqldeveloper overlay under the corresponding installation path.3. Reopen the Start menu inside Sqldeveloper if a flash disappears, you need to perform the fourth step.4. Locate the folder you just overwritten F:\app\Administrator\product\11.2.

Tags: name error technology share replacement how to query Flash recovery free related informationOracle 11g R2 Rman BackupDefinition and classification of backup and recovery Definition and classification of backup: 备份就是把数据库复制到转储设备的过程。其中，转储设备是指用于放置数据库副本的磁带或磁盘。通常也将存放于转储设备中的数据库的副本称为原数据库的备份或转储。备份是一份数据副本，从不同的角度分类如下： From a physical and logical point of view: From physical and logical, backups can be divided into physical and logical backups. Physica

Tags: Linux oracle 11gOracle 11g installation on Linux Create the required users and groups Vim mk_user.sh GROUPADD-G 501 OinstallGROUPADD-G 502 DBAGROUPADD-G 503 OperUseradd-u 501-g oinstall-g Dba,oper Oracle SH mk_user.sh Create the desired directoryVim mk_dir.sh Mkdir-p/u01/app/orainventoryChmod-r 775/u01/app/orainventoryMkdir-p/u01/app/oracleMkdir/u01/app/oracle/cfgtoollogsChown-r oracle:oinstall/u01Chmod-r 775/u01/a

July 2014, wrote an article about EF5 with Visual Studio, Oracle 11g, the original address: http://www.cnblogs.com/HouZhiHouJueBlogs/p/ 3844028.html, Oracle is now supported to EF6. Technical update fast, some details such as not recorded, it is easy to be forgotten, so there is this blog post.　　Some basic knowledge of. NET support from Oracle learn about1. In the early days, Microsoft did its own System.Data.OracleClient. Now it has become an expired

Tags: error in Oracle 11g Dataguard installation1. log_archive_dest_1 parameter not set, archive file is not synchronizedMon Nov 07 17:39:12 2016Using standby_archive_dest parameter default value as Use_db_recovery_file_destMon Nov 07 17:40:12 2016Using standby_archive_dest parameter default value as Use_db_recovery_file_destMon Nov 07 17:41:12 2016Using standby_archive_dest parameter default value as Use_db_recovery_file_destMon Nov 07 17:42:12 2016U

First, the cause of the problem:A new feature in 11G that does not allocate segment when the table has no data to save space1, insert a row, and then rollback will produce segment. The method is to insert data into the empty table and then delete it, resulting in segment. When exporting, you can export empty tables.2. Set Deferred_segment_creation parametersSql> Show Parameter Deferred_segment_creationNAME TYPE VALUE-----------------------------------

The following error occurred while starting the Oracle 11g RAC database, only one of the nodes could be started, and the other node could not start, possibly due to a previous modification of the Cluster_database parameter. This parameter must be set to true in the Oralc RAC schema. Error message: ora-01102:cannot Mount Database in EXCLUSIVE mode Workaround: RAC1 node: Sql>

Label:before closing the backup control file/parameter file:Sqlplus/as Sysdbaalter Database backup controlfile to '/home/oracle/control.ctl.bak '; Create pfile= '/home/oracle/init lt; instance name >.ora ' from SPFile;One, Oracle 11g RAC shutdown sequence1. Stop the EM ServiceSu-oracleExport ORACLE_UNQNAME=DB11Emctl Status DbconsoleEmctl Stop DbconsoleEmctl Status Dbconsole2. Stop listeningSRVCTL Status ListenerSrvctl Stop ListenerSRVCTL Status Listen

, remove the field that was just blindly selected, only keep deptno,dname,sal_sum (the purpose is to do a "departmental classification" of the "Payroll Summary" report)7, switch to the "results" view again, you can find that Sal_sum has been able to correctly summarize the Department information8, the light has tabular form of data rendering, looks more monotonous, you can refer to the operation, add some more vivid and intuitive chart, here we add a vertical bar chart9. After adding the chart,

Tags: new features show row statement query attribute handling cannot export replicationThere is a new feature in ORACLE 11G that does not allocate segment when the table has no data to save space. Workaround: 1) Insert a row, and then rollback will produce segment. The method is to insert data into the empty table and then delete it, resulting in segment. When exporting, you can export empty tables. 2) Set Deferred_segment_creation parameters Sql> S

Tags: Ops directory sed nal RTM user its source users Oracle HR Example User's build 10g,11g can be Put the 10. sql files on the attachment (see the end of the article) in this path first: $ORACLE _home/demo/schema/human_resources Script Name Description Hr_analz.sql Collects statistics on the tables in the schema. Hr_code.sql Creates procedural objects in the schema.

Label:The Oracle 11g database is installed on Windows 10 and appears many times: a prompt box pops up when the progress bar of the installation is nearing the end. As follows: "Java (TM) 2 Platform standard Edition binary has stopped working; a problem has occurred that causes the program to stop working properly. If a solution is available, Windows closes the program and notifies you of the error message. Finally, it was discovered that the inst

After Oracle 11g initialization is installedNote the following points1, the password case of the problem.2. The empty table cannot export the problem. [Features of R2 version]3. The default password is valid for 180 days.How to resolve:Run Sqlplus/nologConnect/as SYSDBAalter system set SEC_CASE_SENSITIVE_LOGON=FALSE; --Change Password casealter system set DEFERRED_SEGMENT_CREATION=FALSE; --The paragraph is not delayed creation, the empty table can be