Database Blog

Various programs (like the AP Trial Balance and Invoice Register Report) complete with a warning status. The log file shows the following error message:

Issue: Various programs (like the AP Trial Balance and Invoice Register Report) complete with a warning status. The log file shows the following error message: Beginning post-processing of request xxxxxxx…

Read More

Untitled

MAX_STRING_SIZE Parameter In Oracle 12c This parameter was introduced in Oracle 12c. MAX_STRING_SIZE controls the maximum size of string size in Oracle database.Either we can set it to STANDARD or.EXTENDED…

Read More

Untitled

     Default Collation and PL/SQL  PLS-00761: Program unit collation may only be USING_NLS_COMP One of the new features that got introduced in Oracle Database 12.2 is the possibility to define…

Read More

Oracle Notification Troubleshooting in 3 steps

From the failed notification, determine the notification ID. Step 1: Use the notification ID to determine the context under which the API was called select substr(notification_id, 1, 12) nid, substr(status,…

Read More

SOA certification import using keytool

1)Login as soauser and append below environment variables in .profile export SOA_HOME=/DEVSOA/product/SOASuite export JAVA_HOME=$SOA_HOME/jdk export PATH=$SOA_HOME/opmn/bin:$SOA_HOME/OPatch:$JAVA_HOME/bin:$PATH export KEYSTORE=$JAVA_HOME/jre/lib/security/cacerts 2) create a directory “certs” in /local/home/ Place all third party trusted…

Read More

Error in password verification for APPS

FNDCPASS  error in R12 as below. [app***@yrdy-testapp ~]$ cat L6630162.log +—————————————————————————+ Application Object Library: Version : 12.1 Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved. FNDCPASS: +—————————————————————————+…

Read More

Attach block volume using ICSCI commands and create mount points in OCI

Attach created storage in new server using ISCSI commands: Verify storage attachment using fdisk fdisk –l Create physical volume pvcreate /dev/sdb Create volume group Vgcreate bvdemo /dev/sdb Create logical volumes…

Read More

Quick installation of OCI client

Below command will quickly install all perl/python libraries along wit CLI sudo yum install gcc libffi-devel python-devel openssl-devel sudo easy_install pip curl -L “https://raw.githubusercontent.com/oracle/oci-cli/master/scripts/install/install.sh” | bash  [root@instance-20180730-1239 opc]# bash -c…

Read More

TUNING SQL STATEMENTS USING SQL TUNING ADVISOR (WITHOUT ENTERPRISE MANAGER)

Below are the steps to use SQL Tuning Advisor for particular SQL.1) Create tuning task using SQL_ID2) Execute tuning task3) Generate report for the tuning taskSTEP 1:CREATE tuning tasks for…

Read More

Restricting access to su for group(dba) of users.

Providing su access to group of users in Oracle Cloud. Add below line in /etc/sudoers.d/90-cloud-init-users %dba ALL=(ALL) NOPASSWD: /bin/su – oracloud And then restart ssh daemon services #/sbin/service sshd restart…

Read More