بتاريخ: 9 يناير 200719 سنة comment_88796 I am facing this problemi used to have a dedicated server process and i needed to change it to the shared server process i done the following:1. shutdoen the data base2. add the following to init.ora Dispatchers="(Protocol=TCP)(dispatchers=5)"Max_Dispatchers=10Shared_Servers=5Max_Shared_Servers=153. and reconfigred the tnsnames as follows: ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = EDATA14.Edata.local)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) (SeRVeR = SHARED) ) )restarted the databsewhen i connect using sys the session in shared modebut when i connect using any other user it appear in dedicated ModeWhat is my problem.Thanx alot. تقديم بلاغ
انضم إلى المناقشة
يمكنك المشاركة الآن والتسجيل لاحقاً. إذا كان لديك حساب, سجل دخولك الآن لتقوم بالمشاركة من خلال حسابك.