Thursday, December 15, 2016

Srvctl is not able to start database (ORA-12547: TNS:lost contact)

Srvctl is not able to start database

[oracle@orcldb-n2 ~]$ srvctl start database -d orcl
PRCR-1079 : Failed to start resource ora.orcl.db
ORA-12547: TNS:lost contact
CRS-5017: The resource action "ora.orcl.db start" encountered the following error:
ORA-12547: TNS:lost contact
. For details refer to "(:CLSN00107:)" in "/u01/app/oracle/diag/crs/orcldb-n1/crs/trace/crsd_oraagent_oracle.trc".

CRS-2674: Start of 'ora.orcl.db' on 'orcldb-n1' failed
ORA-12547: TNS:lost contact
CRS-5017: The resource action "ora.orcl.db start" encountered the following error:
ORA-12547: TNS:lost contact
. For details refer to "(:CLSN00107:)" in "/u01/app/oracle/diag/crs/orcldb-n2/crs/trace/crsd_oraagent_oracle.trc".

CRS-2674: Start of 'ora.orcl.db' on 'orcldb-n2' failed
ORA-12547: TNS:lost contact
CRS-2632: There are no more servers to try to place resource 'ora.orcl.db' on that would satisfy its placement policy
ORA-12547: TNS:lost contact
[oracle@orcldb-n2 ~]$


Below document can help you. It can happen if the it is a cloned env.

Local SQL*Plus Connection and DBCA Fails With: ORA-12547: TNS:Lost Contact (Doc ID 422173.1)

1. Check kernel parameters settings
2. Check permission of permissions on the ORACLE executable, and config.o
[oracle@orcldb-n2 orcl]$ ls -lrt $ORACLE_HOME/rdbms/lib/config.o
-rw-r--r-- 1 oracle dba 1328 Dec 14 13:06 /u01/app/oracle/product/12.1.0.2/orcl/rdbms/lib/config.o
[oracle@orcldb-n2 orcl]$ ls -lrt $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 oracle dba 324021455 Dec 14 13:06 /u01/app/oracle/product/12.1.0.2/orcl/bin/oracle
[oracle@orcldb-n2 orcl]$
3. Do relink all  on the database nodes
[oracle@orcldb-n2 orcl]$ relink all
writing relink log to: /u01/app/oracle/product/12.1.0.2/orcl/install/relink.log
[oracle@orcldb-n2 orcl]$ 

Tuesday, December 13, 2016

ORA-04061: existing state of has been invalidated

Getting below error.

ORA-04061: existing state of has been invalidated
ORA-04061: existing state of package "" has been invalidated
ORA-04065: not executed, altered or dropped package
ORA-06508: PL/SQL: could not find program unit being called:

Do below step to resolve this issue.

1. If it is EBS, then check workflow notification mailer , and OPMN services.
2. If it is other application or does not resolved after 1 search the search the session which is holding this ovject in cache.
3. Kill that session.

java.sql.SQLDataException: ORA-01861: literal

Oracle Concurrent programs are getting below error.

Debug Flag: N
{P_END_DATE=2016/12/02 00:00:00, P_START_DATE=2016/11/01 00:00:00, P_TYPE=AMEX}
Calling XDO Data Engine...
--SQLException
java.sql.SQLDataException: ORA-01861: literal does not match format string
 
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
        at oracle.apps.xdo.dataengine.XMLPGEN.processQuery(XMLPGEN.java:1947)
        at oracle.apps.xdo.dataengine.XMLPGEN.processSQLDataSource(XMLPGEN.java:501)
        at oracle.apps.xdo.dataengine.XMLPGEN.writeData(XMLPGEN.java:445)
        at oracle.apps.xdo.dataengine.XMLPGEN.writeGroupStructure(XMLPGEN.java:308)
        at oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:273)
        at oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:215)
        at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:254)
        at oracle.apps.xdo.dataengine.DataProcessor.processDataStructre(DataProcessor.java:390)
        at oracle.apps.xdo.dataengine.DataProcessor.processData(DataProcessor.java:355)
        at oracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:334)
        at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:294)
        at oracle.apps.fnd.cp.request.Run.main(Run.java:157) 

There are below things that you can check to troubleshoot.

1. Check the template file if any date field is creating any issue.
2. Any data it is pulling are triggering this issue.
 

SMTP Error. Getting below error while trying to send email in XXXXXXX instance

Getting below error in EBS R12.1.3 in Oracle Database 

SMTP Error. Getting below error while trying to send email in XXXXXXX instance
 
Oracle Error in Send Mail prog--ORA-29277: invalid SMTP operation
ORA-06512: at "SYS.UTL_SMTP", line 82
ORA-06512: at "SYS.UTL_SMTP", line 540
ORA-06512: at "SYS.UTL_SMTP", line 525
ORA-29278: SMTP transient error: 421 Service not available 

It can be below different issues.

1. You don't have enough privileges.
2. SMTP server not given properly.
3. Check WF config to validate SMTP server.
4. Firewall ports are opened for the SMTP mail. Use command prompt to send email.

Search This Blog

Loading...