Oracale 10g R2 (x32) Installation Guide

User Manual:

Open the PDF directly: View PDF PDF.
Page Count: 25

1
Vistasoft IT Bangladesh Ltd. House # 20 (4th floor), Road # 02, Block # A, Section # 02 (Rainkhola),
Mirpur, Dhaka – 1216, Phone: 01552-344574, 01711-172053,
Email: vistasoftit@gmail.com, info.vistasoft@yahoo.com, info@vistasoftit.org, Web: www.vistasoftit.org
Vistasoft IT Bangladesh Limited,
H# 20 (4th floor), Rd# 02, Block # A, Section# 02 (Rainkhola),
Mirpur, Dhaka-1216.
Last updated at:
21 July, 2018.
software Installation guide
2
Vistasoft IT Bangladesh Ltd. House # 20 (4th floor), Road # 02, Block # A, Section # 02 (Rainkhola),
Mirpur, Dhaka – 1216, Phone: 01552-344574, 01711-172053,
Email: vistasoftit@gmail.com, info.vistasoft@yahoo.com, info@vistasoftit.org, Web: www.vistasoftit.org
Oracle 10g Installation এর নিয়ম:
Oracle Install    
       
•  Computer  Windows Setup  
• Computer  Name  Work Group    
•  Driver Setup  
• Driver Setup     VGA, LAN Install  
•   Computer  IP  , IP    Internet connection  

•   WinRAR/Adobe reader/MS Office/ Mozilla Firefox Software install   
• Firewall off 
• User Account Control setting – Never Notify 
• D Drive     Drive    VSI Software Backup,VSI PAYROLL &
Database BackupVSISoftware User Guide  Copy  
     Oracle Install      
 Oracle install       
1st Step:
•   Step Oracle 10g R2/ Oracle Developer 6i/ Oracle Patch 18 Install
       Oracle 10g R2x32b install 
•   Oracle 10g R2 32b CD         
    Auto run File  Install    Setup File  
   Window   Install/Deinstall product Administrative Run
click  
3
Vistasoft IT Bangladesh Ltd. House # 20 (4th floor), Road # 02, Block # A, Section # 02 (Rainkhola),
Mirpur, Dhaka – 1216, Phone: 01552-344574, 01711-172053,
Email: vistasoftit@gmail.com, info.vistasoft@yahoo.com, info@vistasoftit.org, Web: www.vistasoftit.org
    Window   
 
 Window       Window   
 
4
Vistasoft IT Bangladesh Ltd. House # 20 (4th floor), Road # 02, Block # A, Section # 02 (Rainkhola),
Mirpur, Dhaka – 1216, Phone: 01552-344574, 01711-172053,
Email: vistasoftit@gmail.com, info.vistasoft@yahoo.com, info@vistasoftit.org, Web: www.vistasoftit.org
 Window  Oracle Home Location  Drive location   D Drive  
    D Drive Installation     Installation Type
  , Global Database Name   PAYROLL    Database
Password   Admin007  Password   
  
       Window   Next  click
 ,    Window   Window    Install   
5
Vistasoft IT Bangladesh Ltd. House # 20 (4th floor), Road # 02, Block # A, Section # 02 (Rainkhola),
Mirpur, Dhaka – 1216, Phone: 01552-344574, 01711-172053,
Email: vistasoftit@gmail.com, info.vistasoft@yahoo.com, info@vistasoftit.org, Web: www.vistasoftit.org
 Window  %    Window     
 %    Window    Window   
6
Vistasoft IT Bangladesh Ltd. House # 20 (4th floor), Road # 02, Block # A, Section # 02 (Rainkhola),
Mirpur, Dhaka – 1216, Phone: 01552-344574, 01711-172053,
Email: vistasoftit@gmail.com, info.vistasoft@yahoo.com, info@vistasoftit.org, Web: www.vistasoftit.org
 Ok Click       Window   
 Window    Oracle   Install    Exit Option Click
   Oracle 10g Install   connection Check 
connection test    Run option        sqlplus
/nolog    
7
Vistasoft IT Bangladesh Ltd. House # 20 (4th floor), Road # 02, Block # A, Section # 02 (Rainkhola),
Mirpur, Dhaka – 1216, Phone: 01552-344574, 01711-172053,
Email: vistasoftit@gmail.com, info.vistasoft@yahoo.com, info@vistasoftit.org, Web: www.vistasoftit.org
Restart 
   
    Oracle Install   
   
       Oracle Install  
    Window   Allow access    ,   Cancel  Exit
 
