This post contains information about Installation procedure of Oracle Linux operating system.It is avialble in DVD format and also you can download it from this site edelivery.oracle.com

This note explains the information about how to access the Linux server which is in VMware work station from Windows Operating System using putty session. You can follow steps as bellow.

RPM(Red Hat Package Manager): RPM is software manager which can be used to build, install, query, verify, update, and uninstall individual software packages.

The following tables are keep on growing  a lot APPS_TS_TX_DATA and APPS_TS_TX_IDX.Moreover archive logs are hugly generating even though transactions are not running on instance.

This script is useful to run the autoconfig in test mode for knowing changes that will effect after next autoconfig run.It generates both html and text reports for viewing the current and changed information once you run this utility. These files are divided into two parts and each one contains the following information.

The following error was occurred in my oracle 11g database due to mount points are filled with lot of trace file.The error is as follows bellow.

The following post gives the information about how to change the all the frontend application users at a time  in 11i and R12 apps .This activity we do normally in the case of DEV and TEST instances for setting default one password for all users.

The following basic UNIX commands are useful for performing the operations on daily basis. The most of the commands are common here for all UNIX operating system flavours.

AD Relink is used to relink AD executables with the Oracle server product libraries for ensuring that they will keep functionality properly with the Oracle Database.This adrelink.sh located in $AD_TOP/bin in Applications File System.

Sql Query: COL FILE_NAME FOR A60 SET LINES 170 SET PAGES 200 SELECT TABLESPACE_NAME,FILE_NAME,BYTES/1024/1024, MAXBYTES/1024/1024,AUTOEXTENSIBLE FROM DBA_DATA_FILES WHERE TABLESPACE_NAME=’&TABLESPACE_NAME’ ORDER BY FILE_NAME ; Sample Output: Enter value for tablespace_name: SYSTEM TABLESPACE_NAME FILE_NAME BYTES/1024/1024 MAXBYTES/1024/1024 AUT ——————– ———————————————————— ————— —————— — SYSTEM /d01/mydb/PROD/db/apps_st/data/system01.dbf 1000 0 NO SYSTEM /d01/mydb/PROD/db/apps_st/data/system02.dbf 1000 0 NO SYSTEM /d01/mydb/PROD/db/apps_st/data/system03.dbf 1000 0 NO …