Friday, October 26, 2012

Installing Oracle Database 10g XE

In this post i will describe the step by step installation of oracle database 10g XE.

1) Run the setup.exe file to start the installation, Welcome screen appears click next.


2) Select the option i accept the terms in the license agreement.





 3) Choose the destination folder and click next.

4) Enter the Password for SYS/SYSTEM users and click next.

5)  Verify the installation summary and click install.





6) You can check the progress of installation.



7) Click finish,




Post Installation steps to configure the database to powerfully support the oracle SOA suite and oracle BPM suite.

1) open the command prompt and navigate to the directory.

    oraclexe\app\oracle\product\10.2.0\server\BIN and execute the below command to enter sql prompt.

sqlplus sys/welcome as sysdba
(provide the password for sys which was used while installation)



2) execute the command: show parameter sessions;

you can see the value of sessions is 49.


3) execute the command: alter system reset sessions scope=spfile sid='*';


4) execute the command: show parameter processes;
you can see the value of processes as 40.


5) execute the command: alter system set processes=300 scope=spfile;


6) Now restart the database.



7) Now check the sessions by executing the command: show parameter session;
 now the value of sessions are modified as 335


8) Now check the processes by executing the command: show parameter processes;
 now the value of processes is modified as 300





 






1 comment:

  1. Did you know there's a 12 word sentence you can communicate to your partner... that will induce deep feelings of love and instinctual appeal to you deep inside his chest?

    That's because deep inside these 12 words is a "secret signal" that fuels a man's instinct to love, treasure and look after you with his entire heart...

    12 Words Will Fuel A Man's Love Impulse

    This instinct is so hardwired into a man's genetics that it will drive him to work harder than before to love and admire you.

    As a matter of fact, triggering this all-powerful instinct is so important to getting the best possible relationship with your man that the instance you send your man one of these "Secret Signals"...

    ...You'll instantly find him open his mind and soul for you in a way he's never experienced before and he will recognize you as the one and only woman in the galaxy who has ever truly tempted him.

    ReplyDelete