Q: | I don't have an Oracle client installed on my workstation. Can
I still use Insider to monitor my Oracle databases |
A: | Yes. Select Thin Driver connection type when entering your database.
Oracle thin driver does not
require Oracle client software to be installed on the machine
|
Q: | I am trying to add an Oracle database however my tnsnames.ora
file is not found (TNS names list is not populated) |
A: | Press Locate tnsnames button next to TNS names combo and
navigate to your tnsnames file, then press
OK
|
Q: | Can Insider support 100+ databases? |
A: | Yes. Insider requires about 2Mb per database connection so if you have
100 databases you need approximately 200Mb RAM. To lower CPU utilization
you may want to turn off alert pop-up notifications (
>
>
General
>
Alert
). Lower refresh rate to avoid excessive load on the network. You can also
switch off session statistics (
>
>
Tuning
) or lower the timeout threshold.
|
Q: | Why am I getting Parse To Execute Ratio greater than 100% alert? |
A: |
Please see Why Parse count is higher than execute count in V$SYSSTAT
Metalink Note 220617.1. This behaviour is observed on Oracle 8i only
|
Q: | I am getting lots of login messages in UNIX system log |
A: | Select
Use Shell
option when you specify operating
system connection parameters
|
Q: | I am using Use Shell option and keep getting error messages |
A: | Use Shell option does not work with variables within UNIX command prompt
like e.g. date/time etc. Try removing variables from UNIX command prompt or
switch off Use Shell option
|
Q: | I am getting a "Not enough priviliges to read alert log" alert |
A: | When choosing an operating system user account make sure it has correct priviliges
to read from Oracle alert log file. If these priviliges are missing Analyze alert
log feature will be disabled and you will receive "Not enough priviliges to read alert log" alert
|
Q: | I am trying to connect to my physical standby however Insider
keeps telling me ORA-12520: TNS:listener could not find available
handler for requested type of server or similar error? |
A: | To connect to a physical standby or any database in mounted or
down state what you should do is: |