- 浏览: 2114647 次
- 性别:
- 来自: 北京
文章分类
最新评论
-
sunzeshan:
找了很久,用了这个插件解决问题啦。谢谢
eclipse jetty debug source not found -
xiaosong0112:
您好,请问为什么要这样设置呢,原理是什么?在网上很多转帖都没有 ...
maven的jetty插件提示No Transaction manager found导致启动慢的解决方法 -
eimhee:
tjzx 写道畅搜谷歌:http://dian168.cc/打 ...
Google 镜像站搜集 -
tjzx:
畅搜谷歌:http://dian168.cc/打开的是“最火源 ...
Google 镜像站搜集 -
eimhee:
finallygo 写道你这属于"头痛医头脚痛医脚& ...
解决linux下too many file问题
在ubuntu server下安装Oracle XE
以前都是在开发环境中使用oracle的轻量级服务器oracle xe。是在windows环境下,见适合开发人员的Oracle10g环境。
在linux上安装oracle是一件痛苦的事情。因为需要为安装做很多准备工作。另外,就是oracle的安装都是基于redhat版本的。
ubuntu server是很好的linux服务器版本,但是得到的企业支持较少,比如oracle,比如其他软件提供商。
公司需要移植以前oracle数据库的东西出来。为了应急,在ubuntu server上安装一个express edition(XE)。这个版本在ubuntu上安装十分容易。
首先需要设置oracle xe版本的源:
sudo vim /etc/apt/sources.list
在该文件中增加:
deb http://oss.oracle.com/debian unstable main non-free
然后需要将该源服务器的公钥添加在本地 apt 系统的密钥库中:
wget http://oss.oracle.com/el4/RPM-GPG-KEY-oracle -O- | sudo apt-key add -
然后,更新apt库:
apt-get update
安装oracle xe服务器:
apt-get install oracle-xe
这样就安装好oracle服务器了。会有提示,启动前作配置。
sudo /etc/init.d/oracle-xe configure
比如配置web管理界面的端口号,oracle监听器的端口号,是否linux启动时启动和sys、system用户的密码等。
另外,需要设置环境变量:
sudo vim /etc/environment
增加:
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:${ORACLE_HOME}/bin
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
TNS_ADMIN=/usr/lib/oracle
然后,使之生效:
source /etc/environment
这样,就可以直接运行sqlplus了。
sqlplus system/password@XE
需要在sqlplus中修改oracle配置,让web访问管理界面可以通过远程访问。
EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE)
另外,需要创建tnsname配置文件:
sudo vim /usr/lib/oracle/tnsnames.ora
文件内容:
XE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = XE)
)
)
然后,需要重启oracle:
sudo /etc/init.d/oracle-xe restart
参考文档:
http://www.oracle.com/technology/tech/linux/install/xe-on-kubuntu.html
http://www.cognovis.de/developer/en/oracle-xe-installation
评论
I am using the Edgy Server, so I will show you how to set things up so that they work whether you have X-Windows installed or not. This has also been successfully tested on Hardy LTS.
[编辑]
Requirements
As usual, Oracle needs a lot of resources, with a minumum for the server of 512 MBytes of Ram and 1024 MBytes of Swap and 1.5 Gbytes of free disk space. This requirements are checked by the install package. As the amount of swap isn't the default value for a fresh install, be aware of that. A workaround for that is described in http://www.oracle.com/technology/tech/linux/install/xe-on-kubuntu.html Oracle10gDapper mentions a dependency on libaio1 and bc - but I don't recall it being a problem on my Edgy installation (the latest oracle-xe package lists them as dependencies inside the package and apt-get will install them for you should they not already be installed).
[编辑]
Requirements for NFS
If you are installing onto nfs (ie, if /usr/lib is on an nfs volume), oracle is very picky about the mount options you must use. You won't get any error message during the configure step - oracle just won't work. These mount options seem to make oracle happy:
rw,nfsvers=3,noatime,rsize=32768,wsize=32768,hard,intr,nolock,tcp,async,noac,suid
It's best to create a new oracle mountpoint (/usr/lib/oracle) and mount a separate nfs export to there (since you might not want all those options on the rest of your nfs mounted filesystem).
[编辑]
Fundamentals
Add this line to /etc/apt/sources.list file:
deb http://oss.oracle.com/debian unstable main non-free
Next, you will need to add the GPG key.
wget http://oss.oracle.com/el4/RPM-GPG-KEY-oracle -O- | sudo apt-key add -
As root, type:
apt-get update
apt-get install oracle-xe
/etc/init.d/oracle-xe configure
Edit your .bashrc file to include the lines:
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_HOME
export ORACLE_SID=XE
export PATH
Start a new bash shell for the changes to take effect. To log in as a database administrator:
sqlplus sys as sysdba
It will then be possible for you to create and unlock user accounts using Oracle SQL commands - they details of which are beyond the scope of this doc.
[编辑]
Testing the Oracle-supplied example database
Oracle have thoughtfully provided a dummy database for you to play with. There is a user called HR with some tables in them. It provides a good test to check that everything is up-and-running. Gain admin access using 'sqlplus sys as sydba' (shown above). Choose a password for user HR (which I will denote by $password) and then type
alter user HR account unlock ;
alter user HR identified by $password ;
exit
Now attempt to examine the database as user HR:
sqlplus HR/$password
SELECT table_name FROM user_tables;
SELECT * FROM regions ;
INSERT INTO REGIONS (REGION_ID, REGION_NAME) VALUES (666, 'Outer Mongolia') ;
COMMIT ;
The first SELECT statement should give you a list of user tables that you can play with (in this example, they are: REGIONS, LOCATIONS, DEPARTMENTS, JOBS, EMPLOYEES, JOB_HISTORY, COUNTRIES). The second SELECT statement shows a list of entries in the REGIONS table. Hopefully everything will show up fine. In the INSERT INTO line, I add a record to the database so that we can prove what database we are connected to. COMMIT just commits the new item.
[编辑]
Connecting via Windows
If the above works, we should be on the home straight. Let's try to connect to our Ubuntu box from Windows. I have assumed that you have set up Oracle on Windows. Edit the file TNSNAMES.ORA, which may typically be found in the directory C:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN and add the following lines:
$CONNID=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = $IP)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
where $CONNID is whatever connection ID you want to use. You could use a name like UBUNTU; but I prefer to give it the name of the server that is running Oracle. $IP is the IP address of your Ubuntu box, typically something like 192.168.30.123 - but you'll have to decide the actual address for yourself (hint: run ifconfig , look at eth0 section, inet addr address). Save and exit. Start a DOS shell, and enter the command:
sqlplus HR@$CONNID
where, of course, you'll have to enter whatever connection ID $CONNID is. You will also need to supply the password that you created for HR. Examine what's in the database. See the "Testing ..." section above to see what tables are available. If you performed the actions specified in that section, then, if you type
SELECT * FROM regions ;
you should see the 'Outer Mongolia' entry that you created. And that's about it! Everything should now be set up, ready for you to do proper adminning of the database in accordance with standard procedures.
[编辑]
Tips
Some random tips which mostly appeared in Oracle10gDapper.
[编辑]
HTTP Interface
Now for creating users / schema / ... you have a nice http interface to do it :
http://localhost:8080/apex/
No more need of java. If like me you install this Oracle database on a server without a graphic X server, you may need to use a SSH port forwarding
ssh -L 8080:localhost:8080 user@IP_of_your_server
Personally, I (MarkCarter2), use Edgy Server, and use putty from Windows to connect to my Ubuntu box. I then do "sqlplus sys as sydba" to administer accounts that way. For me, it's much less fiddle than either method mentioned above
[编辑]
Packages
Apparently, here are 3 packages to select from:
oracle-xe - Oracle Database 10g Express Western European Edition
oracle-xe-client - Oracle Client 10g Express Edition
oracle-xe-universal - Oracle Database 10g Express Universal Edition
I copied the above information from Oracle10gDapper, but I am not sure of the significance of these. You can probably ignore this, as the method I have outlined on this page seems to be adequate anyway.
[编辑]
Installation Troubleshooting
NFS: see Requirements for NFS, above. Others: the directory /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/log contains the logfiles of the sql scripts run to initially set up the database. If you are having problems with oracle not starting up, check these files. ORA-27101: shared memory realm does not exist If this Error appears while connecting, check the following thing: If the command "bc" is installed. if not type
sudo apt-get install bc
aptitude purge oracle-xe-universal
apt-get install oracle-xe
or (apt-get install oracle-xe-universal)
If you now get an error saying that your Swap space is to small please look at the Swap Documentation Entry.
[编辑]
See Also
Oracle How to Install on kubuntu : http://www.oracle.com/technology/tech/linux/install/xe-on-kubuntu.html Oracle10gDapper - Oracle Express Edition 10g R2 / on Ubuntu Dapper 6.06 LTS RevTech Zero's Database Blog - Oracle 10g R2 / Enterprise / Standard on Ubuntu Gutsy Gibbon 7.10 http://revtech0.webonsites.com/blog.html http://mapopa.blogspot.com/2006/03/installing-oracle-on-ubuntu-breezy.html Oracle FAQ, Forum, Wiki, etc. at http://www.orafaq.com/
I am using the Edgy Server, so I will show you how to set things up so that they work whether you have X-Windows installed or not. This has also been successfully tested on Hardy LTS.
[编辑]
Requirements
As usual, Oracle needs a lot of resources, with a minumum for the server of 512 MBytes of Ram and 1024 MBytes of Swap and 1.5 Gbytes of free disk space. This requirements are checked by the install package. As the amount of swap isn't the default value for a fresh install, be aware of that. A workaround for that is described in http://www.oracle.com/technology/tech/linux/install/xe-on-kubuntu.html Oracle10gDapper mentions a dependency on libaio1 and bc - but I don't recall it being a problem on my Edgy installation (the latest oracle-xe package lists them as dependencies inside the package and apt-get will install them for you should they not already be installed).
[编辑]
Requirements for NFS
If you are installing onto nfs (ie, if /usr/lib is on an nfs volume), oracle is very picky about the mount options you must use. You won't get any error message during the configure step - oracle just won't work. These mount options seem to make oracle happy:
rw,nfsvers=3,noatime,rsize=32768,wsize=32768,hard,intr,nolock,tcp,async,noac,suid
It's best to create a new oracle mountpoint (/usr/lib/oracle) and mount a separate nfs export to there (since you might not want all those options on the rest of your nfs mounted filesystem).
[编辑]
Fundamentals
Add this line to /etc/apt/sources.list file:
deb http://oss.oracle.com/debian unstable main non-free
Next, you will need to add the GPG key.
wget http://oss.oracle.com/el4/RPM-GPG-KEY-oracle -O- | sudo apt-key add -
As root, type:
apt-get update
apt-get install oracle-xe
/etc/init.d/oracle-xe configure
Edit your .bashrc file to include the lines:
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_HOME
export ORACLE_SID=XE
export PATH
Start a new bash shell for the changes to take effect. To log in as a database administrator:
sqlplus sys as sysdba
It will then be possible for you to create and unlock user accounts using Oracle SQL commands - they details of which are beyond the scope of this doc.
[编辑]
Testing the Oracle-supplied example database
Oracle have thoughtfully provided a dummy database for you to play with. There is a user called HR with some tables in them. It provides a good test to check that everything is up-and-running. Gain admin access using 'sqlplus sys as sydba' (shown above). Choose a password for user HR (which I will denote by $password) and then type
alter user HR account unlock ;
alter user HR identified by $password ;
exit
Now attempt to examine the database as user HR:
sqlplus HR/$password
SELECT table_name FROM user_tables;
SELECT * FROM regions ;
INSERT INTO REGIONS (REGION_ID, REGION_NAME) VALUES (666, 'Outer Mongolia') ;
COMMIT ;
The first SELECT statement should give you a list of user tables that you can play with (in this example, they are: REGIONS, LOCATIONS, DEPARTMENTS, JOBS, EMPLOYEES, JOB_HISTORY, COUNTRIES). The second SELECT statement shows a list of entries in the REGIONS table. Hopefully everything will show up fine. In the INSERT INTO line, I add a record to the database so that we can prove what database we are connected to. COMMIT just commits the new item.
[编辑]
Connecting via Windows
If the above works, we should be on the home straight. Let's try to connect to our Ubuntu box from Windows. I have assumed that you have set up Oracle on Windows. Edit the file TNSNAMES.ORA, which may typically be found in the directory C:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN and add the following lines:
$CONNID=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = $IP)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
where $CONNID is whatever connection ID you want to use. You could use a name like UBUNTU; but I prefer to give it the name of the server that is running Oracle. $IP is the IP address of your Ubuntu box, typically something like 192.168.30.123 - but you'll have to decide the actual address for yourself (hint: run ifconfig , look at eth0 section, inet addr address). Save and exit. Start a DOS shell, and enter the command:
sqlplus HR@$CONNID
where, of course, you'll have to enter whatever connection ID $CONNID is. You will also need to supply the password that you created for HR. Examine what's in the database. See the "Testing ..." section above to see what tables are available. If you performed the actions specified in that section, then, if you type
SELECT * FROM regions ;
you should see the 'Outer Mongolia' entry that you created. And that's about it! Everything should now be set up, ready for you to do proper adminning of the database in accordance with standard procedures.
[编辑]
Tips
Some random tips which mostly appeared in Oracle10gDapper.
[编辑]
HTTP Interface
Now for creating users / schema / ... you have a nice http interface to do it :
http://localhost:8080/apex/
No more need of java. If like me you install this Oracle database on a server without a graphic X server, you may need to use a SSH port forwarding
ssh -L 8080:localhost:8080 user@IP_of_your_server
Personally, I (MarkCarter2), use Edgy Server, and use putty from Windows to connect to my Ubuntu box. I then do "sqlplus sys as sydba" to administer accounts that way. For me, it's much less fiddle than either method mentioned above
[编辑]
Packages
Apparently, here are 3 packages to select from:
oracle-xe - Oracle Database 10g Express Western European Edition
oracle-xe-client - Oracle Client 10g Express Edition
oracle-xe-universal - Oracle Database 10g Express Universal Edition
I copied the above information from Oracle10gDapper, but I am not sure of the significance of these. You can probably ignore this, as the method I have outlined on this page seems to be adequate anyway.
[编辑]
Installation Troubleshooting
NFS: see Requirements for NFS, above. Others: the directory /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/log contains the logfiles of the sql scripts run to initially set up the database. If you are having problems with oracle not starting up, check these files. ORA-27101: shared memory realm does not exist If this Error appears while connecting, check the following thing: If the command "bc" is installed. if not type
sudo apt-get install bc
aptitude purge oracle-xe-universal
apt-get install oracle-xe
or (apt-get install oracle-xe-universal)
If you now get an error saying that your Swap space is to small please look at the Swap Documentation Entry.
[编辑]
See Also
Oracle How to Install on kubuntu : http://www.oracle.com/technology/tech/linux/install/xe-on-kubuntu.html Oracle10gDapper - Oracle Express Edition 10g R2 / on Ubuntu Dapper 6.06 LTS RevTech Zero's Database Blog - Oracle 10g R2 / Enterprise / Standard on Ubuntu Gutsy Gibbon 7.10 http://revtech0.webonsites.com/blog.html http://mapopa.blogspot.com/2006/03/installing-oracle-on-ubuntu-breezy.html Oracle FAQ, Forum, Wiki, etc. at http://www.orafaq.com/
相关推荐
ubuntu下安装oracle-xe,并建立数据库脚本,包括数据库的表空间脚本,创建用户脚本,建立表脚本等一些。
ubuntu16下安装oracle11g及配置环境,希望能帮助到学习oracle的相关同学,文档中若有不了解的地方可以恢复评论以及探讨,让我们一起进步
Ubuntu Server 12.04安装图解,附件中为安装过程中全部截图,可按照图中所选择部分安装
在ubuntu上安装oracle11g,其中有些小细节,不注意是会出问题的,当时我费了不少力的。
文档描述了如何将oracle安装到ubuntu上
介绍如何在ubuntu server上安装oracle10。在ubuntu server 上安装oracle 有两个原因:1 ubuntu server 发行版本仅一张光盘,而RHEL 要4 张光盘,比较起来安装时间成本会小很多。2 ubuntu server 不带图形界面占用...
ubuntu server 7.0.4 xming,Xmanage putty 1. Update ubuntu sudo apt-get update sudo apt-get upgrade 2. install the development environment and libraries sudo apt-get install build-essential ...
ubuntu8.04 下安装 oracle10g
Ubuntu_10安装Oracle_10g手记
如何在Ubuntu 12.04中安装Oracle Express 11g R2
在ubuntu上安装oracle解决方案
如何在ubuntu14.04中安装oracle11.rc,里面有详细的安装步骤,以及每个步骤的版本信息。
Ubuntu10 server 64位 下安装 oracle11g 希望对大家有所帮助
在Ubuntu上安装Oracle JDK
Ubuntu安装Oracle所需要的一些依赖包,以及卡在68%处解决报错问题需要的依赖包,该文件为有JDK版本。
oracle数据库在ubuntu下的安装,里面有详细的解析,应用终端安装oracle数据库的步骤。。
ubuntu上装oracle确实挺复杂的,因为oracle不支持嘛,折腾了几天,装上之后也很爽。
Ubuntu Server64位系统安装Odoo10
Ubuntu8.04_server安装oracle10g 完整详细的步骤,是公司非让我弄到傻子按着步骤都会做的地步,没办法,只能照做了。真的不错,有需要的赶紧吧。
ubuntu16.04安装oracle操作文档