ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

 root@pandba:/u01/app/oracle/product/12.1.0/dbhome_1/network/admin#

root@pandba:/u01/app/oracle/product/12.1.0/dbhome_1/network/admin# more listener.ora

# listener.ora Network Configuration File: /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = pandba)(PORT = 1521))

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

    )

  )

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

       (GLOBAL_DBNAME = GISUAT)

       (SID_NAME = GISUAT))

     (SID_DESC =

        (GLOBAL_DBNAME = PDBORCL)

        (SID_NAME = PDBORCL))

  )

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_PDB_LISTENER=ON          # line added by Agent

VALID_NODE_CHECKING_REGISTRATION_PDB_LISTENER=SUBNET           # line added by Agent

root@pandba:/u01/app/oracle/product/12.1.0/dbhome_1/network/admin#

root@pandba:/u01/app/oracle/product/12.1.0/dbhome_1/network/admin# more tnsnames.ora

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

GISUAT =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = pandba)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = GISUAT)

    )

  )

PDBORCL =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = pandba)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = PDBORCL)

    )

  )

root@pandba:/u01/app/oracle/product/12.1.0/dbhome_1/network/admin#

root@pandba:/u01/app/oracle/product/12.1.0/dbhome_1/network/admin# more sqlnet.ora

# sqlnet.ora Network Configuration File: /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/sqlnet.ora

# Generated by Oracle configuration tools.

#NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

SQLNET.ALLOWED_LOGON_VERSION_CLIENT=11

SQLNET.ALLOWED_LOGON_VERSION_SERVER=11

root@pandba:/u01/app/oracle/product/12.1.0/dbhome_1/network/admin#

oracle@pandba:~$ sqlplus gisadmin/password@PDBORCL

SQL*Plus: Release 12.1.0.2.0 Production on Mon Jan 27 08:07:05 2020

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to:

Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production

SQL> show user;

USER is "GISADMIN"

SQL> exit

Disconnected from Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production

oracle@pandba:~$ m

list of dba users ACCOUNT_STATUS Expired

 

SQL> select USERNAME,ACCOUNT_STATUS,EXPIRY_DATE,PROFILE,LOCK_DATE from dba_users;

USERNAME                       ACCOUNT_STATUS                   EXPIRY_DA PROFILE                        LOCK_DATE

------------------------------ -------------------------------- --------- ------------------------------ ---------

SYS                            OPEN                             22-OCT-15 DEFAULT

SYSTEM                         OPEN                             30-AUG-17 DEFAULT

OUTLN                          OPEN                             03-OCT-15 DEFAULT

DBSNMP                         OPEN                             03-OCT-15 DEFAULT

ABM                            OPEN                             09-SEP-04 DEFAULT

AHL                            OPEN                             09-SEP-04 DEFAULT

ORDSYS                         OPEN                             03-OCT-15 DEFAULT

ORDPLUGINS                     OPEN                             03-OCT-15 DEFAULT

MDSYS                          OPEN                             03-OCT-15 DEFAULT

E-Business Suite : Responsibilities Are Not Visible When End Date Is Removed

1. Run the request ‘Sync responsibility role data into the WF table’.

2. Run the request “Synchronize WF LOCAL tables”.

3. Run the request “Workflow Directory Services User/Role Validation” (with parameters 10000, yes,yes, yes).

4. Have the user log off and back on and verify that the responsibility appears.

Query to check long running sql

 

Concurrent programs running for + hours

col PROGRAM for a12;
col ACTION for a12;
col MODULE  for a12;
col EVENT for a12;
select status,sid,serial#,module,program,action,event from v$session where logon_time < sysdate-0.125 and action like 'Concurrent Request%';
col PROGRAM for a12;
col ACTION for a12;
col MODULE  for a12;
col EVENT for a12;
select status,sid,serial#,module,program,action,event from v$session where logon_time < sysdate-0.050 and action like 'Concurrent Request%';

select * from v$session where logon_time < sysdate-0.050 and action like '%Concurrent Request%';
prompt Inactive form session with login time greater than 6 hours
prompt *********************************************************************************************************
select sid,serial#,module,action,event,to_char(logon_time,'dd:mm:yyyy hh24:mi:ss'),last_call_et/3600 "last call et in hours" from v$session where status likE 'INACTIVE' and logon_time < sysdate-0.25 and action like 'FRM:%' order by 
logon_time;
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

 HIGH RESOURCE CONSUMING SQL

