Skip to content
Advertisements

Archive for

An error occurred while attempting to receive the output arguments of the remote procedure. Function ncrorou returned error code 3010

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.

 

Solution :

check your DB, Application & Web Server free space

Advertisements

ORA-01157 ORA-01110 ORA-27041 OSD-04002 O/S-Error

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
Database mounted.
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

Solution:

 

I stopped the services and started the services Log on as Local Account, the database is opened.

 

 

ORA-01422: exact fetch returns more than requested number of rows

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 :

[APPLY PHASE]
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

 

Solution :

Refer

Autoconfig Error: ORA-01422: Exact Fetch Returns More Than Requested Number Of Rows (Doc ID 2212698.1)

 

Note :

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.