Oracle User Session Start time and End time

https://dbissues.blogspot.com/2019/05/oracle-user-session-start-time-and-end.html

select *  from fnd_logins c order by c.login_id desc

How to Pass org_id condition in Table value set?

https://dbissues.blogspot.com/2019/04/how-to-check-orgid-conditions-in-value.html

org_id =:$PROFILES$.ORG_ID

org_id =  fnd_global.org_id

mo_global.check_access(org_id) = 'Y'

Query to get cloned date of an oracle instance

https://dbissues.blogspot.com/2018/11/last-cloned-date-of-oracle-instance.html

select CREATED
from V$DATABASE;

Output Post Processor is Down with Actual Process is 0 And Target Process is 1

https://dbissues.blogspot.com/2018/08/output-post-processor-is-down-with.html

If you see OPP is Down with Actual Process is 0 And Target Process is 1 then do the following

SOLUTION:

1. Shutdown concurrent server via command adcmctl.sh under $COMMON_TOP/admin/scripts/<context_name>

2. To ensure concurrent manager down; check there is no FNDLIBR process running.

ps -ef | grep applmgr | grep FNDLIBR

3. Run adadmin to relink FNDSVC executable.
a. Invoke adadmin from command prompt
b. Choose option 2 (2. Maintain Applications Files menu)
c. Choose option 1 (1. Relink Applications programs )
d. Then type “FND” When prompted; ( Enter list of products to link (‘all’ for all products) [all] : FND )
e. Ensure adrelink is exiting with status 0

4. Start Concurrent Managers using adcmctl.sh

ORA-12899: value too large for column “APPLSYS”.”FND_PROFILE_OPTION_VALUES”.”PROFILE_OPTION_VALUE”

https://dbissues.blogspot.com/2018/06/ora-12899-value-too-large-for-column.html

SOLUTION:

Please execute the following steps:

Step 1 – Change the value dbutilfiledir in the database context file

($ORACLE_HOME/appsutil/$CONTEXT_NAME.xml)

Step 2 – Run autoconfig again.

ORA-12157: TNS:internal network communication error

https://dbissues.blogspot.com/2018/06/ora-12157-tnsinternal-network.html

ERROR

ORA-12157: TNS:internal network communication error

SOLUTION

This error ussualy occurs when the network files are not generated properly. Relink them using the below commands to fix the issue.

Step 1. Go to Oracle Home

cd $ORACLE_HOME/network/lib

Step 2. Regenerate file by giving the following Command

$make -f ins_net_client.mk ntcontab.o

Step 3. Got to bin folder of Oracle Home

$cd $ORACLE_HOME/bin

Step 4. Run the following given command

$genclntsh

Step 5. Go to Lib folder

$cd $ORACLE_HOME/rdbms/lib

Generate files through the given command

$make -f ins_rdbms.mk install

Step 6. Go to lib folder

$cd $ORACLE_HOME/sqlplus/lib

Step 7. Generate files through the given command.

$make -f ins_sqlplus.mk install

adstrtal.sh exits with status 150

https://dbissues.blogspot.com/2018/06/adstrtalsh-exits-with-status-150.html

We may get this error when we start all apps tier services.

[oracle@erp scripts]$ ./adstrtal.sh

You are running adstrtal.sh version 120.13

Enter the APPS username: apps

Enter the APPS password:****

Executing service control script: /d01/oracle/PROD/inst/apps/PROD_erp/admin/scripts/adopmnctl.sh

start script returned:

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

You are running adopmnctl.sh version 120.4

Starting Oracle Process Manager (OPMN) …

adopmnctl.sh: exiting with status 0

adopmnctl.sh: check the logfile /d01/oracle/PROD/inst/apps/PROD_erp/logs/appl/admin/log/adopmnctl.txt

for more information …

.end std out.

.end err out.

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

Executing service control script:

/d01/oracle/PROD/inst/apps/PROD_erp/admin/scripts/adapcctl.sh start script returned: ****************************************************

You are running adapcctl.sh version 120.6

Starting OPMN managed Oracle HTTP Server (OHS) instance …

adapcctl.sh: exiting with status 150

adapcctl.sh: check the logfile /d01/oracle/PROD/inst/apps/PROD_erp/logs/appl/admin/log/adapcctl.txt

for more information …

.end std out.

.end err out.

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

Executing service control script: /d01/oracle/PROD/inst/apps/PROD_erp/admin/scripts/adoacorectl.sh start script returned:

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

You are running adoacorectl.sh version 120.11

Starting OPMN managed OACORE OC4J instance …

adoacorectl.sh: exiting with status 150

adoacorectl.sh: check the logfile

/d01/oracle/PROD/inst/apps/PROD_erp/logs/appl/admin/log/adoacorectl.tx t for more information …

.end std out.

.end err out.

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

/d01/oracle/PROD/inst/apps/PROD_erp/admin/scripts/adformsctl.sh start script returned: ****************************************************

You are running adformsctl.sh version 120.12

Starting OPMN managed FORMS OC4J instance …

adformsctl.sh: exiting with status 150

adformsctl.sh: check the logfile

/d01/oracle/PROD/inst/apps/PROD_erp/logs/appl/admin/log/adformsctl.txt for more information…

Solution :

Open a new shell and set your apps environment, and then run the following:

$cd $ADMIN_SCRIPTS_HOME adopmnctl.sh stop

Now Check if  it is really down: ps -ef | grep -i opm

Delete the following:

$ rm -fr $INST_TOP/ora/10.1.3/j2ee/oacore/persistence/*

$ rm -fr $INST_TOP/ora/10.1.3/j2ee/oafm/persistence/*

$ rm -fr $INST_TOP/ora/10.1.3/j2ee/forms/persistence/*

Run the following script

$adopmnctl.sh start

Start all applications services and check if it completes with status 0

$adstrtal.sh.sh apps/[appspassword]