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 revisionLast revisionBoth sides next revision | ||
wiki:install_oracle_10g_on_the_headless_ubuntu [2008/04/01 01:23] – mirnshi | wiki:install_oracle_10g_on_the_headless_ubuntu [2008/04/01 02:36] – mirnshi | ||
---|---|---|---|
Line 73: | Line 73: | ||
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 81: | ||
# 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 179: | ||
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