8
Vistasoft IT Bangladesh Ltd. House # 20 (4th floor), Road # 02, Block # A, Section # 02 (Rainkhola),
Mirpur, Dhaka – 1216, Phone: 01552-344574, 01711-172053,
Email: vistasoftit@gmail.com, info.vistasoft@yahoo.com, info@vistasoftit.org, Web: www.vistasoftit.org
2nd Step: Oracle forms Developer
   Oracle Developer 6i forms Developer  Install  
     Oracle Developer 6i     software     
 copy     Data Missing  
   D Drive Dev_6i   Folder      
Install    setup File Administrative Run Click   Window  
 Window   
  
 Company Name VSI   Name Dev_Home   Location D:\Dev_6i
 Language     
    ok  Click   
   Window   
9
Vistasoft IT Bangladesh Ltd. House # 20 (4th floor), Road # 02, Block # A, Section # 02 (Rainkhola),
Mirpur, Dhaka – 1216, Phone: 01552-344574, 01711-172053,
Email: vistasoftit@gmail.com, info.vistasoft@yahoo.com, info@vistasoftit.org, Web: www.vistasoftit.org
 Oracle Forms Developer Select  ok  
    Window 
no ok 
System Support Files window 
 Ok     Installation       Window   

Installation   
10
Vistasoft IT Bangladesh Ltd. House # 20 (4th floor), Road # 02, Block # A, Section # 02 (Rainkhola),
Mirpur, Dhaka – 1216, Phone: 01552-344574, 01711-172053,
Email: vistasoftit@gmail.com, info.vistasoft@yahoo.com, info@vistasoftit.org, Web: www.vistasoftit.org
Installation      Window     
 ok Click 
     Installation     Installation successful massage 
    Installation 
3rd Step: Oracle Reports Developer:
Oracle Forms Developer setup     Oracle Reports Developer setup 
 Oracle Forms Developer     Installation      
  Oracle Reports Developer,  Window  
11
Vistasoft IT Bangladesh Ltd. House # 20 (4th floor), Road # 02, Block # A, Section # 02 (Rainkhola),
Mirpur, Dhaka – 1216, Phone: 01552-344574, 01711-172053,
Email: vistasoftit@gmail.com, info.vistasoft@yahoo.com, info@vistasoftit.org, Web: www.vistasoftit.org
  Oracle Forms Developer setup    Installation   OK   

# D   Oracle>Network>Admin> tnsnames      
    # D   Dev_6i>NET80>ADMIN>TNSNAMES    
    
12
Vistasoft IT Bangladesh Ltd. House # 20 (4th floor), Road # 02, Block # A, Section # 02 (Rainkhola),
Mirpur, Dhaka – 1216, Phone: 01552-344574, 01711-172053,
Email: vistasoftit@gmail.com, info.vistasoft@yahoo.com, info@vistasoftit.org, Web: www.vistasoftit.org
  connection check …
connection test    cmd mood        sqlplus
/nolog    
13
Vistasoft IT Bangladesh Ltd. House # 20 (4th floor), Road # 02, Block # A, Section # 02 (Rainkhola),
Mirpur, Dhaka – 1216, Phone: 01552-344574, 01711-172053,
Email: vistasoftit@gmail.com, info.vistasoft@yahoo.com, info@vistasoftit.org, Web: www.vistasoftit.org
        Window     conn
system/Admin007@PAYROLL   Enter    connected    
  Install 
4th Step: Oracle Patch 18:
Oracle Patch 18 OracleStop 
Control panel>Administrative tools >service OracleStop   
   
 OracleDBConsolePAYROLL
 OracleOraDb10g_home1iSQL*Plus
 OracleOraDb10g_home1TNSListener
। OracleServicePAYROLL
14
Vistasoft IT Bangladesh Ltd. House # 20 (4th floor), Road # 02, Block # A, Section # 02 (Rainkhola),
Mirpur, Dhaka – 1216, Phone: 01552-344574, 01711-172053,
Email: vistasoftit@gmail.com, info.vistasoft@yahoo.com, info@vistasoftit.org, Web: www.vistasoftit.org
  Service  Started Click 
