- 浏览: 119454 次
- 性别:
- 来自: 西安
文章分类
最新评论
-
DearGrandpa:
sarrow 写道您好,我在使用msys-mingw的时候,遇 ...
Windows下的新玩具 MSYS -
zealotds:
你好!我没有用过msys-cn,但我刚刚看了一下它们的网站。它 ...
Windows下的新玩具 MSYS -
sarrow:
晕掉,缩进没了;重新贴一次。
---------------- ...
Windows下的新玩具 MSYS -
sarrow:
您好,我在使用msys-mingw的时候,遇到了一个疑问,麻烦 ...
Windows下的新玩具 MSYS -
chcan1:
,老师,能把后面几章 的感想和笔触写一下吗,
【Microsoft SQL Server 2008 技术内幕:T-SQL语言基础】五、透视和分组
XE is free to download and use for development. Currently, it only provides Linux64 version (x86_64) or Win32.
Firstly, you need a Oracle account to download the RPM package from Oracle official website, of course. In this tutorial, I have oracle-xe-11.2.0-1.0.x86_64.rpm downloaded. And I used RHEL 5.0, which is officially supported by this version of Oracle. Corresponding CentOS5 should work well too.
Another very important package is rlwrap-0.37-1.el5.i386.rpm, if you want to use SqlPlus in Linux shell, check "Try SqlPlus" section.
1. Installation: Official Doc
2. Configuration
3. Try SqlPlus
4. Deinstallatin & Diagnostic: Official Doc
Firstly, you need a Oracle account to download the RPM package from Oracle official website, of course. In this tutorial, I have oracle-xe-11.2.0-1.0.x86_64.rpm downloaded. And I used RHEL 5.0, which is officially supported by this version of Oracle. Corresponding CentOS5 should work well too.
Another very important package is rlwrap-0.37-1.el5.i386.rpm, if you want to use SqlPlus in Linux shell, check "Try SqlPlus" section.
1. Installation: Official Doc
# a. download # b. install sudo rpm -ivh downloads/oracle-xe-11.2.0-1.0.x86_64.rpm
2. Configuration
# add oracle variables to your personal profile (i.e. ~/.bashrc) export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
# a. start the configure process # for the last question "Whether you want the database to starts # automatically when the computer starts (next reboot)?" # please choose YES because this will create and configure the default # database instance for you automatically and you can disable db auto-start later # by sudo /etc/init.d/oracle-xe disable sudo /etc/init.d/oracle-xe configure # b. reboot (suggested) sudo reboot # c. check Oracle status, and it should print messages like: # # LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 19-MAR-2013 16:18:37 # # Copyright (c) 1991, 2011, Oracle. All rights reserved. # # Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE))) # STATUS of the LISTENER # ------------------------ # Alias LISTENER # Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production # Start Date 19-MAR-2013 15:54:18 # Uptime 0 days 0 hr. 24 min. 19 sec # Trace Level off # Security ON: Local OS Authentication # SNMP OFF # Default Service XE # Listener Parameter File /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora # Listener Log File /u01/app/oracle/product/11.2.0/xe/log/diag/tnslsnr/XIS3TM04/listener/alert/log.xml # Listening Endpoints Summary... # (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE))) # (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XIS3TM04.spss.com)(PORT=1521))) # (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XIS3TM04.spss.com)(PORT=8080))(Presentation=HTTP)(Session=RAW)) # Services Summary... # Service "PLSExtProc" has 1 instance(s). # Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... # Service "XE" has 1 instance(s). # Instance "XE", status READY, has 1 handler(s) for this service... # Service "XEXDB" has 1 instance(s). # Instance "XE", status READY, has 1 handler(s) for this service... # The command completed successfully # if not, check the deinstalltion section sudo /etc/init.d/orace-xe status # d. if not, try to restart the oracle by yourself sudo /etc/init.d/oracle-xe stop sudo /etc/init.d/oracle-xe start
3. Try SqlPlus
# to use command history feature in sqlplus, you need rlwrap: # http://stackoverflow.com/questions/3456024/sqlplus-history-under-linux sudo rpm -ivh rlwrap-0.37-1.el5.i386.rpm # add oracle executable to your personal profile (i.e. ~/.bashrc) export PATH=$ORACLE_HOME/bin:$PATH # add following lines to your .bashrc to ease the sqlplus login alias sqll="sqlplus SYSTEM/<pwd_provided_in_2.a> @XE" alias sqlwrap="rlwrap sqlplus SYSTEM/<pwd_provided_in_2.a>@XE" # or alias sqll="sqlplus SYS/<pwd_provided_in_2.a> @XE AS SYSDBA" alias sqlwrap="rlwrap sqlplus SYS/<pwd_provided_in_2.a> @XE AS SYSDBA" # create a login.sql in your working directory, this script will be # executed automatically when you start sqlplus # source your profile and simply type 'sqlwrap' in bash to login SqlPlus . .bashrc sqlwrap # to exectue sql script file without login echo exit | sqlplus user/pass@connect @scriptname
4. Deinstallatin & Diagnostic: Official Doc
# b. in addition of steps above, if you are re-installing # also clean the dir '/var/temp/.oracle' # c. check if user 'oracle' is functional # log in and check environment variable like above su - oracle
发表评论
-
The Linux Toolchain in My List
2013-03-20 16:54 0cat more tail awk sed join sort ... -
SSH Without Password For Windows Clients
2012-12-17 14:37 2295I guess a lot of folks like me ... -
Linux Shared Library (DLL) & -rpath,'$ORIGIN'
2012-10-11 18:38 3580The Argument -rpath,'$ORIGIN' ... -
Virtualbox Shared Folder In Linux
2012-09-21 22:59 1416This is for those who don't hav ... -
Installing DB2 Manually
2012-09-15 23:23 1079Summarized from DB2 9.7 Officia ... -
Installing Oracle XE 11g On Redhat Enterpise Linux
2012-06-19 16:10 14321. download rpm zip from Oracle ... -
Installing db2 express c in Ubuntu
2012-05-17 08:57 15590. update your apt database: su ... -
Windows下的新玩具 MSYS (2) - MinGW 开发环境
2011-08-03 14:05 0本着学习Unix环境(好吧,我在装*)的精神,这里介绍使用MS ... -
Windows下的新玩具 MSYS
2011-05-20 23:39 29572mingw msys 如果想要利用高效的UNIX环境又无法脱 ... -
Compile Vim In Ubuntu with multi-byte and xterm_clipboard Feature
2010-12-27 17:04 2204tag: vim ubuntu make multi-byte ... -
Fluxbox Screen Size In Virtualbox
2010-12-14 22:03 1262ubuntu linux fluxbox virtualbox ... -
SQL Server 2008 Information Schema Views
2010-04-29 12:04 1112tag: sql server 2008 metadata v ... -
【Microsoft SQL Server 2008 技术内幕:T-SQL语言基础】五、透视和分组
2010-04-01 10:05 2067sql2008 t-sql 基本概念 Pivoting(透 ... -
【Microsoft SQL Server 2008 技术内幕:T-SQL语言基础】四、集合运算
2010-03-19 15:46 2876sql2008 t-sql 集合运算 (Set Opera ... -
SQL Server 2008 Metadata Functions
2010-03-18 16:39 911tag: sql server 2008 functions ... -
【Microsoft SQL Server 2008 技术内幕:T-SQL语言基础】三、表表达式
2010-03-15 14:50 2628sql2008 t-sql Sql Server四 ... -
【Microsoft SQL Server 2008 技术内幕:T-SQL语言基础】二、查询篇
2010-03-11 16:04 2860sql2008 t-sql 单表查询 TO ... -
【Microsoft SQL Server 2008 技术内幕:T-SQL语言基础】一、基础篇
2010-03-10 17:51 1842sql2008 t-sql 写在前边 这 ... -
判断连接型临时表是否存在的问题
2009-10-26 13:58 8781.获取表的id object_id(N'dbname.dbo ... -
关于N' '
2009-10-26 13:46 813用于标注Unicode字串。 看到有人说是中文的SQL就不需 ...
相关推荐
Red Hat系列,CentOS系列,Ubuntu系列的Linux系统都可以安装该数据库。该数据库是从官网下载回来的,绝对可靠。
Linux oracle 11gR2安装数目及依赖包,分享给大家。Linux oracle 11gR2依赖包全套
Oracle11gR2 (p10404530_112030_Linux-x86-64_2of7.zip)文件分割成 2个压缩包: https://download.csdn.net/download/weixin_43800734/72501554 https://download.csdn.net/download/weixin_43800734/72510520 ...
oracle linux 6.4上安装部署 oracle RAC 11G R2,oracle linux上安装oracle是最简便的。
linux64_oracle11gR2_bbed工具需要的文件。
Oracle 11gR1 RAC On Linux Using NFS
oracle linux 11gR2 x86-64 instant client with sqplus sqlldr imp exp
Oracle11gR2 Linux版本linux_x86_64_oracle11.2.0.4 文件分割成7个压缩包,必须集齐7个文件后才能一起解压一起使用: p13390677_112040_Linux-x86-64_7of7.zip下载地址: ... p13390677_112040_Linux-x86-64_6of7.zip...
Oracle11gR2官网下载地址,Oracle11gR2
Linux环境部署Oracle 11gR2 RAC数据库
Oracle11gR2 Linux版本linux_x86_64_oracle11.2.0.4 文件分割成7个压缩包,必须集齐7个文件后才能一起解压一起使用: p13390677_112040_Linux-x86-64_7of7.zip下载地址: ... p13390677_112040_Linux-x86-64_6of7.zip...
Oracle11gR2 (p10404530_112030_Linux-x86-64_2of7.zip)文件分割成 2个压缩包: https://download.csdn.net/download/weixin_43800734/72501554 https://download.csdn.net/download/weixin_43800734/72510520 ...
enterprise linux Install Oracle11gR2.rar
oracle 11g R2软件: linux.x64_11gR2_client.zip、 ...linux.x64_11gR2_database_2of2.zip 适用于linux 64位系统,文件分割成 5个 压缩包,必须集齐5个 文件后才能一起解压一起使用: linux.x64_11gR2.part5.rar ...
Oracle11gR2 (p10404530_112030_Linux-x86-64_2of7.zip)文件分割成 2个压缩包: https://download.csdn.net/download/weixin_43800734/72501554 https://download.csdn.net/download/weixin_43800734/72510520 ...
Oracle11gR2 for Linux 静默安装;Oracle11gR2 for Linux 静默安装;Oracle11gR2 for Linux 静默安装;
Oracle11gR2 (p10404530_112030_Linux-x86-64_2of7.zip)文件分割成 2个压缩包: https://download.csdn.net/download/weixin_43800734/72501554 https://download.csdn.net/download/weixin_43800734/72510520 ...
Oracle11gR2 (p10404530_112030_Linux-x86-64_7of7.zip) Oracle11gR2 (p10404530_112030_Linux-x86-64_6of7.zip) Oracle11gR2 (p10404530_112030_Linux-x86-64_5of7.zip) Oracle11gR2 (p10404530_112030_Linux-...
oracle 11g R2软件: linux.x64_11gR2_client.zip、 ...linux.x64_11gR2_database_2of2.zip 适用于linux 64位系统,文件分割成 5个 压缩包,必须集齐5个 文件后才能一起解压一起使用: linux.x64_11gR2.part5.rar ...
Linux版本 Oracle11g数据库 64位 完整安装包