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
Posts from the ‘Uncategorized’ Category
Feb 16
Jan 14
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
Dec 17
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
Apr 8
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)
Apr 3
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.
Cannot open connection to FALSE The Synch Manager component on the server is most likely unavailable.
When I’m trying to configure local database extract for developers, After login of user, it shows below error
Unable to connect server
Cannot open connection to FALSE The Synch Manager component on the server is most likely unavailable.
I checked that appropriate component running or not, but its running
srvrmgr:siebsrvr01> list comp SynchMgr
SV_NAME CC_ALIAS CC_NAME CT_ALIAS CG_ALIAS CC_RUNMODE CP_DISP_RUN_STATE CP_STARTMODE CP_NUM_RUN_TASKS CP_MAX_TASKS CP_ACTV_MTS_PROCS CP_MAX_MTS_PROCS CP_START_TIME CP_END_TIME CC_INCARN_NO CC_DESC_TEXT
———- ——– ———————– ——– ——– ———– —————– ———— —————- ———— —————– —————- ——————- ———– ———— ————
siebsrvr01 SynchMgr Synchronization Manager SynchMgr Remote Interactive Online Auto 0 100 1 1 2013-03-27 15:07:24
1 row returned.
The problem is we need to edit the siebel tools tools.cfg file and changed the DockConnString parameter of local datasource
DockConnString = servername of siebel server running
