Showing posts from 2011

prerequisites to install oracle Database 11g , 10g

2011 New start For Everything


It's One Of the Most Amazing Year ...Nothing was usual Sadness , happiness , Pressure , failure and successfully moment.

I start Blogging In January 2011 to share my knowledge with people who wants to learn more about Oracle
and here i am Writing in the end of this year to finish what i started . this year include lot of memories and decision i had made ,some of them wrong , some of them right , but as one of these decision was one of the biggest mistake i ever did in my life , i don't love to regret on something i did but the only thing that's makes me feel good about that decision that i met new people who let you feel good all the time .

I learned new things in oracle , give me motivation to continue my career as Oracle Database Administrator this Job , its more than a job to me , as you know there's lot of blog on the internet ,i wish to make this blog very useful for all people who wants to learn something new . i am always here to help,teach and learn from…

How To Secure/Unsecure your Oracle Application Server 10g

Regarding To Oracle Support Document Please Follow the below steps to Secure and Unsecured Oracle AS

Secure Oracle AS 10g :
1.Stop iasconsole
emctl stop iasconsole
2.Secure iasconsole 
emctl secure iasconsole
3.Start iasconsole 
emctl start iasconsole U

Unsecuring Oracle AS 10g 1.Stop iasconsole
emctl stop iasconsole

2.Update Oracle As Console StandAlone OC4J to support unsecure port :



3.In same File 

<ssl-config needs-client-auth="true" keystore="server/keystore.test" keystore-password="%EMD_KEYSTORE_PASSWORD%" />


<ssl-config needs-client-auth="false" keystore="server/keystore.test" keystore-password="%EMD_KEYSTORE_PASSWORD%" />

4.Update AS Console Local Management Agent to support the unsecure HTTP protocol.
The EMD_URL property in


Best Data Center "IRONIC"


Install Oracle Application Server 10g R2 On RHEL 4

Installation Steps For Oracle Application Server 10g R2 On Linux Redhat 4 Update 6
(for people who wonder You can't install it on RHEL 5 ).

Installation Steps :  Pre-Installation Task

1) Check the required packages are installed in OS or not. glibc-2.3.4-2.9
you can check the status of package using rpm -qa | grep command. as a root user.
2) Add following in /etc/sysctl.conf
kernel.shmall = 2097152
kernel.shmmax = 4347483648
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 256 32000 100 142
fs.file-max = 201072
net.ipv4.ip_local_port_range = 10000 65000
kernel.msgmni = 2878
kernel.msgmax = 8192
kernel.msgmnb =…

How to recreate DBA roles if accidently drop?

VERSION 7.X:   From Server Manager, logged in as internal or sys, run the following commands:

         SVRMGRL > create role dba;
        SVRMGRL > grant all privileges to dba with admin option;

VERSION 8.X:   From SQL*Plus or Server Manager, logged in as internal or sys, run the   following commands:   

SQL > create role dba;       
SQL > grant all privileges to dba with admin option;       
SQL > grant select_catalog_role to dba with admin option;       
SQL > grant execute_catalog_role to dba with admin option;       
SQL > grant delete_catalog_role to dba with admin option;

Explanation:  ============    
The DBA role is created at database creation time by the "sql.bsq" script. (The "sql.bsq" script is typically found in the $ORACLE_HOME/dbs or the $ORACLE_HOME/rdbms/admin directory.)  Additional grants are made to dba through other scripts in the admin directory.  For example, exp_full_database  and imp_full_database in catexp.sql.…

How to check default temporary tablespace

COLUMN property_name FORMAT A30
COLUMN property_value FORMAT A30
COLUMN description FORMAT A50

SELECT * FROM database_properties WHERE property_name like '%TABLESPACE';

short topic but hope it will be useful
Thank you
Osama Mustafa

Backup an entire hard disk using dd command

The ' dd ' command is one of the original Unix utilities and should be in everyone's tool box. It can strip headers, extract parts of binary files and write into the middle of floppy disks; it is used by the Linux kernel Makefiles to make boot images. It can be used to copy and convert magnetic tape formats, convert between ASCII and EBCDIC, swap bytes, and force to upper and lowercase. 
# dd --help
full hard disk copy

dd if=/dev/hdx of=/dev/hdy
dd if=/dev/hdx of=/path/to/image
dd if=/dev/hdx | gzip > /path/to/image.gz

Hdx could be hda, hdb etc. In the second example gzip is used to compress the image if it is really just a backup.

Restore Backup of hard disk copy

dd if=/path/to/image of=/dev/hdx

gzip -dc /path/to/image.gz | dd of=/dev/hdx

MBR backup

In order to backup only the first few bytes containing the MBR and the partition table you can use dd as well.

dd if=/dev/hdx of=/path/to/image coun…

Upgrade to - APPS DBA

On each application tier server node,
shut down all server processes or services.

On the database tier server node,
shut down the database listener in the old Oracle home.

On the database server node,
as the owner of the Oracle 11g file system and database instance, unzip and extract the patch set file for your platform.

Use the runInstaller in the patchset to start the OUI.

Once the OUi starts from the LOV s in the Oracle_home list choose the appropriate one to be upgraded and the location also.

The present oracle_home and its location will appear if the environment is set correctly.

Proceed with the next steps on the OUI screen.

On next Screen it will Say Configuration Assistant has failed.Skip this Step since its not required for Oracle E-Business Suite .

After Installation you need toApply the RDBMS patches7486407 and 7684818

Copy $APPL_TOP/admin/adstats.sql from the administration server node to the database server node.

$ sqlplus / as sysdb…

steps to upgrade to

O.S : Linux 64Bit
the steps the same for all Database with different patch .
Database : (R1)

Let start upgrading :

1 - You need To install this patch
2-   Bring Down Database And Services Down And make sure it .
*Database :
sqlplus / as sysdba
SQL>shutdown immediate ;
$ps -ef | grep pmon "to make sure the database is not running"

Listener :
$lsnrctl status
$lsnrctl stop
$lsnrctl status

3-Just In case Take backup of your database .

4-unzip the patch , and run it under Oracle User 

Select the ORACLE_HOME to upgrade and then click next, the prerequisites steps will complete last click INSTALL. At the end up the installation it will ask to run as root user. We need root user password or sudo user privilege to run script.

5-After Upgrade do the following and its mandatory : 
cd $ORACLE_HOME/rdbms/admin
sqlplus  / as sysdba
SQL> startup upgrade;
SQL>spool pre_upgrade.log
SQL> @utlu111i.sql

What Kind Of DataCenter Below ?

Just Watch the below Picture and Dreaming to have one like this 

ORACLE Racing Wallpaper: Need a new image on your desktop ?