-
Our database has the following settings in init.ora :
mts_dispatchers="tcp,1"
mts_max_dispatchers=10
mts_servers=1
mts_max_servers=5
mts_service=EXPSRVR
mts_listener_address="(ADDRESS=(PROTOCOL=TCP)(HOST=NH_ORACLE)(PORT=1521))"
The listener.ora file is as follows :
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = NH_ORACLE)(PORT = 1521))
)
)
The users are able to connect. But when I run the query :
select username, server from v$session; I see that every user is DEDICATED. V$CIRCUIT view is also empty. I have also checked the TNSNAMES.ORA file and it does NOT contain
(SRVR = DEDICATED) in the CONNECT_DATA.
Any idea why everybody is still connecting using a dedicated server...???
Regards
Puneet Sachdev
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|