1 / 19

Compiere Training

Compiere Training. Oracle Installation. Agenda. Oracle Installation Minimum Footprint Database (Instance) Creation Oracle Networking & Diagnostics Windows/Linux specific issues Survival Tips Firewall issues. Server Installation. Oracle Installation Cause of Frustration Complex Install

elinor
Download Presentation

Compiere Training

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Compiere Training Oracle Installation Installation Oracle

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

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

  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 ;-) Installation Oracle

  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 Installation Oracle

  6. Database Creation • Manual: “dbca” • Start > Programs > Oracle – OraHome92 > Configuration and Migration Tools > Database Configuration Assistant • Database Naming • Global Name (TNS Name) • Example: “main.compiere.org” • SID • Example: “main” • Remember Passwords of System and Sys Installation Oracle

  7. Oracle Networking Installation Oracle

  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 Installation Oracle

  9. Oracle Net Manager • Manual: “netmgr” • Start > Programs > Oracle – OraHome92 > Configuration and Migration Tools > Net Manager • Allows you to change and test your Network connections • Change test login from scott/tiger to system/pass Installation Oracle

  10. Oracle Networking • Network tests • tnsping main.compiere.org • tnsping main • sqlplus system/pass@main.compiere.org • sqlplus system/pass@main • Network files • ORACLE_HOME/network/admin/tnsnames.ora • ORACLE_HOME/network/admin/sqlnet.ora • NAMES.DEFAULT_DOMAIN = compiere.org • SQLNET.AUTHENTICATION_SERVICES= (none) Installation Oracle

  11. Oracle Windows Services • Automatically created – start/stop • Listener • Database • Agent • Services • OracleOraHome92TNSListener • OracleServiceMAIN Installation Oracle

  12. Linux/Unix Installation • Follow the book (!) • Before Install • Create groups (oinstall, dba, oracle) • Create user (oracle) • Reconfigure Kernel • Sufficient TEMP & SWAP space Installation Oracle

  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 sysdba”SQL> startup • Agent – agentctl start Installation Oracle

  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 Installation Oracle

  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 Installation Oracle

  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 > SOFTWARE > Oracle • the node with all sub nodes • HKEY_LOCAL_MACHINE > SYSTEM > CurrentControlSet > Services • the orphaned Oracle services (optional) Installation Oracle

  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 Installation Oracle

  18. Network Performance • Issue: High Latency Networks • Ping > 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 Installation Oracle

  19. Database Independence • We are converting • PL/SQL Procedures -> Java • PL/SQL Triggers -> Java • Evaluation what to do best • PL/SQL Functions & Views • Persistency Management beyond CMP/JDO • Built-in Security & Lazy Loading Installation Oracle

More Related