All posts by Rajat
continuation of last post upgradation from 10.2.0.1 to 10.2.0.2 in E-Business Suit
Introduction We need to install the 10.2.0.2 software only follow my last post , the process remain same. Up gradation of Oracle Database on Sun OS using catupgrd.sql is same as like other catupgrd.sql on other platforms. The only difference lies in setting operating system parameters like kernel configuration, checking memory, disks and other resources. […]
Read MoreORACLE DATABASE UPGRADATION 9.2.0.6 TO 10GR2 ON SUNOS AND ORACLE E-BUSINESS SUIT 11.5.10.2
Oracle E –Business suit 11.5.10.2 does not work with the database 10.2.0.1 so we need to upgrade the database to the next patch set level 10.2.0.2 Next post following this one is about upgradation from 10.2.01. to 10.2.0.2 . Introduction Upgradation of Oracle Database on Sun OS using DBUA is same as like other […]
Read MoreHow to check Corruption in Database Using DBVERIFY
The primary tool for checking for corruption in an Oracle database is DBVERIFY. It can be used to perform a physical data structure integrity check on data files whether the database is online or offline. The big benefit of this is that DBVERIFY can be used to check backup data files without adding load to […]
Read MoreOracle Advanced Supply Chain Planning (ASCP)multi node implementation
Oracle Advanced Supply Chain Planning (ASCP) is a comprehensive, Internet-based planning solution that decides when and where supplies (for example, inventory, purchase orders and work orders) should be deployed within an extended supply chain. This is the supply planning function. Oracle ASCP addresses the following key supply planning issues: • How do I plan my […]
Read MoreSharing File System between SunOS Servers
Servers: Indapp001 and Usaapp002 To do: To mount “/export/home” of Indapp001 on Usaapp002. Issue the following commands on Indapp001: 1. Share the required file system “/export/home” of Indapp001. Start the nfs server on Indapp001. # svcadm enable network/nfs/server 2. Share the “/export/home” of Indapp001 for everyone on the network. #share -F nfs -o rw -d […]
Read MoreHow to Change Apps Password in 11i, if you forget ?
We need to change apps password manually, if you forgot and can’t check it in wdbsvr.app at $IAS_ORACLE_HOME/Apache/modplsql/cfg . Please remember that the APPLSYS and APPS passwords always have to be the same. Always change both at the same time. When changing these passwords, it is important to change the APPLSYS password first and the APPS later. […]
Read More