How to track failed login attempts in Oracle

 How to track failed login attempts in Oracle

audit_file_dest string /lapps/ag2/oappsr12/db/tech_st/11.1.0/rdbms/audit
audit_sys_operations boolean FALSE
audit_syslog_level string
audit_trail string DB, EXTENDED

I run the following query to get more info on who tries to login with incorrect username/password and who locks the user.

select USERID,
userhost,
decode(returncode,01017,'Login Error','Acount Locked') "ISSUE",
spare1,
TO_CHAR ( CAST(
( FROM_TZ(
CAST(
TO_DATE(
TO_CHAR( ntimestamp# , 'DD/MM/YYYY HH:MI PM'),
'DD/MM/YYYY HH:MI PM'
)
AS TIMESTAMP
) ,
'GMT'
) AT LOCAL
)
AS TIMESTAMP)
, 'DD/MM/YYYY HH:MI PM') "Time",
sqltext,
comment$text from SYS.aud$
where ( returncode=1017 OR returncode=28000 )
order by ntimestamp# desc ;

Setup VNC Server on Linux

Configure VNC Server on Linux

1) Install VNC server packages

# yum install tigervnc-server

2) Edit the "/etc/sysconfig/vncservers" file to configure the required displays. The following entries enable VNC for display numbers ":2" and ":3". Notice multiple "display:user" pairs are defined on a single line, but the arguments for each display are defined separately.

VNCSERVERS="2:root 3:oracle"
VNCSERVERARGS[2]="-geometry 1280x1024 -nolisten tcp -localhost"
VNCSERVERARGS[3]="-geometry 1280x1024"

3) Set the VNC password for any users defined in the "/etc/sysconfig/vncservers" file.

# vncpasswd
Password:
Verify:
#

# su - oracle
$ vncpasswd
Password:
Verify:
$ exit
logout
# 

4) Enable the "vncserver" service for autostart and start the service.

# chkconfig vncserver on
# service vncserver start

Stop Firewall for 12c grid control

Make sure that no firewall is enabled. It is usually enabled by default. In Redhat or Fedora, you can quickly disable the firewall:

First, login to the Linux computer.In a terminal window or shell prompt, type

 service iptables stop 

 If you see the below error while opening the 12c grid control EM url then

 stop the iptables

The connection has timed out
The server at ***** is taking too long to respond.
The site could be temporarily unavailable or too busy. Try again in a few moments.

If you are unable to load any pages, check your computer's network  connection.

If your computer or network is protected by a firewall or proxy, make sure 

that Firefox is permitted to access the Web.