Is there somebody who can provide me demo file for configuring the server in multi thread cause each time i try i failed
thanks
Printable View
Is there somebody who can provide me demo file for configuring the server in multi thread cause each time i try i failed
thanks
http://www.dbasupport.com/forums/sho...?threadid=6654
Pretty much thats it and bounce the database and login to sqlplus and run the query it should show up your userid under MTS as SHARED. If not troubleshoot.
SQL> select username,server from v$session ;
DBSNMP DEDICATED
ADMIN NONE
ADMIN NONE
ADMIN NONE
SREDDY SHARED
SQL>
Hi,
Please write to me at rohitsn@altavista.com I will send u a sample init.ora file which will give u all the parameters to configure ur system for MTS
#Configuring your server to be multithreaded server
#local_listener=bscs521 #service name with which
dispatcher gets registered
#mts_service=bscs #instance name
#mts_dispatchers="(protocol=tcp)(poo=yes)(dispatchers=1)" #initial no of dispatchers started
for tcp/ip
#mts_max_dispatchers=2 #max no of dispatchers
#mts_servers=1 #initial no of shared servers
started
#mts_max_servers=3 #max no of shared servers
Regards,
Rohit Nirkhe,oracle DBA,OCP