select sql_text,
       username,
       disk_reads_per_exec,
       buffer_gets,
       disk_reads,
       parse_calls,
       sorts,
       executions,
       rows_processed,
       hit_ratio,
       first_load_time,
       sharable_mem,
       persistent_mem,
       runtime_mem,
       cpu_time,
       elapsed_time,
       address,
       hash_value
from
(select sql_text ,
        b.username ,
 round((a.disk_reads/decode(a.executions,0,1,
 a.executions)),2)
       disk_reads_per_exec,
       a.disk_reads ,
       a.buffer_gets ,
       a.parse_calls ,
       a.sorts ,
       a.executions ,
       a.rows_processed ,
       100 - round(100 *
       a.disk_reads/greatest(a.buffer_gets,1),2) hit_ratio,
       a.first_load_time ,
       sharable_mem ,
       persistent_mem ,
       runtime_mem,
       cpu_time,
       elapsed_time,
       address,
       hash_value
from
   sys.v_$sqlarea a,
   sys.all_users b
where
   a.parsing_user_id=b.user_id and
   b.username not in ('sys','system')
order by 3 desc)
where rownum < 21;
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
modukle name TA_auto_apply

If Actual and Target OPP processes do not match EBS

 Check from backend which ones are "ACTIVE"

SQL> select sid,serial#,program,module,status,process,logon_time from v$session where module like'%OPP%';

       SID    SERIAL# PROGRAM
---------- ---------- ------------------------------------------------
MODULE                                           STATUS   PROCESS      LOGON_TIM
------------------------------------------------ -------- ------------ ---------
      4748          1 JDBC Thin Client
FNDCPOPP                                         INACTIVE              15-JUL-20
      4750          3 JDBC Thin Client
FNDCPOPP                                         INACTIVE              15-JUL-20
      4753         17 JDBC Thin Client
FNDCPOPP                                         INACTIVE              15-JUL-20

       SID    SERIAL# PROGRAM
---------- ---------- ------------------------------------------------
MODULE                                           STATUS   PROCESS      LOGON_TIM
------------------------------------------------ -------- ------------ ---------
      5769         31 JDBC Thin Client
FNDCPOPP                                         ACTIVE                20-JUL-20
      5773         10 JDBC Thin Client
FNDCPOPP                                         ACTIVE                20-JUL-20
      5780          4 JDBC Thin Client
FNDCPOPP                                         ACTIVE                20-JUL-20

6 rows selected.

select sid,serial#,program,module,status,process,logon_time from v$session where module like'%OPP%'and status='INACTIVE';

ALTER SYSTEM KILL SESSION 'sid,serial#' IMMEDIATE;

alter system kill session '4748,1' immediate;

alter system kill session '4750,3' immediate;

alter system kill session '4753,17' immediate;

SQL> select sid,serial#,status,logon_time,module from v$session where module like'%OPP%';

  SID    SERIAL# STATUS   LOGON_TIM
---------- ---------- -------- ---------
MODULE
------------------------------------------------
      5769         31 ACTIVE   20-JUL-20
FNDCPOPP
      5773         10 ACTIVE   20-JUL-20
FNDCPOPP
      5780          4 ACTIVE   20-JUL-20
FNDCPOPP

Check from front end.

Actual and Target processes should both be 3.

Oracle Grant privilege to function

SQL> desc apps.xxta_inter_acces;

FUNCTION apps.xxta_inter_acces RETURNS NUMBER(38)

 Argument Name                  Type                    In/Out Default?

 ------------------------------ ----------------------- ------ --------

 P_SR                           VARCHAR2                IN

 P_TEL                          VARCHAR2                IN

SQL> create user xxalj identified by xxalj;

User created.

SQL> grant connect,resource to xxalj;

Grant succeeded.

SQL> grant select on dual to xxalj;

Grant succeeded.

SQL> conn apps/taapps11i

Connected.

grant execute on apps.xxta_inter_acces to xxalj;

SQL> conn xxalj/xxalj

