Tweet
SQL server Simplest data loading script
T-SQL script to add a server load . I have used this script to test backup timings, replication latency. One run of following procedure incerased log fie to 8GB and datafile to 6GB Read more…
Change EBS Apps Ports
If concurrent ma nagers are running then see the process using ps- ef | grep FND : Normally can take upto 5 minutes to kill all processes so be patient.
To abort all procsses = kill -9 `ps -ef | grep FND | awk `{print $2}’`
Status of each concurrent requests are hosted at FND_Concurrent_requests & Fnd_concurrent_queues. Running is R and complegted is set as C in this tables. Read more…
Healthcheck of EBS Components Using AOL
All checks are done using aoljtest.jsp. The app front end connects to database suing $INST_TOP/fnd/secure/DBC- Database connector file
An experience with Oracle EBS Patching :Upgrade from 12.0.2 -> 12.0.4
Hierarchy : One off Patch -> Mini pack -> Family pack & Finally Maintenance Pack
Maintenance pack : Upgrade from one version to another . 12.0.2 -> 12.0.4
Family pack – Fixing the functional modules.FIN.B – Latest family pack for release 12 . FIN is financial B where B denotes the version -. For 11i HRPF.K – K is level of Module.
One off – One off issue
Mini Pack : Small functionality
Enhance functionality like VAT change. – One off else MINI pack. Apps patch is done by adpatch utility. Also look into readme file. “adpatch” is like opatch so can be copied from CD.
How to bounce & Debug Apache /Forms : Log files
[applmgr@ebs scripts]$ pwd
/oracle/u01/VIS/inst/apps/VIS_ebs/admin/scripts
[applmgr@ebs scripts]$ adapcctl.sh stop
You are running adapcctl.sh version 120.6.12000000.2
Stopping OPMN managed Oracle HTTP Server (OHS) instance …
adapcctl.sh: exiting with status 0
adapcctl.sh: check the logfile /oracle/u01/VIS/inst/apps/VIS_ebs/logs/appl/admin/log/adapcctl.txt for more information …
[applmgr@ebs scripts]$ adapcctl.sh status
You are running adapcctl.sh version 120.6.12000000.2 Read more…
Backups and Recovery Options on SQL server
Backup Types
There are 5 backup types. All these backups can be carried out online. databases. Offline backups require SQLSERVER be stopped. Offline backups are useful for the master, msdb and model databases
1. Full : This takes a complete copy of the database and logs.
2. Differential : This takes a copy of all changed pages since the last full backup (for database and logs.)
3. Transaction Log : This takes a copy of the transactions logs and clears its contents on completion.
4. File or File group : This copies only the specified file or group.
5. File differential : This takes a copy of all changed pages in file since the last file backup. In situations when the backup is too big for a backup window. Read more…
Using a Maintenance Plan to Backup SQL Databases
Maintenance Plans are only displayed to those users who are connected to the SQL Server using Windows Authentication Mode.
EMD upload error: uploadXMLFiles skipped :: OMS version not checked yet..
EMD upload error: uploadXMLFiles skipped :: OMS version not checked yet..
Maks sure AGENT_HOME is set and EMCTL is not running from ORACLE_DATABASE_HOME than AGENT_HOME
SQL Server Transaction Log Shipping Replication
Prerequisite :
- 2 separate SQL database instances at 2 different physical boxes – T-B0399254ED744 & TVLX4686.
- A share accessible to Primary and Secondary Server for log shipping
Here I am going to log replicate AdventureWorks database from T-B0399254ED744 to TVLX4686
SQL Server Remote Connection Error : An error has occurred while establishing a connection to the server.
This morning I installed a new instance of SQL server and while connecting remotely it sent me an error message.
Maintaining SQL Server High Availability
- Failover Clustering
- Log Shipping
- Database Mirroring
Locks,Monitoring SQL Server Pocesses
Please navigate to Management ->Activity Monitor -> Double Click
AWR : How to run Reports
The architecture of the AWR is quite simple. The MMON background process polls the x$ fixed tables from the SGA region and stores them in the AWR tables. From there, the performance data is instantly available for analysis. The Enterprise Manager can be used for graphical data display. Alternatively, the Automatic Database Diagnostic Monitor (ADDM) can be used for automated tuning analysis, or SQL*Plus can be used if customized Oracle tuning size reports are desired. Read more…
Installing Oracle 9.2.0.6 on Red Hat Linux AS release 5 Update 3
Installing Oracle 10.2.0.1 on Red Hat Linux AS release 4 Update 5 (Nahant Update)
Table of Contents
1.1 Objectives
1.2 Scope
2 System Configuration
2.1 Architecture
3 System Configuration
3.1 Machine Configuration
3.2 External/Shared Storage
4 Oracle Pre-Installation tasks
4.1 Redhat Pre-Requisite
4.2 Copy Oracle 10.2.0.1 software onto server
4.3 Unpack Files
4.4 Download Patches
4.5 Check kernel and update rpm files
4.6 Creating Required Operating System Groups and Users
4.7 Oracle required directory creation
4.8 Set Kernel Parameters
4.9 Create Oracle Profile
5 Oracle Software Configuration
5.1 Directory Structure
5.2 Download ASM packages
5.3 ASM package install
5.4 Configuring and Loading ASM
5.5 Creating ASM Disks
5.6 Installation
5.6.1 Database Only Installation
5.6.2 Installing the Listener
5.6.3 DBCA : Creating an ASM /Database Instance
Views Relevant to Oracle Data Guard
| LOGICAL | DBA_LOGSTDBY_EVENTS | Contains information about the activity of the logical standby database system. It can be used to determine the cause of failures that occur when SQL Apply is applying redo to logical standby databases. |
| LOGICAL | DBA_LOGSTDBY_LOG | Shows the log files registered for logical standby databases. |
| LOGICAL | DBA_LOGSTDBY_NOT_UNIQUE | Identifies tables that have no primary and no non-null unique indexes. |
| LOGICAL | DBA_LOGSTDBY_PARAMETERS | Contains the list of parameters used by SQL apply. |
| LOGICAL | DBA_LOGSTDBY_PROGRESS | Describes the progress of SQL Apply on the logical standby database. |
| LOGICAL | DBA_LOGSTDBY_SKIP | Lists the tables that will be skipped by SQL Apply. |
| LOGICAL | DBA_LOGSTDBY_SKIP_TRANSACTION | Lists the skip settings chosen. |
| DBA_LOGSTDBY_UNSUPPORTED | Identifies the schemas and tables (and columns in those tables) that contain unsupported datatypes. Use this view when you are preparing to create a logical standby database. | |
| PHYSICAL/LOGICAL | V$ARCHIVE_DEST | Read more… |
Multimaster Replication :How to resolve Replication Errors
While using multimaster replication often you would be bombarded with errors like “No data found”, “Unique Key Violated” etc .
These are purely data mismatch errors and a user intervention needed to resolve them.
I often come across these errors when we run applications at multiple sites which are part of same replication group/tables when they are designed to run at one replication site at any given time.
You can get list of these errors at DEFERROER view with transaction ids but there is no easy way to locate the parameters,columns and tables on which these errors occurred.
Thankfully there is a solution if you have EM installed.
10g RAC Install under RHEL/OEL 4.5
Compare and copy files remotely using SCP
Using adadmin to compile an Apps environment
While installing apps 12 under OEL 5, I came across a problem and one of the suggestion made was to relink/compile an apps setup to see if that resolves the problem…
Multi Node to Single Node Cloning
With Oracle Applications 11.5.10 the ability to clone from a multi node to a single node system using rapid clone has now been certified.
Best way to check patches on Metalink
http://metalink.oracle.com
Using Patches -> simple search with following details
How to deploy form on server
Generally, in Oracle Applications
- All *.fmb located at $AU_TOP/forms/US
- All *.fmx will be located at their respective Product top’s/forms/US.
Log4plsql for PL/SQL Logging
Log4plsql is an open source tool that uses PL/SQL framework to log into PL/SQL code package, function, web application, procedure, trigger and various oracle tools such as reports, forms etc. Before we proceed with Log4plsql for PL/SQL Logging, it is important to understand the concept behind the importance of logging and logs in the development environment.
Logging is very important part of development lifecycle for any process or application. These logs are important for tracing functional events, data and operations. Logs are also used for code debugging and in testing or maintenance phase to understand unforeseen events such as system crash, quit or launch. It is considered as a very time-consuming tedious job as all the logs during the development strategy have to be considered which utilizes vital computer memory or resources.
