We generally have Dataguard in the Production env and for some reason if we have to flashback Production,then below steps could be used which will keep the standby in the Sync 1. Disable Log Transport Services to the Standby Database On Primary database alter system set log_archive_dest_state_n = ‘defer’ scope=both; 2. Perform a Log Switch on […]
Forms Server Architecture in 11i
Forms Server Architecture Forms Server use a three-tier architecture, consisting of the following components:• Client – A Java Applet running on the client PC that handles the UI presentation.• Middle tier – The Web Listener and the Form run-time that handles the logic.• Database tier – Data-intensive logic and data management. The Forms run-time consists […]
All about Apache(Oracle HTTP Server) in EBS 11i/R12
Apache is widely used Web server. Oracle HTTP server is based on Apache web server and includes modules developed specifically by Oracle. Here in this section we will have discussion about Apache (Oracle HTTP server) used in EBS 11i and R12 Important Directive in httpd.conf Listen:The Listen directive instructs Apache to listen to more than […]
How to setup diag wait in cluster
How to setup diag wait in cluster 1. Execute as root#crsctl stop crs #/bin/oprocd stop 2. Ensure that Clusterware stack is down on all nodes by executing #ps -ef |egrep “crsd.bin|ocssd.bin|evmd.bin|oprocd” This should return no processes. If there are clusterware processes running and you proceed to the next step, you will corrupt your OCR. Do […]
why-database-not-startup-automatic in 11gR2 cluster
There is one important attribute in 11gR2 cluster ie. AUTO_START We can check it using following command $ crsctl status resource ora.TEST.db -p | grep AUTO_START AUTO_START=restore – always: Restarts the resource when the server restarts regardless of the state of the resource when the server stopped. – restore: Restores the resource to the same […]
Steps to upgarde 11i Application database to 11gR1
Steps to upgarde 11i Application database to 11gR1 1) Oracle Application Prerequisites patches before upgrade : Interoperability notes for Oracle Applications 11i with 11gR1 – 452783.12) Install Oracle 11.1.0.x software 3) run pre upgrade tool 4) collect stats on database 5) Check for Connect Role and get user or role list which are having the […]
