Find in this Blog

Thursday, May 16, 2019

Oracle Password Expire set unlimited

I am getting password expire each 4 5 months, I wan to set to unlimited


SQL> connect sqlplus"/as sysdba"


SQL> alter user system account unlock ;




Next, change the profile limit to unlimited.

SQL> alter profile DEFAULT limit PASSWORD_REUSE_TIME unlimited;
SQL> alter profile DEFAULT limit PASSWORD_LIFE_TIME  unlimited;



Check the password expiry date 
 
SQL> select username, account_status, EXPIRY_DATE from dba_users where username='BURLESON';
 
USERNAME                       ACCOUNT_STATUS               EXPIRY_DATE
------------------------------ ---------------------------- ---------
BACMONIT                       OPEN                         UNLIMITED


Thanks
Yoonus

Wednesday, May 8, 2019

how to veryfy or check the memmory slot in windows server OS

Using commands you will be able to identify your server RAM slot and capacity information

Execute the below command in command prompt with admin right.


C:\Users\gppadm>wmic memphysical get MaxCapacity, MemoryDevices
MaxCapacity  MemoryDevices
201326592    6



C:\Users\gppadm>wmic MEMORYCHIP get banklabel, capacity, caption, devicelocator,partnumber
BankLabel  Capacity       Caption          DeviceLocator               PartNumber
           8589934592  Physical Memory  PROC 1 DIMM 1D
           8589934592  Physical Memory  PROC 1 DIMM 2A
           8589934592  Physical Memory  PROC 1 DIMM 4B
           8589934592  Physical Memory  PROC 1 DIMM 6C

The above output based on my server ram and slots.

Thanks
Yoonus