Requirements for installing oracle10gr2 on RHEL 5/OEL 5 (x86_64) [ID 421308.1]
Additional Notes----------------1.Supported distributions of the 32-bit (x86) Linux OS can run onAmd64/em64t and Intel processor chips that adhere to the x86_64ArchitectureA.) Oracle 32-bit running on amd64/em64t with 32-bit OS is supported, but is not covered by this note.B.) Oracle 32-bit running on amd64/em64t with 64-bit OS
Oracle database-enterprise edition-version 8.1.7.4 and later information in this document applies to any platform. **checked for relevance 06-apr-2010 **checked for relevance 17-apr-2013 * * Checked for relevance on 16-nov-2011 * * *Purpose1.1 Abstract ============ This document provides guidelines for customers to doing an initial analysis of problems related to Internal errors (ORA-600) and core dumps (ORA-7445) by using My
The common problem of using PHP is: Compile PHP forgot to join an extension, and then want to join the extension, but because the installation of PHP and then installed something such as pear, do not want to remove the folder reload, then you need to add a module once again support, Linux operating system under the ability to use Phpize to dynamically add extensions to PHP. The following is an example of extension module oci8 (PHP connection to
Author: eygle link: http://www.eygle.com/archives/2011/02/oracle_asmlib_support.html
Since the launch of Oracle Linux 6, many users are eager to try. In Linux 6, a change in asmlib has been published on Metalink. See Metalink note1089399.1.
Oracle points out:
For rhel6 Oracle will only provide asmlib software and updates via unbreakable Linux Network (uln).
Label: The main updates to the DATAUML Design1.5 version include the following:1, optimize the database login interface;2, Query Analyzer smart tips;3, optimize the database browsing plug-in, database login components, support history cache;4, Support no Oracle client connection;5, Support browsing database view, sto
Tags: OracleThe solution is as follows: Use Goto to jump DECLARE done BOOLEAN; BEGIN forIinch 1.. the LOOP
IFDone Then
GOTOEnd_loop;END IF; notAllowed unless an executable statement followsNULL; --AddNULLStatement toAvoidError
END LOOP; --Raises anErrorWithout the previousNULL
END; 11g Add continue keyword usage as follows DECLARE
done BOOLEAN;
BEGIN
FOR i IN 1..50 LOOP
IF done THEN
continue;
END IF;
END LOOP;
END;
Refer to aReference
Label:Performance tuning is a task that every DBA can encounter in his careerBig to the World 500 strong core system, small to the township enterprises of the invoicing, almost will have to tune the timeFaced with a variety of systems, a wide range of needs, the means of tuning is also colorfulLocating the problem, analyzing the problem, solving the problem, is indispensable, and the method is diverse, and the effect is different.determining baselines is the first major task in the communication
Oracle's 11GR2 version does not make much of a change to the data pump, mainly by adding support for the original version parameters and removing some small restrictions.
This article describes the support of the data pump version.
In 11.2, Oracle added functionality to the version, and the data pump also supports exporting to the specified version or importing
1. According to Q193893, we need to build two views within Oracle.
Information about using Oracle with Microsoft Transaction Server and COM + components
http://support.microsoft.com/?id=193893
Based on our past experience, we can try to run Oracle's own scripts with the SYS account. The default path for the script is:
C:oracleora92dbmsadminxaview.sql
Please run the script in SQL Plus.
2. The above c
This article describes the maximum length that a table name can use in the Oralce database. This length is also the maximum length of the Oracle identifier, which is 30 characters.
Small weave today, when an Oracle database table is being built, it is suggested that the following table name is longer than the maximum value. The error is as follows:
Copy Code code as follows:
Error Reporting:
SQ
It's not good to look at Doc.
sql> shutdown Immediate
The database has been closed.
The database has been unloaded.
The ORACLE routine has been closed.
Sql> Startup Mount
The ORACLE routine has started.
Total System Global area 104857600 bytes
Fixed Size 1247540 bytes
Variable Size 96470732 bytes
Database buffers 4194304 bytes
Redo buffers 2945024 bytes
Database loading complete.
--Enable manua
Label:GoldenGate support for IBM mainframe z/OS 2.1 and DB2 v11From:GoldenGate support for z/OS 2.1 and DB2 v11 (document ID 1941364.1) Suitable for:Oracle goldengate-version 12.1.2.1.2 and laterInformation in this document applies to any platform. Goal:Need to know if a goldengate version can support DB2 v11 on IBM mainframe z/OS 2.1? Solution:There are currentl
The previous project data used MSSQL and MySQL, and the orm used a lightweight dapper, which was very convenient and had better performance than ef. The key was the flexible syntax and ease of use, I feel very good when I develop several websites using this framework.
However, if Oracle is to be used in the new project, a problem occurs. The keyword "@" in dapper is not supported in the Oracle database. Af
Label: An exception was thrown after using a transaction during Oraclebulkcopy bulk data import. You can import batches correctly when you are not using transactions. ORA-12154: Unable to resolve the specified connection string. But the TNS configuration is certainly not wrong, Is it not connectionstring that the execution of the transaction has changed, And also: Temporarily discovers that Oracle's bulkcopy does not support transactional processing u
Adding a shared disk to a VM supports ORACLE 10g rac. Because the original ASM shared disk capacity is small, it is impossible to mount the archive log and backup files. so I decided to add a disk. 1. Add a virtual disk to node 1 and place it in the original shared directory named ASM4. Select SCSI. Note that the disk is placed behind another disk on SCSI bus 1, otherwise, it is easy to change the drive letter mode = independent-> Persistent www.2cto.
Language _ region. Character Set SIMPLIFIEDCHINESE_CHINA.ZHS16GBKsetnls_lang
Language _ region. Character set SIMPLIFIED CHINESE_CHINA.ZHS16GBK set nls_lang =
Language _ region. Character SetSIMPLIFIED CHINESE_CHINA.ZHS16GBK
Set nls_lang = 'simplified CHINESE_CHINA.ZHS16GBK'
Oracle modifies the server character set:SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP MOUNT;
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES
between two items
Character families
Character meaning
[[: Alpha:]]
Any letter.
[[:d Igit:]]
[[:d Igit:]] any number.
[[: Alnum:]]
Any alphanumeric
[[: Space:]]
Any whitespace characters.
[[: Upper:]]
Any uppercase letters.
[[: Lower:]]
Any lowercase letters.
[[:p UNCT:]]
Any punctuation.
passwd file =/etc/smbpasswd
WINS support = yes
4. Add a line:
Interfaces = 111.222.1.2/24 (you can input your IP address and subnet mask)
5. Add the necessary shared directories
[Deploy]
Comment = NDB Web document root
Path =/usr/local/jakarta-tomcat/webapps/deploy
writable = yes
6. Restart SMB
/ETC/RC.D/INIT.D/SMB restart
6. Add user to THE/ETC/SMBPASSWD
#smbpassed-a username
Where username is a Linux system user.
Set the password for this user to
Label:Troubleshooting X64 operating system PL/SQL connection error Make sure the the-Bits Oracle client installedDescription Plsql developer does not support Oracle 64-bit client connections.Workaround:1. Download 32-bit Oracle ClientIn fact, you can download the free installation version, http://www.oracle.com/technet
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.