| Listener Problem [message #367628] |
Tue, 04 May 1999 15:04  |
sreeram
Messages: 5
Registered: May 1999
|
Junior Member |
|
|
We have two servers linked in LAN and about 150 clients are configured to access these
servers. Right now 80 to 90 clients are getting connected to these servers. All clients are using
VSat communication through dial-up. We are not using IP address for networking purpose. On
one server running on Windows NT 4.0 Enterprise Edition, Webserver (IIS 4) and Oracle 8.0.4
services are running. And the on the second same operating system is there and only Oracle
services are running.
Previously onle one Listener with one port 1521 was there on Webserver (Which is the first
one) and was hanging frequently. Then we added one more Listener with port number 2100
which is working fine, but the default Listener is still hanging. There is no fixed number of users
when it is hanging and there is no fixed time observed when it is hanging.
Most of the times we come acrossed 'DR Watson for Windows NT error on apllication
PLUS80W.exe'
error when Listner hangs. Some times when we say 'Exit' from SQL also we observed the
same error in normal conditions[[no services are hanged .
System on which it is running is as follows:
Operating System Windows NT Enterprise Edition[[Service Pack 3, Option Pack
Oracle Oracle 8.0.4 Enterprise Edition
Applications Running Webserver using IIS 4.0
User are getting connected to the server through VSAT networkDial Up using COM ports and
ICON Card[[X.25 card at the server]]. Applications[[consists of Active Server Pages,uses
ADO/OLE DB]] and the database is linked using ODBC Drivers. Usage of resources at any
given point of time is below 50%.
Parameter files of this Server Database are as below:
LISTENER:
LISTENER =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL= TCP)
(Host= webserver1)
(Port= 1521)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = 0
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = webserver1)
(SID_NAME = ORCL)
)
(SID_DESC =
(SID_NAME = extproc)
(PROGRAM=extproc)
)
)
#PASSWORDS_LISTENER = (oracle)
LISTENHAS =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL= TCP)
(Host= 192.9.250.4)
(Port= 2100)
)
)
STARTUP_WAIT_TIME_LISTENHAS = 0
CONNECT_TIMEOUT_LISTENHAS = 10
TRACE_LEVEL_LISTENHAS = 0
SID_LIST_LISTENHAS =
(SID_LIST =
(SID_DESC =
# (GLOBAL_DBNAME = webserver1)
(SID_NAME = ORCL)
)
(SID_DESC =
(SID_NAME = extproc)
(PROGRAM=extproc)
)
)
#PASSWORDS_LISTENHAS = (oracle)
********************************************************************************
INITORCL.ORA
db_name = ORCL
db_files = 1020
control_files = ("D:\orant\database\ctl1ORCL.ora", "D:\orant\database\ctl2ORCL.ora")
db_file_multiblock_read_count = 32
db_block_buffers = 25000
shared_pool_size = 100000000
log_checkpoint_interval = 8000
processes = 500
dml_locks = 500
log_buffer = 163840
sequence_cache_entries = 100
sequence_cache_hash_buckets = 89
#audit_trail = true
#timed_statistics = true
background_dump_dest = D:\orant\rdbms80\trace
user_dump_dest = D:\orant\rdbms80\trace
db_block_size =4096
compatible = 8.0.4.0.0
sort_area_size = 655360
log_checkpoint_timeout = 0
remote_login_passwordfile = shared
max_dump_file_size = 10240
############### Oracle replication ########################
global_names = false
job_queue_processes = 2
job_queue_interval = 60
job_queue_keep_connections = false
distributed_lock_timeout = 60
distributed_transactions = 5
open_links = 4
snapshot_refresh_interval = 60
snapshot_refresh_keep_connections=false
snapshot_refresh_processes = 2
#mts_listener_address = "(ADDRESS=(PROTOCOL=TCP)(Host=webserver1)(Port=1521))"
#mts_service = "ORCL"
#mts_dispatchers = "(protocol=tcp)(dispatchers=2)(mul=yes)(pool=yes)(con=500)"
#mts_max_dispatchers = 2
#mts_servers = 1
#mts_max_servers = 2
dblink_encrypt_login = true
|
|
|
|
| Re: Listener Problem [message #367644 is a reply to message #367628] |
Fri, 23 July 1999 09:28  |
MarkJ
Messages: 17
Registered: July 1999
|
Junior Member |
|
|
|
I get the same error using TCP/IP connections. From what I have heard, this has nothing to do with the protocol adapter. I also get the same error running on Windows 98. It seems to be a bug in the 8.0.4 client software. I have not yet looked for a patch.
|
|
|
|
| Re: Listener Problem [message #367796 is a reply to message #367628] |
Fri, 04 August 2000 00:20 |
Arvind Mattoo
Messages: 2
Registered: August 2000
|
Junior Member |
|
|
Hello:
Could you send me the listener shell script in case you are using to start up multiple listeners
what you have stated above.
I am writing a similar script.
Thanks
Arvind
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
