How to set the oracle from "Dedicated" to "Shared" server? What are all parameters needs to set to change the Oracle from "Dedicated" Server to "Shared" Server?

raj_java_j2ee

 Profile Answers by raj_java_j2ee Questions by raj_java_j2ee

• May 12th, 2009

1.To change from dedicated server to shared server add the following initialization parameters in the parameter file.dispatchers='(protocol=TCP)(disp=5)' max_dispatchers=150 shared_server...

Answer Question  Select Best Answer

When a Oracle instance is up, How can we find which parameter file (pfile or spfile) the oracle is using?

chaitra murthy

 Profile Answers by chaitra murthy Questions by chaitra murthy

• Jan 9th, 2009

The command given below will display 3 colums NAME, TYPE, VALUESQL> show parameter spfile NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile ...

Answer Question  Select Best Answer

While Installing Oracle9i/10g at unix (RedHat) environment , which parameter needs to be set at OS level, to login as a sysdba in Oracle for the first time?

skpanuganti

 Profile Answers by skpanuganti Questions by skpanuganti

• Feb 8th, 2008

.bash_profile has to set at OS level before connecting to oracle database.

Answer Question  Select Best Answer