wiki:install_oracle_10g_on_the_headless_ubuntu
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
wiki:install_oracle_10g_on_the_headless_ubuntu [2008/03/31 23:49] – mirnshi | wiki:install_oracle_10g_on_the_headless_ubuntu [2008/11/17 16:05] (current) – mirnshi | ||
---|---|---|---|
Line 19: | Line 19: | ||
sudo apt-get install xauth libxp6 libxt6 libxtst6 | sudo apt-get install xauth libxp6 libxt6 libxtst6 | ||
sudo apt-get install libaio1 | sudo apt-get install libaio1 | ||
+ | |||
+ | sudo apt-get install libstdc++5 | ||
The whole x-windows is not necessary, some articles said that we should install the x-windows and WM, it's probably not a good idea to install these software only for installing another software. | The whole x-windows is not necessary, some articles said that we should install the x-windows and WM, it's probably not a good idea to install these software only for installing another software. | ||
- | Note: xauth makes x11-forward work, libaio1 makes sqlplus work. | + | Note: xauth makes x11-forward work, libaio1 makes sqlplus work, libstdc++5 makes liborasdkbase.so.10.2 work(ubuntu 8.04.1). |
3. add user oracle and group dba | 3. add user oracle and group dba | ||
Line 66: | Line 68: | ||
choice custom install, not create DB. | choice custom install, not create DB. | ||
Maybe there' | Maybe there' | ||
- | | + | |
| | ||
sudo ln -s / | sudo ln -s / | ||
Line 73: | Line 75: | ||
9. create the startup file of oracle | 9. create the startup file of oracle | ||
- | sudo cat > / | + | sudo cat > / |
# startup of oracle 10.2.0 | # startup of oracle 10.2.0 | ||
| | ||
Line 81: | Line 83: | ||
# Oracle listener and instance startup | # Oracle listener and instance startup | ||
echo -n " | echo -n " | ||
- | su $ORA_OWNR -c " | + | su - $ORA_OWNR -c " |
- | su $ORA_OWNR -c $ORACLE_HOME/ | + | su - $ORA_OWNR -c $ORACLE_HOME/ |
;; | ;; | ||
stop) | stop) | ||
# Oracle listener and instance shutdown | # Oracle listener and instance shutdown | ||
echo -n " | echo -n " | ||
- | su $ORA_OWNR -c " | + | su - $ORA_OWNR -c " |
- | su $ORA_OWNR -c $ORACLE_HOME/ | + | su - $ORA_OWNR -c $ORACLE_HOME/ |
;; | ;; | ||
reload|restart) | reload|restart) | ||
Line 179: | Line 181: | ||
5. create a test user | 5. create a test user | ||
connect SYS/admin as SYSDBA | connect SYS/admin as SYSDBA | ||
- | CREATE USER ora IDENTIFIED BY pwd DEFAULT TABLESPACE users TEMPORARY TABLESPACE | + | CREATE USER ora IDENTIFIED BY pwd DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp; |
GRANT CONNECT, RESOURCE TO ora; | GRANT CONNECT, RESOURCE TO ora; | ||
CONNECT ora/pwd | CONNECT ora/pwd |
wiki/install_oracle_10g_on_the_headless_ubuntu.txt · Last modified: 2008/11/17 16:05 by mirnshi