-
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
-
Checkup if the dispatcher process is startted or not.
-
The V$dispatcher view is showing one D000 with WAIT in the status column.
Regards
Puneet Sachdev
-
Whats your dataabse name ? Is it EXPSRVR ?
Reddy,Sam
-
Yes this is the DB_NAME. This is also the GLOBAL_DBNAME and SID defined in SID_LIST clause of listener.ora.
Puneet Sachdev
-
type in at the prompt "lsnrctl services" and see you have the services runnning and dispathers are active.
Reddy,Sam
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
|