Monday, October 17, 2011

Getting "Error from SQLPLUS: 255" error message from Grid Control

Problem: SQL Job:
Getting "Error from SQLPLUS: 255" error message from Grid Control

Ensure that the Oracle Home for the database is setup correctly.

From the Grid Control home page click on Targets > Databases.
Now select the database for which you are trying to run the sqlplus job.
Click on the "Monitoring Configuration" link, and enter the correct Oracle Home.

Now run the SQL script job.

Reference:- Metalink Note ID 402204.1

No comments: