When I am trying to prepare phase in ADOP, I am getting below issue
Submitting ADZDPATCH concurrent program.
Waiting for conflicting requests to complete.
[ERROR] Failed to execute sql statement:
select AD_ZD_ADOP.WAIT_FOR_CP_TO_RUN(5775506) from dual
[ERROR] SQLPLUS error: buffer=
SQL*Plus: Release 10.1.0.5.0 – Production on Wed Jan 23 16:39:59 2019
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> SQL> Connected.
SQL> select AD_ZD_ADOP.WAIT_FOR_CP_TO_RUN(5775506) from dual
ERROR at line 1:
ORA-20008: No Concurrent Manager is defined that can run concurrent program
ORA-06512: at “APPS.AD_ZD_ADOP”, line 274
Disconnected from Oracle Database 12c Enterprise Edition Release 126.96.36.199.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[UNEXPECTED]Error calling runConcurrentProgram subroutine.
Stopping services on patch file system.
Stopping admin server.
Stopping node manager.
[ERROR] Prepare phase has failed.
[STATEMENT] Please run adopscanlog utility, using the command
to get the list of the log files along with snippet of the error message corresponding to each log file.
adop exiting with status = 1 (Fail)
Please check your concurrent manager are working fine and then start to do prepare phase again, It will work.
If concurrent manager does not have issue, check the support document (Doc ID 2334520.1).
When users are trying to take output or view log files after completed request, they are getting below issues
An error occurred while attempting to receive the output arguments of the remote procedure. Function ncrorou returned error code 3010. The Applications File Server process may have exited abnormally. Please contact your system administrator.
check your DB, Application & Web Server free space
I am trying to change the one of the database running on Window server with my domain user But this existing oracle service running on NT Services.
I renamed the database and created a new sid and service started by NT Services and then I tried to start the database, Its throwing the below error
SQL> startup pfile=’E:\oracle\INITSIEBUAT.ORA’;
ORACLE instance started.
Total System Global Area 7734296576 bytes
Fixed Size 8764936 bytes
Variable Size 1543504376 bytes
Database Buffers 6174015488 bytes
Redo Buffers 8011776 bytes
ORA-01157: cannot identify/lock data file 8 – see DBWR trace file
ORA-01110: data file 8: ‘E:\ORACLE\PRODUCT\12.2.0\DBHOME_1\DATABASE\S_DATA01’
I checked the alter log file
Errors in file E:\ORACLE\diag\rdbms\siebelbi\siebelbi\trace\siebelbi_dbw0_8316.trc:
ORA-01157: cannot identify/lock data file 9 – see DBWR trace file
ORA-01110: data file 9: ‘E:\ORACLE\PRODUCT\12.2.0\DBHOME_1\DATABASE\S_DATA02’
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.
But I have full rights of the directory but still I am facing the above issue
I stopped the services and started the services Log on as Local Account, the database is opened.
When you’re doing clone of EBS 12.2, you may get below issue
INFO : Rapid Clone completed successfully , but the AutoConfig run recorded some errors.
Please review the AutoConfig section in the logfile. and Re-Run the entire cloning cycle , after fixing the problem.
Checked the logfile :
AutoConfig could not successfully execute the following scripts:
Directory: /u01/LEBEBSDEV/fs2/FMW_Home/webtier/perl/bin/perl -I /u01/LEBEBSDEV/fs2/FMW_Home/webtier/perl/lib/5.10.0 -I /u01/LEBEBSDEV/fs2/FMW_Home/webtier/perl/lib/site_perl/5.10.0 -I /u01/LEBEBSDEV/fs2/EBSapps/appl/au/12.0.0/perl -I /u01/LEBEBSDEV/fs2/FMW_Home/webtier/ohs/mod_perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /u01/LEBEBSDEV/fs2/inst/apps/EBSLEBBI_bid-leb-119-60/admin/install
txkGenADOPWrapper.pl INSTE8_APPLY 1
AutoConfig is exiting with status 1
ERROR: RC-50014: Fatal: Execution of AutoConfig was failed
Raised by oracle.apps.ad.clone.ApplyApplTop
I am trying to get node value
SQL> SELECT ad_zd_adop.get_node_type(‘node name’) from dual;
SELECT ad_zd_adop.get_node_type(‘node name’) from dual
ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at “APPS.AD_ZD_ADOP”, line 3062
Autoconfig Error: ORA-01422: Exact Fetch Returns More Than Requested Number Of Rows (Doc ID 2212698.1)
As per the document If parameter is disabled, I can’t start the admin server node. because I configured single node, but the admin node type is in second row and first row is non shared master node, However I can able to start the service. I need to check with Oracle regarding how to fix permanently.