Connected.

SQL> desc apps.xxta_inter_acces;

FUNCTION apps.xxta_inter_acces RETURNS NUMBER(38)

 Argument Name                  Type                    In/Out Default?

 ------------------------------ ----------------------- ------ --------

 P_SR                           VARCHAR2                IN

 P_TEL                          VARCHAR2                IN

OBJECT_NAME

--------------------------------------------------------------------------------

OWNER                          OBJECT_TYPE

------------------------------ -------------------

XXTA_INTER_ACCES

APPS                           FUNCTION

find username for request_id EBS

 select a.request_id,b.user_name from fnd_concurrent_requests a,fnd_user b where a.requested_by=b.user_id and a.request_id='&requestid';

how to delete Delete Trace Files

 oratest#df -k .

/db03                  (/dev/vgdb01/lvDB03    ) : 261776736 total allocated Kb

                                                   5561302 free allocated Kb

                                                  256215434 used allocated Kb

                                                        97 % allocation used

find /db03/oracle/10R2/admin/PROD_oratest/udump -mtime +15 -name "*.trc"|wc -l

find /db03/oracle/10R2/admin/PROD_oratest/udump -mtime +15 -name "*.trc" -exec rm "{}" ";"

oratest#df -k .

/db03                  (/dev/vgdb01/lvDB03    ) : 261564248 total allocated Kb

                                                   8765334 free allocated Kb

                                                  252798914 used allocated Kb

                                                        96 % allocation used

find /db03/oracle/10R2/admin/PROD_oratest/bdump -mtime +15 -name "*.trc"|wc -l

find /db03/oracle/10R2/admin/PROD_oratest/bdump -mtime +15 -name "*.trc" -exec rm "{}" ";"

oratest#df -k .

/db03                  (/dev/vgdb01/lvDB03    ) : 261560275 total allocated Kb

                                                   8825460 free allocated Kb

                                                  252734815 used allocated Kb

                                                        96 % allocation used

find /db03/oracle/10R2/admin/PROD_oratest/udump -mtime +35 -name "*.trc"|wc -l

find /db03/oracle/10R2/admin/PROD_oratest/udump -mtime +35 -name "*.trc" -exec rm "{}" ";"

oratest#df -k .

/db03                  (/dev/vgdb01/lvDB03    ) : 261474396 total allocated Kb

                                                  10118857 free allocated Kb

                                                  251355539 used allocated Kb

                                                        96 % allocation used

Delete Apache logs & rti files

 find /app01/oracle/prodcomn/conf/PROD_approd1/iAS/Apache/Apache/logs -type f -mtime +180|wc -l

approd1#df -k .

/app01                 (/dev/vgapp01/app01    ) : 102400000 total allocated Kb

                                                   2210727 free allocated Kb

                                                  100189273 used allocated Kb

                                                        97 % allocation used

find /app01/oracle/prodcomn/conf/PROD_approd1/iAS/Apache/Apache/logs -mtime +180 -name "access_log*"|wc -l

find /app01/oracle/prodcomn/conf/PROD_approd1/iAS/Apache/Apache/logs -mtime +180 -name "access_log*" -exec rm "{}" ";"

approd1#df -k .

/app01                 (/dev/vgapp01/app01    ) : 101759060 total allocated Kb

                                                  13011907 free allocated Kb

                                                  88747153 used allocated Kb

                                                        87 % allocation used

find /app01/oracle/prodcomn/conf/PROD_approd1/iAS/Apache/Apache/logs -mtime +365 -name "OracleSoapAuditLog*"|wc -l

find /app01/oracle/prodcomn/conf/PROD_approd1/iAS/Apache/Apache/logs -mtime +365 -name "OracleSoapAuditLog*" -exec rm "{}" ";"

find /app01/oracle/prodcomn/conf/PROD_approd1/iAS/Apache/Apache/logs -type f -mtime +365 |xargs rm -Rf {} \;

find /app01/oracle/prodcomn/conf/PROD_approd1/iAS/Apache/Apache/logs -type f -mtime +365|wc -l

===========Delete ".rti" and "f60dump" files from $APPLCSF/$APPLLOG===========

find $APPLCSF/$APPLLOG -mtime +1 -name "*.rti"|wc -l