ServiceStop   Service Stop          Oracle Patch 18

  Oracle Patch 18 Install    Oracle Patch 18  Setup File 
      File Missing   Zip File  Unzip
 c:\temp\oracle_forms\
15
Vistasoft IT Bangladesh Ltd. House # 20 (4th floor), Road # 02, Block # A, Section # 02 (Rainkhola),
Mirpur, Dhaka – 1216, Phone: 01552-344574, 01711-172053,
Email: vistasoftit@gmail.com, info.vistasoft@yahoo.com, info@vistasoftit.org, Web: www.vistasoftit.org
Unzip   C Drive   Unzip      Administrative
Run click 
Setup File Administrative Run click InstallInstallok 
Oracle Patch 18InstallInstallrestart 
connection check 

Register Edit 

16
Vistasoft IT Bangladesh Ltd. House # 20 (4th floor), Road # 02, Block # A, Section # 02 (Rainkhola),
Mirpur, Dhaka – 1216, Phone: 01552-344574, 01711-172053,
Email: vistasoftit@gmail.com, info.vistasoft@yahoo.com, info@vistasoftit.org, Web: www.vistasoftit.org
Start> regedit  Enter  WindowEdit>Find NLS_LANG
Find Next Modify Click 
AMERICAN_AMERICA.UTF8
• Modify  
• Client    Modify  
5th Step: TOAD Version 8.5:
   TOAD Version 8.5 Install     , TOAD Version 8.5  
      TOAD Version 8.5  Setup File     
                 
  
17
Vistasoft IT Bangladesh Ltd. House # 20 (4th floor), Road # 02, Block # A, Section # 02 (Rainkhola),
Mirpur, Dhaka – 1216, Phone: 01552-344574, 01711-172053,
Email: vistasoftit@gmail.com, info.vistasoft@yahoo.com, info@vistasoftit.org, Web: www.vistasoftit.org
 Setup File   Administrative Run Click     Window 
 Next    Window 
 Window  Installation Type     Local Toad Install (FULL)   Next
 
18
Vistasoft IT Bangladesh Ltd. House # 20 (4th floor), Road # 02, Block # A, Section # 02 (Rainkhola),
Mirpur, Dhaka – 1216, Phone: 01552-344574, 01711-172053,
Email: vistasoftit@gmail.com, info.vistasoft@yahoo.com, info@vistasoftit.org, Web: www.vistasoftit.org
  Window   Backup Replaced Files        
  NO   Next      Window   
        Next   ,   Window    
 Next  Install      Window     Window 
 Yes  Continue with install Click      Window    
19
Vistasoft IT Bangladesh Ltd. House # 20 (4th floor), Road # 02, Block # A, Section # 02 (Rainkhola),
Mirpur, Dhaka – 1216, Phone: 01552-344574, 01711-172053,
Email: vistasoftit@gmail.com, info.vistasoft@yahoo.com, info@vistasoftit.org, Web: www.vistasoftit.org
 Yes  Continue with install  
Installation of Xpert Option 
  Window   Yes  Next       Window
  Cancel  
20
Vistasoft IT Bangladesh Ltd. House # 20 (4th floor), Road # 02, Block # A, Section # 02 (Rainkhola),
Mirpur, Dhaka – 1216, Phone: 01552-344574, 01711-172053,
Email: vistasoftit@gmail.com, info.vistasoft@yahoo.com, info@vistasoftit.org, Web: www.vistasoftit.org
Cancel   Installation complete window   Start Toad for oracle Select 
    Window  
  System Restart ,   Restart         
Restart     Window   product key and massage  
     Window         
21
Vistasoft IT Bangladesh Ltd. House # 20 (4th floor), Road # 02, Block # A, Section # 02 (Rainkhola),
Mirpur, Dhaka – 1216, Phone: 01552-344574, 01711-172053,
Email: vistasoftit@gmail.com, info.vistasoft@yahoo.com, info@vistasoftit.org, Web: www.vistasoftit.org
   Window    Window      NEXT  
 Window    Window    Finish  
Finish    TOAD Database Login window   Database, User, Password
 Login     Window  
22
Vistasoft IT Bangladesh Ltd. House # 20 (4th floor), Road # 02, Block # A, Section # 02 (Rainkhola),
Mirpur, Dhaka – 1216, Phone: 01552-344574, 01711-172053,
Email: vistasoftit@gmail.com, info.vistasoft@yahoo.com, info@vistasoftit.org, Web: www.vistasoftit.org
  Database= PAYROLL, User=system, Password=Admin007  
