Installing Oracle 7.3.4 on Solaris 2.6.

• Preliminary info for our project
  
  
  1. Machine name is sqasun5.
     
     
  2. Mount point is /export/home/oracle.
     
     
• Login as root.
  
  
  1. Add following lines to /etc/system.
     
     set shmsys:shminfo_shmmax=8388608
     set shmsys:shminfo_shmmin=1
     set shmsys:shminfo_shmmni=100
     set shmsys:shminfo_shmseg=10
     set semsys:seminfo_semmns=200
     set semsys:seminfo_semmni=70
     
     
  2. Reboot the system.
     
     
  3. # groupadd -g 200 dba
     
     
  4. Add users oracle and root
     
     /etc/group
     
     ......
     dba::200:oracle,root
     ......
     
     
  5. Create following directories and
     # chown oracle:dba $directory
     
     
  6. # mkdir /opt/bin
     
     
  7. # mkdir /export/home/oracle
     
     
  8. # mkdir /export/home/oracle/oracle734
     
     
  9. # mkdir /export/home/oracle/u1
     
     
  10. # mkdir /usr/oracle
      
      
  11. # mkdir /usr/oracle/u2
      
      
  12. # mkdir /usr/oracle/u3
      
      
• Insert Oracle 7 CD into the drive.
  
  
• Login as oracle
  
  
  1. Create /export/home/oracle/.profile and add following lines:
     
     ORACLE_HOME=/export/home/oracle/oracle734
     export ORACLE_HOME
     ORACLE_SID=sqasun5
     export ORACLE_SID
     PATH=/usr/bin:$ORACLE_HOME/bin
     export PATH
     LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
     export LD_LIBRARY_PATH
     
     
  2. $ cd /cdrom/cdrom0/orainst
     
     
  3. $ ./orainst
     
     
  4. Installer Screen appears.
     
     
  5. Choose Custom Install. Select default in most cases except for the followings:
     
     
  6. Mount point is $ORACLE_BASE: /export/home/oracle
     
     
  7. $ORACLE_HOME is /export/home/oracle/oracle734
     
     
  8. Choose default for logs.
     
     
  9. $ORACLE_SID: sqasun5
     
     
  10. Select following to install:
      
      Oracle UNIX Installer
      Server Manager
      Oracle7 Server (RDBMS)
      TCP/IP
      Oracle7 Enterprise Backup
      Oracle7 JDBC
      PL/SQL
      SQL*NET (V2)
      SQL*Plus
      
      
  11. group: dba
      
      
  12. OSOPER: dba
      
      
  13. Filesystem_based Database: Yes
      
      
  14. As for 3 mounting points:
      
      /export/home/oracle/u1
      /usr/oracle/u2
      /usr/oracle/u3
      
      
  15. US7ASCII
      
      
  16. SYSTEM ORACLE password: manager
      
      
  17. 'SYS' ORACLE password: manager
      
      
  18. NO password for internal users - dba and operator.
      
      
  19. MTS and SQL*Net: NO
      
      
  20. Choose default in most selections.
      
      
  21. JDK 1.0 JDBC Thin Driver
      JDK 1.1 JDBC Thin Driver
      
      Check for your JDBC settings.
      
      
  22. Select more defaults.
      
      
  23. It should start installing packages and takes a while.
      
      
  24. After the installation is finished, it will take you back to the first Installer Screen. Check for the installed packages before exiting. You are set for the next step.
      
      
• Login as root.
  
  
  1. # cd /export/home/oracle/oracle734/orainst
     
     
  2. # ./root.sh
     
     
• Login as oracle.
  
  
  1. $ cd /export/home/oracle/oracle734/dbs
     
     
  2. Check initsqasun5.ora for:
     
     compatible = 7.3.4.0.1 #This should match the installed Oracle version.
     
     
  3. $ svrmgrl
     
     
     1. SVRMGRL> connect internal
        
        
     2. SVRMGRL> shutdown normal
        
        
     3. SVRMGRL> startup
        
        
     4. SVRMGRL> exit
        
        
  4. $ lsnrctl
     
     
     1. LSNRCTL> start
        
        
     2. LSNRCTL> exit
        
        
  5. $ sqlplus system/manager
     
     
     1. SQL> should appear on your screen, then you're all set.
        
        
     2. Create more users.
        
        
     3. SQL> create user daniel identified by daniel ;
        user created
        
        
     4. SQL> grant connect, resource, create view to daniel ;
        Grant successful
        
        
     5. SQL> quit
        (You're all set.)