Compiere Training

1
Compiere Training

• Oracle Installation

2
Agenda

• Oracle Installation
• Minimum Footprint
• Database (Instance) Creation
• Oracle Networking Diagnostics
• Windows/Linux specific issues
• Survival Tips
• Firewall issues

3
Server Installation

• Oracle Installation
• Cause of Frustration
• Complex Install
• Outlook -)
• Oracle 10g
• 1 CD
• 20 Parameters max
• Install in 20-30 min

4
Oracle 9i2

• Media
• From CD - Download
• Platform
• Proper Server
• W2000 Server Linux Solaris
• For Test
• Works also on W2000 XP Professional
• Disk space
• You should have 5 GB
• Memory
• You should have 512 MB (more is better -)

5
Oracle Install

• Installation Program
• Define Oracle Home
• Example OraHome92 C\oracle\ora92
• Database Creation do as separate step
• (Default) Listener Installation
• Agent Installation
• Allows remote Administration

6
Database Creation

• Manual dbca
• Start gt Programs gt Oracle OraHome92 gt
  Configuration and Migration Tools gt Database
  Configuration Assistant
• Database Naming
• Global Name (TNS Name)
• Example main.compiere.org
• SID
• Example main
• Remember Passwords of System and Sys

7
Oracle Networking
8
Oracle Networking

• Listener
• Accepts connections on port 1521 (default)
• Returns new (dedicated/shared) connection on
  another port
• Does not work with most firewalls
• Need to fix port or use Connection Manager
• Protocols
• Net8 (oci) Heavy e.g. Oracle Tools
• Thin (JDBC) Direct TCP/IP

9
Oracle Net Manager

• Manual netmgr
• Start gt Programs gt Oracle OraHome92 gt
  Configuration and Migration Tools gt Net Manager
• Allows you to change and test your Network
  connections
• Change test login from scott/tiger to system/pass

10
Oracle Networking

• Network tests
• tnsping main.compiere.org
• tnsping main
• sqlplus system/pass_at_main.compiere.org
• sqlplus system/pass_at_main
• Network files
• ORACLE_HOME/network/admin/tnsnames.ora
• ORACLE_HOME/network/admin/sqlnet.ora
• NAMES.DEFAULT_DOMAIN compiere.org
• SQLNET.AUTHENTICATION_SERVICES (none)

11
Oracle Windows Services

• Automatically created start/stop
• Listener
• Database
• Agent
• Services
• OracleOraHome92TNSListener
• OracleServiceMAIN

12
Linux/Unix Installation

• Follow the book (!)
• Before Install
• Create groups (oinstall, dba, oracle)
• Create user (oracle)
• Reconfigure Kernel
• Sufficient TEMP SWAP space

13
Linux/Unix Installation

• After Install
• Set Environment
• LD_LIBRARY_PATH PATH
• Create Script to start / stop
• Listener lsnrctl start
• Database
• sqlplus system/pass as sysdbaSQLgt startup
• Agent agentctl start

14
Survival Tips

• Linux Do the pre-install Tasks
• Two Steps
• Installation (of code)
• Creation of Database
• Check the Network files
• Test the connection
• Reboot Test the connection

15
If things failed badly Uninstall

• Run DB Configuration Assistant
• Delete Database Instance
• Run Oracle Installer
• Select Deinstall Products
• Stop/Kill Services
• Delete Oracle_Home

16
Oracle Uninstall (2)

• Linux/Unix
• Delete Inventory /var/oracle/
• Delete Startup /etc/oratab
• Windows Uninstall
• Delete C\Program Files\Oracle
• Start regedit and delete
• HKEY_LOCAL_MACHINE gt SOFTWARE gt Oracle
• the node with all sub nodes
• HKEY_LOCAL_MACHINE gt SYSTEM gt CurrentControlSet
  gt Services
• the orphaned Oracle services (optional)

17
Firewall Issues

• Standard Listener Port Switching
• Contact Listener on port 1521
• Returns a (dedicated) connection on another Port
• Options
• Windows
• USE_SHARED_SOCKET TRUE
• Net8 compliant firewall
• Connection Manager
• Port 1610

18
Network Performance

• Issue High Latency Networks
• Ping gt 60ms
• JDBC about 10-15 round trips
• Upload Speed of 128k usually sufficient
• Options
• Create Objects on Server - Preferences Option
• Tunnel via HTTP Connection Option
• JDBC via RMI via HTTP

19
Database Independence

• We are converting
• PL/SQL Procedures -gt Java
• PL/SQL Triggers -gt Java
• Evaluation what to do best
• PL/SQL Functions Views
• Persistency Management beyond CMP/JDO
• Built-in Security Lazy Loading