JBAS015899: JBoss AS 7.1.1.Final “Brontes” starting
Java 8 wasn’t compatible with JBoss AS7 so I prefered to upgrade the JBoss version rather than downgrade the Java version
Read MoreWebLogic Server 12.2 EM and Console Slow Response
Remove the below parameter in startup script -Dweblogic.UseEnhancedIncrementAdvisor=false
Read MoreNode Manager associated with machine Admin server is not reachable
1)Check if Machine is configured in console against Node where Managed Server is running. 2) Check Node Manager IP and port number configured for that Machine. 3)Check firewall and antivirus …
Read MoreHow to take thread dumb in JVM
1)Verify java installed. 2) find the required process of PID sing below command can take thread dumb. jstack -l <pid> >> threaddumps.log
Read MoreHow to generate heap dump in weblogic using hprof
Using HPROF: You can use HPROF: Heap and CPU Profiling Agent. A complete dump of the current live objects in the heap can be obtained with: -java -agentlib:hprof=heap=dump,format=b -jar application…
Read MoreHow to change Oracle Database NLS DATE FORMAT
Here is the below statement. alter system set nls_date_format=’dd.mm.yyyy hh24:mi:ss’ scope=spfile
Read MoreHow to Run sql statements in all PDBS
Oracle catcon.pl program is used to run a SQL scripts or SQL statements in all PDBS . $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -u SYS/****AhAhpassword-changed*** -d /export/home/oracle/scripts -l /export/home/oracle/scripts/logs -b give-write_ps give-write_ps.sql -u username/password…
Read MoreHow to find last modified table in oracle.
Here is the query below. set linesize 500; select TABLE_OWNER, TABLE_NAME, INSERTS, UPDATES, DELETES, to_char(TIMESTAMP,’YYYY-MON-DD HH24:MI:SS’) from all_tab_modifications where table_owner<>’SYS’ and EXTRACT(YEAR FROM TO_DATE(TIMESTAMP, ‘DD-MON-RR’)) > 2010 order by 6;…
Read MoreHow to catch DDL statements oracle database.
CREATE TABLE AUDIT_DDL ( DDL_DATE date, OSUSER varchar2(255), CURRENT_USER varchar2(255), HOST varchar2(255), TERMINAL varchar2(255), IP_ADDRESS VARCHAR2(100), module varchar2(100), owner varchar2(30), type varchar2(30), name varchar2(30), sysevent varchar2(30), sql_txt varchar2(4000) ) tablespace…
Read More