Skip to content

Posts from the ‘Uncategorized’ Category

Disable cache obiee 11g

You can able to disable the cache from Fusion middleware enterprise manager console. No need to manul edit in NQSConfig.ini file

http://machine:7001/em

Go to :

Business Intelligence –> coreapplication –> select Capacity Management tab –> Select Performance tab –> click “Lock and Edit configuration”  –> deselect the cache enabled –> apply –> activate changes

Restart the BI services

Enterprise Manager is not able to connect to the database instance

Solution :

check the sysman and dbsnmp account status, If expired, please activate
SQL> select username,account_status from dba_users where username =’SYSMAN’;

USERNAME ACCOUNT_STATUS
—————————— ——————————–
SYSMAN EXPIRED

SQL> select username,account_status from dba_users where username =’DBSNMP’;

USERNAME ACCOUNT_STATUS
—————————— ——————————–
DBSNMP OPEN

 

So sysman account has been expired.  Please activate with old password and also Please check if this account has been locked, please unlock this account.

 

SQL> alter user sysman identified by Admin123;

User altered.

SQL> select user,account_status from dba_users where username=’SYSMAN’;

USER ACCOUNT_STATUS
—————————— ——————————–
SYS LOCKED(TIMED)

SQL> alter user sysman account unlock;

User altered.

 

It will work after start the dbconsole

 

 

No Oracle instances were discovered do you want to enter one

While try to configure Backup exec agent in database server

“No Oracle instances were discovered do you want to enter one”

Solution:

add the instance value in /etc/oratab

Oracle 12c (12.1.0.2.0) database step by step installation guide on redhat linux 5.6

 

Download Document here

Oracle 12c database installation guide on redhat linux 5.6

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