User Tools

Site Tools


wiki:install_oracle_10g_on_the_headless_ubuntu

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Last revisionBoth sides next revision
wiki:install_oracle_10g_on_the_headless_ubuntu [2008/04/01 01:23] mirnshiwiki: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 > /etc/init.d/oracle << OEF+   sudo cat > /etc/init.d/oracle << EOF
    # startup of oracle 10.2.0    # startup of oracle 10.2.0
    ORA_OWNR=oracle    ORA_OWNR=oracle
Line 81: Line 81:
  # Oracle listener and instance startup  # Oracle listener and instance startup
  echo -n "Starting Oracle: "  echo -n "Starting Oracle: "
- su $ORA_OWNR -c "$ORACLE_HOME/bin/lsnrctl start" + su $ORA_OWNR -c "$ORACLE_HOME/bin/lsnrctl start" 
- su $ORA_OWNR -c $ORACLE_HOME/bin/dbstart+ su $ORA_OWNR -c $ORACLE_HOME/bin/dbstart
  ;;  ;;
       stop)       stop)
  # Oracle listener and instance shutdown  # Oracle listener and instance shutdown
  echo -n "Shutdown Oracle: "  echo -n "Shutdown Oracle: "
- su $ORA_OWNR -c "$ORACLE_HOME/bin/lsnrctl stop" + su $ORA_OWNR -c "$ORACLE_HOME/bin/lsnrctl stop" 
- su $ORA_OWNR -c $ORACLE_HOME/bin/dbshut+ su $ORA_OWNR -c $ORACLE_HOME/bin/dbshut
  ;;  ;;
       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 tablespace temp;+    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