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

kasus ini saya alami pada saat penginstallan oci8 di server debian9. saya menggunakan langkah sebagai berikut: https://pengingatdasar.blogspot.co.id/2018/04/cara-install-oci8-di-ubuntu-1604-dan.html pada saat selesai penginstallan, saya ketikkan command php -i | grep oci muncul keterangan bahwa oci8 tersebut sudah terpasang, lalu saya uji menggunakan file phpinfo(); dari file tsb tidak tampak keberadaan modul oci8 sudah terpasang. langkah yang saya lakukan adalah edit file : nano /etc/apache2/envvars tambahkan script: export  LD_LIBRARY_PATH="/(path oci)/instantclient_12_1/" restart apache. /etc/init.d/apache2 restart buka kembali file phpinfo() nya, dan selesai