Wednesday, November 4, 2020

Performance tuning wildfly

 from here :

performance tuning performance tuning for jboss or wildfly

here summary :

The fine-tuned configurations that we recommend for optimizing the performance of the JBoss or Wildfly application server are:
 

  1.     Recommended JVM Settings
  2.     Open Files
  3.     Maximum User Processes
  4.     Connection Backlog
  5.     Set TCP_KEEPALIVE_INTERVAL
  6.     Set TCP_KEEPALIVE_PROBES
  7.     Allocate Huge Pages for Java Virtual Machine (JVM) Heap
  8.     Increase Linux kernel Entropy
  9.     Test Entropy

wildfly memory jvm setting

 from here :

wildfly-increase-heap

In the WildFly installation home directory, we can find the standalone.conf (for Unix based systems) or standalone.conf.bat (for Windows systems) file in the bin folder.

We can simply open it and update the -Xmx option in the following line (change the number as per the requirement):

    JAVA_OPTS="-Xms64m -Xmx512m ..."

This will set the heap memory while starting up the server.



Friday, May 22, 2020

resource files for sysadmin


here from linux user group .ph :

Pinoy Linux - resource files for sysadmin

securing fresh install centos 7

here for guideline:

Securing fresh install centos 7

always check &test for configuration after change configuration

Opensource sysadmin Library

Please check here :

Open Source SysAdmin Resources

many list of resource stuff that you may need.

free or Opensource Desktop management software

 1. Chocolatey - https://chocolatey.org
 2. just-install - https://just-install.github.io/
 3. WAPT - https://www.tranquil.it/en/price/
 4. Opsi - https://www.opsi.org/
 5. WPKG - https://wpkg.org/
 6. desktop central free edition
 7. PDQ Deply

please test which ne suit for your need.
popularity comparison check in here:
https://sysadmin.libhunt.com/categories/1967-client-management

Sunday, July 7, 2019

Move or Rename Tempfile in Oracle


Move or Rename Tempfile in Oracle

#####  Move tempfile from location  ‘/u01/data/temp01.dbf’ to ‘/u03/data/temp01.dbf’  #####

SQL> SELECT v.file#, t.file_name, v.status from dba_temp_files t, v$tempfile v WHERE t.file_id = v.file#;
FILE#  FILE_NAME STATUS
-----------------------------------------------
 1  /u01/data/temp01.dbf  ONLINE
 2 /u02/data/temp02.dbf   ONLINE

SQL> ALTER DATABASE TEMPFILE '/u01/data/temp01.dbf' OFFLINE;

Database altered.

SQL> SELECT v.file#, t.file_name, v.status from dba_temp_files t, v$tempfile v WHERE t.file_id = v.file#;
 FILE# FILE_NAME STATUS
----------------------------------------------------
 1 /u01/data/temp01.dbf  OFFLINE
 2 /u02/data/temp02.dbf  ONLINE


#Copy the old temp files to other location(/u03):

SQL> !cp -p /u01/data/temp01.dbf /u03/data/temp01.dbf;

SQL> ALTER DATABASE RENAME FILE '/u01/data/temp01.dbf' TO '/u03/data/temp01.dbf';

Database altered.

SQL> SELECT v.file#, t.file_name, v.status from dba_temp_files t, v$tempfile v WHERE t.file_id = v.file#;
  FILE#   FILE_NAME STATUS
--------------------------------------------------------
  1    /u03/data/temp01.dbf OFFLINE
  2   /u02/data/temp02.dbf  ONLINE

SQL> ALTER DATABASE TEMPFILE '/u03/data/temp01.dbf' ONLINE;

Database altered.

SQL> SELECT v.file#, t.file_name, v.status from dba_temp_files t, v$tempfile v WHERE t.file_id = v.file#;
 FILE# FILE_NAME STATUS
---------------------------------------------------------
 1 /u03/data/temp01.dbf   ONLINE
 2 /u02/data/temp02.dbf   ONLINE


#Remove the old temp file
SQL> !rm -rf /u01/data/temp01.dbf



here: moving temfile temp tablespace oracle 11g

How to deal with ORA-00020: maximum number of processes (%s) exceeded

sqlplus /nolog

 SQL*Plus: Release 11.2.0.4.0 Production on Fri Jun 6 09:07:23 2014

 Copyright (c) 1982, 2013, Oracle.  All rights reserved.
 @ SQL> connect /
 ERROR:
 ORA-00020: maximum number of processes (1000) exceeded
I then found the page by tech.e2sn.com that showed how to use sqlplus with the "preliminary connection".

Simply by using
sqlplus -prelim "/as sysdba"
I was able to connect and shutdown the database with the abort option.
sqlplus -prelim "/ as sysdba"

 SQL*Plus: Release 11.2.0.4.0 Production on Fri Jun 6 09:09:15 2014
 Copyright (c) 1982, 2013, Oracle.  All rights reserved.

 SQL> shutdown abort
 ORACLE instance shut down.
 SQL> exit
 Disconnected from ORACLE
After this point the database could once again be restarted:
sqlplus / as sysdba

 SQL*Plus: Release 11.2.0.4.0 Production on Fri Jun 6 09:10:38 2014
 Copyright (c) 1982, 2013, Oracle.  All rights reserved.
 Connected to an idle instance.
SQL> startup
 ORACLE instance started.

 Total System Global Area 2137886720 bytes
 Fixed Size                  2248080 bytes
 Variable Size            1258291824 bytes
 Database Buffers          855638016 bytes
 Redo Buffers               21708800 bytes
 Database mounted.
 Databasen opened. 
 
here : maximum number exeed - oracle