Monday, December 1, 2014

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.

Friday, November 14, 2014

How cat Learn to Hunting Rat ?

Just a little Fun.
With my Cat's Family. "Tiger" & "Fighter" (little one)

Hope get some fun.

Off topic :)

Tuesday, October 28, 2014

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.

Wednesday, October 22, 2014

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

  1. Execute the following query
  2. 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.

  1. Here PASSWORD_LIFE_TIME field is responsible for expiring of password after 180 days.
  1.  Execute following command to disable this feature:
  2. Sql> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; 
  1. Now crosscheck for disabling of this feature.
  2. Sql > select * from dba_profiles;
  1. 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.