Skip to content

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 NOT NULL VARCHAR2(30)
VIEW_NAME NOT NULL VARCHAR2(30)
TEXT_LENGTH NUMBER
TEXT LONG
TYPE_TEXT_LENGTH NUMBER
TYPE_TEXT VARCHAR2(4000)
OID_TEXT_LENGTH NUMBER
OID_TEXT VARCHAR2(4000)
VIEW_TYPE_OWNER VARCHAR2(30)
VIEW_TYPE VARCHAR2(30)
SUPERVIEW_NAME VARCHAR2(30)
EDITIONING_VIEW VARCHAR2(1)
READ_ONLY VARCHAR2(1)

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: Command Start failed, or completed with errors.

Enable HAS

C:\app\mazar\product\11.2.0\grid\BIN>crsctl enable has
CRS-4622: Oracle High Availability Services autostart is enabled.

C:\app\mazar\product\11.2.0\grid\BIN>crsctl start has
CRS-4123: Oracle High Availability Services has been started.

C:\app\mazar\product\11.2.0\grid\BIN>crs_stat -t
Name Type Target State Host
————————————————————
ora.DATA.dg ora….up.type ONLINE ONLINE trai…6-pc
ora….ER.lsnr ora….er.type ONLINE ONLINE trai…6-pc
ora.asm ora.asm.type ONLINE ONLINE trai…6-pc
ora.asmdb.db ora….se.type ONLINE ONLINE trai…6-pc
ora.cssd ora.cssd.type ONLINE ONLINE trai…6-pc

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:22:54 2014

Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Automatic Storage Management option

SQL> select status from v$instance;

STATUS
————
STARTED

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′  > /sys/class/scsi_disk/0:0:2:0/device/rescan

Suppose to be you’re added that hard disk after shutdown the machine. No need to rescan that harddisk

My case I shutdown the machine and added that hard disk in vmware workstation ( note: I think workstation you can’t expand hard disk while machine running)

Step 1:

Check Hard disk and space

[root@localhost dev]# df -h

Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
23G 2.9G 19G 14% /
/dev/sda1 99M 13M 82M 14% /boot
tmpfs 502M 0 502M 0% /dev/shm

Step 2:

[root@localhost dev]# fdisk sda

The number of cylinders for this disk is set to 3916.
There is nothing wrong with that, but this is larger than 1024,
and could in certain setups cause problems with:
1) software that runs at boot time (e.g., old versions of LILO)
2) booting and partitioning software from other OSs
(e.g., DOS FDISK, OS/2 FDISK)

Command (m for help): p

Disk sda: 32.2 GB, 32212254720 bytes
255 heads, 63 sectors/track, 3916 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
sda1 * 1 13 104391 83 Linux
sda2 14 2610 20860402+ 8e Linux LVM
sda3 2611 3263 5245222+ 8e Linux LVM

Step 4:

Here Note the Last Cyclinder value is 3263. So your new partition should be start from Last Cyclinder value + 1 like 3264

Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Selected partition 4
First cylinder (3264-3916, default 3264):
Using default value 3264
Last cylinder or +size or +sizeM or +sizeK (3264-3916, default 3916):
Using default value 3916

Command (m for help): t
Partition number (1-4): 4
Hex code (type L to list codes): 8e
Changed system type of partition 4 to 8e (Linux LVM)

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.

WARNING: Re-reading the partition table failed with error 16: Device or resource busy.
The kernel still uses the old table.
The new table will be used at the next reboot.
Syncing disks.

Step 6:

No need to reboot If you use this below command

[root@localhost dev]# partprobe -s

/dev/sda: msdos partitions 1 2 3 4

Step 7:

[root@localhost dev]# vgextend VolGroup00 /dev/sda4
No physical volume label read from /dev/sda4
Physical volume “/dev/sda4″ successfully created
Volume group “VolGroup00″ successfully extended
[root@localhost dev]# lvextend /dev/VolGroup00/LogVol00 /dev/sda4
Extending logical volume LogVol00 to 27.91 GB
Logical volume LogVol00 successfully resized
[root@localhost dev]# resize2fs /dev/VolGroup00/LogVol00
resize2fs 1.39 (29-May-2006)
Filesystem at /dev/VolGroup00/LogVol00 is mounted on /; on-line resizing required
Performing an on-line resize of /dev/VolGroup00/LogVol00 to 7315456 (4k) blocks.
The filesystem on /dev/VolGroup00/LogVol00 is now 7315456 blocks long.

Step 8: Check the hard disk size now

[root@localhost dev]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
28G 2.9G 23G 12% /
/dev/sda1 99M 13M 82M 14% /boot
tmpfs 502M 0 502M 0% /dev/shm

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

Follow

Get every new post delivered to your Inbox.

Join 122 other followers