In Linux, the total number of Oracle clients is less than 40 MB, which is very convenient and quick to install.
1. First, check the directory structure after downloading:
Copy it to linux.
2. Use the root user in the command line window to operate in the rpm directory:
Rpm-ivh... rpm
Rpm-ivh... rpm
Rpm-ivh... rpm
Rpm-
export or after the import recompile. The stored procedure did not import successfully, so I finally took advantage of Navicat to import the stored procedure successfully.Note: (1) To ensure that two databases have the same character set, if the difference will be an error. I checked the next two database character sets are the same, so I'm not sure what is wrong with the specific report. To view the database character set:SELECT * from V$nls_parameters WHERE PARAMETER in (' Nls_characterset ',
Operating system: Red Hat Enterprise Linux Server Release 6.2 x86_64Oracle version: Oracle Database 11g Release 2
Oracle Official Download Address:File1:http://download.oracle.com/otn/linux/oracle11g/r2/linux.x64_11gr2_database_1of2.zipFile2:http://download.oracle.com/otn/
After a night of hard work, we finally installed ORACLE and successfully called the ORACLE database using the PHP script. Now we will share with you.(Note: according to some information on the Internet, oracle8.1.6 + php4.0.4 + apache1.3.2 is successful.I tried it several times with a friend but it was not successful. If you have any experts, please advise. It is best to provide more details .)
1. hardware
Tags: hint information software dir SOF limit Mirror Tor Nofile bar1. Acquisition of the CentOS image on the virtual machine. It is recommended that the CentOS7 version of the NetEase Mirror Station (other open source mirror stations may also). Here are the links: Http://mirrors.163.com/centos/7.3.1611/isos/x86_64/CentOS-7-x86_64-DVD-1611.iso PS: This is 64-bit, and now few people use the 32-bit system. Installation of the CentOS system (many online tutorials, not to repeat here) PS: It is best
);Commit;
SQL> select *From test1, test2, test3Where test1.id = test3.dept _ id (+)And test2.id = test3.measure _ id (+ );ID DEPT_ID MEASURE_ID----------------------------------------1 10 1 102 102 203 201 203 10You have selected 6 rows.
There is a problem at 11g:
SQL> select * from v $ version;BANNER--------------------------------------------------------------------------------Oracle Database
or ASM. Block devices and bare devices will no longer be supported in Oracle12. Oracle strongly recommends using at least 3 voting disks in a different location. When using ASM to manage voting disks, you need to be aware of the redundancy levels of disk groups and failure groups. Note that all copies of voting disk are in one disk group, and you cannot distribute voting disks across multiple disk groups. When using an externally redundant disk group
Lab environment: Oracle 11g R2 RAC (11.2.0.3.5) Oracle Enterprise Linux 5.6x86
1. Create an ASM disk group and mount the disk on two nodes. Then, partition the disk on the first node. [root @ Rac1 ~] # Fdisk-ldisk/dev/SDE: 2147 MB, 2147483648 bytes255 heads, 63 sectors/track, 261 cylindersunits = cylinders of 16065*512
terminated.Conclusion: It is not recommended to install 32-bit oracle on 64-bit linux.Can 32-bit oracle databases be installed in 64-bit Linux?
YesAll hardware devices are backward compatible.64-bit can be installed with 32-bitBut 32-bit cannot be installed 64However, there may be a lack of runtime libraries, which is
conflicts with file Span class= "Hljs-keyword" >from package lvm2-7:2.02.105-14.el7.x86_64 error Summary ------------- Workaround, upgrade lvm2 first:
Yum-y Install LVM2
Installing Oracle
Because I'm using a remote host, I'm using VNC as a remote Linux graphics desktop.To install
Client installation is quite simple: you only need to pay attention to the following instructions.
NOTE: If it is installed on the same server as the server, replace the Oracle symbol with the client, and change the installation path accordingly.
Version: Linux Red Hat Enterprise Linux Release 5.5 Nahant Update2
Kernel 2.6.9.22.EL
NONE
Pwrite64
NO
Db file parallel write
FALSE
ASYNCH
Pwrite64
NO
Db file parallel write
TRUE
ASYNCH
Io_submit/io_getevents
YES
Db file parallel write
TRUE
NONE
Pwrite64
NO
Db file async I/O submit
In addition, if disk_asynch_io = false, you can set the dbwr_io_slaves parameter to a value greater than 0 to simulate asynchronous io.
View the asynchronous io of files in the database:
SQL> select file_no, filetype_name
Oracle 11g ASM: how to create an Oracle ACFS file system experiment environment in ASMCMD command line tool: Oracle 11g R2 RAC (11.2.0.3.5) oracle Enterprise Linux 5.6x86 1. Create an A
Oracle 11g, oracle11g
General requirements for software environments
RHEL 5. x System and RHEL 6. x System
Graphical desktop environment + development tools + Chinese Java support
-- When installing in RHEL 6. x, ksh needs to use the 5. x software package instead.
Preparations:
Yum install yum *
Yum groupinstall "X Window System" "desktop platform" "Chinese supp
Prospect:1. Install the x86_64 version of the CentOS 7 system (or the corresponding version of Red Hat, etc.) to the GNOME Desktop edition.2. Download and install and activate Xmanager Enterprise 5 for connection access to Linux systems, data transfer, etc.3. Download the unpacked Oracle
is set as: Oracle_owner= Oracle Oracle_home=/u01/app/oracle/product/11.2.0/db_1 Enter the full pathname of the local bin directory: [/usr/local/bin]: Copying dbhome To/usr/local/bin ... Copying oraenv To/usr/local/bin ... Copying coraenv To/usr/local/bin ... Creating/etc/oratab file ... Entries'll be added to The/etc/oratab file as needed by Database Configuration Assistant When a database is created Finis
1, the establishment of Oracle installation directory, generally/opt/oracle;2, put the installation package instantclient-basic-linux.x64-11.2.0.3.0.zip into the directory, and extract: Unzip XXX, generate directory:/opt/oracle/instantclient_11 _2;;3. Create a new Tnsnames.ora file in the/opt/oracle/instantclient_11_2
/112010/win32_11gR2_client.zip
No grid
Oracle Database 11g Release 2 (11.2.0.1.0) for Linux x86
Http://download.oracle.com/otn/linux/oracle11g/R2/linux_11gR2_database_1of2.zip
Http://download.oracle.com/otn/linux/oracle11g/R2/linux_11gR2_database_2of2.zip
Http://do
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.