Who Is Wiki

User Tools

Site Tools

Trace:
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
wiki:install_oracle_10g_on_the_headless_ubuntu [2008/03/24 23:08] – mirnshiwiki: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 29: Line 31:
    su - oracle    su - oracle
    cat > .bash_profile << EOF    cat > .bash_profile << EOF
-   export $ORACLE_HOME=/home/oracle/product/10.2.0 +   export ORACLE_HOME=/home/oracle/product/10.2.0 
-   export $ORACLE_SID=orcl +   export ORACLE_SID=orcl 
-   export $PATH=$PATH:$ORACLE_HOME/bin+   export PATH=$PATH:$ORACLE_HOME/bin
    EOF    EOF
    exit    exit
Line 66: Line 68:
 choice custom install, not create DB. choice custom install, not create DB.
 Maybe there's an error: libagtsh.so: undefined reference to 'nnfyboot', run the next commands: Maybe there's an error: libagtsh.so: undefined reference to 'nnfyboot', run the next commands:
-   export $ORACLE_HOME=/home/oracle/product+   export ORACLE_HOME=/home/oracle/product
    export LD_LIBRARY_PATH=$ORACLE_HOME/lib    export LD_LIBRARY_PATH=$ORACLE_HOME/lib
    sudo ln -s /usr/bin/basename /bin/basename    sudo ln -s /usr/bin/basename /bin/basename
Line 73: Line 75:
  
 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 83:
  # 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 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 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.1206400094.txt.gz · Last modified: 2008/03/24 23:08 by mirnshi