Changing the server type
- From: "Octavian Rasnita" <orasnita@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 11 Jul 2010 15:35:45 +0300
Hi,
I have installed Oracle 11G under Windows XP and I've seen that for the current
database it was installed as DEDICATED, but I want to set it as SHARED.
Is it possible?
I've used Database Configuration Assistant and I changed its type to SHARED, it
told that the changes were successfully, but then I've seen that in
tnsnames.ora the server still appears as DEDICATED.
Is it ok (it keeps these settings somewhere else) or I need to do something
else in order to make this change?
I try to set it as SHARED because I use the Oracle under Windows only for
testing purposes and I want it to consume as few resources as possible.
Here is the relevant part of tnsnames.ora:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
Thank you.
Octavian
--
//www.freelists.org/webpage/oracle-l
Other related posts:
