REP 501 error show when view report in Oracle Fusion Middleware Service

 That is not application server problem. You just follow below process and overcome this unwanted error.

#############################################################################

Login Your Database Server.Then

#sqlplus sys as sysdba

Run Below command.

sql> alter system set sec_case_sensitive_logon=FALSE;


Then Restart your application server and start all service.

ENJOY

Reports Service Down Problem

If your Oracle Fusion Middleware Report  service down problem arise follow below process.

#######################################################################
Stop WLS_REPORTS and opmnctl Sevice.

For Windows:

Search rwnetwork.conf file 

For Linux

#locate rwnetwork.conf

This command show all rwnetwork.conf file in Oracle Fusion Middleware.

Open all file one by one.Then follow.

Search Below Two Line.

<multicast channel="228.5.6.7" port="14021" timeout="1000" retry="3"/>

<!--namingService name="Cos" host="mymachine.mydomain.com" port="14021"/-->

Then modify first line like.

<!--multicast channel="228.5.6.7" port="14021" timeout="1000" retry="3"/-->  (Disable Multicast process)

Modify Second Line.

<namingService name="Cos" host="host name" port="14021"/>

host name= your computer name (Windows) linux host name.

Do this things in all rwnetwork.conf file.

Then Start WLS_REPORTS, namingservice and opmnctl all.

ENJOY

Charecter set (UTF8) in oracle Database

If you want to show Bangla  to your website from database.you must set utf8 character to your Database. The process of setting utf8 character to Database:

First. 
#Sqlplus sys as sysdba
sql>Shutdown immediate;

Second.
#Sqlplus sys as sysdba
sql>startup mount;

Third.
sql>alter system enable restricted session;

Four.
sql>alter database open;

Five.
sql>ALTER DATABASE CHARACTER SET INTERNAL_USE UTF8;

ENJOY.

Welcome to my Blog

Hello 

I am Imran Hussain Heron from Bangladesh.I have been working on a software firm for 2 years. i share my knowledge and practical experience both.Please pray for me.Read my blog regularly.

Thanks.

Md. Imran Hussain Heron

RHCE, RHCSA,ORACLE DBA,ORACLE APPLICATION