My Journey to the cloud…

In pursuit of excellence….

  • Log file location in Oracle application 11i

    Below is the ready reckoner for the location of various log files in Oracle apps 11i. This is very much helpful when troubleshooting any issue Database Tier Alert Log File – $ORACLE_HOME/admin/$CONTEXT_NAME/bdump/alert_$SID.log Trace file – $ORACLE_HOME/admin/SID_Hostname/udump Autoconfig Log file – $ORACLE_HOME/appsutil/log/SID_Hostname/DDMMTime/adconfig.log Application Tier Autoconfig Log file             – $APPL_TOP/admin/SID_Hostname/log/DDMMTime/adconfig.log Start/Stop Continue reading

    ,

  • Microsoft AD and OID synchronization not happening

    Support team reported an issue where they were not able to see some of the new users created in AD (Active Directory) flowing to OID (Oracle Internet Directory) I started looking into the issue. I checked ODI synchronization services (odisrv process) Logged into the infra tier and ran the command then checked the ldap synchronization Continue reading

  • File o7725967.tmp creation for FND_FILE failed

    Today support team sought a help for the issue they were encountering in the TEST instance. Error as given by the support team I tried a quick test to see if there is any issue with utl_file_dir Above test threw an error. Then I verified 2 more things 1) APPLPTMP directory should be the first one Continue reading

  • PASSWORD column NULL in DBA_USERS from 11g onwards

    I got a request from support team to reset the DBA user password as they were getting some error due to password expiration. However support person was not aware of the password. Oracle 11g brought several security enhancements, as it is well known by the 11g users. On previous Oracle versions it was possible to Continue reading

    ,

  • How to change “orcladmin” user password when it is expired

    Login to $ORACLE_HOME/bin (Infra Home) Make sure vnc process is running and DISPLAY variable is configured to the VNC port export DISPLAY=<server_name>:<port_no> Invoke the script -oidamin $ ./oidadmin Now login to the GUI (onVNC) with the following credential User = “cn=orcladmin” Password = default it is the same as that of “ias_admin” Once logged in, Continue reading

  • Usage of various pgp command

    Recently I got a request from a bank where the customer transmits some of the files. Bank was upgrading and changing their target server and hence we need to accommodate certain changes on our side to do the testing before the same is done in production environment. Command to list the existing Key IDs on Continue reading

  • adstpall.sh on Web tier and giving “Timeout specified in context file: 100 second(s)” error

    Today our development team complained of ‘Development’ instance of Oracle 11 Ebiz is not accessible. Even the login page is not loading. I tried to login and got the login page but later on after keying the login credential, it was taking extremely long time to open and later on threw ‘page not found’ error. I Continue reading

  • ORA-01017 error while accessing DB link from 9i to 11g

    Today I faced a strange issue. Support team needed to extract some data from PeopleSoft database (11.2.0.1) via oracle ERP database (9.2.0.6). A database links already exists between the 2 databases but when SELECT query is fired, we were getting below error. and I was pretty sure that the login credential for the remote database is Continue reading

  • Understanding Database locks using v$lock

    Many times I have seen either user or development team complaining of their DML statements running long or hung. And it is most of the time perceived as caused by slow database. But every time, I don’t see any contention from database side. It is the database lock that has been causing the ‘hung’ behaviour. Continue reading

  • WebLogic Server 12c (Rel 12.1.1.) installation on RHEL 5 Update 3

    Software – Following software are needed for WebLogic Server (WLS) 12c (Release 12.1.1) on RHEL 5 Update 3 WebLogic Server 12c Release 12.1.1 – Generic Installer http://www.oracle.com/technetwork/middleware/fusion-middleware/downloads/index.html For Licensed customer, s/w must be downloaded from Oracle e-Delivery JDK (User here is 7u2 Linux64 RPM) – Download it from http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downloads-1880260.html Please refer the below link for Continue reading

About Me

I’m a Hands-On Technical & Entrprise Solutions Architect based out of Houston, TX. I have been working on Oracle ERP, Oracle Database and Cloud technologies for over 20 years and still going strong for learning new things.

You can connect me on Linkedin and also reach out to me

I am certified for 8x AWS, OCP (Oracle Certified Professionals), PMP, ITTL and 6 Sigma.

Disclaimer

This is a personal blog. Any views or opinions represented in this blog are personal and belong solely to the blog owner and do not represent those of people, institutions or organizations that the owner may or may not be associated with in professional or personal capacity, unless explicitly stated.
All content provided on this blog is for informational purposes only. The owner of this blog makes no representations as to the accuracy or completeness of any information on this site or found by following any link on this site.

The owner will not be liable for any errors or omissions in this information nor for the availability of this information. The owner will not be liable for any losses, injuries, or damages from the display or use of this information. Any script available on the blog post MUST be tested before they are run against Production environment.

Recent Posts

Newsletter