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 … Continue reading Oracle Application R12 :- Database connection could not be established. Either the database is down or the APPS credentials supplied are wrong ?
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 … Continue reading Analyzing application patches from front end for Oracle E-Business Suite R12
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 … Continue reading Creating Cloud Trail in AWS Cloud and sending logs to CloudWatch amazing !
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 … Continue reading Create a CloudWatch Alarm Based on a CloudWatch Metric in AWS
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 … Continue reading Creating Recovery Catalog in Oracle Database 12cR1
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 … Continue reading Configururing the default Fast Recovery Area to custom Fast Recovery Area for backup and archive log
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 … Continue reading Oracle Database backup in No Archive log mode
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 … Continue reading Restart Failed Patches in Oracle E-business Suite R12