Monday, 31 October 2011

WEB ADI - issues encountered during initial access

On accessing create document link under Desktop Integrator responsibility browser was showing following error


Set BNE UIX Physical Directory profile value to proper directory at site level


Location = $COMMON_TOP/html/cabo/  (11i)
Location = $COMMON_TOP/webapps/oacore/html/cabo/  (R12)


As this was a cloned instance the value of this profile setting was pointing to a wrong location.

set as
BNE UIX Physical Directory /u03/oracle/prodcomn/html/cabo/

Access to functions are controlled by function security so to access and work with web adi the user should have proper access.

You should have access to particular integrator to access and work with it

Find out responsibility which is created to work with web adi check the main menu for this responsibility. Modify the responsibility or Menu if default is not fitting to your needs.


For instance Desktop Integration Menu has create document, Define Lay out, Define Mapping, Manage Documents, Setup options

Note : you must add "HR ADI Seeded Integrator Form Functions" sub menu to your menu(s) to access the seeded integrators for HRMS from the application, if you don’t add this menu you are going to run in to following error (see metalink note : 240142.1)



Assign this responsibility to the user who wants to use WEB ADI




The below error kept coming on browser once we click create document, We tried to create web a document using oracle supplied Integrator "General Ledger – Journal"

Once we click create document a popup will come for downloading and opening that document wend will end up with the following error




bne error log:


10/30/11 2:11 PM WARNING BneUserLocaleUtils.getTimeZone CLIENT_TIMEZONE_ID has not been set

10/30/11 2:11 PM WARNING BneSitePropertyManager.setValuesFromBneProperties - loading values from properties file

10/30/11 2:11 PM WARNING BneSitePropertyManager.setValuesFromBneProperties - end

Setting these profile values at site level was not solving this problem.

So further rnd lead to this conclusion, to fix this issue add application site address to trusted sites in internet explorer. We were using internet explorer 7

If the check box "Require server verification(https:) fro all sites in this zone" is checked your site address should be secure (https) , check if it is uncheck if you are not able to add to

List of Errors at a glance



  • Exception Name: oracle.apps.bne.exception.BneFatalException - A system error has occurred. Have your system administrator view the bne.log file. Log File Bookmark: 432
  • You do not have permission to access this functionality
  • BneUserLocaleUtils.getTimeZone CLIENT_TIMEZONE_ID.
Oracle support Notes of interest :
 360105.1
888386.1
1312156.1

http://blogs.oracle.com/stevenChan/entry/webadi_dif_ebs
Oracle E-Business Suite Desktop Integration Framework Developer's Guide, Release 12.1 (Note 979354.1)



Sunday, 2 October 2011

Mounting Linux NFS on solaris 10 (RPC: Program not registered and Not owner errors)


NFS server is running on Redhat Linux machine 4E

IP of NFS server 192.168.1.251
share     /u01/nfs

mounting the above nfs on Solaris 10  (192.168.1.119)

mounting point on client /u01/nfstest

mount -F nfs 192.168.1.251:/u01/nfs /nfstest



the above command should mount the nfs share to /u01/nfstest on client

but after i issued the command i was getting

nfs mount: 192.168.1.251: : RPC: Program not registered

after searching i found this link http://www.softpanorama.org/Net/Application_layer/NFS/troubleshooting_of_nfs_problems.shtml#The_program_not_registered_Error

which was telling mountd deamon was not up on nfs server machine

started nfs service on nfs server

service nfs start


after starting issued the command to mount the nfs on solaris client

mount -F nfs 192.168.1.251:/u01/nfs /nfstest

this time another error

nfs mount: mount: /nfstest: Not owner

googling taught me that this was becuase of NFS version, linux is using version 3 but solaris is using version 4

I found two way of overcoming this issu

1. editig /etc/default/nfs file

you can change #NFS_CLIENT_VERSMAX=4 value to #NFS_CLIENT_VERSMAX=3

by default it is commented out so make sure you remove comment symbol
just restart the service, it is working even without restarting
svcadm restart  network/nfs/server

second way to mount is just to add -o switch with vers=3 parameter
mount -F nfs -o vers=3 192.168.1.251:/u01/nfs /nfstest

Friday, 23 September 2011

Keep Track Of Your Data Usage Calls and Text Messages on Android Mobiles


Your data line service provider is charging you more than you expected ! Here's the solution to keep track of your data usage , calls and text messages on Android.


http://www.addictivetips.com/mobile/how-to-check-android-data-usage-stats/

 I have tested this on IDEOS x5, it is running without any issues

Sunday, 18 September 2011

ORA-04043: object dba_tablespaces does not exist

