Oracle Application DBA

Unable to mount NTFS file system in oracle enterprise linux 5 Applies to: Oracle Enterprise Linux 5.5 Database 11gR2 Description: I am using Oracle Enterprise Linux 5.5, I am trying to mount a NTFS file system USB drive on linux but unable to succeed and got the following error:   mount -t ntfs /dev/sdb1 /media/usbdrive/  mount: unknown filesystem type 'ntfs' Solution: After some research work I found that install the  FUSE and NTFS-3G packages  to resolve the issue. You can download the packages from: http://dag.wieers.com/rpm/packages/fuse-ntfs-3g/ http://packages.sw.be/fuse-ntfs-3g/ To check the package installed or not: rpm -qa |grep fuse To install the packages execute the folloiwng: rpm -ivh fuse-2.6.3-1.el4.rf.x86_64.rpm rpm -ivh fuse-ntfs-3g-2010.5.22-1.el5.rf.x86_64.rpm After successfull installation of packages I can mount the NTFS USB drive successfully: mount -t ntfs-3g /dev/sdb1  /media/usbdrive/

sqlplus: error while loading shared libraries: cannot restore segment prot after reloc: Permission denied Applies to: Oracle Enterprise Linux 5.5 Database 11gR1 Description: I am using Oracle Enterprise Linux 5.5 and install Oracle Database 11gR1. After successfull installation of OS and Database when I try to login database it give me the following error: sqlplus / as sysdba sqlplus: error while loading shared libraries: /d01/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1: cannot restore segment port after reloc: Permission denied Solution: Reason of the above error because of SELinux is running in ENFORCING mode, Oracle development has recommended the following workaround while they correct the problem. To check the mode execute the following command from root user: root> getenforce Enforcing Switch SELinux from the default “Enforcing” mode that it is running in, to the “Permissive” mode. root> setenforce 0 Now check

Requested URL/OA_HTML/AppsLogin was not found on this server Applies to: Oracle Enterprise Linux 5.5 Oracle Application Install - Version: 12.1.1 Database 11gR1 Description: I recently came across a problem  the login page was throwing an error - 404 /OA_HTML/AppsLogin was not found on this server. All services of Database and Listener working fine and get connected. All Application services started successfully without any error/warning on status 0, multiple time restart the services of application and database and also restart the whole machine but still facing the same problem. Solution: After some research work I have found the following solution: The Problem occurs because the wsrp_service.wsdl was owned by root but the services were being started by applmgr. Ensure that the permission of the file $ORA_CONFIG_HOME/10.1.3/j2ee/oacore/application-deployments/oacore/html/server-wsdl/wsrp_service.wsdl Shows that it is owned by root user. Somebody sta

APP-FND-01630, APP-FND-01662, cannot open .dbc file Applies to: I am using:  Oracle Enterprise Linux 5.5 Oracle Application Install - Version: 11.5.10.0 and later Database 11gR1 Description: I recently came across a problem after creating repository for Enterprise Manager of 11g, and unable to login the oracle application, facing the following errors: Solution: Locate the .dbc file and issue read/write permissions on it: cd $FND_SECURE chmod 777 TEST.dbc Your comments, especially which will help us improve the functionality, will be greatly appreciated :)

tmp folder 100 percent full in Linux Applies to: I am using:  Red Hat Enterprise Linux 5.5 Oracle Application Install - Version: 11.5.10.0 and later Description: I recently came across a problem where the /tmp folder was listed as 100% full: [root@prodapps01 ~]# df -h Filesystem            Size  Used Avail Use% Mounted on /dev/cciss/c0d0p2     9.7G  4.2G  5.1G  46% / /dev/cciss/c0d0p8     2.0G  152M  1.7G   9% /home /dev/cciss/c0d0p7     3.9G  3.9G  0M  100% /tmp /dev/cciss/c0d0p6     7.8G  334M  7.1G   5% /var /dev/cciss/c0d0p5      12G  3.2G  7.9G  29% /usr /dev/cciss/c0d0p1     494M   32M  437M   7% /boot Strangely, there were no files in the /tmp folder. This is how it happens. If you delete files from a folder and they still show up when you check a df -h disk status, then the deleted files are linked to currently running processes. You will have to stop or restart the processes that had those files open in the first place. lsof | g

Adapcctl.Sh: Exiting With Status 1 Applies to: Oracle Applications Technology Stack - Version: 11.5.10.2 Description: When attempting to stop Apache using adapcctl.sh, the following error occurs: ERROR Service can not be stopped using this script After doing some research work I found that the issue is caused by the following setup: $IAS_ORACLE_HOME/Apache/Apache/logs/ directory contained both httpd.pid and apache_runmode.properties Files httpd.pid and httpd_pls.pid gets created when Apache is started in NORMAL mode. File apache_runmode.properties gets created when Apache is started in RESTRICTED mode. As both kind of files are present in Logs directory, adapcctl.sh script thinks Apache cannot be started in both modes and fails to stop. Solution: To implement the solution, please execute the following steps: 1. Stop Apache / Kill all httpd processes if exists any. 2. Backup $IAS_ORACLE_HOME/Apache/Apache/logs 3. Delete all files under $IAS_OR

