ubuntu安装oracleXEubuntu不支持oracle,网上教程太复杂,总是出错.后来找到个能装XE的就装了.Oracle Databa
ubuntu安装oracleXE
ubuntu不支持oracle,网上教程太复杂,总是出错.后来找到个能装XE的就装了.
Oracle Database 10g Express Edition requires 1006 MB of swap space
echo "deb http://oss.oracle.com/debian/ unstable main non-free" >> /etc/apt/sources.listapt-get updateapt-get install oracle-xe-client apt-get install oracle-xesh /etc/init.d/oracle-sh configurevim /etc/default/oracle-xe
You can always disable Oracle XE startup in boot time with (no update-rc.d method here ;-) ):
chmod -x /etc/init.d/oracle-xe
The alernative way to the same is to edit /etc/default/oracle-xe and change:
#ORACLE_DBENABLED=trueORACLE_DBENABLED=false
Web console management
- If you have installed OracleXE database on remote *nix server, you can easily setup a ssh tunnel in order to gain access to a web administration console (since web console is bound to loopback device and therefore unavailable outside to the network):
$ ssh oracle-xe-server -L 8081:localhost:8080
While keeping this proces running (or keep it on background via `screen` or `nohup`), you may now login to Oracle XE web administrations console on your local computer: http://localhost:8081/apex/. Please notice that your ssh daemon on your local computer should allow TCP forwarding: AllowTcpForwarding yes in your sshd configuration file.
SQL Remote connection management
- By default OracleXe installation does not allow sql network connections to your XE database. To enable it, logon to web management console and enable "Remote connections": "Administration->enable "Available from local server and remote clients"-> press "Apply Changes". The same procedure can also be done from the commandline:
$ sqlplus -S system/password@//localhost/XE <<!
EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);
EXIT;
/
!
If your SQL client uses a Oracle Instant client installation, the SQL connection can be obtained by entering:
[atrakic@adm2-43 ~]$ sqlplus username/password@//oraclexe.hostname.or.ip//XE
If somewhat connection is refused (due to firewall restrictions) you can use same ssh trick as done previously:
$ ssh oracle-xe-server -L 1512:localhost:1512
where your sql connection should be like this:
[atrakic@adm2-43 ~]$ sqlplus username/password@//localhost//XE
User management
Add user
- In order to add single sql user with non-dba privilages to OracleXE execute following commands:
---- Contents of: this_script.sql--CREATE USER myuser IDENTIFIED BY the_password DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp QUOTA UNLIMITED ON users;CREATE ROLE myconnection;GRANT CREATE session, CREATE table, CREATE view, CREATE procedure, CREATE synonym TO myconnection;GRANT myconnection TO myuser;/
You can run this SQL script with:
# su - oracle oracle@server:~$ sqlplus / as sysSQL> @this_script.sqlSQL> exit;
Alternatively use web managment console to add new Oracle XE users accordingly.
Delete user
- For deleting a sql users from OracleXE use web management console or execute following commands from the commandline:
# su - oracle oracle@server:~$ sqlplus / as sysSQL> drop user myuser cascade;SQL>exit;
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/
可在命令行创建表空间
