Langsung ke konten utama

Postingan

Menampilkan postingan dari November, 2018

Cara melakukan SSH Port Forwarding

1. konfigurasi ssh di server forward dengan menambahkan vi /etc/ssh/sshd_config GatewayPorts yes 2. ketikan perintah di server forward /usr/bin/ssh -f -C -R Portforward:IPserverTujuan:Porttujuan usernamekita@localhost -pPortKita ping 8.8.8.8 -s1 Contoh: /usr/bin/ssh -f -C -R 2225:192.168.90.x:22 pandu@localhost -p22 ping 8.8.8.8 -s1

ORA-28001: THE PASSWORD HAS EXPIRED

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