Hi everyone!
I received the above stated error and the database is designed in such a way that it depends on another database which maintains a lot of details about the production database.
I checked the trace file and found this:
HS: RPC error, SendGetProduct pid, NCR code 1003
HS: Probable error (ORA-28546) in network administration
*** 2010-07-12 13:30:03.642
*** 2010-07-12 13:30:03.642
HS: Error ORA-28544 or 28546, probable network admin error
HS: Lost RPC connection to remote Agent...
HS: ... Agent SID = (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ipaddress)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=MainDB)(INSTANCE_NAME=maindb))), NCR status = 28546
The error pops up suddenly and sometimes leave undisturbed and sometimes I am required to restart it.
I restarted the production database and its working fine.
What causes it and how should I handle this problem? Please advice me.
I don't think so its running in shared server mode.
I checked this query and it returned:
select * from v$resource_limit
--1 processes 32 34 40 40 (within the limit)
select * from v$shared_server
-- returned null
select * from v$circuit
-- returned null
select * from v$dispatcher
--returned null
I noticed in other threads, we are adviced to perform the following steps which I didn't as I believe its for shared server:
DIRECT_HANDOFF_TTC_LISTENER=OFF -- what does this do?
Increase the value of large_pool_size. - This is applicable if Oracle runs on shared servers?
Please advice on how should I go about this?
The error appears on and off!
Expecting some guidance.
Thanks in advance.
Nith