Using Database oracle10g
The name of the database I am going to build is called db231 (three digits after the db+ number)
oracle_sid=db231
Oracle_base=f:\oracle\
Oracle_home=f:\oracle\product\10.2.0\db_1\
First, do not choose to install the
Download the software package to the official website, first register an account number, download is a compressed package, extract the oracle-xe-11.2.0-1.0.x86_64.rpm. There are only 64-bit versions under Linux.
1, install the dependent package
oracle| Data | database
Tenth Oracle database Startup and shutdown
First, start data$sqlplus "Sys/pass as SYSDBA"Sql>startup
Second, start the listenerAfter the database is started, if the listener process is not started, the client cannot connect
1. Log in to PL/SQL DeveloperThis omits the installation steps for the Oracle database and PL/SQL Developer, and note that when you install the PL/SQL Developer software, do not install it under the program Files (x86) directory or you cannot start
Linux configuration Oracle with system boot and shutdown1. Modify the/etc/oratab fileModify the database you want to start with the OS from N to yLis:/u01/app/oracle/product/11.2.0/db_1:nModified to:Lis:/u01/app/oracle/product/11.2.0/db_1:y 2, edit
Available with three Oracle clients: SQL Developer, pl Developer, Navicat PremiumI. SQL Developer (Oracle's Own)Download and install SQL Developer, the connection is simply not said.:
1 Right-click on "Computer"--services and services and applications--Stop all Oracle-related services (Oracle-like ORACLEDBCONSOLEORCL).2 Start-All Programs-->oracle-->oracle Install the product-->universal Installer, "Welcome" after you start,
Application: Connect Oracle, normally install Oracle client on native, but Oracle software is too big and bloated, so the lite version of Instantclient is born.1,: http://www.oracle.com/technetwork/topics/winsoft-085727.html2: Decompression,
(previously because I did not know the computer is because of the installation of Oracle, the result of up to two weeks of boot speed of 10 minutes, before only a minute!) You can imagine Oracle's service startup powerful, knowing that I immediately
Oracle11 Full Unload methodFirst, uninstall Oracle before oracle11g there is a situation where uninstalling is not clean, causing the installation to fail again, running services.msc to open the service, stop all services of Oracle.Second, oracle11g
Get ready:
PL/SQL Developer: I'm using plsqldev1005 (32-bit)
Win32_11gr2_client: Remember that it must be 32-bit, because PL/SQL developer only recognize 32-bit
After the installation is successful, you need to configure the
DirectoryFirst, hardware requirementsSecond, the softwareThird, System installation noteIv. System Readiness prior to Oracle installationV. Install Oracle and set up the settingsSix, upgrade Oracle to Patchset 10.2.0.4Vii. using Rlwrap to invoke the
Oracle Data Access Component (ODAC) Full name: Oracle Database Access ComponentsPros: Because Microsoft will deprecated System.Data.OracleClient.dll in. NET Framework4, and in terms of access efficiency and speed, System.Data.OracleClient.dll
Prerequisite: The Oracle database has been successfully installed.Installation environment: Win7 64-bitOracle installation version 11g 64-bitQuestion 1) Oracle comes with SqldeveloperLet me enter the full path of the Java.exe and then report a
Some people may re-install the system for a variety of reasons, but there are always some more important software in the system can not be used after reloading. such as Oracle database, it is well known that the database if through the DMP import
The installation of ODI is very simple, all the way next. However, the JDK must be installed before installation, and JDK 8 is used here. Download the following jar files from the Oracle official website as shown in:Install using the following
I. Oracle database installation PROCEDURE reference: https://jingyan.baidu.com/article/363872eccfb9266e4aa16f5d.htmlIi. Oracle Client Installation: https://www.jb51.net/article/101306.htmThird, plsql install or use the free installation version.Iv.
Win32 does not install Oracle clients using PLSQL1. Ready to work 1.1 download Plsqldev hack version softwareI use the plsqldev715 version here1.2 Download instantclient-basic-win32-11.2.0.1.0 Oracle official website Download 2. Plsqldev Installing 2
A. Open Net Manager, configure service naming650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/53/FE/wKioL1R1i7PQrUxVAAINdLa6fIA338.jpg "style=" float: none; "title=" 1 "alt=" wkiol1r1i7pqruxvaaindla6fia338.jpg "/>The service name fills in
1. Log in to PL/SQL DeveloperThis omits the installation steps for the Oracle database and PL/SQL Developer, and note that when you install the PL/SQL Developer software, do not install it under the program Files (x86) directory or you cannot start
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.