desc dba_views does not exist in database open stage

While you issued this dba_*  dictionary views on database mount

SQL> alter database mount;

Database altered.

SQL> desc dba_views;
ERROR:
ORA-04043: object dba_views does not exist

After database opened

SQL> alter database open;

Database altered.

SQL> desc dba_views;
ERROR:
ORA-04043: object dba_views does not exist

Don’t issue this command on database mount stage

Restart the database normal

or

SQL> alter system flush shared_pool;

System altered.

SQL> desc dba_views;
Name Null? Type
—————————————– ——– —————————-

OWNER (more...)

ORA-29701: unable to connect to Cluster Synchronization Service

I try to restart asm service, it shows below error

C:\app\mazar\product\11.2.0\grid\BIN>sqlplus / as sysasm

SQL*Plus: Release 11.2.0.1.0 Production on Tue Jan 14 11:14:10 2014

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

Connected to an idle instance.

SQL> startup
ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service

C:\app\mazar\product\11.2.0\grid\BIN>crsctl start resource ora.cssd
CRS-4639: Could not contact Oracle High Availability Services
CRS-4000: (more...)

How do i check versions of *.fmb?

 

[appltrng@ebsdev ~]$ strings -a /u02/backup/appltrng/apps/apps_st/appl/au/12.0.0/forms/US/GLXCORUN.fmb | grep Header
FDRCSID(‘$Header: APPSTAND.fmb 115.33 2002/04/04 11:13:40 pkm ship $’);
$Header: APPSTAND.fmb 115.33 2002/04/04 11:13:40 pkm ship $
FDRCSID(‘$Header: GLXCORUN.fmb 120.34.12010000.1 2008/07/28 05:17 appldev ship $’);
$Header: GLXCORUN.fmb 120.34.12010000.1 2008/07/28 05:17 appldev ship $
[appltrng@ebsdev ~]$ adident Header /u02/backup/appltrng/apps/apps_st/appl/au/12.0.0/forms/US/GLXCORUN.fmb
/u02/backup/appltrng/apps/apps_st/appl/au/12.0.0/forms/US/GLXCORUN.fmb:
$Header APPSTAND.fmb 115.33 2002/04/04 11:13:40 pkm ship $
$Header APPSTAND.fmb 115.33 2002/04/04 11:13:40 pkm ship $
$Header GLXCORUN.fmb 120.34.12010000.1 2008/07/28 05:17 appldev ship $
$Header GLXCORUN.fmb 120.34.12010000.1 2008/07/28 05:17 appldev ship $


Is any email configuration required for Oracle Alert manager?

Yes. If once you email configured on workflow notification mailer, It will automatically send alert mail to you .No need to configure in oracle alert manager mail server options.

So please check it, Whether workflow notification mailer running or not.


Increase space in Linux Volumegroup while running linux in vmware

If you like to increase space in linux volume group, you can do it on while machine up.

Afer added harddisk on existing hard disk. you can’t identify that hard disk on machine. So in this case you need to rescan the hard disk using below command.

$echo ’1′  > (more...)

Clear memory cache in linux

The below command will remove cache memory

 sudo sh -c “sync; echo 3 > /proc/sys/vm/drop_caches” 

 

 

 


How do i delete all files older than six days in linux

Use this command

[applprod@ebs ~]$ find access_log*  -mtime +6 | xargs rm -rf

 

 


EBS list of username with responsibility

select d.full_name,a.USER_NAME USER_ID, a.EMPLOYEE_ID, c.RESPONSIBILITY_NAME
from apps.FND_USER a, apps.FND_USER_RESP_GROUPS b, apps.FND_RESPONSIBILITY_VL c, apps. per_all_people_f d
where a.USER_ID=b.USER_ID and b.RESPONSIBILITY_ID=c.RESPONSIBILITY_ID and a.employee_id=d.person_id and sysdate between d.effective_start_date and d.effective_end_Date group by a.USER_NAME,a.EMPLOYEE_ID,c.RESPONSIBILITY_NAME,d.full_name order by a.USER_NAME


delete responsibility for user EBS

If you want to delete responsibility for user, you can’t delete the responsibility filed in user define forms.

See this forum thread for more detail

You can able to disable the responsibility using end date field.

System Administrator –> Security –> User –> Define — > query the user (F11, Ctrl+F11)

ebs


OBIEE 11.1.1.7.0

OBIEE 11.1.1.7.0 was released earlier this week . So this is the time to upgrade your OBIEE to higher version.

Refer this site for upgrade