find $APPLCSF/$APPLLOG -mtime +1 -name "*.rti" -exec rm "{}" ";"

find $APPLCSF/$APPLLOG -mtime +1 -name "f60*dump*"|wc -l

find $APPLCSF/$APPLLOG -mtime +1 -name "f60*dump*" -exec rm "{}" ";"

Query to find Concurrent programs running for more then 4 hours

 set line 200
set pagesize 500
col PROGRAM_NAME format a30
col concreq format a8
col Username format a10
col opid format a4
col dbuser format a6
SELECT SUBSTR(LTRIM(req.request_id),1,15) concreq,
           fcp.USER_CONCURRENT_PROGRAM_NAME "Program_Name",
                fu.user_name "Username",
               round((sysdate - actual_start_date) * 24 ,2) "Running_Hrs", 
           SUBSTR(proc.os_process_id,1,15) clproc,
           SUBSTR(LTRIM(proc.oracle_process_id),1,15) opid,
           SUBSTR(vsess.username,1,10) dbuser,
           SUBSTR(vproc.spid,1,10) svrproc,
           vsess.sid sid,
           vsess.serial# serial#
    FROM   fnd_concurrent_requests req,
           fnd_concurrent_processes proc,
           fnd_lookups look,
           fnd_lookups look1,
           v$process vproc,
           v$session vsess,
           fnd_concurrent_programs_vl fcp,
        fnd_user fu
    WHERE  req.controlling_manager = proc.concurrent_process_id(+)
    AND    req.status_code = look.lookup_code
    AND    look.lookup_type = 'CP_STATUS_CODE'
    AND    req.phase_code = look1.lookup_code
    AND    look1.lookup_type = 'CP_PHASE_CODE'
    AND    look1.meaning = 'Running'
    and    req.CONCURRENT_PROGRAM_ID = fcp.CONCURRENT_PROGRAM_ID
    AND    proc.oracle_process_id = vproc.pid(+)
    AND    vproc.addr = vsess.paddr(+)
    AND    fu.user_id = req.requested_by
    AND    round((sysdate - actual_start_date) * 24) > 4;

To find Blocking Session

 To find Blocking Session

========================================

col WAIT_CLASS for a12;

select blocking_session,sid,serial#,wait_class,seconds_in_wait,status

from v$session where blocking_session is not NULL order by blocking_session;

select sid,serial#,event,module,action,status,program,blocking_session,last_call_et/60 min from v$session where sid=&sid;

select p.spid,s.sid,s.serial#,s.status,s.last_call_et,s.module,s.osuser from V$process p,V$session s where s.paddr = p.addr and p.spid=&pid;

SQL> alter system kill session '5213,45198';

To find out work flow blocking session 

select sid,serial#,event,module,action,status,program,blocking_session,last_call_et from V$session where module like '%WFBG%';

**********************************************************************************

Blocking session 

select l1.sid, ' IS BLOCKING ', l2.sid

  from v$lock l1, v$lock l2

  where l1.block =1 and l2.request > 0

  and l1.id1=l2.id1

  and l1.id2=l2.id2;

********************************************************************************

BLocking session

select s1.username || '@' || s1.machine

   || ' ( SID=' || s1.sid || ' )  is blocking '

   || s2.username || '@' || s2.machine || ' ( SID=' || s2.sid || ' ) ' AS blocking_status

   from v$lock l1, v$session s1, v$lock l2, v$session s2

   where s1.sid=l1.sid and s2.sid=l2.sid

   and l1.BLOCK=1 and l2.request > 0

   and l1.id1 = l2.id1

   and l2.id2 = l2.id2 ;

************************************************************************

Blocking session

