Customizing the WebLogic JVM heap size

You can change the default JVM heap size to fit the needs of your deployment.

The default JVM heap size for WebLogic is 3GB. The size is set in the setDomainEnv.sh file for Linux or setDomainEnv.cmd for Windows, which is in the $DOMAIN_HOME/bin directory. The heap size is set with the -Xmx option.

To change the WebLogic JVM heap size:

1. Open the setDomainEnv file in a text editor.
2. Search for this comment line:
   For Linux:
   

   # IF USER_MEM_ARGS the environment variable is set, use it to override ALL MEM_ARGS values

   For Windows:
   

   @REM IF USER_MEM_ARGS the environment variable is set, use it to override ALL MEM_ARGS values

3. Immediately after the comment line, add one of these lines:
   For Linux:
   

   export USER_MEM_ARGS="-Xms2048m -Xmx2048m ${MEM_DEV_ARGS} ${MEM_MAX_PERM_SIZE}"

   For Windows:
   

   set USER_MEM_ARGS=-Xms2048m -Xmx2048m %MEM_DEV_ARGS% %MEM_MAX_PERM_SIZE%

4. Save the file.
5. Re-start WebLogic Server.

SQL Command

CREATE TABLE #TEMP(TBLNAME VARCHAR(200))

SELECT 'IF (SELECT COUNT(*) FROM '+TABLE_SCHEMA+'.'+TABLE_NAME +')=0 INSERT INTO #TEMP  SELECT '''+TABLE_SCHEMA+'.'+TABLE_NAME +''' '
from INFORMATION_SCHEMA.TABLES order by TABLE_SCHEMA,TABLE_NAME

SELECT 'DROP TABLE '+TABLENAME FROM #TEMP

Oracle 12c Expired User

-- How to reset the Expired user to Open with same password

select 'alter user ' || su.name || ' identified by values'    || ' ''' || spare4 || ';'    || su.password || ''';'
from sys.user$ su
join dba_users du on ACCOUNT_STATUS like 'EXPIRED%' and su.name = du.username;


-- Set Oracle Profile as Password Unlimited and Failed Login Unlimited

ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED PASSWORD_LIFE_TIME UNLIMITED;

Manually Import E1Local Database on Fat Client

Manually Import E1Local Database on Fat Client

Step 1 - Decrypt the password
C:\e920\system\bin32
ReconfigureDB.exe to set decrypt password

Step 2 - Import JDELOCAL_PY920

CREATE USER JDELOCAL_PY920 IDENTIFIED BY JDELOCAL_PY920;

GRANT CREATE SESSION, ALTER SESSION, CREATE TABLE, CREATE VIEW TO JDELOCAL_PY920;

CREATE OR REPLACE DIRECTORY PKGDIR AS 'C:\E920_1\PY920\data\' ;

impdp TRANSPORT_DATAFILES='C:\E920_1\PY920\data\jdelocal_py920.dbf' DIRECTORY=PKGDIR DUMPFILE='jdelocal_py920.dmp' REMAP_TABLESPACE=JDELOCAL:JDELOCAL_PY920 REMAP_SCHEMA=JDELOCAL:JDELOCAL_PY920 LOGFILE='impjdelocal_py920.log'

ALTER TABLESPACE JDELOCAL_PY920 READ WRITE ;

ALTER USER JDELOCAL_PY920 DEFAULT TABLESPACE JDELOCAL_PY920 QUOTA UNLIMITED ON JDELOCAL_PY920;

Step 3- Import SPEC_PY920


CREATE USER SPEC_PY920FB IDENTIFIED BY SPEC_PY920FB;

GRANT CREATE SESSION, ALTER SESSION, CREATE TABLE, CREATE VIEW TO SPEC_PY920FB ;

CREATE OR REPLACE DIRECTORY PKGDIR AS 'C:\E920_1\PY920\spec\' ;

impdp TRANSPORT_DATAFILES='C:\E920_1\PY920\spec\spec_py920fb.dbf' DIRECTORY=PKGDIR DUMPFILE='spec_py920fb.dmp' REMAP_TABLESPACE=SPEC__PY920FB:SPEC_PY920FB REMAP_SCHEMA=SPEC__PY920FB:SPEC_PY920FB LOGFILE='impspec_py920fb.log'

ALTER TABLESPACE SPEC_PY920FB READ WRITE ;

ALTER USER SPEC_PY920FB DEFAULT TABLESPACE SPEC_PY920FB QUOTA UNLIMITED ON SPEC_PY920FB ;

Step 4 - Encrypt the password
C:\e920\system\bin32
ReconfigureDB.exe to set encrypt password