Brain Log

 Already checked credentials, already tried to connet to other Oracle server but the error still the same: 12546 ORA-12546: TNS:permission denied * The setting I was missing is: setsebool -P httpd_can_network_connect on

Then as root switch to this user so have to have all the oracle variables in your path, You MUST log on as sysdba that's the only internal user allowed to access the database in such situations. eg if the owner owner/user is oradba # su - oradba Now you can invoke sqlplus $sqlplus /nolog SQL>conn / as sysdba SQL> archive log list; Database log mode        Archive Mode Automatic archival        Enabled Archive destination        USE_DB_RECOVERY_FILE_DEST Oldest online log sequence     482 Next log sequence to archive   482 Current log sequence        487 Check the Archive destination and delete all the logs SQL> shutdown immediate Database closed. Database dismounted. SQL> startup mount ORACLE instance started. Total System Global Area 3240239104 bytes Fixed Size     2217712 bytes Variable Size 2835351824 bytes Database Buffers   385875968 bytes Redo Buffers    16793600 bytes Database mounted. SQL> alter database noar

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

untuk mengatasi masalah error pada oracle, dengan kode error 'ORA-00257: archiver error. Connect internal only' dapat diatasi dengan cara: masuk sebagai sys: sqlplus / as sysdba ketikan: SQL> show parameter recovery   NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest                string      /u01/fast_recovery_area db_recovery_file_dest_size           big integer 3882M SQL> alter system set db_recovery_file_dest_size = 4500M; System altered. selesai lalu start menggunakan perintah: startup

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

Install Oracle Instant Client and SDK Download Oracle instant client dan SDK di website oracle: http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html download file berikut: instantclient-basic-linux.x64-12.1.0.2.0.zip instantclient-sdk-linux.x64-12.1.0.2.0.zip Buat folder baru untuk mengektrak file zip oracle instant client di dalam server. mkdir /opt/oracle extrak file tersebut: cd /opt/oracle unzip instantclient-basic-linux.x64-12.1.0.2.0.zip unzip instantclient-sdk-linux.x64-12.1.0.2.0.zip buat symlink untuk instant client: ln -s /opt/oracle/instantclient_12_1/libclntsh.so.12.1 /opt/oracle/instantclient_12_1/libclntsh.so ln -s /opt/oracle/instantclient_12_1/libocci.so.12.1 /opt/oracle/instantclient_12_1/libocci.so buat folder di ldconfig echo /opt/oracle/instantclient_12_1 > /etc/ld.so.conf.d/oracle-instantclient update ldconfig ldconfig install depedensi yang dibutuhkan untuk memasang oci8 apt-get install