Skip to main content

Posts

Oracle Database 11g Release 1 (11.1) Installation On Fedora 7 (F7)

Oracle Database 11g Release 1 (11.1) Installation On Fedora 7 (F7) This article describes the installation of Oracle Database 11g Release 1 (11.1) on Fedora 7 (F7). The article is based on a server installation with a minimum of 2G swap, secure Linux disabled and the following package groups installed: • GNOME Desktop Environment • Editors • Graphical Internet • Development Libraries • Development Tools • Server Configuration Tools • Administration Tools • Base • System Tools • X Window System An example of this type of Linux installation can be seen here. Alternative installations may require more packages to be loaded, in addition to the ones listed below. • Download Software • Unpack Files • Hosts File • Set Kernel Parameters • Setup • Installation • Post Installation Download Software Download the following software: • Oracle Database 11g Release 1 (11.1) Software Unpack Files Unzip the files: unzip linux_11gR1_database.zip You should now have a single directory called "databa...

The Seven Deadly Habits of a DBA

The Seven Deadly Habits of a DBA ... and how to cure them A passion for excellence Calling widespread bad habits in database administration "deadly" may seem extreme. However, when you consider the critical nature of most data, and just how damaging data loss or corruption can be to a corporation, "deadly" seems pretty dead-on. Although these habits are distressingly common among DBAs, they are curable with some shrewd management intervention. What follows is a list of the seven habits we consider the deadliest, along with some ideas on how to eliminate them. Habit #1. THE LEAP OF FAITH: "We have faith in our backup." Blind faith can be endearing, but not when it comes backing up a database. Backups should be trusted only as far as they have been tested and verified. Cures: * Have your DBAs verify that the backup is succeeding regularly, preferably using a script that notifies them if there's an issue. * Maintain a backup to your backup. DBAs...

How To Change the Apps Password

The passwords of APPS and APPLSYS must be identical. So you just need to change APPLSYS password not APPS , by changing APPLSYS password , APPS password assumes the same value (i) Shutdown the Applications Tier services on each of the Nodes Database Tier Services must be up and running Any node where APPL_TOP , 8.0.6 and iAS ORACLE_HOME are present is part of the Application tier Any node where RDBMS ORACLE_HOME is present is part of the Database tier (ii) Then . issue the commands at the Unix command line similar to the following on any Node of Oracle Applications where the executable FNDCPASS is present in $FND_TOP/bin To change the APPLSYS password: FNDCPASS apps/apps_schema_password 0 Y system/system_schema_password SYSTEM APPLSYS new_password Ex: FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS CITRIX123 To change an Oracle user password: FNDCPASS apps/apps_schema_password 0 Y system/system_schema_password ORACLE apps_database_user new_password Example FNDCPASS app...

How to Remove the Yellow Warning Bar in Release 11i

PURPOSE ------- Why do I get a Yellow Warning Bar connecting to Applications Rel 11i? How to Remove the Yellow Warning Bar in 11i? SCOPE & APPLICATION ------------------- Anyone using Oracle Applications Rel 11.5.x HOW TO REMOVE THE YELLOW WARNING BAR IN ORACLE APPLICATIONS REL 11.5.x ------------------------------ ------------------------------ ---------- If you are connecting to an Oracle Applications Rel 11.5.1 Instance and now see a Yellow Warning Bar in the bottom margin of your screens I What does the Yellow Warning Bar mean II Who does this affect? III Where are all the files located IV Why do I get it now, what changed? V How to remove it. I - What does the Yellow Warning Bar mean? Oracle Applications Rel 11.5.1 (11i) requires that its code run in a trusted mode, and uses JInitiator to run Java applets on a desktop client. If an applet is "trusted," however, Java will extend the privileges of the applet. The Yellow Warning Bar is a warning that you...

Oracle Fusion: Next-Generation Enterprise Applications

Oracle Fusion: Next-Generation Enterprise Applications Applications Unlimited is Oracle's commitment to continue providing enhancements to current JD Edwards EnterpriseOne, JD Edwards World, Oracle E-Business Suite, PeopleSoft, and Siebel product lines beyond the delivery of Oracle Fusion Applications. At the same time, with Oracle's extensive development resources, we are building Oracle Fusion Applications. These are being designed to unify best-of-business capabilities from all Oracle Applications in a complete suite delivered on Oracle's open technology. Only Oracle can offer you the scale of resources needed to extend the solutions you own today, while simultaneously evolving to the next generation of Oracle Fusion Applications. With Oracle's unique Applications Unlimited and Lifetime Support policy – customers will not be forced to upgrade to Fusion Applications, but can decide when and if they choose to upgrade. Application integration has never been easier. Le...