select do.object_name,

  row_wait_obj#, row_wait_file#, row_wait_block#, row_wait_row#,

  dbms_rowid.rowid_create ( 1, ROW_WAIT_OBJ#, ROW_WAIT_FILE#, ROW_WAIT_BLOCK#, ROW_WAIT_ROW# )

  from v$session s, dba_objects do

  where sid=543

  and s.ROW_WAIT_OBJ# = do.OBJECT_ID ;

alter system kill session 'SID,SERIAL#';

Configure Agents with OBIEE 12c and EBS Cookie Integration

1. Create a new session initialization block called 'EBS Initialize Session Cookies'

2. Click on 'Edit Data Source' and input the default Initialization String as:

select '-1', '0' from dual;

3. Select the Oracle EBS OLTP Connection Pool

4. Press 'Edit Target Data' button and create 2 variables: ICX_SESSION_COOKIE and ACF

5. Define session variable: ICX_SESSION_COOKIE:

6. Check the "Enable any user to set the value" checkbox

7. Check the 'Security Sensitive" checkbox

8. Set the Default Initializer to:

'-1'

9. Define session variable: ACF

10. Check the "Enable any user to set the value" checkbox

11. Check the "Security Sensitive" checkbox

12. Set the Default Initializer to:

'0'

13. Redefine the 'Execute on connect' query for the Oracle EBS OLTP Connection Pools as follows:

Declare /* valueof (NQ_SESSION.ACF) */ v_icx_session_cookie varchar2(100) := 'valueof(NQ_SESSION.ICX_SESSION_COOKIE)'; begin if v_icx_session_cookie <> '-1' then APP_SESSION.validate_icx_session(v_icx_session_cookie); end if; end;

14. Update the session variable initialization block 'EBS Security Context' query to be:

select FND_GLOBAL.RESP_ID,
FND_GLOBAL.RESP_APPL_ID,
FND_GLOBAL.SECURITY_GROUP_ID,
FND_GLOBAL.RESP_NAME,
FND_GLOBAL.USER_ID,
FND_GLOBAL.EMPLOYEE_ID,
NVL(FND_GLOBAL.USER_NAME,'IMPERSONATOR') from dual
where NVL(FND_GLOBAL.USER_NAME,'IMPERSONATOR') != 'GUEST'
NQS_PASSWORD_CLAUSE(and FND_GLOBAL.USER_NAME != 'GUEST')NQS_PASSWORD_CLAUSE

15. Restart OBIEE services.

ORDS 403 not able to login using chrome and firefox

ORDS:-

Issue:-

The request cannot be processed because this resource does not support Cross Origin Sharing requests, or the request Origin is not authorized to access this resource. If ords is being reverse proxied ensure the front end server is propagating the host name, for mod_proxy ensure ProxyPreserveHost is set to On



Solution :-


1) Add below parameter in defaults.xml file and restart all services.

<entry key="security.httpsHeaderCheck">X-Forwarded-Proto: https</entry>

2) In case if your using  OHS  then restart OHS services.

oracle 19c Installation Fails with error libclntsh.so

While installation  19c oracle home we are facing below issue.

Issue:- 

1) libclntsh.so: file format not recognized; treating as linker script.

2) unzip issue cannot find LINUX.X64_193000_db_home.zip

Solution:-

[root@ebs143 dbhome_1]# chmod -R 644 LINUX.X64_193000_db_home.zip 

[root@ebs143 dbhome_1]# ll

total 2988000

-rw-r--r-- 1 root root 3059705302 Apr  7 22:21 LINUX.X64_193000_db_home.zip

[root@ebs143 dbhome_1]# chown -R oracle:dba LINUX.X64_193000_db_home.zip 

[root@ebs143 dbhome_1]# yum install zip

Loaded plugins: langpacks, ulninfo

Package zip-3.0-11.el7.x86_64 already installed and latest version

Nothing to do

[root@ebs143 dbhome_1]# yum install unzip 

Loaded plugins: langpacks, ulninfo

Resolving Dependencies

--> Running transaction check

---> Package unzip.x86_64 0:6.0-19.el7 will be installed

       Protected multilib versions: unzip-6.0-19.el7.x86_64 != unzip-5.40-1.i386

[root@ebs143 dbhome_1]# yum remove unzip

root@ebs143 dbhome_1]# yum install unzip 

Loaded plugins: langpacks, ulninfo

Resolving Dependencies

--> Running transaction check

---> Package unzip.x86_64 0:6.0-19.el7 will be installed

--> Finished Dependency Resolution

Dependencies Resolved

=======================================================================================

 Package         Arch             Version                 Repository              Size

=======================================================================================

Installing:

 unzip           x86_64           6.0-19.el7              InstallMedia           169 k

