Skip to main content

EBS Prepare phase encountered Error Message: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor (DBD ERROR: OCIServerAttach)

Error:
[EVENT]     Creating database patch edition.
    [PROCEDURE] [START 2018/12/03 11:05:43] Creating patch edition if it does not exist
    Existing patch edition found, so no need to create.
    [PROCEDURE] [END   2018/12/03 11:05:43] Creating patch edition if it does not exist
[PROCEDURE] [START 2018/12/03 11:05:43] Performing steps for CLONE from run file system to patch file system
[PROCEDURE] [START 2018/12/03 11:05:43] Preparing seed data tables
[STATEMENT] Sourcing Patch edition environment /u01/applprod/fs1/EBSapps/appl/APPSPREPROD2_preprodapp.env
[ERROR]     Cannot connect to database
[ERROR]     Error Message: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor (DBD ERROR: OCIServerAttach)
[ERROR]     Error calling ad_zd_log. Refer to log file for details.
[ERROR]     Error calling ad_zd_log. Refer to log file for details.
[ERROR]     Error calling ad_zd_log. Refer to log file for details.
[ERROR]     Error calling ad_zd_log. Refer to log file for details.
[ERROR]     Error calling ad_zd_log. Refer to log file for details.
[ERROR]     Error calling ad_zd_log. Refer to log file for details.
[ERROR]     Cannot connect to database
[ERROR]     Error Message: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor (DBD ERROR: OCIServerAttach)
[ERROR]     Error calling ad_zd_log. Refer to log file for details.
[UNEXPECTED]Error calling runPendingClone subroutine.

Solution:


To implement the solution test the following steps in a development instance and then migrate accordingly:
Current parameter value
SQL> show parameter local
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      (ADDRESS =(PROTOCOL=TCP)(HOST=
                                                 epc-db-clint01.epcco.com)(PO
                                                 RT=1524))
1. Ensure a valid backup exists before testing the solution.
2. Check if the local_listener is set incorrectly by using:
At the RDBMS HOME:
sqlplus / as sysdba
SQL>show parameter local_listener

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      PREPROD2_LOCAL

In this scenario PREPROD2 is the SID used in this Environment
3. If the local listener value returned is incorrect, change it to the correct value in the init.ora parameter file.
4. Restart the Database tier and the listener.
show parameter output after changes
SQL> show parameter local
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      PREPROD2_LOCAL

5. Execute the "adop phase=prepare" again and confirm the error no longer occurs.









After this run prepare phase with restart=yes option it will run successful.

Comments

Post a Comment

Popular posts from this blog

19c ORACLE HOME Cloning -Linux/Solaris

  Cloning an Oracle home involves creating a copy of the Oracle home and then configuring it for a new environment. If you are performing multiple Oracle Database installations, then you may want to use cloning to create each Oracle home, because copying files from an existing Oracle Database installation takes less time than creating a new version of them. This method is also useful if the Oracle home that you are cloning has had patches applied to it. When you clone the Oracle home, the new Oracle home has the patch updates which is already applied on oracle home. Steps to clone an Oracle home step 1 : Stop Services Stop all processes related to the Oracle home. Step 2 : Create a ZIP or TAR file with the Oracle home (/u01/app/oracle/product/19.0.0/dbhome_1)    Use ROOT user for ZIP and UNZIP  # zip -r dbhome_1.zip /u01/app/oracle/product/19.0.0/dbhome_1 TAR option: # tar -cvf dbhome_1.tar /u01/app/oracle/product/19.0.0/dbhome_1 Step 3: s cp zip/tar to target s...
Post a Comment
Read more

EBS Standby Role Tranistion using standby database and standby application Tier

 Role Transitions A database can operate in either a primary or standby role - these roles are mutually exclusive. Oracle Data Guard enables you to change these roles dynamically by issuing SQL commands, and supports the following transitions: Switchover Allows the primary database to switch roles with one of its standby databases. There is no data loss during a switchover. After a switchover, each database continues to participate in the Oracle Data Guard configuration with its new role. Failover Changes a standby database to the primary role in response to a primary database failure. The following role transitions are discussed: 6.1 Performing a Switchover 6.2 Performing a Failover 6.3 Performing a Switchback to the Primary Following A Switchover/Failover Each of these three transitions requires some application configuration to be performed. Most of the application configuration step...
1 comment
Read more

EBS R12.2.4 AutoConfig could not successfully execute the following scripts followed by error "txkGenADOPWrapper.pl INSTE8_APPLY 1"

issue:txkGenADOPWrapper.pl    INSTE8_APPLY       1 WARNING: [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>   [APPLY PHASE]   AutoConfig could not successfully execute the following scripts:     Directory: /u01/applprod/fs2/FMW_Home/webtier/perl/bin/perl -I /u01/applprod/fs2/FMW_Home/webtier/perl/lib/5.10.0 -I /u01/applprod/fs2/FMW_Home/webtier/perl/lib/site_perl/5.10.0 -I /u01/applprod/fs2/EBSapps/appl/au/12.0.0/perl -I /u01/applprod/fs2/FMW_Home/webtier/ohs/mod_perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /u01/applprod/fs2/inst/apps/PRODDB_epc-apps12-node41v/admin/install       txkGenADOPWrapper.pl    ...
Post a Comment
Read more