autoconfig failed in 12.1.3 database tier

Posted by karthikmca.bhc on Oct 18, 2017; 2:01pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/autoconfig-failed-in-12-1-3-database-tier-tp4050.html

Hi Erman

I ran autoconfig and it got failed in error in 12.1.3

autoconfig error log show the below and also i cannot login as sqlplus also.


error log:

       ORACLE_HOME : /u01/install/PROD/db/tech_st/12
        ORACLE_SID : PROD
          TWO_TASK :
              PATH : /u01/install/PROD/db/tech_st/12/perl/bin:/u01/install/PROD/db/tech_st/12/bin:/usr/bin:/usr/sbin:/u01/install/PROD/db/tech_st/12/jdk/jre/bin:/bin:/usr/bin/X11:/usr/local/bin:/u01/install/PROD/db/tech_st/12/perl/bin:/u01/install/PROD/db/tech_st/12/perl/bin:/u01/install/PROD/db/tech_st/12/bin:/usr/bin:/usr/sbin:/u01/install/PROD/db/tech_st/12/jdk/jre/bin:/bin:/usr/bin/X11:/usr/local/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/bin:.:.
      Library Path : /u01/install/PROD/db/tech_st/12/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/install/PROD/db/tech_st/12/lib:/usr/dt/lib:/u01/install/PROD/db/tech_st/12/ctx/lib

SQLPLUS Executable : /u01/install/PROD/db/tech_st/12/bin/sqlplus


SQL*Plus: Release 12.1.0.1.0 Production on Wed Oct 18 13:38:11 2017

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

Enter value for 1: Enter value for 2: Enter value for 3: ERROR:
ORA-12537: TNS:connection closed


adcrobj.sh exiting with status 1
ERRORCODE = 1 ERRORCODE_END
.end std out.

.end err out.
****************************************************



===========================================================================
Starting Restore Profile utility at Wed Oct 18 13:38:11 EDT 2017
Using version 120.4


---------------------------------------------------------------
                   ADX Database Utility
---------------------------------------------------------------

getConnectionUsingAppsJDBCConnector() -->
    APPS_JDBC_URL='null'
    Trying to get connection using SID based connect descriptor
getConnection() -->
    sDbHost    : d1logpsp01
    sDbDomain  : qp.net
    sDbPort    : 1521
    sDbSid     : PROD
    sDbUser    : apps
    Trying to connect using SID...
getConnectionUsingSID() -->
    JDBC URL: jdbc:oracle:thin:@d1logpsp01.qp.net:1521:PROD
    Exception occurred: java.sql.SQLRecoverableException: IO Error: Got minus one from a read call
    Trying to connect using SID as ServiceName
getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=d1logpsp01.qp.net)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PROD)))
    Exception occurred: java.sql.SQLRecoverableException: IO Error: Got minus one from a read call
    Trying to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=d1logpsp01.qp.net)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PROD.qp.net)))
    Exception occurred: java.sql.SQLRecoverableException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

    Connection could not be obtained; returning null

-------------------ADX Database Utility Finished---------------



[oracle@d1logpsp01 bin]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Wed Oct 18 14:00:53 2017
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
Enter user-name:



Please advise.