If you try to describe any DBA_* views in mount state after opening database describing those views will give you ORA-04043 Object does not exist error.

Solutions:

Restart the database

Flush Shared pool with "alter system flush shared_pool"

References

http://kr.forums.oracle.com/forums/thread.jspa?threadID=557085
metalink note  296235.1








Saturday, 10 September 2011

RMAN-06136: ORACLE error from auxiliary database: ORA-01013: user requested cancel of current operation

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/09/2007 12:01:22
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database: ORA-01013: user requested cancel of current operation




At the end of duplication of database using rman duplicate command was giving the above error . It kept coming again and again whenever i tried to duplicate.


After a search on google i found that having another session with system user will cause rman to throw this error. I found myself having another session which i used to start up database in nomount mode was still in an active state. 


After closing that session and rerunning the duplicate command did the work successfully


 Helpful Link
http://www.orafaq.com/forum/t/78078/2/

Sunday, 28 August 2011

Configure Database Options and Delete Database option are greyed out (DBCA)

Database Configuration Assistant is not showing the database and  Configure Database Options and Delete a Database option are greyed out(disabled)

 after setting up ORACLE_SID and ORACLE_HOME running dbca is not showing the database and the above options are greyed out.

check the oratab file for correct entry for the database we are trying to access from dbca.

Give database name and database home path in the oratab file and save it

now run dbca to configure the database.






Sunday, 21 August 2011

Connecting to remote host with ssh without password - By passing ssh/scp password

go to the node from where you will be connecting [ source machine ]
run
ssh-keygen -t dsa or ssh-keygen -t rsa
this will generate public and private key when asked for file name and password just press enter so that default file will be created and password will be blank

now copy the .pub content to the target machine's authorized_keys file under [username]/.ssh/



ssh-copy-id  -i [pub_file_name] [username]@[targethostname] [it will ask for password to connect to target provide password for this time]

ex: ssh-copy-id  -i id_dsa.pub testuser@testserver

this command will copy the public key to the target machines user's authorised_keys file

location of the authorized_key file is - [user's home folder]/.ssh/



if the above command does not work copy the public key manually to target machine

add the copied public key to user's authorized_key file, if it does not exist just create one

ex: ssh-copy-id -i id_dsa.pub test@testserver

Note: ssh-copy-id command sets the permission properly. if its created manually ,Make sure the autorised_key file is with 600 permission. Other wise it will keep asking password.
Ex: -rw-------. 1 yoonus yoonus 611 Feb 23 00:49 authorized_keys



now connecting with ssh/scp  should not ask for password

Wednesday, 15 June 2011

FRM-902050: Failed to connect to the server: /forms/lservlet:-1

FRM-902050: Failed to connect to the server: /forms/lservlet:-1

Not able to access oracle e-business suite R12 forms from internet explorer . When any form link is clicked this error is thrown out.


\

Just add the address in local intranet zone's trusted sites zone

Do it this way (Internet explorer 8)

Tools>Internet Options>Security>Local Intranet > Sites > Advanced > Add - "add oracle applications address here"









Tuesday, 14 June 2011

Shrinking Vmware Workstation Disks on linux guests

This method describes doing it in Linux guest virtual machine, there is another method from host using vmware-vdiskmanager.

In the guest where you are trying to shrink, make sure VMware Tools is already installed.

To get vmware toolbox (which has many options including shrink)

run vmware-toolbox
ex: vmware-toolbox   
      or
/usr/bin/vmware-toolbox

run this command as root otherwise shrink option will not be enabled.

this will open a new window with shrink option, you can select the partitions you want to shrink and click on shrink.

Saturday, 23 April 2011

Configuring NFS


File sharing between to linux boxes with NFS

start nfs service on the server machine and client machine
Server : 192.168.1.2
Client:    192.168.1.1

service nfs start

edit /etc/exports file and add the location you want to share

this is the entry to be added to exports file to share a folder called test in home directory. (rw) will allow both read and write

folder_name_with_path host_name(options)
host_name is the name of the host(client IP or client hostname) from where you are going to mount this share

ex: if you want to share a folder called test in home folder to a client with ip address 192.168.1.1 do as below..

edit export file to add this entry (this is entered host server whose folder is actually shared)

on Server(192.168.1.2)

/home/test 192.168.1.1(rw)


go to cleint machine and start nfs service


then mount the nfs sharing

mount -t nfs -o rw nfs_server_name://folder_name_with_path mount_point

on Client(192.168.1.1)
mount -t nfs -o rw 192.168.1.2://home/test /testnfs

see man page of mount to see all the mount options.

now you can see the sharing as a folder in your own filesystem with read write permission

Friday, 22 April 2011

Io Error: Got minus one from a read call

When trying to connect using oracle sqldeveloper this error messages is thrown. I came across this error two times, on each occasion different cause.

1)  Make sure you are connecting to the correct port, wrong port also gives the error above.


