thimself
thimself
Hi, The reason i asked is because i have altered privileges for the monitoring user. I am able to connect to the standby database with sqlplus and query its status,...
Hi, We are using a proxy to monitor this target. I will clear and unlink, then let it run for 24h and see what it picks up. I will update...
Hi, Problem still persists. We had this issue in 2 databases so for testing purposes i dit the following things: 1. First database configuration was changed that monitoring account is...
Hi, I have disconnected the problematic one manually by renaming cfg file and then naming it back. Will have to see if it helps. Monitoring is done by one host...
Hi, I will look into these triggers. We are always connecting to the primary database, we do not need to have open connections to standby database. We connect directly to...
Yes, one instance and connection string what connects to both databases. Most of the cases its like this: db_url = (DESCRIPTION =(FAILOVER=ON)(LOAD_BALANCE=OFF)(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER1)(PORT...
Also noticed another problem with target(s). At the moment one of these databases what we are discussing at the moment is also getting an repeating information about cancelled checks in...
_For the timeout on p_ts: more often than not this is a problem with a large recycle bin. Could you empty that? Normally it runs sub second._ This solved timeout...
Hi, Tried this with another cluster target, this time it is ASM cluster, but the principle is same. Current configuration: - both nodes monitored separately, 2 .cfg files and both...
Sorry for the delay, busy as always. Queries are running fine and data is updating normally. I have run into to issues with for example databases running on RAC as...