Transaction Summary

=======================================================================================

Install  1 Package

Total download size: 169 k

Installed size: 365 k

Is this ok [y/d/N]: Y

Downloading packages:

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

  Installing : unzip-6.0-19.el7.x86_64                                             1/1 

  Verifying  : unzip-6.0-19.el7.x86_64                                             1/1 

Installed:

  unzip.x86_64 0:6.0-19.el7                                                            

Complete!

[root@ebs143 dbhome_1]# 

Complete the installation.

OBIEE 12c: Exceeded configured maximum number of allowed input records

How to Fix Error Exceeded Co Maximum number of allowed I Records


Error:-

Solution :-


1) Go to the Instance Config file and take a backup copy of it .
2) Locate the cube section in the file, if it doesn't exist you might need to add.
3) Include the following set of code between the server instance tag.

Take a backup and modify [Domain-Home]/config/fmwconfig/biconfig/OBIPS/instanceconfig.xml

<Table>
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<DefaultRowsDisplayedInDownload>1000000</DefaultRowsDisplayedInDownload>
<DefaultRowsDisplayedInDownloadCSV>1000000</DefaultRowsDisplayedInDownloadCSV>
<MaxCells>20000000</MaxCells>
<MaxVisiblePages>10000</MaxVisiblePages>
<MaxVisibleRows>200000</MaxVisibleRows>
<MaxVisibleSections>200000</MaxVisibleSections>
<DefaultRowsDisplayed>30</DefaultRowsDisplayed>
</Table>

<Pivot>
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<DefaultRowsDisplayedInDownload>1000000</DefaultRowsDisplayedInDownload>
<DisableAutoPreview>false</DisableAutoPreview>
<MaxCells>20000000</MaxCells>
<MaxVisibleColumns>20000</MaxVisibleColumns>
<MaxVisiblePages>10000</MaxVisiblePages>
<MaxVisibleRows>200000</MaxVisibleRows>
<MaxVisibleSections>200000</MaxVisibleSections>
</Pivot>

To export large quantities of rows to MS Excel, increase the InputStreamLimitInKB parameter and changed the ReadRequestBeforeProcessing value to false in $DOMAIN_HOME/config/fmwconfig/biconfig/OBIJH/config.xml file, as recommended by Oracle in Doc ID 1595671.1 

<XMLP> 

<InputStreamLimitInKB>0</InputStreamLimitInKB> 

<ReadRequestBeforeProcessing>false</ReadRequestBeforeProcessing> 

</XMLP

<MessageProcessor> 

<!-- How much time worker thread should wait for a message before returning socket to the "idle" pool. Initial messages in the idle pool are handled using Java NIO Channels. --> 

<SocketTimeout>1200000</SocketTimeout> 

</MessageProcessor> 

In the obijh.properties file located in $ORACLE_HOME/bi/modules/oracle.bi.cam.obijh/env/ increase the memory reserved for JavaHost requests to 16GB 

MEM_ARGS=-Xmx16384M 

Edit the bridgeconfig.properties file, which is the configuration file for the Presentation Services Plug-In located in $DOMAIN_HOME/config/fmwconfig/biconfig/, adding the following parameters to increase the socket timeout and connection pool maximum connections 

# Number of seconds to wait for a response from sawserver 

# Default value is 360 seconds 

oracle.bi.presentation.sawconnect.ConnectionPool.SocketReadTimeoutSec = 3600 

# Maximum number of connections in pool. Default is a function of number of processors. 

# Default value is 128 

oracle.bi.presentation.sawconnect.ConnectionPool.MaxConnections = 512 

Restart OBIEE and validate the issue. 

4) If your using load balancer then perform below action plan

Take a backup of the existing configuration files mod_wl_ohs.conf. 

Increase the below parameter of <Location /analytics> and <Location /analytics-ws> to 

WLSocketTimeoutSecs 3600 

Restart OHS server and validate the issue. 

If still having the issue, increase the timeout from Oracle Load balancer "hostname". 

Contact your network team and troubleshoot network trace while running the report. This could help to understand the network breaking. 

Timeout parameter value of listener for obiee load balancer to 1800 seconds.