All Receiving Transactions Fail with rvtptcontrol Error Applies to: Oracle Application Install - Version: 11.5.10.0 and later. Oracle Inventory Management - Version: 11.5.1 to 12.1.3 Description: All Receiving transactions fail with rvtptcontrol. After some research work I found that the error occurs when many transactions fail with same error it is usually because the receiving executables (RVCTP and RCVOLTM) are out of sync. Solution: 1.       Resolve INVALID Objects 1.1   Set environment 1.2   cd $ORACLE_HOME/rdbms/admin 1.3   sqlplus / as sysdba 1.4   SQL>@utlrp.sql 2.       Relink Receiving executables 2.1   cd $AD_TOP/bin 2.2   sh adrelink.sh force=y ranlib=y "PO RCVOLTM" 2.3   sh adrelink.sh force=y ranlib=y "PO RVCTP" 3         Bounce Receiving Transaction Manager: 3.1   (System Administrator > Concurrent > Manager > Administer) 3.2   Deactivate Receiving Transaction Manager 3.3   ps -ef | grep

Adcfgclone.pl dbTier Failed: RC-00110 Applies to: Oracle Application Install - Version: 11.5.10.0 and later. Description: On Applications 11.5.10.2, when attempting to clone using rapidclone the following error occurs: ERROR: -------- Log file located at ORACLE_HOME/appsutil/log/$SID_$HOSTNAME/ApplyDBTechStack_22472575.log RC-00110: Fatal: Error occurred while relinking of ApplyDBTechStack \ 40% completed ERROR while running Apply... ERROR: Failed to execute $RDBMS_ORACLE_HOME/appsutil/clone/bin/adclone.pl-- Found the following in Cloning log file: dest : $ORACLE_HOME/oui/bin/runInstaller.sh backup : $ORACLE_HOME/oui/bin/runInstaller.sh to $ORACLE_HOME/appsutil//out/$SID_$HOSTNAME/runInstaller.sh DEBUG : The destination file does not have write permission $ORACLE_HOME/oui/bin/runInstaller.sh DEBUG : Changing the permission of the file failed AC-00444: Unable to write to file: java.io.FileNotFoundException: $ORACLE_HOME/oui/bin/runInstaller.sh (

ORA-19909: Datafile 1 belongs to an orphan incarnation  Applies to:  Oracle Database 10gR2 Description: I have faced the error ORA-19909 while creating physical standby database through RMAN backup. When start recovery MRP process terminated with error.After doing some research work I found the following solution: Solution: After some research I have found the following solution: The Problem occurs because the Primary Database has different incarnation with standby database. On the Primary site: Set environment > rman  target / RMAN> list incarnation; using target database control file instead of recovery catalog List of Database Incarnations DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time ------- ------- -------- ---------------- --- ---------- ---------- 1       1       PROD     143178490        PARENT  5988067599851 02-OCT-10 2       2       PROD     143178490        CURRENT 5988067601797 02

RESIZE REDO LOGS ON PRIMARY AND STANDBY Applies to:  Oracle Database 10gR2 Description: Need to increase the size of existing Redo Logs. In current environment there is one physical standby database. Solution: SQL> SELECT a.group#, a.member, b.bytes FROM v$logfile a, v$log b WHERE a.group# = b.group#;   SQL> select group#, status from v$log;       GROUP# STATUS ---------- ----------------          1 CURRENT          2 INACTIVE          3 INACTIVE   SQL> alter system switch logfile; SQL> alter system switch logfile; SQL> select group#, status from v$log;       GROUP# STATUS ---------- ----------------          1 INACTIVE          2 INACTIVE          3 CURRENT   -- To make primary redo log changes on primary and standbys: set -- STANDBY_FILE_MANAGEMENT to MANUAL so file changes not transferred to standby   SQL> alter system set STANDBY_FILE_MANAGEMENT=MANUAL scope=both; To stop Redo Apply, issue the following SQL statem

MRP: Background Media Recovery process shutdown on Physical standby Dataguard Applies to:  Oracle Database 10gR2 Description: RFS process successfully running, archive logs successfully shipped from Primary server to standby, but archive logs did not apply. MRP process going to shutdown automatically. After doing some research work I found the following solution: Solution: SQL> alter database recover managed standby database cancel; SQL> alter database recover managed standby database cancel; alter database recover managed standby database cancel * ERROR at line 1: ORA-16136: Managed Standby Recovery not active SQL> alter database recover managed standby database disconnect from session; Alert log: alter database recover managed standby database disconnect from session Sat Jun  9 09:51:56 2012 Attempt to start background Managed Standby Recovery process (PROD) MRP0 started with pid=18, OS id=6591 Sat Jun  9 09:51:56 2012 MRP0: