User is able to log in locally to server using SYSDBA from the host itself via SQL, however when using the database agent installer the Oracle SYSDBA account could not log in remotely.
The agent could be created by using the grant privileges script in SQL*Plus.
Oracle's Remote Login restriction functionality was preventing remote login from Foglight.
The following command can be used to confirm if this functionality is in place:
show parameter remote_login_passwordfile;
WORKAROUND
Install the Foglight Agent Manager on the monitored Oracle host
RESOLUTION
'Granting Privileges' was successful after the remote login is enabled. Set the database parameter to:
REMOTE_LOGIN_PASSWORDFILE = { shared | exclusive | none }
It should be set to shared/exclusive, in order for the database to allow remote connection.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center