Error Codes: OAMP2OPY:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P:OI2DL65P

Error:

OAMP2OPY:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P:OI2DL65P
Odbc driver returned an error (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.


Solution:

[obiee@pan OBIS]$ pwd
/OBIEE/middleware/oracle/user_projects/domains/bi12/config/fmwconfig/biconfig/OBIS
[obiee@opera OBIS]$ ls -ltr
total 28
-rw-r----- 1 obiee dba 22401 Dec 26 11:06 NQSConfig.INI
-rw-r----- 1 obiee dba  1500 Dec 26 18:49 logconfig.xml
[obiee@pan OBIS]$ cp -rf NQSConfig.INI NQSConfig-org.INI
[obiee@pan OBIS]$ ls -ltr
total 52

Add below parameter.

[obiee@pan OBIS]$ ls
logconfig.xml  NQSConfig.INI  NQSConfig-org.INI
[obiee@opera OBIS]$ grep  EVALUATE_SUPPORT_LEVEL NQSConfig.INI
# EVALUATE_SUPPORT_LEVEL:
EVALUATE_SUPPORT_LEVEL = 2;
[obiee@pan OBIS]$

Restart BI services.

ORA-04063: Package Body APPS.FND_PROFILE Has Errors

Error:-


Cause: afpodbinit failed due to ORA-04068: existing state of packages has been discarded
ORA-04065: not executed, altered or dropped package body "APPS.ICX_SEC"
ORA-06508: PL/SQL: could not find program unit being called: "APPS.ICX_SEC"
ORA-06512: at "APPS.FND_PROFILE", l.


The SQL statement being executed at the time of the error was: begin fnd_global.bless_next_init('FND_PERMIT_0000'); fnd_global.initialize(:session_id, :user_id, :resp_id, :resp_appl_id, :security_group_id, :site_id, :login_id, :conc_login_id, :prog_appl_id, :conc_program_id, :conc_request_id, :conc_priority_request, :form_id, :form_application_id, :conc_process_id, :conc_queue_id, :queue_appl_id, :server_id); fnd_profile.put('ORG_ID', :org_id); fnd_profile.put('MFG_ORGANIZATION_ID', :mfg_org_id); fnd_profile.put('MFG_CHART_OF_ACCOUNTS_ID', :coa); fnd_profile.put('APPS_MAINTENANCE_MODE', :amm); end; and was executed from the file &ERRFILE.


Solution:-

SQL> alter package apps.ICX_SEC compile;

Package altered.

SQL> alter package apps.ICX_SEC compile body;

Package body altered.

SQL> show  error
No errors.
SQL> alter package apps.FND_PROFILE compile;

Package altered.

SQL> show error
No errors.
SQL> alter package apps.FND_PROFILE compile body;

Package body altered.

SQL> show error
No errors.
SQL> exit


Run Autoconfig at application.

You are not currently signed in to the Oracle BI Server

Error:-

You are not currently signed in to the Oracle BI Server

If you have already signed in, your connection might have timed out, or a communications or server error may have occurred.

To sign in again, click here. If the problem persists, please contact the site's administrator

Raised Oracle SR but Oracle was failed to Solve the ISSUE using below document.

OBIEE 12c : EBS / OBIEE 12c Integration Missing Steps (Doc ID 2141505.1) OBIEE 12c: Integrating OBIEE 12c with Oracle E-Business Suite (EBS) Security (Doc ID 2174747.1)

Solution:-

1) Execute the EBS security(RPD)  query against the EBS database and check the result.
2) Do not include ROLES and USER is same target variable.it will give same error.
3) check the parameters in two files authenticationschemas.xml and instanceconfig.xml. as per oracle doc id 2174747.1.
4) Found issue in  RPD need to correct the initialization using below parameters.

•   Get Oracle EBS Security Context
  
  Query=

SELECT
  FND_GLOBAL.RESP_ID,
  FND_GLOBAL.RESP_APPL_ID,
  FND_GLOBAL.SECURITY_GROUP_ID,
  FND_GLOBAL.RESP_NAME,
  FND_GLOBAL.USER_ID,
  FND_GLOBAL.EMPLOYEE_ID,
  FND_GLOBAL.USER_NAME
FROM DUAL

