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

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>

Oracle Forms 10g/11g (web version) Keyboard Shortcut Key List

As salamualikum (islamic greetings), brothers and sisters. :)

  Hope you are well with the grace of Almighty Allah (swt)

 

Some times, you may forget about the shortcut key when working in oracle forms.

 To get the list at forms just press Ctrl + K, and you will get all the list.

Here i add in details.

Function	Shortcut Key
Show Shortcut Keys	Ctrl + K
Enter Query	F11
Execute Query	Ctrl + F11
Count Query	F12
Clear Block	F7
Clear Field	F5
Clear Form	F8
Clear Record	F6
Edit	Ctrl + E
Update Record	Ctrl + U
Insert Record	Ctrl + Down
Delete Record	Ctrl + Up
Commit	Ctrl + S
Duplicate Field	Shift + F5
Duplicate Record	Shift + F6
List of values	Ctrl + L
List Tab Pages	F2
Next Field	Tab
Next Record	Down Arrow Key
Next Primary	Key Shift + F7
Next Set of Records	Shift + F8
Previous Field	Shift + Tab
Previous Record	Up Arrow Key
Previous Block	Shift+PageUp
Scroll Down	PageDown
Scroll Up	PageUp
Up	Up Arrow Key
Down	Down Arrow Key
Print	Ctrl + P
Exit	F4
Help	Ctrl + H
Block Menu	Ctrl + B
Display Error	Shift + Ctrl + E

 Thanks for reading the post and congratulation on your success.

Part 1 || ORA-06512: at "SYS.UTL_HTTP", line 1130 ORA-24247: network access denied by access control list (ACL)

As salamualikum (islamic greetings), brothers and sisters. :)

  Hope you are well with the grace of Almighty Allah (swt)

If you confirm about creating Oracle Database ACL (Access Control List ) for 11g and higher,

and getting following error for calling a web service or web address, then this solution if for you.

Error

Error starting at line : 1 in command -
begin
PROC_URL_CALL;
end ;
Error report -
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1130
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "HR.PROC_URL_CALL", line 8
ORA-06512: at line 2
29273. 00000 -  "HTTP request failed"
*Cause:    The UTL_HTTP package failed to execute the HTTP request.
*Action:   Use get_detailed_sqlerrm to check the detailed error message.
           Fix the error and retry the HTTP request.

Where PROC_URL_CALL have the following code,

create or replace PROCEDURE PROC_URL_CALL AS

  l_url            VARCHAR2(500) := 'http://allieditbd.com';
  l_http_request   UTL_HTTP.req;
  l_http_response  UTL_HTTP.resp;
BEGIN
  -- Make a HTTP request and get the response.
  l_http_request  := UTL_HTTP.begin_request(l_url);
  l_http_response := UTL_HTTP.get_response(l_http_request);
  UTL_HTTP.end_response(l_http_response);
END;

and calling the procedure ,

begin
PROC_URL_CALL;
end ;

There is no error in the ACL creation, issue in the procedure where we set default value for url.

remove the http:// and add www.

Now the code will be

create or replace PROCEDURE PROC_URL_CALL AS

  l_url            VARCHAR2(500) := 'www.allieditbd.com';
  l_http_request   UTL_HTTP.req;
  l_http_response  UTL_HTTP.resp;
BEGIN
  -- Make a HTTP request and get the response.
  l_http_request  := UTL_HTTP.begin_request(l_url);
  l_http_response := UTL_HTTP.get_response(l_http_request);
  UTL_HTTP.end_response(l_http_response);
END;

Now run call the procedure

begin
PROC_URL_CALL;
end ;

and you will get

PL/SQL procedure successfully completed.

Thanks for reading the post and congratulation on your success.

Using In-process Reports Server causes FRM-41213 after system startup

After an installation/configuration of Oracle Forms and Reports (11gR1 or 11gR2), two reports servers are created:

•  In-process reports server (Runs inside WLS_REPORTS)
• Standalone reports server (Separate instance from WLS_REPORTS managed by OPMN)

If you have the in-process reports server (rep_wls_reports_hostname_asinst_1) configured for generating reports, there have been situations where after either WLS_REPORTS or the server/PC itself have been rebooted, running reports always generates FRM-41213 (Unable to connect to Report Server) errors.

There are two solutions which can be done:

• Using the standalone reports server (RptSvr_hostname_asinst_1)

1.  Go to your env file associated to your Forms application. 
2. Look for a variable called ‘APP_RS’ or ‘RSERV’. (If they do not exist, skip to step 4) 
3. Change the value of the variable from the in-process reports server to the standalone reports server. Save changes made in the file. 
4. If the reports server is referenced directly in your WHEN_NEW_FORM_INSTANCE trigger, you will need to make the change specified in step 3 in the form itself. Save and recompile the form.

 

• Starting the in-process reports server before using application (methods shown below)

1. Starting the in-process reports server through Enterprise Manager FMW Control 
2. Starting the server by URL: http://hostname:port/reports/rwservlet/startserver 
3. Calling anything in rwserver by URL (Example: Go to Showjobs at http://hostname:port/reports/rwservlet/showjobs)

If you choose to switch to the standalone reports server, it will always be running after starting up your system as all OPMN processes start automatically in Windows. The standalone reports server will be ready instantly as soon as all WebLogic servers are up and running.

Creating Domain Failed while Configuring Oracle Forms Instance 11gR2

As salamualikum (islamic greetings), brothers and sisters. :)

