Feb 26, 2013
Upgrade Oracle database from 10.2.0.1 to 10.2.0.4
1.3K

Upgrade Oracle database from 10.2.0.1 to 10.2.0.4

Oracle Database Upgrade from 10.2.0.1 to 10.2.0.4 Oracle Database 10g Release 2 (10.2.0.4) Patch Set 3 Installation steps: 1)This is not a complete software distribution. You must install it in an existing Oracle Database 10g Oracle home. To identify Oracle home directories, view the/etc/oratab file. 2)Oracle Database List of Bugs Fixed,...
Oct 19, 2012
ORA-39001:ORA-39000:ORA-39142
12.8K

ORA-39001:ORA-39000:ORA-39142

Error ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-39142: incompatible version number 3.1 in dump file “/bds/app/oracle/product/cedb/10.2.0/admin/cdprod/dpdump/tables236351_01.dmp” Solution Import 11g data dump into 10g You can use Oracle data dump to export data dump from 11g server, and import into 10g using the data Pump parameter called Version....
Jul 26, 2012
Oracle Process Limit exceeds
1.4K

Oracle Process Limit exceeds

ORA-00020: maximum number of processes (150) exceeded ORA-12520: TNS:listener could not find available handler for requested type of server: arithmetic syntax error   When you get this error, check what is the limit for database process and how many connections are already established:  If processes reached to the limit, database...
Jul 13, 2012
How to change the password of a DB Link in Oracle
2.9K

How to change the password of a DB Link in Oracle

How to change the password of a DB Link in Oracle? Alter Database Link to Change Password Sometimes, when we use alter database link command, it will show below error: SQL> ALTER DATABASE LINK APPS_SME.SAMPLE.COM CONNECT TO hr IDENTIFIED BY hr; ALTER DATABASE LINK APPS_SME.SAMPLE.COM CONNECT TO hr IDENTIFIED BY...
May 23, 2012
Kill LOCAL=NO Processes at one go
3.2K

Kill LOCAL=NO Processes at one go

Kill LOCAL=NO Processes at one go Whenever you are trying to shutdown the database, sometimes it will hang up in the process of shutdown. At that time, open another terminal and grep for LOCAL=NO processes “ps -ef|grep LOCAL” Output oracle 3747948 1 0 Apr 27 – 0:00 INSTANCENAME (LOCAL=NO) oracle...
May 23, 2012
ORA-04031: unable to allocate 4080 bytes of shared memory
1.1K

ORA-04031: unable to allocate 4080 bytes of shared memory

ORA-04031: unable to allocate 4080 bytes of shared memory This is very common error in Oracle Whenever you get below error, try to flush the shared pool with this command “alter system flush shared_pool”.  It doesn’t have any impact on performance of the database. “java.sql.SQLException: ORA-04031: unable to allocate 4080...
May 23, 2011
Oracle DB Upgrade from 9.2.0.6 to 10.2.0.2
538

Oracle DB Upgrade from 9.2.0.6 to 10.2.0.2

Oracle DB Upgrade from 9.2.0.6 to 10.2.0.2 Patching before Upgrading Database from 9.2.0.6 to 10.2.0.2 Step-1 Apply Developer 6i Patchset version 19. Step-2 Apply TXK (FND & ADX) AUTOCONFIG ROLLUP PATCH p9535311_11i_LINUX.zip Generate appsutil.zip and ftp to RDBMS OH. unzip and run autoconfig Features & Enhancements Step-3 Apply AD.I.7 Patch...
May 11, 2011
Why excessive redo during Hot Backup
661

Why excessive redo during Hot Backup

What will happen when you put database in begin backup mode? Why excessive redo during Hot Backup?? Why fractured blocks will occur when database in begin backup mode? When you put the db in backup mode, Oracle will take a checkpoint and update the datafile headers with checkpoint SCN and...