ORA-01017: invalid username/password; logon denied ERROR: ORA-01017: invalid username/password; logon denied First of all you need to edit your sqlnet.ora adding (or lowering) the parameter SQLNET.ALLOWED_LOGON_VERSION_SERVER to…
Read MoreDescription : This script is used to find total number of database startup in the year or month. You can schedule the script in crontab for every month. Script :…
Read MoreDescription: This Shell script is very useful to calculate and review total no of database shutdown in the year or month. We can schedule the script to crontab for every…
Read MoreDescription: Once we completed clone successfully after that we run the Autoconfig its completed with error. error code (AC-50480: Internal error occurred) Cause : The issue can occur if the…
Read MoreDescription : The cloned instance and all managers and OPP services were up and running. However users were reporting of XML reports completed in Error. Issue Log : [OPPServiceThread0] java.sql.SQLException:…
Read MoreDescription : When attempting to run a concurrent program which is accessing file “reports.log” in directory $APPLCSF/$APPLLOG then following error occurs Error: emsg:was terminated by signal 25 Cause : File…
Read MoreDescription: This script mainly used for monitoring database alert log from a table. Instead of login in the Unix and start doing vi and tail to see the contents of…
Read MoreDescription : If we lost adapcctl.sh, adalnctl.sh, and adcmctl.sh scripts. we can re-generate it, By running autoconfig. Solution : [applabc@apps scripts]$ ls -ltrh adapcctl.sh adalnctl.sh adcmctl.sh No such file directory…
Read MoreDescription : This script is very useful for calculate and report to database growth in day/week/month/year wise. Script: SELECT (select min(creation_time) from gv$datafile) “Create Time”, (select name from gv$database) “Database…
Read MoreOracle Database 18c new features Versions 18.1.0 18.2.0 18.3.0 General Features in 18C we can configure ORACLE_HOME in read-only mode. we can CANCEL any database session SQL query (instead…
Read More