Hope you are well with the grace of Almighty Allah (swt).

You are planning to install Oracle Forms 11gR2 ( 11.1.2.2.0). :)

And you done all pre-requition task  before installing Oracle Forms 11gR2

Installation going on all the way fine but stuck at the point of configuration like bellow image

and said Domain creation failed.

??? What's the wrong I've done ? Don't worry, go to the log file indicated by the image arrow location and open it.
Go to the end and scrolling up.

If you see something like

XXX: adding task: oracle.as.install.classic.ca.standard.DomainProvisioningTask
  AdminServer port is 7001
  trying to connect to WIN-EJ826NJ1OBP 7001
  Creating Weblogic Domain.
oracle.as.provisioning.exception.ASProvWorkflowException
    at oracle.as.provisioning.weblogic.ASDomain._createDomain(ASDomain.java:2633)


WIN-EJ826NJ1OBP indicate Operating System Name

THEN it's the certainly issue of 
Oracle WebLogic NodeManager  service is started and you NEED to stop them to continue your setup.

Ok. Open Services (Windows)
Search for the named services and stop it.

Now Click on the Check box of First image and click RETRY

Wow... Configuration going on and Completed. Now start the NodeManager.

All the praises to Almighty Allah (swt)

Pray for me to Almighty Allah (swt) to keep it up and for my hereafter.

How to Read Image / Picture in Oracle Reports from File System ?

As salamualikum (islamic greetings), brothers and sisters. :)

Hope you are well with the grace of Almighty Allah (swt).

Today, i discuss an important issue, many of oracle developer spend hours and hours to make a reports to show image from file system, which is much complex.

From Now on, it will be easy and remain easy. :)

Follow the bellow steps.

1. Take a Formula column
2. Data Type Char
3. Length 500
4. Set READ FROM FILE property to YES
5. Set File Format to Image
6. Make the Image stored folder as Shared Folder

Example Code::

function CF_IMAGEFormula return Char is
  
  filename VARCHAR2(200);
  tiff_image_dir VARCHAR2(80) :='<PC_NAME>/emp_picture/'; --// Folder name should be shared for shared link.
    out_file Text_IO.File_Type;
BEGIN

out_file :=Text_IO.Fopen(tiff_image_dir||:EMP_CODE||'.jpg', 'r'); -- r is read only AND EMP_CODE is the name of image.

filename := tiff_image_dir||:EMP_CODE||'.jpg';
return filename;

exception
when no_data_found then
RETURN tiff_image_dir||'blank.jpg';

when others then
if sqlcode=-302000 then
RETURN tiff_image_dir||'blank.jpg';
end if; 

end;


 You are Done :)
Pray for me to Almighty Allah (swt) to keep it up and for my hereafter.

ORA-28001: the password has expired or ORA-28002 the password will expire within 7 days (Oracle Database Password Expired)

As salamualikum (islamic greetings), brothers and sisters. :)

Hope you are well with the grace of Almighty Allah (swt).

Today we talk on issue of Oracle Database password Expired issues show version 11g and on words.

What will you see ? 

Solution:: 

1. Connect to Database with SYS DBA.

For Example

C:\oraclexe\app\oracle\product\11.2.0\server\bin>SQLPLUS/NOLOG

SQL*Plus: Release 11.2.0.2.0 Production on Fri May 23 19:53:42 2014

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

SQL> CONN SYS/SYSTEM11g AS SYSDBA

2. Execute the following query
3. Sql > select * from dba_profiles;

You will see something like bellow… (Shortened)

1.  PROFILE              RESOURCE_NAME             RESOURCE LIMIT

2.  -------------------- ------------------------- -------- ---------------

3.  DEFAULT              FAILED_LOGIN_ATTEMPTS     PASSWORD 10

4.  MONITORING_PROFILE   PASSWORD_LIFE_TIME        PASSWORD DEFAULT

5.  DEFAULT              PASSWORD_LIFE_TIME        PASSWORD 180

6.   

7.  PROFILE              RESOURCE_NAME             RESOURCE LIMIT

8.  -------------------- ------------------------- -------- ---------------

9.  MONITORING_PROFILE   PASSWORD_REUSE_TIME       PASSWORD DEFAULT

10.DEFAULT              PASSWORD_REUSE_TIME       PASSWORD UNLIMITED

11. 

12.32 rows selected.

4. Here PASSWORD_LIFE_TIME field is responsible for expiring of password after 180 days.

5.  Execute following command to disable this feature:
6. Sql> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; 

7. Now crosscheck for disabling of this feature.
8. Sql > select * from dba_profiles;

9. The value in PASSWORD_LIFE_TIME has changed to unlimited. Now password will never expire.

 You are almost DONE

 Now reset the password of locked user. 
Here are two options to reset password. 
Either you can keep same password or you can give a new password.

One is..

 

 You are Done :)

Pray for me to Almighty Allah (swt) to keep it up and for my hereafter.