Oracle Applications: Script to Start and Stop the Application, Database Servers

Posted by Jay     Tags: , , , 5 September, 2009    3,040 views    (0) Comment

Oracle Applications: Script to Start and Stop the Application, Database Servers: This is script is tested in oracle applications version 12.1.1 on linux 64 bit system cent OS. Oracle software, by default, gives startup script for database and applications server for each server basis. Once you have installed the server, and established your working site, you need to Database, listeners and application servers in sequence and process the same kind of execution to stop the system. I tried to Read Full Article (Click here)...

Categories : 11i Installation, 11i Scripts Tags : , , ,

How to Recreate the Passwordfile for Oracle Database?

Posted by Jiltin     Tags: , , , 23 March, 2009    5,786 views    (0) Comment

If you are the system administrator with full privilege, you can Recreate the Passwordfile for Oracle Database. This is required at times, if you forget or do not know the SYS or SYSTEM password. For example, typically some vendor application, such is Equity Edge, does not provide or share the password. You are forced to login, for genuine reasons, to maintain the database. For example: Nobody here knows any of the account passwords for this instance I want to setup rman backups so they can Read Full Article (Click here)...

Categories : 11i DBA Scripts, Equity Edge, Oracle Applications, Scripts Oracle Tags : , , ,

General Outlines for Installing & Configuring an Oracle Software on Unix/Linux OS

Posted by Jiltin     Tags: , 20 March, 2009    15,000 views    (0) Comment

Following are the general outlines (not the commands and statements) which I followed whenever there is a requirement to Install and Configure an Oracle Server on Unix/Linux Operating Systems. I would like to share them in my blog as a reference for the same. Pre-Installation Tasks: * Prepare the stage area for Oracle Software on the Serve —– Choose the mount point where software needs to be staged. —– Create the stage directories —– Copy the software in Read Full Article (Click here)...

Categories : Oracle Applications, Scripts Oracle Tags : ,

Installation of Oracle 11g on Linux (Red Hat Enterprise Linux – 4)

Posted by Jiltin     Tags: , 20 March, 2009    14,167 views    (1) Comment

As we all aware that Oracle 11g is now available for installing on Linux. Yesterday, I installed & configured the Oracle 11gR1 (11.1.0) and created the database on Linux (Red Hat Enterprise Linux – 4.0) successfully. I would like to share the steps with my blog viewers what I have followed to install it. Operating System Details: Linux – (Red Had Enterprise Linux – 4.0) Database Version Details: Oracle 11g Release 1 (11.1.0) Download Software: Read Full Article (Click here)...

Categories : Scripts Oracle, Scripts Unix Tags : ,

Oracle Applications – How to register Forms or Reports?

Posted by Jiltin     Tags: , , 17 March, 2009    1,024 views    (1) Comment

These are my notes and this is not organized properly: Step 1: Register a concurrent program executable Navigate to the Define Executable form This determines the type of program being run ie an Oracle Report. Fill in the executable name application and execution method. For the Execution File fill in just the filename. The concurrent manager will look in the appropriate directory under the application’s top directory. For spawned programs the file must be in the bin directory for Read Full Article (Click here)...

Categories : Oracle AOL, Oracle Applications Tags : , ,