2) This is happening becuase oracle is using ACL (access control list) where only authorised clients are given access.

check sqlnet.ora file ($ORACLE_HOME/network/admin)

tcp.validnode_checking = yes
tcp.invited_nodes=(ORACLE11I.mylearn.com)


we can either disable this checking

tcp.validnode_checking = no

or add the node in the acl.

tcp.invited_nodes=(ORACLE11I.mylearn.com,192.168.1.14)


bounce the listener and try connecting again

if oracle apps is using use addlnctl script to bounce it.






Saturday, 16 April 2011

Receipt account is created with wrong cash account – updating receipt class bank account cash field

Bank account for receiving was created with wrong cash account.

To resolve this issue there is no way to update cash account of bank account field in receipt class

Receivables > Setup > Receipt Classes > Bank Accounts


oracle suggested solution to use this account again in receipt is to create a new calss with proper accounts.

oracle doc ID = 1234022.1

End date the bank account in receivables classes (the account which is entered with wrong cash account).

create a new class

Add the bank accoun in the newly created class

take care for the effective dates of both classes and accounts. For account classes the effective date from can not be updated, it has to be deleted and recreated. The account can only be deleted if there is no related transactions


Sunday, 3 April 2011

excell,word and other programmes are not displaying charecters properly (Change the system locale )

Change the system locale
charecters for languages like arabic wont open properly. A csv file with arabic name list is opened in excel but excel is showing as junk charecters.

change the charecter set to your locale
 control paner > Regional and Language options > Administrative >change system locale

Select the system locale you want and click ok

The system will restart with newly selected language

http://windows.microsoft.com/en-US/windows-vista/Change-the-system-locale

Wednesday, 30 March 2011

FTP Client Access from an ISA Server Network

The error below were thrown out whenever we try to connect to an ftp site from our windows xp clients. Our clients are configured to access internet through ISA 200

"200 PORT command successful. Consider using PASV"



Solution

Article ID: 300641 - Last Review: May 24, 2010 - Revision: 8.0

http://support.microsoft.com/Default.aspx?kbid=300641



Related reads

http://technet.microsoft.com/en-us/library/bb794745.aspx (Troubleshooting Outbound FTP Access in ISA Server)

http://technet.microsoft.com/en-us/library/cc750609.aspx (FTP Client Access from an ISA Server Network)

Tuesday, 29 March 2011

Uninstalling VMware products from Linux

To uninstall vmware products from linux use vmware-installer script.

Go to > /usr/bin
the file is located there
linux # vmware-installer     -u      

ex: to uninstall vmware-workstation

linux #    vmware-installer -u vmware-workstation












Network Manager icon is not appearing on desktop after opensuse 11.4 installation


the icon for network manager is not appearing on panel.

this is becuase by default network is managed with traditional method with ifup, to change this we have to change it to user controlled network manager

Steps

go to yast > Network Devices > Network Settings > Global options

select User controlled with NetworkManager

by default traditional method with ifup is selected

once you did that network manager icon will be added to panel, now you can set up your network using this from your desktop

Saturday, 12 March 2011

Installing nvdia driver on linux


Downolad nvidia driver from nvdia website
stop xserver
to do this restart with init 3
or edit /etc/inittab file to change runlevel to 3 then restart
if nouveau driver is used nvida will detect (we can manually disable this refer nvidia readme) this at installation and add an entry in
/etc/modprobe.d/nvidia-installer-disable-nouveau.conf
the entries in the file will be
blacklist nouveau
options nouveau modeset=0

this will disable nouveau but if os is taking  this at boot level this wont be enough to disable,
to disable this at boot level we have to edit boot configuration file to add an entry there or

at the time of booting press e and go to kernel line and add this at the end

rdblacklist=nouveau

this will disable nouveau at boot level also


go to /etc/Xorg and take a back up of xorg.conf file (incase if installation fails we can just restore and bring back the system to old condition)
now go to the folder where nvdia driver is stored and run

sh

nvdia installer will run and it will prompt for many inputs from us

once installed restart the pc with run level 5

go and edit /etc/inittab to make it to 5

remeber if you disabled nouveau at boot prompt with rdblacklist=nouveau you have to do the same thing here but its difficult to do here everytime so go and edit grub/grub.conf

append rdblacklist=nouveau to the kernel line


incase failed remove the nvidia-installer-disable-nouveau.conf from /etc/modprobe.d/ and replace the old xorg.conf file