Skip to content
Advertisements

Logical volume group partition inactive

We rebooted a one of our linux machine which is running a database, After rebooted We can’t able to start the database due to the one of partition of the logical volume group has missing.

[root@ezylebuat ~]# pvs
WARNING: Device for PV EiG4AR-8JDt-bzEj-5si7-Wf4z-xrYC-a8zXgu not found or rejected by a filter.
WARNING: Device for PV HfPGnn-1bgb-j1HH-7Xvd-6hvq-yk14-jMCrkM not found or rejected by a filter.
PV VG Fmt Attr PSize PFree
/dev/sda2 ol lvm2 a– <199.00g 0
[unknown] ol lvm2 a-m <50.00g 0
[unknown] ol lvm2 a-m <50.00g <50.00g

[root@ezylebuat ~]# lvscan
WARNING: Device for PV EiG4AR-8JDt-bzEj-5si7-Wf4z-xrYC-a8zXgu not found or rejected by a filter.
WARNING: Device for PV HfPGnn-1bgb-j1HH-7Xvd-6hvq-yk14-jMCrkM not found or rejected by a filter.
inactive ‘/dev/ol/u01’ [<167.00 GiB] inherit
ACTIVE ‘/dev/ol/swap’ [<32.00 GiB] inherit
ACTIVE ‘/dev/ol/home’ [25.00 GiB] inherit
ACTIVE ‘/dev/ol/root’ [25.00 GiB] inherit

 

Solution :

activate the volume group

 

[root@ezylebuat ~]# vgchange -a y –partial ol
PARTIAL MODE. Incomplete logical volumes will be processed.
WARNING: Device for PV EiG4AR-8JDt-bzEj-5si7-Wf4z-xrYC-a8zXgu not found or rejected by a filter.
WARNING: Device for PV HfPGnn-1bgb-j1HH-7Xvd-6hvq-yk14-jMCrkM not found or rejected by a filter.
4 logical volume(s) in volume group “ol” now active

 

[root@ezylebuat ~]# df -h
Filesystem Size Used Avail Use% Mounted on
devtmpfs 7.7G 0 7.7G 0% /dev
tmpfs 7.8G 0 7.8G 0% /dev/shm
tmpfs 7.8G 8.9M 7.8G 1% /run
tmpfs 7.8G 0 7.8G 0% /sys/fs/cgroup
/dev/mapper/ol-root 25G 16G 9.5G 63% /
/dev/mapper/ol-home 25G 39M 25G 1% /home
tmpfs 1.6G 40K 1.6G 1% /run/user/0
/dev/sda1 1014M 266M 749M 27% /boot
/dev/sdb1 99G 31G 63G 34% /backup
/dev/mapper/ol-u01 117G 101G 17G 86% /u01

 

[root@ezylebuat ~]# lvdisplay
WARNING: Device for PV EiG4AR-8JDt-bzEj-5si7-Wf4z-xrYC-a8zXgu not found or rejected by a filter.
WARNING: Device for PV HfPGnn-1bgb-j1HH-7Xvd-6hvq-yk14-jMCrkM not found or rejected by a filter.
— Logical volume —
LV Path /dev/ol/u01
LV Name u01
VG Name ol
LV UUID OoQvh4-9PRs-zVY3-ZFbO-SGn9-qUng-iJR2wL
LV Write Access read/write
LV Creation host, time localhost.localdomain, 2018-01-17 11:43:54 +0300
LV Status available
# open 1
LV Size <167.00 GiB
Current LE 42751
Segments 2
Allocation inherit
Read ahead sectors auto
– currently set to 8192
Block device 249:4

 

After volume group activated , I can able to start the database . Even though  I can see the some of the HDD server failure, So  I plan to migrate the database to other machine.

Advertisements

java.sql.SQLException: invalid name pattern

We are trying to push the data to Oracle EBS via SOAP But We’re getting the below errors

Errors in log file

oracle.apps.fnd.soa.util.SOAException: ServiceProcessingError: Exception returned from JCA Service Runtime. file:/u01/…….soa/PLSQL/4457/XXACE_XXXXXXXX_LOAD.wsdl [ XXACE_XXXXXXXXXLOAD_ptt::XXACE_XXXXXXXXX_LOAD(InputParameters,OutputParameters) ] – WSIF JCA Execute of operation ‘XXACE_XXXXXXXXX_LOAD’ failed due to: Error while converting to a Java array object. Unable to convert the XSD element P_INVOICE_REC whose collection type is APPS.XXACE_XXXXXXXXX_SOA_PKG_XX_6. Cause: java.sql.SQLException: invalid name pattern: APPS.XXACE_XXXXXXX_SOA_PKG_XX_6 [Caused by: invalid name pattern: APPS.XXACE_XXXXXXX_SOA_PKG_XX_6] ; nested exception is: ORABPEL-11801 Error while converting to a Java array object. Unable to convert the XSD element P_INVOICE_REC whose collection type is APPS.XXACE_XXXXXXXXX_SOA_PKG_XX_6. Cause: java.sql.SQLException: invalid name pattern: APPS.XXACE_XXXXXXXXX_SOA_PKG_XX_6 [Caused by: invalid name pattern: APPS.XXACE_XXXXXXXXX_SOA_PKG_XX_6] Check to ensure that the XML data describing the collection matches the definition of the array in the XSD. Contact oracle support if error is not fixable. at oracle.apps.fnd.soa.provider.services.jca.JCAHandler.invoke(JCAHandler.java:173) at oracle.apps.fnd.soa.provider.services.jca.JCAHandler.handleRequest(JCAHandler.java:120) at oracle.apps.fnd.soa.provider.SOAProvider.processMessage(SOAProvider.java:342) at oracle.j2ee.ws.server.provider.ProviderProcessor.doEndpointProcessing(ProviderProcessor.java:958) at oracle.j2ee.ws.server.WebServiceProcessor$1.run(WebServiceProcessor.java:388) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:396) at oracle.j2ee.ws.server.WebServiceProcessor.invokeEndpointImplementation(WebServiceProcessor.java:385) at oracle.j2ee.ws.server.provider.ProviderProcessor.doRequestProcessing(ProviderProcessor.java:481) at oracle.j2ee.ws.server.WebServiceProcessor.processRequest(WebServiceProcessor.java:114) at oracle.j2ee.ws.server.WebServiceProcessor.doService(WebServiceProcessor.java:96) at oracle.j2ee.ws.server.WebServiceServlet.doPost(WebServiceServlet.java:200) at javax.servlet.http.HttpServlet.service(HttpServlet.java:763) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391) at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458) at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313) at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:662) org.collaxa.thirdparty.apache.wsif.WSIFException:

