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 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 : 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 MoreFAILURE IN PRIMARY DATABASE: ORA-10458: standby database requires recovery ORA-01196: file 1 is inconsistent due to a failed media recovery session ORA-01110: data file 1: ‘/u01/app/oracle/oradata/prime/system01.dbf’ SQL> startup ORACLE instance…
Read MoreError: rpmdb: Thread/process 4330/140521027696384 failed: Thread died in Berkeley DB library YUM FAILED [root@ranesh yum.repos.d]# yum update rpmdb: Thread/process 4330/140521027696384 failed: Thread died in Berkeley DB library error: db3 error(-30974)…
Read Moreadstrtal.sh: Database connection could not be established [applmgr@ranesh scripts]$ sh adstrtal.sh apps/oracle You are running adstrtal.sh version 120.24.12020000.6 Enter the WebLogic Server password: adstrtal.sh: Database connection could not be established. Either…
Read MoreHow to change apps& sysadmin password in R12.2 Important Note: These steps must be carried out on the run file system. Step 1. Shut down the application tier services using…
Read MoreFind Application URL From Database and Context File in Oracle App R12.2 solution 1: SQL> select home_url from icx_parameters; HOME_URL ——————————————————————————– http://document.subnet.vcn.oraclevcn.com:8000/OA_HTML/AppsLogin solution 2: [applmgr@document appl]$…
Read MoreError: libmawt.so: libXtst.so.6: cannot open shared object file: No such file or directory [root@ebs ~]# Exception in thread “main” java.lang.UnsatisfiedLinkError: /u01/ebs_12.2.0/startCD/Disk1/rapidwiz/jre/Linux_x64/1.6.0/lib/i386/xawt/libmawt.so: libXtst.so.6: cannot open shared object file: No such file…
Read More