Apps DBA Workshop

Hi, The abnormal termination of sendmail process will bring the service in maintenance mode. I use command "pkill sendmail" for killing all sendmail process as there were thousands of junk mails were pending in a queue. Due to this there was a poor performance on apps 11i web application Sever. After killing sendmail with pkill and disabled sendmail service with svcadm command, after this cpu and memory holds by this processes were release and Server performance resumed to normal. After clearing the mail queue tried to enable sendmail but failed. It was still in maintenace mode. bash-3.00# svcs -p smtp STATE STIME FMRI maintenance Oct_12 svc:/network/smtp:sendmail To find the impact on service: bash-3.00# svcs -x vc:/network/smtp:sendmail (sendmail SMTP mail transfer agent) State: maintenance since Tue Oct 12 10:23:18 2010 Reason: Method failed repeatedly. See: http://sun.com/msg/SMF-8000-8Q See: sendmail(1M) See: /var/svc/log/network-smtp:sendmail

This article will be useful for Moving control file from Normal UNIX file system or any other file system to Oracle ASM. Moving control file from UFS to ASM: 1) Check the location of control file: SQL> select name from v$controlfile; NAME -------------------------------------------------------------------------------- /u01/11g_Home/oradata/db1/control01.ctl 2)check ASM Disk group: SQL> select state,name from v$asm_diskgroup; STATE NAME ----------- ------------------------------ MOUNTED ASMDATA1 3) Shutdown the database and startup in nomount SQL> shutdown normal Database closed. Database dismounted. ORACLE instance shut down. SQL> ---- startup database in nomount state: Connected to an idle instance. SQL> startup nomount ORACLE instance started. Total System Global Area 1720844288 bytes Fixed Size 2159024 bytes Variable Size 1241517648 bytes Database Buffers 469762048 bytes Redo Buffers 7405568 bytes SQL> 4

Hi, This article will be useful for Installing Oracle 11.2.0.2 grid Infrastructure for a standalone server. Oracle Database 11g Release 2 makes it easier to configure and incorporate many of the grid computing features that were only available in a Real Application Clusters (RAC) clustered database environment in previous releases for a single-instance Oracle database. This article will be useful for Installing Oracle 11.2.0.2 grid Infrastructure for a standalone server on Oracle Solaris 10 U9. 1) Download patchset from http://support.oracle.com p10098816_112020_SOLARIS64_3of7.zip 918M (963322837 bytes) Download The third zipped file contains the grid infrastructure software. 2) Make sure all the pre-requistes exists on the server. You need to have following patches and packages Installed on your server: pkginfo -i SUNWarc SUNWbtool SUNWhea SUNWlibC SUNWlibms SUNWsprot \ > SUNWtoo SUNWi1of SUNWi1cs SUNWi15cs SUNWxwfnt List of patches: 120753-06: SunOS 5.10: Microtasking libraries (l

Error encountered in step1 while Installing oracle E-Business suite R12.1.1 on Oracle Solaris 10 U9: Unzip Count:163 Processing Disk1.... RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported. Please make sure you have UnZip 5.X in your path and try again... Cannot execute Install for database ORACLE_HOME RW-50010: Error: - script has returned an error: 1 RW-50004: Error code received when running external process. Check log file for details. Running Database Install Driver for ebsdb instance Cause: The unzip utility 6.0 is not supported with the rapidwiz version 12.1.1.9, the default unzip utility present on the server is 6.0 Action plan: Download and Install patch p8639046_R12_GENERIC.zip to overcome this issue. --> Download patch p8639046_R12_GENERIC.zip and copy in R12 Stage area. --> unzip patch in stage R12 Stage directory "/R12_Stage" /R12_Stage bash-3.00$ ls oraAppDB oraDB oraiAS

This article will be useful for Installation of Oracle 11.2.0.2 on Latest available Oracle Soalris Update 9 Note: 11.2.0.2 (10098816) patchset comes with complete Installation. For this release we need not have to Install base release 11.2.0.1 software. The base release software is already included in software. Steps for Installation: 1) Donwload patchset 10098816 from http://support.oracle.com File Size p10098816_112020_SOLARIS64_1of7.zip 1.4G (1424340471 bytes) Download p10098816_112020_SOLARIS64_2of7.zip 1.0G (1069940891 bytes) Download p10098816_112020_SOLARIS64_3of7.zip 918M (963322837 bytes) Download p10098816_112020_SOLARIS64_4of7.zip 674M (707499195 bytes) Download p10098816_112020_SOLARIS64_5of7.zip 621M (651345204 bytes) Download p10098816_112020_SOLARIS64_6of7.zip 483M (506870319 bytes) Download p10098816_112020_SOLARIS64_7of7.zip 138M (144770887 bytes) Download The first two files contains RDBMS Software. 2) Unzip the files in a stage area. 3) Perform all pre-requisite s

Hi, When we install fresh installation of Solaris 10, then by default the service for rexec will be diabled and you couldn't login to sever with Xmanager software from client computer. The port 512 will not be able to listen any incoming request if rexec service is disabled. To check status of port: bash-3.00# netstat -an | grep '512' bash-3.00# If its not listening then it will not return any output. To check status of rexec service: bash-3.00# svcs rexec STATE STIME FMRI disabled 9:49:41 svc:/network/rexec:default bash-3.00# Enable rexec service: bash-3.00# svcadm enable rexec bash-3.00# svcs rexec STATE STIME FMRI online 10:20:26 svc:/network/rexec:default bash-3.00# Now check the status of port: bash-3.00# netstat -an | grep '512' *.512 *.* 0 0 49152 0 LISTEN 192.168.1.21.512 192.168.1.11.1833 64511 0 49680 0 ESTABLISHED *.512

Hi, After fresh Installation of 11.2.0.1 on Sun Solaris 10, sqlplus command was not working. When i am using sqlplus command after setting all valid environment variables getting error SP2-1503: Unable to Initialize oracle call interface. SP-0152: ORACLE may not be functioning properly. This is a know issue and provided in tech note SP2-1503 SP2-0152 with new 11.2 installation. Execute below steps: -> creating softlinks for timezone files. cd $ORACLE_HOME pwd /db/data/prod/11.2.0/oracore/zoneinfo ln -s timezone_11.dat timezone.dat ln -s timezlrg _11.dat timezlrg.dat After creating the soft links with these files sqlplus command is working properly. Tech Note: [ID 974515.1]

After upgrading datbase from version 10.2.0.4 to 11.2.0.1, i encountered Some issues. I encounter this issue while running autoconfig as post upgrade step. Error stack while running autoconfig: Updating Context file...COMPLETED Attempting upload of Context file and templates to database...ERROR: InDbCtxFile.uploadCtx() : Exception : Error executng BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;: 1; Oracle error -29532: ORA-29532: Java call terminated by uncaught Java exception: java.lang.NegativeArraySizeException has been detected in FND_GSM_UTIL.upload_context_file. oracle.apps.ad.autoconfig.oam.InDbCtxFileException: Error executng BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;: 1; Oracle error -29532: ORA-29532: Java call terminated by uncaught Java exception: java.lang.NegativeArraySizeException has been detected in FND_GSM_UTIL.upload_context_file. at oracle.apps.ad.autoconfig.oam.InDbCtxFile.uploadCtx(InDbCtxFile.java:281)