Solution :Regenerate the WSDL and deploy

We push the data, its successful.

Please be note : We cloned the data only not entire application files, so that reason the above error occurred.

mailx sender address picks the OS user account instead of sender address

We’re trying to send email from redhat 7 terminal using with below command,

mailx -s “Test mail” mazar@xxxx.com -r ezylebdb@alerts.xxxx.net

But its sender by OS hostname

Solution :

Send by like below

mailx -r ezylebdb@alerts.xxxx.net -s “Test mail” mazar@xxxx.com

 

EBS 12.2.6 Generate Automatically and Enter Manually Options Are Missing In User Management

When you try to reset password for asadmin and other users in User management, Its invisible.

Solution :

 

12.2.6 Reset Password Options: Generate Automatically and Enter Manually Options Are Missing In User Management > Users Page (Doc ID 2260179.1)

ORA-20008: No Concurrent Manager is defined that can run concurrent program

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
ADZDPATCH
ORA-06512: at “APPS.AD_ZD_ADOP”, line 274
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.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

“adopscanlog -latest=yes”

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)

 

Solution :

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).

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

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.

bsu.sh Exception in thread “main” java.lang.OutOfMemoryError: GC overhead limit exceeded

Error :

[appluat@ebs-xxx–xxx bsu]$ bsu.sh -install -patch_download_dir=/u01/EBSUPGR/fs1/FMW_Home/utils/bsu/cache_dir -patchlist=EQDE -prod_dir=/u01/EBSUPGR/fs1/FMW_Home/wlserver_10.3
Exception in thread “main” java.lang.OutOfMemoryError: GC overhead limit exceeded
at org.apache.xmlbeans.impl.schema.SchemaTypeImpl.getProperties(SchemaTypeImpl.java:707)
at com.bea.cie.common.dao.xbean.XBeanDataHandler.loadPropertyMap(XBeanDataHandler.java:775)
at com.bea.cie.common.dao.xbean.XBeanDataHandler.<init>(XBeanDataHandler.java:99)
at com.bea.cie.common.dao.xbean.XBeanDataHandler.createDataHandler(XBeanDataHandler.java:559)
at com.bea.cie.common.dao.xbean.XBeanDataHandler.getComplexValue(XBeanDataHandler.java:455)
at com.bea.plateng.patch.dao.cat.PatchCatalogHelper.getPatchDependencies(PatchCatalogHelper.java:442)
at com.bea.plateng.patch.dao.cat.PatchCatalogHelper.getPatchDependencies(PatchCatalogHelper.java:464)
at com.bea.plateng.patch.dao.cat.PatchCatalog.getPatchDependencies(PatchCatalog.java:56)
at com.bea.plateng.patch.dao.cat.PatchCatalogHelper.getInvalidatedPatchMap(PatchCatalogHelper.java:1621)
at com.bea.plateng.patch.PatchSystem.updatePatchCatalog(PatchSystem.java:436)
at com.bea.plateng.patch.PatchSystem.refresh(PatchSystem.java:130)
at com.bea.plateng.patch.PatchSystem.setCacheDir(PatchSystem.java:201)
at com.bea.plateng.patch.Patch.main(Patch.java:281)

Solution :

/u01/EBSUPGR/fs1/FMW_Home/utils/bsu

vi bsu.sh

MEM_ARGS=”-Xms512m -Xmx1048m -XX:+UseParallelGC”

to

MEM_ARGS=”-Xms1536m -Xmx1536m -XX:+UseParallelGC”

 

 

[appluat@ebs-xxx-xxx bsu]$ bsu.sh -install -patch_download_dir=/u01/EBSUPGR/fs1/FMW_Home/utils/bsu/cache_dir -patchlist=EQDE -prod_dir=/u01/EBSUPGR/fs1/FMW_Home/wlserver_10.3
Checking for conflicts…….
No conflict(s) detected

Installing Patch ID: EQDE.
Result: Success

 

RW-20006: Error: – OC4J JMS Port Range for Oafm value is not valid: port value = 24505-24509

while doing Upgrade EBS 12.2, you may get the below issue when validate application node

 

“RW-20006: Error: – OC4J JMS Port Range for Oafm value is not valid: port value = 24505-24509”

 

Solution :

check any port range open

netstat -anp|grep 245

and then Kill the process or reboot the server