Skip to content
Advertisements

Oracle database 12c (12.2.0.1.0) step by step installation guide on oracle linux 7.6

Installation document :

Oracle Database 12.2.0.1.0 step by step installation guide on oracle linux 7.6

 

Issue faced:

 

[root@dbhost1 ~]# xhost +
access control disabled, clients can connect from any host
[root@dbhost1 ~]# su – oracle
Last login: Mon Jun 17 14:36:55 +03 2019 on pts/1
[oracle@dbhost1 ~]$ cd /u01/install/database/
[oracle@dbhost1 database]$ ./runInstaller
Starting Oracle Universal Installer…

Checking Temp space: must be greater than 500 MB. Actual 35971 MB Passed
Checking swap space: must be greater than 150 MB. Actual 2047 MB Passed
Checking monitor: must be configured to display at least 256 colors
>>> Could not execute auto check for display colors using command /usr/bin/xdpyinfo. Check if the DISPLAY variable is set. Failed <<<<

Some requirement checks failed. You must fulfill these requirements before

continuing with the installation,

Continue? (y/n) [n] n

User Selected: No

Exiting Oracle Universal Installer, log for this session can be found at /tmp/OraInstall2019-06-17_02-39-33PM/installActions2019-06-17_02-39-33PM.log

solution :

[oracle@dbhost1 database]$ export DISPLAY=:0
[oracle@dbhost1 database]$ ./runInstaller

Advertisements

ORA-19809 ORA-19804

I trying to open a one of our old database and I am getting following error

 

SQL> startup
ORACLE instance started.

Total System Global Area 5117050880 bytes
Fixed Size 8757424 bytes
Variable Size 1207963472 bytes
Database Buffers 3892314112 bytes
Redo Buffers 8015872 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 7328
Session ID: 373 Serial number: 9392

 

Alert log file :

Errors in file C:\APP\ORACLE\diag\rdbms\auditdb\auditdb\trace\auditdb_ora_1280.trc:
ORA-16038: log 3 sequence# 63 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 3 thread 1: ‘C:\APP\ORACLE\ORADATA\AUDITDB\ONLINELOG\O1_MF_3_G3XO7R8J_.LOG’
ORA-00312: online log 3 thread 1: ‘C:\APP\ORACLE\FAST_RECOVERY_AREA\AUDITDB\AUDITDB\ONLINELOG\O1_MF_3_G3XO7YNR_.LOG’
2019-06-12T12:06:43.111652+03:00
USER (ospid: 1280): terminating the instance due to error 16038
ERROR: Unable to normalize symbol name for the following short stack (at offset 125):
dbgeGetAsyncActivForED()+939<-dbkif_record_dde_actions()+421<-ksuitm_opt()+2482<-ksuitm()+14<-kcfopd()+10758<-adbdrv_options..0()+38247<-adbdrv()+161<-opiexe()+29912<-opiosq0()+6886<-kpooprx()+464<-kpoal8()+1173<-opiodr()+1378<-ttcpip()+1368<-opitsk()+2474<-opiino()+1265<-opiodr()+1378<-opidrv()+1833<-sou2o()+112<-opimai_real()+499<-opimai()+231<-OracleThreadStart()+745<-00007FFDB0B084D4<-00007FFDB340E851
2019-06-12T12:06:43.181682+03:00
Errors in file C:\APP\ORACLE\diag\rdbms\auditdb\auditdb\trace\auditdb_tt00_12308.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 209715200 bytes disk space from 10009706496 bytes limit
2019-06-12T12:06:43.489757+03:00
System state dump requested by (instance=1, osid=1280), summary=[abnormal instance termination].
System State dumped to trace file C:\APP\ORACLE\diag\rdbms\auditdb\auditdb\trace\auditdb_diag_13476_20190612120643.trc
2019-06-12T12:06:47.049651+03:00
Instance terminated by USER, pid = 1280

 

Solution :

Deleted  the old archivelog file and reclaim space

SQL> startup mount
ORACLE instance started.

Total System Global Area 5117050880 bytes
Fixed Size 8757424 bytes
Variable Size 1207963472 bytes
Database Buffers 3892314112 bytes
Redo Buffers 8015872 bytes
Database mounted.

RMAN> crosscheck archivelog all;  or delete archivelog all

RMAN> delete expired archivelog all;

SQL> alter database open;

Database altered.

SQL> select status from v$instance;

STATUS
————
OPEN

could not lock request concurrent manager

When we try to cancel a some request in concurrent manager, we might got the below issue

 

“could not lock request” ,

Solution :

Output post processor may have a issue, so terminate the output post processor and activate again.

 

But still the old request running on long time and complete with warnings or the request keep on running, so you need to cancel the request from database backend.

 

open two session as a apps user

Cancel the request :

 

update fnd_concurrent_requests set phase_code=’C’ , status_code=’X’ where request_id=’8239849′;

the command may be taking long time for complete or keep running. so you please check any blocking session there in the system

 

select sid, username, event, blocking_session,
seconds_in_wait, wait_time
from v$session where state in (‘WAITING’)
and wait_class != ‘Idle’;

 

kill the blocking session and you can see the cancel update command done and commit. now the request has been  terminated.

Hopefully after output post processor activated, the future concurrent request are running without issues.

 

 

Troubleshooting Oracle Temporary Tablespaces

Refer

Master Note: Troubleshooting Oracle Temporary Tablespaces (Doc ID 1524594.1)

 

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.

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