Use Following query to validate wether sysadmin password that we are
using is correct or not
select fnd_web_sec.validate_login('SYSADMIN','<SYSADMIN PASSWORD>')
from dual;
If it returns Y then Sysadmin password is correct
If it returns N then sysadmin password that we are using
is wrong. try to change sysadmin password using FNDCPASS
This are the Responsibilities for DBA. Top 99 Responsibilities of a DBA Database Architecture Duties 1. Planning for the database’s future storage requirements 2. Defining database availability and fault management architecture 3. Defining and creating environments for development and new release installation 4. Creating physical database storage structures after developers have designed an application 5….
Oracle Applications login page sometimes will have the Exception: java.lang.NoClassDefFoundError. Request URI:/OA_HTML/AppsLocalLogin.jsp Exception: java.lang.NoClassDefFoundError The workaround used to solve this Exception: java.lang.NoClassDefFoundError was to rebounce the Apache server in Oracle Applications. Aside from rebounce the Apache server in Oracle Applications, you have to remove the server side cache as well. Stop the Apache Web Listener…
Database Statistics Statspack is different from BSTAT/ESTAT Statspack collects more data, including high-resource SQL It precalculates many ratios such as cache hit ratios, rates and transaction statistics It uses permanent tables owned by PERFSTAT user to store performance stats It separates data collection from report generation It makes data collection easy to automate using either…
alias abort=’echo shutdown abort|sqlplus -L -s / as sysdba’ alias alertvi=’vi $ORACLE_HOME/admin/ ORACLE_SID/bdump/alert_ORACLE_SID.log’ alias nomount=’echo startup nomount quiet|sqlplus -L -s / as sysdba’ alias ora=’cd $ORACLE_HOME’ alias pmon=’ps -ef | grep [p]mon’ alias startup=’echo startup quiet|sqlplus -L -s / as sysdba’ alias sysdba=’sqlplus -L / as sysdba’ alias tns=’cd $ORACLE_HOME/network/admin’ alias alert=’tail -100 $ORACLE_LOG/alert_$ORACLE_SID.log|more’ alias…
HOW-TO: Mount USB Thumbdrives in Solaris USB thumbdrives have become mainstream. And most of the portable tools and utilities are stored in them. This is true for both Windows and Unix/Linux. But I recently was asked a question on how to mount USB thumbdrives in Solaris. Indeed, how is a thumbdrive mounted in Solaris? Aside…
How to check if an rpm package is installed on a Red Hat Linux server rpm check, check if package is installed, red hat linux Maintaining a server up-to-date requires regular rpm checks. Each time Red Hat releases a newer version of, for example, samba rpm (and requisites) with fixes for known vulnerabilities one needs…