Required for authentication = checked box –YES

•  Get OBIEE User Group Persmissions

Query=

SELECT RESPONSIBILITY_NAME

FROM FND_RESPONSIBILITY_TL

WHERE RESPONSIBILITY_ID = 'valueof(NQ_SESSION.OLTP_EBS_RESP_ID)'

Variable target  =GROUP

Execution precedence = ORACLE EBS Security Context

Required for authentication = checked box –YES

•  EBS Security Context – ROLES – Row wise

Query=

SELECT RESPONSIBILITY_NAME FROM FND_RESPONSIBILITY_TL WHERE
RESPONSIBILITY_ID = 'valueof(NQ_SESSION.OLTP_EBS_RESP_ID)'
Variable target = ROLES
 Execution precedence = ORACLE EBS Security Context 

       Required for authentication = checked box –YES

Finally Issue resolved.

Create View ORA-01031: insufficient privileges

*Cause:    An attempt was made to perform a database operation without
           the necessary privileges.
*Action:   Ask your database administrator or designated security
           administrator to grant you the necessary privileges



Solution :

[oracle@~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu Dec 5 14:54:07 2019

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> grant CREATE ANY VIEW to XXALU;

Grant succeeded.


SQL> alter user XXALU enable editions;

User altered.


SQL> exit
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
[oracle@~]$

View "XXTAM"."JOBS" created.

R12.2: Cloning Failed While Running adcfgclone appstier dualfs With sqlplus: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory

Error:-

TXK Script Name: txkChkFormsLaunchMethod.pl
Enter the APPS user password:
*******FATAL ERROR*******
PROGRAM : (/u01/oracle/pansoft/fs2/EBSapps/appl/fnd/12.0.0/patch/115/bin/txkChkFormsLaunchMethod.pl)
TIME    : Mon Sep  9 12:31:54 2019
FUNCTION: main::validateAppsSchemaCredentials [ Level 1 ]
ERRORMSG: Invalid APPS database user credentials.
ERRORCODE = 1 ERRORCODE_END
.end std out.
stty: standard input: Inappropriate ioctl for device
stty: standard input: Inappropriate ioctl for device
/u01/oracle/pansoft/fs2/EBSapps/10.1.2/bin/sqlplus: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory
*******FATAL ERROR*******
PROGRAM : (/u01/oracle/pansoft/fs2/EBSapps/appl/fnd/12.0.0/patch/115/bin/txkChkFormsLaunchMethod.pl)
TIME    : Mon Sep  9 12:31:54 2019
FUNCTION:  [ Level 1 ]
ERRORMSG: *******FATAL ERROR*******
PROGRAM : (/u01/oracle/pansoft/fs2/EBSapps/appl/fnd/12.0.0/patch/115/bin/txkChkFormsLaunchMethod.pl)
TIME    : Mon Sep  9 12:31:54 2019
FUNCTION: main::validateAppsSchemaCredentials [ Level 1 ]
ERRORMSG: Invalid APPS database user credentials.




FIX:- (RHEL -7)

yum install binutils -y
yum install compat-libstdc++-33 -y
yum install compat-libstdc++-33.i686 -y
yum install gcc -y
yum install gcc-c++ -y
yum install glibc -y
yum install glibc.i686 -y
yum install glibc-devel -y
yum install glibc-devel.i686 -y
yum install ksh -y
yum install libgcc -y
yum install libgcc.i686 -y
yum install libstdc++ -y
yum install libstdc++.i686 -y
yum install libstdc++-devel -y
yum install libstdc++-devel.i686 -y
yum install libaio -y
yum install libaio.i686 -y
yum install libaio-devel -y
yum install libaio-devel.i686 -y
yum install libXext -y
yum install libXext.i686 -y
yum install libXtst -y
yum install libXtst.i686 -y
yum install libX11 -y
yum install libX11.i686 -y
yum install libXau -y
yum install libXau.i686 -y
yum install libxcb -y
yum install libxcb.i686 -y
yum install libXi -y
yum install libXi.i686 -y
yum install make -y
yum install sysstat -y
yum install unixODBC -y
yum install unixODBC-devel -y
yum install zlib-devel -y
yum install zlib-devel.i686 -y