-
Titel
SYSDBA account cannot log in remotely to run the Oracle grant privileges script -
Beschreibung
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.
-
Ursache
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;
-
Lösung
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. -
Weitere Informationen
Additional information can be found here: http://docs.oracle.com/cd/B28359_01/server.111/b28320/minitparams199.htm