Posts

Showing posts from 2011

WEB ADI - issues encountered during initial access

Image
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

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

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

ORA-04043: object dba_tablespaces does not exist

Image
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

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/

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.

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 comm

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

Image
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"  

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.

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:

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. http://forums.oracle.com/forums/thread.jspa?threadID=431151

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

Image
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

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

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)

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 Step s 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

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