Monday, March 26, 2018

Status failur - Test failed : IO Error : Got minus one from a read call

Error while connecting SQL developer

"Status failur - Test failed : IO Error : Got minus one from a read call"

Resolution:

1. Open sqlnet.ora from $ORACLE_HOME/network/admin location

2. Change the setting to:
tcp.validate_node = no


3. Now try reconnecting to the database from SQL Developer and you should be able to connect it successfully this time.

Saturday, March 10, 2018

APPS User Account locked in Oracle EBS

During the post clone in EBS Application, Removed the existing node entry and try to ran autoconfig on database tier. and its completed with error,

In log file, 

WARNING:     Exception occurred: java.sql.SQLException: ORA-28000: the account is locked

SQL> select username,account_status from dba_users where username like 'APPS';

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
APPS                           LOCKED

SQL> alter user apps account unlock;

User altered.

$ sqlplus apps/apps

SQL*Plus: Release 11.2.0.4.0 on Sat Mar 10 01:11:11 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

ERROR:
ORA-28000: the account is locked

Even after unlock the apps user also, same issue exists.

Solution:

SQL> select * from dba_profiles where RESOURCE_NAME like 'FAILED%';

PROFILE                        RESOURCE_NAME                    RESOURCE
------------------------------ -------------------------------- --------
LIMIT
----------------------------------------
DEFAULT                        FAILED_LOGIN_ATTEMPTS            PASSWORD
3

AD_PATCH_MONITOR_PROFILE       FAILED_LOGIN_ATTEMPTS            PASSWORD
3

EM_OAM_MONITOR_PROFILE         FAILED_LOGIN_ATTEMPTS            PASSWORD
3


SQL> alter profile DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;

Profile altered.

After changing the profile value as unlimited, we are able to connect apps user and auto config also completed successfully.


VNC Settings

Stopping the VNC Server:

$ vncserver -kill :1

Killing Xvnc process ID 2695

Changing the VNC Password:

$ vncpasswd

Password:
Verify:

Setting VNC Server Number or Screen Size:

$ vncserver :5

$ vncserver -geometry 800x600