Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

alert received

Posted on 2014-04-01
2
Medium Priority
?
837 Views
Last Modified: 2014-04-06
When an dba receives an e-mail alert
what does it means..


Host=ppp
Target type=Database Instance
Target name=TjR.tb.COM
Message=User SYS logged on from ppp.
Severity=Warning
Event reported time=Apr 1, 2014 3:00:46 AM CDT
Event Type=Metric Alert
Event name=UserAudit:username
Metric Group=User Audit
Metric=Audited User
Metric value=SYS
Key Value=SYS_puccdstmc01
Key Column 1=Username_Machine
Rule Name=Alerts - vvC-ORADBA,Rule for alerts
Rule Owner=SYSMAN
0
Comment
Question by:tonydba
2 Comments
 
LVL 23

Accepted Solution

by:
David earned 2000 total points
ID: 39969438
Hi Tony, this is a warning message, informational, that the highly privileged SYS account was used by someone at that day and time.  Given its 03.00 today, my educated guess is that you have some scheduled job (in cron or Oracle job scheduler) that runs under the SYS permissions.

Bad idea.  Bad.

The context of the message suggests your database is being monitored with Oracle Enterprise Manager, or the newer equivalent (grid 11, cloud 12).

Do you have an experienced DBA available to walk this through?  It's neither a quick fix, nor appropriate for a public forum.
0
 

Author Closing Comment

by:tonydba
ID: 39981682
got it
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

886 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question