Database= PAYROLL, User=system, Password=Admin007    window  
  
23
Vistasoft IT Bangladesh Ltd. House # 20 (4th floor), Road # 02, Block # A, Section # 02 (Rainkhola),
Mirpur, Dhaka – 1216, Phone: 01552-344574, 01711-172053,
Email: vistasoftit@gmail.com, info.vistasoft@yahoo.com, info@vistasoftit.org, Web: www.vistasoftit.org
 Table create, Data space resize   Database   size   
payroll   user     
       
alter database datafile 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\PAYROLL\SYSTEM01.DBF' resize 600M
alter tablespace SYSTEM add datafile 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\PAYROLL\SYSTEM02.DBF' size 200M
alter database datafile 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\PAYROLL\USERS01.DBF' resize 200M
alter tablespace USERS add datafile 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\PAYROLL\USERS02.DBF' size 150M
alter database tempfile 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\PAYROLL\TEMP01.DBF' resize 950M
create tablespace INDX datafile 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\PAYROLL\INDX01.DBF' size 100M
create tablespace USRPICTURE datafile 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\PAYROLL\USRPICTURE01.DBF'
size 100M
create user payroll identified by payroll
grant dba to payroll
   Shift+F9 key  
 
Cmd     Database   
imp payroll/payroll@payroll file=D:\DataBackup\26022017092213.dmp full=y
6th Step: Fonts installation & “PAYROLL” Shortcut Key creation
PAYROLL Shortcut Key 

select  Font windows
Font Option install 
Desktop Right Click New >Shortcut then Browse
click D DrivePAYROLL>>Form>>WELCOME_SCREEN nextclick 
PAYROLL  Shortcut Key 
Start Menu Oracle Forms 6i RuntimeProperties  Target   
Copy , copy  Shortcut key 
Properties Target  Paste then PAYROLL/PAYROLL@PAYROLL
 Target Box Apply ok shortcut key  target path
  D:\Dev_6i\BIN\ifrun60.EXE D:\PAYROLL\FORM\WELCOME_SCREEN.fmx
PAYROLL/PAYROLL@PAYROLL
24
Vistasoft IT Bangladesh Ltd. House # 20 (4th floor), Road # 02, Block # A, Section # 02 (Rainkhola),
Mirpur, Dhaka – 1216, Phone: 01552-344574, 01711-172053,
Email: vistasoftit@gmail.com, info.vistasoft@yahoo.com, info@vistasoftit.org, Web: www.vistasoftit.org
Note: , Installation 64-bitOS Oracle Reporting  #Ddrive
>>Dev_6i>>BIN  NN60.DLL NNBDDL replace 
Folder Structure: Software installation   Server PC  folder structure  

Software installation   Client PC  folder structure   
Installation  Contact details for support  JPEG File  desktop   ।  D
drive PAYROLL Folder VSI Software User Guide   Copy   
25
Vistasoft IT Bangladesh Ltd. House # 20 (4th floor), Road # 02, Block # A, Section # 02 (Rainkhola),
Mirpur, Dhaka – 1216, Phone: 01552-344574, 01711-172053,
Email: vistasoftit@gmail.com, info.vistasoft@yahoo.com, info@vistasoftit.org, Web: www.vistasoftit.org
❖ Server and client Installation এর নিছ
ু নিয়ম
 Installation   Oracle 10g Database, Oracle forms Developer, Oracle
Reports Developer, Oracle Patch 18, TOAD Version 8.5   Install 

 Installation    Oracle forms Developer, Oracle Reports
Developer, Oracle Patch 18 Install  
 Oracle Patch 18 Install     stop    stop  
    Oracle Patch 18 Install    Install     
Restart  
  Restart    Register Edit    
 Installation   Oracle Patch 18 Install     stop  
Restart     Oracle Patch 18 Install   Register Edit   

    Installation      copy  Developer
paste  
Connection check   “error ora 12203 tns unable to connect to destination”
massage  Windows Firewall Off   
64-bitOS Oracle Reporting #Ddrive>>Dev_6i>>BIN 
NN60.DLL NNBDDL replace  

Navigation menu