Alibabacloud.com offers a wide variety of articles about oracle 11g end of support, easily find your oracle 11g end of support information here online.
BKJIA exclusive Translation] This article provides a general introduction to the automatic database maintenance task management in Oracle 11g. The article is concise for two reasons: 1. Most people have not touched these settings. Even so, if you are processing maintenance tasks at night and opening a maintenance window at night is not a good idea, you may want to change it all. 2. Basic management tasks ar
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
With the upgrade of the Oracle version, RMAN is also enhanced. RMAN in Oracle11g supports the use of different operating systems and different databases. For the compatibility of RMAN, refer: Oracle RMAN compatibility and FAQs between different versions and different platforms This article demonstrates an example of restoring 10 Gb to 11 GB in linux. Target end:
linux.x64_11gR2_database_1of2.zipunzip linux.x64_11gR2_database_2of2.zip chown-r oracle:o Install /home/oraclechmod-r 775 /home/oracle8. Installing the graphical user interfaceYum Groupinstall "Desktop" Yum groupinstall "X Window System" Yum groupinstall "KDE Desktop"----#启用图形用户界面Init 59. Install./runinstall1. Uncheck (update password support)2. Option "Create and configure a database"3. "Desktop Class"4. Enter the Administrator password5. Direct N
Oracle language, add the environment variable Nls_lang, and the value is simplified Chinese_china. Zhs16gbkIf you do not know the Oracle language of the remote database, you can ssh or telnet to the remote machine, enter it at the command interface, and connect to the database using the command line.SELECT * from Nls_instance_parameters;View the value of Nls_languageNls_languageNls_territory5. Download and
affects the productivity of the shared pool or PGA.5.Java PoolUsed to provide memory space for use with Java virtual machines in order to support the running of Java packages in the database, which is determined by the Java_pool_size parameter.6. Flow PoolUsed to share information between databases and databases. If the Oracle stream is not used, you do not need to set up the pool. The size of the flow poo
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
This article describes how to install the OracleDatabase 11g Release 2 64bit database on the 64ora17 64bit system. Assume that you have installed the 64ora17 64bit operating system and the swap partition is 2 GB, linux security is disabled and the following software groups are installed: Gnome Desktop Environment Editors Graphical Internet Development Libraries Development Tools Legacy Software Development Server Configuration Tools Administr
machine is: d:/instantclient_11_2/network/admin4, set the language of Oracle, add the environment variable Nls_lang, the value is simplified Chinese_china. Zhs16gbkAssuming that the Oracle language of the remote database is unclear, SSH or telnet to the remote machine, enter in the command interface, and connect to the database with the command line.SELECT * from Nls_instance_parameters;View the value of N
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
library, I also do this the first time, DBCA build the library will be an error, because Ubutunbu does not support the RPM package) ... During the installation of a makefile error, a library file has not been compiled, but can continue to install, it is estimated that later use will be problematic; In addition, there will be a configuration link at the end of the installation and so long, only one advert
Oracle 11G 11.2.0.1.0 using exp cannot export empty tables solution 11G (11.2.0.1.0) has a bug, when the table does not have data, no segment is assigned solution: www.2cto.com 1, insert a row, then rollback generates the segment. This method inserts data into an empty table and then deletes it, resulting in a segment. An empty table can be exported. 2. set the d
The developer asked me to set an Oracle 11g sga slightly larger. Therefore, follow the previous 10 Gb memory operation on oracle.[Oracle @ localhost db_1] $ sqlplus/nologSQL * Plus: Release 11.2.0.1.0 Production on Saturday June 30 13:42:07 2012Copyright (c) 1982,200 9, Oracle
serverGgsci (HWOGG01) 5>add replicat rep_w2, Exttrail d:\app\Administrator\ogg\dirdat\rt, checkpointtable ogg.checkpointGgsci (HWOGG01) 6> edit params rep_w2Click "Yes "to enter the following and saveReplicat REP_W2DDL include allDdlerror default Ignore RETRYOP maxretries 3 RetryDelay 5UserID OGG, password OracleAssumetargetdefsDiscardfile D:\app\administrator\ogg\dirdat\rep_w2_discard,appendMap prun.*, Target prun.*ResolveConflict (Updaterowexists, (DEFAULT, OVERWRITE))ResolveConflict (Insertr
Oracle 11G Virtual column virtual Columnoracle 11G introduces a dummy column in a table, a virtual column is an expression that is evaluated at run time, not stored in the database, and cannot update the value of a virtual column. Defines the syntax for a virtual column: column_name [datatype] [GENERATED always] as [expression] [virtual]1. Virtual column can be u
Export ORACLE_HOME = $ ORACLE_BASE/product/11g Export ORACLE_SID = msgplus Export LANG = en_US.UTF-8 Export NLS_LANG = AMERICAN_AMERICA.AL32UTF8 Export PATH = $ ORACLE_HOME/bin: $ PATH 4. Modify the Shell restrictions of oracle users. Modify the "limits. conf" file under "/etc/security/" and add the following four lines: Oracle soft nproc 2047 Hard nproc
Http://blog.sina.com.cn/s/blog_7c855cf70100shrv.html Oracle 11g and EM cannot be started. It may be because the IP address has changed. So I used the emca command to reconfigure Oracle em. The specific process is as follows:I: \ Documents ents and Settings \ geshaoqing> emca-config dbcontrol DB-repos recreateEmca started at 11:16:40Em configuration assistant 10.2
Oracle 11g Release 1: http://www.oracle.com/technology/software/products/database/index.html RHEL5 under the ASMLib2.0: http://www.oracle.com/groovy/global/cn/tech/linux/asmlib/index.htmlopen the page, will find a Red Hat Enterprise Linux 4 AS (x86) Link, click it, the new page contains the Red Hat Enterprise Linux 5 AS download link. Read more: Install Oracle
Oracle Log Full system disk is full, causing the database to hang up and the Archivelog log is full, but the database is not open, unable to login, fortunately, can also go to Mount state. Workaround:1. According to the error View appearance: CRS service downCrs-0184:cannot communicate with the CRS daemonDelete/var/tmp/.oracle DirectoryTo delete an Oracle ALTER L
is: Span style= "COLOR: #ff0000" > " | | Mnttime); -- set serveroutput on/off on or off display Dbms_output.put_line ( " ok, im fine " end / You can save the statement to a file and then call it with the "@/path/filename.sql".Substitution variables:SELECT empno, ename from EMP WHERE deptno= Department number;If the replacement variable provides data for a numeric column, you can drink it directly, or if you provide data for a character
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
