Oracle Application R12 :- Database connection could not be established. Either the database is down or the APPS credentials supplied are wrong ?

adstrtal.sh: Database connection could not be established. Either the database is down or the APPS credentials supplied are wrong adstrtal.sh: Database connection could not be established. Either the database is down or the APPS credentials supplied are wrong Problem:- When trying to start or stop application on middle tier following error was seen. ./adstrtal.sh apps/<apps …

Analyzing application patches from front end for Oracle E-Business Suite R12

1.. Login to Oracle Application with sysadmin privileges and click on Dashboard. It will navigate to Application Dashboard . 2.. Now click on SITE Map above dashboard . 3.. Click on the Maintenance Tab and then Patch Wizard 4.. Under Patch Wizard Tab, Click on the Tasks button horizontal to Recommend /analyse Patches. Similarly, from …

Creating Cloud Trail in AWS Cloud and sending logs to CloudWatch amazing !

1.. Login to AWS Cloud Account and in AWS Management Console search for CloudTrail 2.. Once selected on CloudTrail and Trails, click on the Create Trail 3.. For your Trail give information as given below Trail Name = DEMO_TRAIL Apply trail to all regions = YES or NO 4.. Management events For Management events select …

Create a CloudWatch Alarm Based on a CloudWatch Metric in AWS

1.. Login to amazon cloud console and in Service Dashboard search for Alarm or directly click on CloudWatch down below the service dashboard. 2.. Select Alarm at the Left Navigation pane window and click on Create Alarm. 3.. Under Metric Tab click on Select Metric. 4.. Choose the service namespace that contains the metric you …

Creating Recovery Catalog in Oracle Database 12cR1

Creating Recovery Catalog :-  1.. Log in to SQL*Plus as the SYS user with SYSDBA role and create a tablespace named RCATBS to hold the repository data. Few points:- 1.1.. Number of databases supported by the recovery catalog 1.2.. Number of archived redo log files and backups recorded. 1.3.. Use of RMAN stored scripts And …

Configururing the default Fast Recovery Area to custom Fast Recovery Area for backup and archive log

1.. Check Oracle Database is in Archive log mode or not and Fast Area Recovery . 2.. Check default Fast Recovery Area destination and size 3.. Alter default Fast Recovery Area destination to custom Fast Recovery Area destination FRA and size 4.. Once altered default Fast Recovery Area destination to custom Fast Recovery Area destination  …

Oracle Database backup in No Archive log mode

1.. Confirm log mode of Oracle Database 2.. Invoke RMAN command with SYSBACKUP role SYSBACKUP and SYSDBA :- Similar to SYSDBA privilege, except that it doesn’t include the SELECT privileges  for user-content tables or cannot see content of user tables but SYSDBA can see content of user tables . 3.. Check the name of user …

Restart Failed Patches in Oracle E-business Suite R12

1.. First Shutdown the workers navigate to $AD_TOP/bin and execute adctrl utility  ./adctrl select option 3 “Tell worker to shutdown/quit” 2.. Now take the backup of the FND_INSTALL_PROCESSES table Connect as applsys because FND_INSTALL_PROCESS is owned by applsys schema. Sqlplus applsys/<password> create table fnd_Install_processes_back as select * from fnd_Install_processes; Check the both tables should have …