How to Enable Archive log in oracle Database ?

 Greetings from Hamid Blog. :)

WARNING:

You must ensure that there is sufficient disk space at all times for archived log file destinations. If the database encounters a disk full error as it attempts to archive a log file, a fatal error occurs and the database stops responding. 

You can check the alert log for a disk full message by executing the bellow SQL.

SELECT LOG_MODE FROM V$DATABASE;

Please follow

1. SHUTDOWN IMMEDIATE;

2. STARTUP MOUNT;

3. ALTER SYSTEM SET LOG_ARCHIVE_DEST_1 = 'LOCATION=</u02/oracle/logfiles>';

4. (Optional) ALTER SYSTEM SET LOG_ARCHIVE_DEST_2 = 'LOCATION=</u03/oracle/logfiles>';

5. ALTER DATABASE ARCHIVELOG;

6. ALTER DATABASE OPEN;

7. SHUTDOWN IMMEDIATE;

8. STARTUP;

To get the list by executing following SQL

archive log list

Thanks,

🔗FOLLOW also: 

 Facebook: https://www.facebook.com/ariderseye 

Website: www.ariderseye.com

YouTube: https://www.youtube.com/c/ariderseye

REP-1060: Reports Builder database tables have not been installed.

 Greetings from Hamid Blog

Issue on: Oracle Forms 10g, 6i

After opening the report builder, when you try to open an existing reports, you will get bellow error message.

REP-1060: Report Builder database tables have not been installed.
ORA-00942: table or view does not exist.
Report Builder tables may not be installed in the database.

cause: Database access is chosen in Reports Builder Preferences

Solution:

1) Open Reports Builder

2) Choose Tools -> Preferences

3) Go to Access tab and make sure that the checkbox next to 
   Access -> File
   is checked

4) Ensure that Access -> Database
   or
   Access -> File/database is not checked

Finally, you will get,

Thanks for reading my blog!

ORA-00020: maximum number of processes (150) exceeded

Welcome back to HamidHelal blog.

Sorry for the long delay.

Today i encountered an error from client

ORA-12520: TNS:listener could not find available handler for requested type of server


when i tried to connect to database as admin, i got another error is


ORA-00020: maximum number of processes (150) exceeded


but there is a trick to connect

try,

C:\Users\Administrator>CD C:\app\Administrator\product\11.2.0\dbhome_1\BIN

C:\app\Administrator\product\11.2.0\dbhome_1\BIN>SQLPLUS /NOLOG

SQL*Plus: Release 11.2.0.4.0 Production on Tue Aug 20 00:38:14 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL> CONN /AS SYSDBA
ERROR:
ORA-00020: maximum number of processes (150) exceeded




C:\app\Administrator\product\11.2.0\dbhome_1\BIN>sqlplus -prelim "/ as sysdba"

SQL*Plus: Release 11.2.0.4.0 Production on Tue Aug 20 00:41:43 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL> SHUTDOWN ABORT
ORACLE instance shut down.
SQL> EXIT
Disconnected from ORACLE



C:\app\Administrator\product\11.2.0\dbhome_1\BIN>SQLPLUS / AS SYSDBA

SQL*Plus: Release 11.2.0.4.0 Production on Tue Aug 20 00:43:31 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> STARTUP
ORACLE instance started.

Total System Global Area 1.0255E+10 bytes
Fixed Size                  2290120 bytes
Variable Size            1644170808 bytes
Database Buffers         8589934592 bytes
Redo Buffers               18817024 bytes
Database mounted.
Database opened.
SQL>