8 Replies Latest reply on Sep 11, 2018 12:59 AM by Beauty_and_dBest

    Our EBS 12.0 has error - adstrtal.sh: Exiting with status 1

    Beauty_and_dBest

      EBS 12.0.6

      Database 10.2.0.5 upgraded to 12.1.0.2

      OL6

       

       

      Hi ALL,

       

      We upgraded our EBS 12.0.6  database from 10.2.0.5 to  12.1.0.2.

      After completing the upgrade we can still startup both apps and database successfully without error, and able to login to the apps.

       

      Next step was  we apply ETCC patches for 12c database in dbTier.

       

      Generating Patch Recommendation Summary.

       

      ===============================================================================

      PATCH RECOMMENDATION SUMMARY

      ===============================================================================

      The default patch recommendations to install these missing bugfixes are:

      -------------------------------------------------------------------------------

      Oracle Database Release 12.1.0.2  (No PSU applied)

      -------------------------------------------------------------------------------

        Patch 27264965

          - Filename: p27264965_121020_Linux-x86-64.zip

       

        Patch 19779059

          - Filename: p19779059_121020_Linux-x86-64.zip

       

        Patch 27062381

          - Filename: p27062381_121020_Linux-x86-64.zip

       

        Patch 26113202

          - Filename: p26113202_121020_Linux-x86-64.zip

       

        Patch 27872956

          - Filename: p27872956_121020_Linux-x86-64.zip

       

        Patch 22098146

          - Filename: p22098146_121020_Linux-x86-64.zip

       

        Patch 18793246

          - Filename: p18793246_121020_Generic.zip

       

        Patch 18966843

          - Filename: p18966843_121020_Generic.zip

       

        Patch 19291380

          - Filename: p19291380_121020_Linux-x86-64.zip

       

        Patch 19472320

          - Filename: p19472320_121020_Linux-x86-64.zip

       

        Patch 19835133

          - Filename: p19835133_121020_Linux-x86-64.zip

       

        Patch 20093776

          - Filename: p20093776_121020_Linux-x86-64.zip

       

        Patch 20181016

          - Filename: p20181016_121020_Linux-x86-64.zip

       

        Patch 20294666

          - Filename: p20294666_121020_Linux-x86-64.zip

       

        Patch 20766180

          - Filename: p20766180_121020_Generic.zip

       

        Patch 20798891

          - Filename: p20798891_121020_Linux-x86-64.zip

       

        Patch 20887355

          - Filename: p20887355_121020_Generic.zip

       

        Patch 21153266

          - Filename: p21153266_121020_Linux-x86-64.zip

       

        Patch 21321429

          - Filename: p21321429_121020_Generic.zip

       

        Patch 21864513

          - Filename: p21864513_121020_Linux-x86-64.zip

       

        Patch 21904072

          - Filename: p21904072_121020_Linux-x86-64.zip

       

        Patch 21967332

          - Filename: p21967332_121020_Linux-x86-64.zip

       

        Patch 22223463

          - Filename: p22223463_121020_Linux-x86-64.zip

       

        Patch 22496904

          - Filename: p22496904_121020_Linux-x86-64.zip

       

        Patch 23089357

          - Filename: p23089357_121020_Linux-x86-64.zip

       

        Patch 24560906

          - Filename: p24560906_121020_Linux-x86-64.zip

       

        Patch 25305405

          - Filename: p25305405_121020_Linux-x86-64.zip

       

        Patch 25643931

          - Filename: p25643931_121020_Linux-x86-64.zip

       

        Patch 25906117

          - Filename: p25906117_121020_Linux-x86-64.zip

       

       

      Apply the required patches and rerun this script

       

      You should check the patch READMEs for minimum opatch version requirements.

      The latest opatch is available from My Oracle Support via Patch 6880880.

       

       

      +-----------------------------------------------------------------------------+

      A consolidated zip file with the required patches for Database release

      12.1.0.2.0 is available on My Oracle Support via:

       

        Patch 27557445 [12.1.0.2.0 version]

          - EBS RELEASE 12.2 CONSOLIDATED DATABASE FIXES FOR APR 2018

       

      Note: This zip does not include any database bundle patches or PSUs.

      +-----------------------------------------------------------------------------+

       

      See Doc ID 1594274.1 for any special instructions for these patches.

      Note: Footnotes in Doc ID 1594274.1 also apply to corresponding overlay patches.

       

      Stored Technology Codelevel Checker results in the database PPAPROD successfully.

       

      Finished checking fixes for Oracle Database: Mon Sep  3 10:21:32 +08 2018

       

      Log file for this session: ./checkDBpatch_30984.log

       

       

       

      After completing all the ETCC patches for the database, we startup the apptier. But now it encountered error below

       

      [applmgr@oraapps-2 ~]$ ./start

       

      You are running adstrtal.sh version 120.13.12000000.4

       

      The logfile for this session is located at /mnt/data/u01/oracle/PPAPROD/inst/apps/PPAPROD_oraapps-2/logs/appl/admin/log/adstrtal.log

      Executing service control script:

      /mnt/data/u01/oracle/PPAPROD/inst/apps/PPAPROD_oraapps-2/admin/scripts/adopmnctl.sh start

      script returned:

      ****************************************************

       

      You are running adopmnctl.sh version 120.4.12000000.3

       

      Starting Oracle Process Manager (OPMN) ...

      opmnctl: opmn started.

       

      adopmnctl.sh: exiting with status 0

       

      adopmnctl.sh: check the logfile /mnt/data/u01/oracle/PPAPROD/inst/apps/PPAPROD_oraapps-2/logs/appl/admin/log/adopmnctl.txt for more information ...

       

       

      .end std out.

       

      .end err out.

       

      ****************************************************

       

      Executing service control script:

      /mnt/data/u01/oracle/PPAPROD/inst/apps/PPAPROD_oraapps-2/admin/scripts/adalnctl.sh start

      script returned:

      ****************************************************

       

      adalnctl.sh version 120.3

       

      Checking for FNDFS executable.

      Starting listener process APPS_PPAPROD.

       

      adalnctl.sh: exiting with status 0

       

      adalnctl.sh: check the logfile /mnt/data/u01/oracle/PPAPROD/inst/apps/PPAPROD_oraapps-2/logs/appl/admin/log/adalnctl.txt for more information ...

       

      .end std out.

       

      .end err out.

       

      ****************************************************

       

      Executing service control script:

      /mnt/data/u01/oracle/PPAPROD/inst/apps/PPAPROD_oraapps-2/admin/scripts/adapcctl.sh start

      script returned:

      ****************************************************

       

      You are running adapcctl.sh version 120.6.12000000.4

       

      Starting OPMN managed Oracle HTTP Server (OHS) instance ...

      opmnctl: opmn is already running.

      opmnctl: starting opmn managed processes...

       

      adapcctl.sh: exiting with status 0

       

      adapcctl.sh: check the logfile /mnt/data/u01/oracle/PPAPROD/inst/apps/PPAPROD_oraapps-2/logs/appl/admin/log/adapcctl.txt for more information ...

       

       

      .end std out.

       

      .end err out.

       

      ****************************************************

       

      Executing service control script:

      /mnt/data/u01/oracle/PPAPROD/inst/apps/PPAPROD_oraapps-2/admin/scripts/adoacorectl.sh start

      script returned:

      ****************************************************

       

      You are running adoacorectl.sh version 120.11.12000000.3

       

      Starting OPMN managed OACORE OC4J instance  ...

       

      adoacorectl.sh: exiting with status 0

       

      adoacorectl.sh: check the logfile /mnt/data/u01/oracle/PPAPROD/inst/apps/PPAPROD_oraapps-2/logs/appl/admin/log/adoacorectl.txt for more information ...

       

       

      .end std out.

       

      .end err out.

       

      ****************************************************

       

      Executing service control script:

      /mnt/data/u01/oracle/PPAPROD/inst/apps/PPAPROD_oraapps-2/admin/scripts/adformsctl.sh start

      script returned:

      ****************************************************

       

      You are running adformsctl.sh  version 120.12.12000000.6

       

      Starting OPMN managed FORMS OC4J instance  ...

      Calling txkChkFormsDeployment.pl to check whether latest FORMSAPP.EAR is deployed...

      Program : /mnt/data/u01/oracle/PPAPROD/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChkFormsDeployment.pl started @ Mon Sep 10 10:56:32 2018

       

      *** Log File = /mnt/data/u01/oracle/PPAPROD/inst/apps/PPAPROD_oraapps-2/logs/appl/rgf/TXK/txkChkFormsDeployment_Mon_Sep_10_10_56_32_2018/txkChkFormsDeployment_Mon_Sep_10_10_56_32_2018.log

       

       

      =============================================

      *** Latest formsapp.ear has been deployed ***

      =============================================

       

       

      Program : /mnt/data/u01/oracle/PPAPROD/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChkFormsDeployment.pl completed @ Mon Sep 10 10:56:33 2018

       

      Perl script txkChkFormsDeployment.pl got executed successfully

       

      adformsctl.sh: exiting with status 0

       

      adformsctl.sh: check the logfile /mnt/data/u01/oracle/PPAPROD/inst/apps/PPAPROD_oraapps-2/logs/appl/admin/log/adformsctl.txt for more information ...

       

      .end std out.

      *** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS

      *** Log File = /mnt/data/u01/oracle/PPAPROD/inst/apps/PPAPROD_oraapps-2/logs/appl/rgf/TXK/txkChkFormsDeployment_Mon_Sep_10_10_56_32_2018/txkChkFormsDeployment_Mon_Sep_10_10_56_32_2018.log

       

      .end err out.

       

      ****************************************************

       

      Executing service control script:

      /mnt/data/u01/oracle/PPAPROD/inst/apps/PPAPROD_oraapps-2/admin/scripts/adoafmctl.sh start

       

       

      script returned:

      ****************************************************

      ERROR : Timed out( 100000 ): Interrupted Exception

       

      You are running adoafmctl.sh version 120.6.12000000.3

       

      Starting OPMN managed OAFM OC4J instance  ...

       

      ****************************************************

      Executing service control script:

      /mnt/data/u01/oracle/PPAPROD/inst/apps/PPAPROD_oraapps-2/admin/scripts/adcmctl.sh start

      script returned:

      ****************************************************

      You are running adcmctl.sh version 120.14.12000000.4

       

      Starting concurrent manager for PPAPROD ...

      Starting PPAPROD_0910@PPAPROD Internal Concurrent Manager

      Default printer is noprint

       

      adcmctl.sh: exiting with status 0

       

      adcmctl.sh: check the logfile /mnt/data/u01/oracle/PPAPROD/inst/apps/PPAPROD_oraapps-2/logs/appl/admin/log/adcmctl.txt for more information ...

       

      .end std out.

       

      .end err out.

       

      ****************************************************

      Executing service control script:

      /mnt/data/u01/oracle/PPAPROD/inst/apps/PPAPROD_oraapps-2/admin/scripts/jtffmctl.sh start

      script returned:

      ****************************************************

       

      You are running jtffmctl.sh version 120.3

       

      Validating Fulfillment patch level via /mnt/data/u01/oracle/PPAPROD/apps/apps_st/comn/java/classes

      Fulfillment patch level validated.

      Starting Fulfillment Server for PPAPROD on port 9300 ...

       

      jtffmctl.sh: exiting with status 0

       

       

      .end std out.

       

      .end err out.

       

      ****************************************************

       

      adstrtal.sh: Exiting with status 1

       

      adstrtal.sh: check the logfile /mnt/data/u01/oracle/PPAPROD/inst/apps/PPAPROD_oraapps-2/logs/appl/admin/log/adstrtal.log for more information ...

       

      [applmgr@oraapps-2 ~]$

       

      ****************************************************

      [Service Control Execution Report]
      The report format is:
        <Service Group>            <Service>                                     <Script>         <Status>

       

        Root Service                                                                              Enabled
        Root Service               Oracle Process Manager for PPAPROD_oraapps-2  adopmnctl.sh     Started
        Web Entry Point Services                                                                  Enabled
        Web Entry Point Services   Oracle HTTP Server PPAPROD_oraapps-2          adapcctl.sh      Started
        Web Entry Point Services   OracleTNSListenerAPPS_PPAPROD_oraapps-2       adalnctl.sh      Started
        Web Application Services                                                                  Enabled
        Web Application Services   OACORE OC4J Instance PPAPROD_oraapps-2        adoacorectl.sh   Started
        Web Application Services   FORMS OC4J Instance PPAPROD_oraapps-2         adformsctl.sh    Started
        Web Application Services   OAFM OC4J Instance PPAPROD_oraapps-2          adoafmctl.sh     Failed
        Batch Processing Services                                                                 Enabled
        Batch Processing Services  OracleConcMgrPPAPROD_oraapps-2                adcmctl.sh       Started
        Batch Processing Services  Oracle Fulfillment Server PPAPROD_oraapps-2   jtffmctl.sh      Started
        Other Services                                                                            Disabled
        Other Services             OracleFormsServer-Forms PPAPROD_oraapps-2     adformsrvctl.sh  Disabled
        Other Services             Oracle Metrics Client PPAPROD_oraapps-2       adfmcctl.sh      Disabled
        Other Services             Oracle Metrics Server PPAPROD_oraapps-2       adfmsctl.sh      Disabled
        Other Services             Oracle MWA Service PPAPROD_oraapps-2          mwactlwrpr.sh    Disabled

       


      ServiceControl is exiting with status 1

       

       

       

       

       

      Please help how to resolve above error....What patch could have made it wrong?

       

       

      Kind regards,

      jc

        • 2. Re: Our EBS 12.0 has error - adstrtal.sh: Exiting with status 1
          Beauty_and_dBest

          Thanks Kanda,

           

           

          I also see this from logs:

           

          Caused by: oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.AppsException: java.sql.SQLException: ORA-28040: No matching authentication protocol

           

                  at oracle.apps.fnd.security.AppsConnectionManager.makeGwyuidConn(AppsConnectionManager.java:904)

                  at oracle.apps.fnd.security.AppsConnectionManager.getGwyuidConn(AppsConnectionManager.java:963)

                  at oracle.apps.fnd.security.AppsConnectionManager.makeGuestConnection(AppsConnectionManager.java:781)

                  at oracle.apps.fnd.security.DBConnObj.<init>(DBConnObj.java:228)

                  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

                  at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

                  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

                  at java.lang.reflect.Constructor.newInstance(Constructor.java:494)

                  at oracle.apps.fnd.common.Pool.createObject(Pool.java:1273)

                  ... 47 more

          Caused by: oracle.apps.fnd.common.AppsException: java.sql.SQLException: ORA-28040: No matching authentication protocol

           

                  at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1423)

                  at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1326)

                  at oracle.apps.fnd.security.AppsConnectionManager.makeGwyuidConn(AppsConnectionManager.java:885)

                  ... 55 more

          Caused by: java.sql.SQLException: ORA-28040: No matching authentication protocol

           

                  at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)

                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)

                  at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOsesskey(T4CTTIoauthenticate.java:294)

                  at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:357)

                  at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:439)

                  at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)

                  at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)

                  at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)

                  at java.sql.DriverManager.getConnection(DriverManager.java:525)

                  at java.sql.DriverManager.getConnection(DriverManager.java:140)

                  at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1410)

                  ... 57 more

          • 3. Re: Our EBS 12.0 has error - adstrtal.sh: Exiting with status 1
            Kanda-Oracle

            1. Please check guest parameter in $FND_SECURE DBC file has an correct value ?

             

              oracle.apps.fnd.cache.CacheException - null connection - on AppsLocalLogin.jsp (Doc ID 414170.1)

              Login Fails After Changing The 'GUEST' Password To Either Mixed / Lowercase In R12 (Doc ID 602425.1

             

            2. Did you remove  class files from $COMMON_TOP/_pages ; if yes, then compile it.

             

            R12 E-Business Suite Technology Stack JSP Pages Hanging in R12 After Removing Cached Class Files in _pages (Doc ID 433386.1)

            • 4. Re: Our EBS 12.0 has error - adstrtal.sh: Exiting with status 1
              Kanda-Oracle

              In addition to the above,

              To validate guest user use this API fnd_web_sec.validate_login. example

               

              Cannot Login After Running Autoconfig To Change The Guest User Password (Doc ID 406916.1)

               

              Thanks!

              • 5. Re: Our EBS 12.0 has error - adstrtal.sh: Exiting with status 1
                Beauty_and_dBest

                Thanks Kanda,

                 

                I will check above docs....brb

                • 6. Re: Our EBS 12.0 has error - adstrtal.sh: Exiting with status 1
                  Beauty_and_dBest

                  Hi Kanda,

                   

                  I tried running autoconfig on apps-tier but I got error below

                   

                  Updating Context file...COMPLETED

                   

                  Attempting upload of Context file and templates to database...COMPLETED

                   

                  Configuring templates from all of the product tops...

                  Configuring AD_TOP........COMPLETED
                  Configuring FND_TOP.......COMPLETED
                  Configuring ICX_TOP.......COMPLETED
                  Configuring IEO_TOP.......COMPLETED
                  Configuring BIS_TOP.......COMPLETED
                  Configuring AMS_TOP.......COMPLETED
                  Configuring CCT_TOP.......COMPLETED
                  Configuring WSH_TOP.......COMPLETED
                  Configuring CLN_TOP.......COMPLETED
                  Configuring OKE_TOP.......COMPLETED
                  Configuring OKL_TOP.......COMPLETED
                  Configuring OKS_TOP.......COMPLETED
                  Configuring CSF_TOP.......COMPLETED
                  Configuring IGS_TOP.......COMPLETED
                  Configuring IBY_TOP.......COMPLETED
                  Configuring JTF_TOP.......COMPLETED
                  Configuring MWA_TOP.......COMPLETED
                  Configuring CN_TOP........COMPLETED
                  Configuring CSI_TOP.......COMPLETED
                  Configuring WIP_TOP.......COMPLETED
                  Configuring CSE_TOP.......COMPLETED
                  Configuring EAM_TOP.......COMPLETED
                  Configuring FTE_TOP.......COMPLETED
                  Configuring ONT_TOP.......COMPLETED
                  Configuring AR_TOP........COMPLETED
                  Configuring AHL_TOP.......COMPLETED
                  Configuring OZF_TOP.......COMPLETED
                  Configuring IES_TOP.......COMPLETED
                  Configuring CSD_TOP.......COMPLETED
                  Configuring IGC_TOP.......COMPLETED

                   

                  AutoConfig completed with errors.

                  [applmgr@oraapps-2 scripts]$

                   

                   

                  [applmgr@oraapps-2 09101844]$ cat NetServiceHandler.log

                          Classpath                   : /mnt/data/u01/oracle/PPAPROD/apps/apps_st/comn/java/lib/appsborg2.zip:/mnt/data/u01/oracle/PPAPROD/apps/apps_st/comn/java/classes

                   

                  ===============================================================================

                  NetServiceHandler 120.16.12000000.5 started for oraapps-2 at Mon Sep 10 18:44:31 PHT 2018

                  ===============================================================================

                   

                  [ Context Information ]

                      Host              : oraapps-2

                      Domain            : prompt.ppa

                      Out Dir           : /mnt/data/u01/oracle/PPAPROD/inst/apps/PPAPROD_oraapps-2/admin/out/09101844

                      Tier Type         : MIDDLE TIER

                  Getting connection...

                   

                  ---------------------------------------------------------------

                                     ADX Database Utility

                  ---------------------------------------------------------------

                   

                  getConnectionUsingAppsJDBCConnector() -->

                      APPS_JDBC_URL=''

                      Trying to get connection using SID based connect descriptor

                  getConnection() -->

                      sDbHost    : oradb-2

                      sDbDomain  : prompt.ppa

                      sDbPort    : 1521

                      sDbSid     : PPAPROD

                      sDbUser    : APPS

                      Trying to connect using SID...

                  getConnectionUsingSID() -->

                      JDBC URL: jdbc:oracle:thin:@oradb-2.prompt.ppa:1521:PPAPROD

                      Exception occurred: java.sql.SQLException: ORA-28040: No matching authentication protocol

                   

                      Trying to connect using SID as ServiceName

                  getConnectionUsingServiceName() -->

                      JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oradb-2.prompt.ppa)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PPAPROD)))

                      Exception occurred: java.sql.SQLException: ORA-28040: No matching authentication protocol

                   

                      Trying to connect using SID as ServiceName.DomainName

                  getConnectionUsingServiceName() -->

                      JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oradb-2.prompt.ppa)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PPAPROD.prompt.ppa)))

                      Exception occurred: java.sql.SQLException: Listener refused the connection with the following error:

                  ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

                  The Connection descriptor used by the client was:

                  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oradb-2.prompt.ppa)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PPAPROD.prompt.ppa)))

                   

                      Connection could not be obtained; returning null

                   

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

                   

                  Could not get connection to the database.

                  Exiting with status 100 to instantiate the tnsnames.ora template

                  instantiate file:

                     source : /mnt/data/u01/oracle/PPAPROD/apps/apps_st/appl/fnd/12.0.0/admin/template/tnsnames_80.ora

                     dest   : /mnt/data/u01/oracle/PPAPROD/inst/apps/PPAPROD_oraapps-2/ora/10.1.2/network/admin/tnsnames.ora

                   

                  AutoConfig is exiting with status 0

                   

                  instantiate file:

                     source : /mnt/data/u01/oracle/PPAPROD/apps/apps_st/appl/fnd/12.0.0/admin/template/tnsnames_ias.ora

                     dest   : /mnt/data/u01/oracle/PPAPROD/inst/apps/PPAPROD_oraapps-2/ora/10.1.3/network/admin/tnsnames.ora

                   

                  AutoConfig is exiting with status 0

                   

                  adgentns.pl exiting with status 0

                  ERRORCODE = 0 ERRORCODE_END

                  [applmgr@oraapps-2 09101844]$

                   

                   

                  ===========================================================================

                  Starting Restore Profile utility at Mon Sep 10 18:47:11 PHT 2018

                  Using version 120.2.12000000.3

                   

                   

                  ---------------------------------------------------------------

                                     ADX Database Utility

                  ---------------------------------------------------------------

                   

                  getConnectionUsingAppsJDBCConnector() -->

                      APPS_JDBC_URL=''

                      Trying to get connection using SID based connect descriptor

                  getConnection() -->

                      sDbHost    : oradb-2

                      sDbDomain  : prompt.ppa

                      sDbPort    : 1521

                      sDbSid     : PPAPROD

                      sDbUser    : APPS

                      Trying to connect using SID...

                  getConnectionUsingSID() -->

                      JDBC URL: jdbc:oracle:thin:@oradb-2.prompt.ppa:1521:PPAPROD

                      Exception occurred: java.sql.SQLException: ORA-28040: No matching authentication protocol

                   

                      Trying to connect using SID as ServiceName

                  getConnectionUsingServiceName() -->

                      JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oradb-2.prompt.ppa)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PPAPROD)))

                      Exception occurred: java.sql.SQLException: ORA-28040: No matching authentication protocol

                   

                      Trying to connect using SID as ServiceName.DomainName

                  getConnectionUsingServiceName() -->

                      JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oradb-2.prompt.ppa)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PPAPROD.prompt.ppa)))

                      Exception occurred: java.sql.SQLException: Listener refused the connection with the following error:

                  ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

                  The Connection descriptor used by the client was:

                  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oradb-2.prompt.ppa)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PPAPROD.prompt.ppa)))

                   

                      Connection could not be obtained; returning null

                   

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

                   

                          Verifying connection to the Database   : Could not be stablished

                          No Restore Profile file created.

                   

                   

                  Restore Profile utility ran successfully

                   

                  ===========================================================================

                   

                   

                  adcvmlog.xml renamed to /mnt/data/u01/oracle/PPAPROD/inst/apps/PPAPROD_oraapps-2/admin/log/09101844/adcvmlog.xml.09101847

                   

                   

                  [AutoConfig Error Report]

                  The following report lists errors AutoConfig encountered during each

                  phase of its execution.  Errors are grouped by directory and phase.

                  The report format is:

                        <filename>  <phase>  <return code where appropriate>

                   

                    [SETUP PHASE]

                    AutoConfig could not successfully execute the following scripts:

                      Directory: /mnt/data/u01/oracle/PPAPROD/inst/apps/PPAPROD_oraapps-2/admin/install

                        adgendbc.sh             INSTE8_SETUP       1

                   

                   

                  AutoConfig is exiting with status 1

                   

                  [applmgr@oraapps-2 09101844]$

                   

                   

                   

                  Please help...........

                   

                   

                  Kind regards

                  • 7. Re: Our EBS 12.0 has error - adstrtal.sh: Exiting with status 1
                    Pravin Takpire

                    ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

                    The Connection descriptor used by the client was:

                    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oradb-2.prompt.ppa)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PPAPROD.prompt.ppa)))

                     

                    ---> This is your error. Please check from appstier are you able to connect to database as apps user using sqlplus. If not please resolve that. Looks like your Database listener is not configured correctly

                     

                    regards

                    Pravin

                    • 8. Re: Our EBS 12.0 has error - adstrtal.sh: Exiting with status 1
                      Beauty_and_dBest

                      Thanks Pravin,

                       

                      Yeah I found that too so funny of me.

                       

                      It says to set in sqlnet.ora > SQLNET.ALLOWED_LOGON_VERSION_SERVER=8

                       

                      And issue is resolved.

                       

                       

                      This was already set before, but when autoconfig is run, it was reset.