GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  Scenarios
Go To First  |  Previous Question  |  Next Question 
 Scenarios  |  Question 15 of 25    Print  
What are the differences you have seen while installing Oracle on NT and Unix platform

  
Total Answers and Comments: 4 Last Update: October 27, 2007   
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: Ritesh Singh
 

Oracle Server = Oracle Instance + Oracle Database Oracle instance comprises of Background Process and memory structures in Unix all background processes are treated as independent processes but in windows all are combined together within oracle.exe in unix when a user logins he is dedicated to the server via an independed process so if require you can kill a process through os level ..this is one of the major advantage of using oracle on unix based system rather then windows system bcoz in case database stucks or hangs an independent process causing the problem can be killed and database will be made resumable immediately.

and one more diffrence is in windows you are require to create a service to start the instance by using oradim but in unix its not required .you can start the instance.in windows unique service name is required but in unix diffrent user can have the same service name started by them but its not advisable.

Regards

Ritesh Raj Singh

Database Administration Team

ICICI Ltd

Mumbai



Above answer was rated as good by the following members:
kn.reddy, bassem_farouk
June 24, 2006 05:24:43   #1  
Tejas Kulkarni        

RE: What are the differences you have seen while insta...
Oracle on UNIX platform is a process based concept and on windows it is thread based concept. So kernel parameter provided by UNIX OS are not sufficient setting of kernel parameter is required in case of UNIX whcih is not required in case of WINDOWS.
 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
July 07, 2006 10:48:41   #2  
Ritesh Singh        

RE: What are the differences you have seen while insta...

Oracle Server Oracle Instance + Oracle Database Oracle instance comprises of Background Process and memory structures in Unix all background processes are treated as independent processes but in windows all are combined together within oracle.exe in unix when a user logins he is dedicated to the server via an independed process so if require you can kill a process through os level ..this is one of the major advantage of using oracle on unix based system rather then windows system bcoz in case database stucks or hangs an independent process causing the problem can be killed and database will be made resumable immediately.

and one more diffrence is in windows you are require to create a service to start the instance by using oradim but in unix its not required .you can start the instance.in windows unique service name is required but in unix diffrent user can have the same service name started by them but its not advisable.

Regards

Ritesh Raj Singh

Database Administration Team

ICICI Ltd

Mumbai


 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
March 30, 2007 18:40:16   #3  
Chiranjeevi Manne        

RE: What are the differences you have seen while insta...
1. installing oracle on Windows is piece of cake which requires less DBA intervention.

2. While installing Oracle on Linux is a laborious process which involves in
a. creating the groups (oinstall oracle) required
b. creating the Oracle user who own the Oracle software directories and is a member of the groups previusly created.
c. Configuring Kernel parameters
d. Checking the network configuration.
e. configuring shell limits.
f. Checking the package requirements and installing the missing packages.
g. Creating the required mount points and fixing the ownership of all those mount points.

h. Fixing the environment variables of oracle user and installing oracle as Oracle user

 
Is this answer useful? Yes | NoAnswer is useful 2   Answer is not useful 0Overall Rating: +2    
October 27, 2007 11:52:49   #4  
kkalluri Member Since: November 2005   Contribution: 1    

RE: What are the differences you have seen while insta...

Hi

I strongly feel with OUI installtion is more or less same on Windows and Unix.
there is nothing great about Unix installation.

krishna

 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape