DBA Arena

Issue:

While applying the OJVM patch on Exadata, the patch application fails on relinking.

Error:

OPatch failed: ApplySession failed in system modification phase... 'ApplySession::apply failed: Re-link fails on target "jox_refresh_knlopt ioracle".

OJVM Patch Installation:

Go to the patch directory.

[oracle@exadb01~]$ cd /u01/exadata_patch_apr2016/22738416/Database/11.2.0.4.0/11.2.0.4.160419OJVMPSU/22674697

OPatch Conflict Check

Determine whether any currently installed interim patches conflict with this patch.

[oracle@exadb01 22674697]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home : /u01/app/oracle/product/11.2.0.4/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0.4/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0.4/dbhome_1/cfgtoollogs/opatch/opatch2016-11-04_13-34-29PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

Read more...

1. Check database and application availability
2. Check status of cluster services
3. Monitor space availability in all tablespaces
4. Check for errors in Database Alert log files and take appropriate action
5. Check Concurrent Managers
6. Check /tmp for space constraints
7. Check invalid objects and compile if required
8. ASM Grid Space Check
9. Database and Application Mount points check
10. Verify Backups
11. Verify Gather Schema Statistics and Purge Concurrent Request and/or Manager Data Concurrent Requests are scheduled and are completing successfully

Read more...

Objective:

The objective is to migrate the EBS instance from a server running Linux 5 to a new server running Linux 7.

Environment Details:

EBS R12.1.3, Database 11.2.0.4
Mount points: Database: /ddb02, Application: /dap01

Create Users and Groups on the new server.

[root@ebs01 ~]# groupadd dba

[root@ebs01 ~]# groupadd oinstall

[root@ebs01 ~]# groupadd oper

[root@ebs01 ~]# groupadd asmdba

[root@ebs01 ~]# groupadd asmoper

[root@ebs01 ~]# useradd -g dba -G oinstall,oper,asmdba,asmoper -m oradev

[root@ebs01 ~]# useradd -g dba -G oinstall,oper -m appldev

[root@ebs01 ~]# groups oradev

oradev : dba oinstall oper asmdba asmoper

[root@ebs01 ~]# groups appldev

appldev : dba oinstall oper

Read more...

There are two nodes in a cluster ebsdb01.dbaarena.com, ebsdb02.dbaarena.com

cd $ORACLE_HOME/oui/prov/resources/scripts
[oraprod@ebsdb01 scripts]$ ls -ltr
total 100
-rwxr-x--- 1 oraprod oinstall 1394 Jul 20 2006 validatePaths
-rwxr-x--- 1 oraprod oinstall 6983 Jul 20 2006 ouiSetup
-rwxr-x--- 1 oraprod oinstall 35064 Dec 11 2006 sshUserSetupNT.sh
-rwxr-x--- 1 oraprod oinstall 16520 Mar 31 2009 sshConnectivity.sh
-rwxr-x--- 1 oraprod oinstall 32343 Dec 16 2009 sshUserSetup.sh

./sshUserSetup.sh -user -hosts <"hostname1 hostname 2"> -noPromptPassphrase
Read more...

ORACLE error 20100 in FDPSTP
FDPSTP failed due to ORA-20100: ORA-20100: Temporary file creation for FND_FILE failed.
Directory &FILE_DIR is invalid, contact your system administrator.

Check that the directory is a valid directory with wri06-APR-2016 14:48:29

The concurrent program was unable to write to the specified temporary file because the virtual path assigned to the APPLPTMP environment variable is not referenced in the UTL_FILE_DIR
Read more...