Brain Log

Connect as sysdba to the database. [oracle@ijindbclone ~]$  sqlplus / as sysdba Run the query to set the password’s life time to unlimited. SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; Profile altered. Set a password for the locked user. SQL> ALTER USER user_name IDENTIFIED BY password; User altered. Unlock the user account. SQL> ALTER USER user_name ACCOUNT UNLOCK; User altered. Make sure your user is not locked anymore. SQL> SELECT USERNAME,ACCOUNT_STATUS FROM DBA_USERS; USERNAME ACCOUNT_STATUS ------------------------------ -------------------------------- HR                             OPEN ANONYMOUS                      OPEN APEX_040000                    LOCKED FLOWS_FILES                    LOCKED XDB                            EXPIRED & LOCKED CTXSYS                         EXPIRED & LOCKED MDSYS                          EXPIRED & LOCKED SYSTEM                         OPEN SYS                            OPEN

setelah server oracle restart, terjadi masalah sebagai berikut. [oracle@host ~]$ sqlplus / as sysdba ... ... Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 2147483648 bytes Fixed Size 2926472 bytes Variable Size 1224738936 bytes Database Buffers 905969664 bytes Redo Buffers 13848576 bytes Database mounted. ORA-03113: end-of-file on communication channel Process ID: 4903 Session ID: 237 Serial number: 26032 untuk mengatasi error tersebut, dapat dilakukan dengan cara: SQL> exit Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production [oracle@zeus ~]$ sqlplus / as sysdba ... ... Connected to an idle instance. SQL> startup nomount ORACLE instance started. Total System Global Area 2147483648 bytes Fixed Size 2926472 bytes Variable Size 1224738936 bytes Database Buffers 905969664 bytes Redo Buffers 13848576 bytes SQL> alter database

Config Server Firewall (atau CSF) adalah firewall gratis dan canggih untuk beberapa distribusi Linux dan VPS berbasis Linux. Selain fungsi dasar dari paket penyaringan firewall - CSF memiliki fitur keamanan yang lain, seperti penditeksi login/intrusion/flood detections. CSF dapat digunakan untuk cPanel, DirectAdmin dan Webmin, WHM. CSF dapat mengenali beberapa serangan, seperti port scan, SYN floods, brute force login. apabila peretas terjaring dalam firewall ini, maka peretas akan terblokir untuk beberapa waktu. Installasi Masuk menggunakan root melalui port ssh ke server/VPS ketikkan: # rm -fv csf.tgz # wget http://www.configserver.com/free/csf.tgz # tar -xzf csf.tgz # cd csf # sh install.sh lalu, masuk ke whm http://domain.com:2087 cari " ConfigServer Security & Firewall " enable firewall dengan cara masuk ke Configserver Firewall -> Firewall Configuration -> TESTING = OFF -> Return