|
|
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.
|
Locked
