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]

How to Create Group and User in Linux 7.2

https://dbissues.blogspot.com/2018/06/how-to-create-group-and-user-in-linux-72.html

1:  Command to create user.

useradd   -r  shafqat

2:) Command to create  group.

groupadd  dba

3:) Command to assign  group to a user.

usermod  -a  -G  dba  shafqat

4:) Command to delete group.

groupdel  dba

5:) Command to delete user.

userdel   shafqat

Change a User’s Primary Group

Sometimes you might want to switch out the primary group that a user is assigned to, which you can do with this command:

usermod -g <groupname> username

You need to the useradd command to add new users to existing group (or create a new group and then add user). If group does not exist, create it. The syntax is as follows:
useradd -G {group-name} username

RMAN SIGN

https://dbissues.blogspot.com/2018/06/rman-sign.html

%a          Specifies the activation id number of the database.

%A         Specifies the activation id number of the database completed 0

%c          Specifies the copy number of the backup piece within a set of duplexed backup pieces. The maximum value is 256.

%d          Specifies the name of the database--

%D         Specifies the current day of the month in format DD--

%e          Specifies the archived log sequence number--

%f           Specifies the absolute file number           
       

%F          Combines the DBID, day, month, year, and sequence into a unique and repeatable generated name--

%h          Specifies the archived redo log thread number--

%I           Specifies the DBID--

%M        Specifies the month in format MM--

%n          Specifies the name of the database. padded on the right with x characters to a total length of eight characters.

%N         Specifies the tablespace name.

%p          Specifies the piece number within the backup set

%r           Resetlogs ID

%s          Specifies the backup set number

%S          Specifies the backup set number completed 0

%t           Specifies the backup set time stamp.

%T          Specifies the year, month, and day in format YYYYMMDD

%u          Specifies an 8-character name constituted by compressed representations of the backup set or image copy number.

%U         Specifies a system-generated unique file name.

%Y          Specifies the year in this format: YYYY.