Krishna Sudagani (Oracle Application DBA, OCI Admin, and Middleware Expertise)

Over a decade of expertise as an Oracle DBA, Application DBA, OCI Admin, and Fusion Middleware specialist, I’ve solved complex challenges, optimized systems, and led innovations across diverse Oracle platforms. Now, I’m passionate about sharing insights to bridge the gap between theory and practice. From database optimization to middleware best practices, join me as we explore Oracle technologies and grow together. Stay tuned for expert tips and resources!

Tuesday, 28 February 2017

ENABLE_DDL_LOGGING

ENABLE_DDL_LOGGING enables or disables the writing of a subset of data definition language (DDL) statements to a DDL log.

The DDL log is a file that has the same format and basic behavior as the alert log, but it only contains the DDL statements issued by the database. The DDL log is created only for the RDBMS component and only if the ENABLE_DDL_LOGGING initialization parameter is set to true. When this parameter is set to false, DDL statements are not included in any log.

The DDL log contains one log record for each DDL statement issued by the database. The DDL log is included in IPS incident packages.

There are two DDL logs that contain the same information. One is an XML file, and the other is a text file. The DDL log is stored in the log/ddl subdirectory of the ADR home.

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> show parameter enable_ddl_loggingshow parameter enable_ddl_logging
SQL> show parameter enable_ddl_logging;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
enable_ddl_logging boolean FALSE
SQL> alter system set enable_ddl_logging=TRUE scope=both;

System altered.

SQL> show parameter enable_ddl_logging;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
enable_ddl_logging boolean TRUE

SQL> select value from v$diag_info where name='ADR Home';

VALUE

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

/u01/app/oracle/12.1.0/admin/diag/rdbms

SQL> select value from v$diag_info where name='ADR Home';

VALUE

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

/u01/app/oracle//12.1.0/admin//diag/rdbms/

SQL> create table test(name number);

Table created.

[oracle@test26 ddl]$ pwd

/u01/app/oracle//12.1.0/admin/diag/rdbms/log/ddl

[oracle@test26 ddl]$ cat log.xml

<msg time='2017-02-28T18:01:57.657+05:30' org_id='oracle' comp_id='rdbms'

msg_id='opiexe:4407:2946163730' type='UNKNOWN' group='diag_adl'

level='16' host_id='srv-vimats26-int.com' host_addr='172.17.1.226'

version='1'>

<txt> create table test(name number)

</txt>

</msg>

Monday, 23 January 2017

EBS R12.2.5 To R12.2.6 Upgrade Patch: 21900901-peposasd.sql Errors with "The call_procedure does not e xist in the call_package" ORA-06512

When attempting to apply 12.2.6 patch: 21900901:oracle e-business suite 12.2.6 release update pack the following error occurs.

Error:
(XX_HR_USER_HOOK_PKG.POSITION_BEFORE_UPDATE_BK2) The call_package does not exist in the database. Code to carry out this hook call has not been created.

DELETE_POSITION(Business Process API) successful.
BEGIN hr_api_user_hooks_utility.clear_hook_report; END;

*
ERROR at line 1:
ORA-06501: PL/SQL: program error
ORA-06512: at "APPS.HR_API_USER_HOOKS_UTILITY", line 891
ORA-06512: at line 1

Fix:

To implement the solution, please execute the following steps:

1. Run the following sql.

SQL> select CALL_PACKAGE, CALL_PROCEDURE, ENABLED_FLAG from HR_API_HOOK_CALLS;

This will provide you a list of the user hooks, procedures and enabled_flag values

From this table, update the user hook in question and set it to 'N.'

2. Run the following in sql:

cd $PER_TOP/admin/sql
Log into SQLPLUS as the APPS user
SQL> @hrahkall.sql

This will clear up the child process that are still enabled.

3. Restart the failed worker and allow the patch to complete.

4. Properly create your user hook.

Ref Doc ID 2196150.1

How To Grant / Revoke Privileges For Multiple Discoverer Applications Users / Responsibilities In Batch Mode

In an Oracle Application mode EUL, privileges are usually granted or revoked using Discoverer Administration Edition.
The Discoverer Administration Edition will process one user or responsibility at a time.
Is is possible to grant or revoke the privileges for multiple users / responsibilities in batch mode?

Solution:

Privileges can also be granted or revoked using a Java Command Line utility called EULAPI.
This EULAPI utility is shipped with the Oracle Application Server and has to be executed from the Discoverer server / middle tier environment.

For more information, please refer to the following document:

Oracle Business Intelligence Discoverer EUL Command Line for Java User's Guide 10g Release 2 (10.1.2.1)
Part # B13919-03
Ch 2 Discoverer EUL Command Line for Java Reference

Example 1: To revoke save workbook to database from a responsibility:

$ORACLE_HOME/bin/eulapi \
-connect SYSADMIN/<sysadmin_password>@database \
-eul EUL_US \
-apps_user \
-apps_responsibility "System Administrator" \
-apps_gwuid "APPLSYSPUB/PUB" \
-apps_fndnam APPS \
-revoke_privilege \
-privilege save_workbook_database -role "Discoverer Workbook Management"

Example 2: To grant schedule privilege to users JOE and JCHAN

$ORACLE_HOME/bin/eulapi \
-connect SYSADMIN/<sysadmin_password>@database \
-eul EUL_US \
-apps_user \
-apps_responsibility "System Administrator" \
-apps_gwuid "APPLSYSPUB/PUB" \
-apps_fndnam APPS \
-grant_privilege \
-privilege schedule_workbook \
-user JOE \
-user JCHAN

Example 3: To revoke Save workbook to database, scheduling and sharing workbook in Applications mode EUL

$ORACLE_HOME/bin/eulapi \
-connect SYSADMIN/<sysadmin_password>@database \
-eul EUL_US \
-apps_user \
-apps_responsibility "System Administrator" \
-apps_gwuid "APPLSYSPUB/PUB" \
-apps_fndnam APPS \
-revoke_privilege \
-privilege save_workbook_database \
-privilege schedule_workbook \
-privilege grant_workbook \
-user "Joe Smith"

NOTE:
1.The above commands need to be in one continuous line. or separated into multiple lines with continuation character "\" .

2. Roles and Responsibilities should be case sensitive and enclosed in double quotes as long as they have multiple words.

Ref Doc ID 420357.1

Sunday, 4 December 2016

How to change the apps password in Oracle E-Business Suite R12.2

Below steps to change the apps password in Oracle E-Business Suite R12.2

Step 1:

Shut down all the application services by using below script.
$INST_TOP/admin/scripts/adstpall.sh

Step 2:
Change the APPLSYS password by using FNDCPASS
$FNDCPASS apps/<appspwd> 0 Y system/manager SYSTEM APPLSYS WELCOME

Step 3:
Run autoconfig with the newly changed password.

Step 4:
Start AdminServer using the $INST_TOP/admin/scripts/adadminsrvctl.sh script. (Do not start any other application tier services).

Step 5:
Change the "apps" password in WLS Datasource as follows:

a) Log in to WLS Administration Console.
b) Click Lock & Edit in Change Center.
c) In the Domain Structure tree, expand Services, then select Data Sources.
d) On the "Summary of JDBC Data Sources" page, select EBSDataSource.
e) On the "Settings for EBSDataSource" page, select the Connection Pool tab.
f) Enter the new password in the "Password" field.
g) Enter the new password in the "Confirm Password" field.
h) Click Save.
i) Click Activate Changes in Change Center.

Step 6:
Start all the application tier services using the below script
$INST_TOP/admin/scripts/adstrtal.sh

Step 7:
Verify the WLS Datastore changes as follows:

a) Log in to WLS Administration Console.
b) In the Domain Structure tree, expand Services, then select Data Sources.
c) On the "Summary of JDBC Data Sources" page, select EBSDataSource.
d) On the "Settings for EBSDataSource" page, select Monitoring > Testing.
e) Select "oacore_server1".
f) Click Test DataSource
g) Look for the message "Test of EBSDataSource on server oacore_server1 was successful".

Tuesday, 29 November 2016

weblogic.nodemanager.common.ConfigException: Identity key store file not found: DemoIdentity.jks (SOA 12c)

We are getting below error while starting Node-manager in weblogic 12c server. Below is the steps to resolve the issue.

Error Message:

+ /usr/java/jdk1.8.0_112/bin/java -server -Xms32m -Xmx200m -Dweblogic.RootDirectory=/u01/soa_12c/Middleware/MW_Home/wlserver/../oracle_common/common/nodemanager -Dcoherence.home=/u01/soa_12c/Middleware/MW_Home/wlserver/../coherence -Dbea.home=/u01/soa_12c/Middleware/MW_Home/wlserver/.. -Xverify:none -Djava.system.class.loader=com.oracle.classloader.weblogic.LaunchClassLoader -Djava.security.policy=/u01/soa_12c/Middleware/MW_Home/wlserver/server/lib/weblogic.policy -Dweblogic.nodemanager.JavaHome=/usr/java/jdk1.8.0_112 weblogic.NodeManager -v

weblogic.nodemanager.common.ConfigException: Identity key store file not found: /u01/soa_12c/Middleware/MW_Home/oracle_common/common/nodemanager/security/DemoIdentity.jks

at weblogic.nodemanager.server.SSLConfig.loadKeyStoreConfig(SSLConfig.java:225)

at weblogic.nodemanager.server.SSLConfig.access$000(SSLConfig.java:33)

at weblogic.nodemanager.server.SSLConfig$1.run(SSLConfig.java:118)

at java.security.AccessController.doPrivileged(Native Method)

at weblogic.nodemanager.server.SSLConfig.<init>(SSLConfig.java:115)

at weblogic.nodemanager.server.NMServer.<init>(NMServer.java:143)

at weblogic.nodemanager.server.NMServer.main(NMServer.java:527)

at weblogic.NodeManager.main(NodeManager.java:31)

+ status=1

+ set +x

Fix:

Copy the file <domainhome>/security/DemoIdentity.jks to <domainhome>/nodemanager/security/DemoIdentity.jks

Copy the file <domainhome>/security/DemoIdentity.jks to <MW_Home>/oracle_common/common/nodemanager/security/DemoIdentity.jks

Wednesday, 23 November 2016

How to find weblogic server version in E-Business Suite R12.2.5

Below steps to find the Weblogic server version in E-Business Suite R12.2.5

Step 1:

Goto $FMW_HOME

[applmgr@test26 FMW_Home]$ pwd
/u01/app/applmgr/TEST/fs1/FMW_Home

[applmgr@test26 FMW_Home]$ grep -I version registry.xml

<?xml version="1.0" encoding="UTF-8"?><bea-product-information xmlns:fo="http://www.w3.org/1999/XSL/Format" xmlns:gpr="http://www.bea.com/ns/cie/gpr">

Step 2:

Monday, 14 November 2016

BI AppS ETL fails with the 'ORA-01792: maximum number of columns in a table or view is 1000' Error Message

We are getting below error while loading the data into BI APPS server .

Error:

Caused By: java.sql.SQLSyntaxErrorException: ORA-01792: maximum number of columns in a table or view is 1000

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows => ORA-20942:

Fix:

The workaround is to set "_fix_control"='17376322:OFF'

SQL> alter session set "_fix_control"='17376322:OFF';

or at system level :

SQL> alter system set "_fix_control"='17376322:OFF';

Apply Patch 19509982 if available for your DBVersion and Platform

Friday, 11 November 2016

Weblogic Server 12.1.2 Performance Issue Due To weblogic.socket.NIOSocketMuxer

Weblogic server 12.1.2 in a runnable state consuming high CPU resources.

Error:

"LDAPConnThread-579 ldaps://ldapserver.us.oracle.com:636" daemon prio=10 tid=0x00000000041f6800 nid=0x56d7 runnable [0x00007f9b6b9f8000]
java.lang.Thread.State: RUNNABLE
at sun.nio.ch.IOUtil.drain(Native Method)
at sun.nio.ch.EPollSelectorImpl.doSelect(EPollSelectorImpl.java:90)
- locked <0x000000078a2f6e48> (a java.lang.Object)
at sun.nio.ch.SelectorImpl.lockAndDoSelect(SelectorImpl.java:87)
- locked <0x000000078a2f6b48> (a sun.nio.ch.Util$2)
- locked <0x000000078a2f6b38> (a java.util.Collections$UnmodifiableSet)
- locked <0x000000078a2f6910> (a sun.nio.ch.EPollSelectorImpl)
at sun.nio.ch.SelectorImpl.select(SelectorImpl.java:98)
at weblogic.socket.NIOSocketMuxer$NIOInputStream.readInternal(NIOSocketMuxer.java:815)
at weblogic.socket.NIOSocketMuxer$NIOInputStream.read(NIOSocketMuxer.java:759)
at weblogic.socket.NIOSocketMuxer$NIOInputStream.read(NIOSocketMuxer.java:742)
at weblogic.socket.JSSEFilterImpl.readFromNetwork(JSSEFilterImpl.java:462)
at weblogic.socket.JSSEFilterImpl.read(JSSEFilterImpl.java:424)
at weblogic.socket.JSSESocket$JSSEInputStream.read(JSSESocket.java:64)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
at java.io.BufferedInputStream.read(BufferedInputStream.java:254)
- locked <0x000000079c2dc630> (a java.io.BufferedInputStream)
at netscape.ldap.ber.stream.BERElement.getElement(Unknown Source)
at netscape.ldap.LDAPConnThread.run(Unknown Source)
at java.lang.Thread.run(Thread.java:745)

Fix:

In this case, as customer was using Linux x86-64, changing the MuxerClass from weblogic.socket.NIOSocketMuxer to weblogic.socket.PosixSocketMuxer worked.

In WLS Admin Console

Go to Environment > Servers > Server Name > Tuning, under Advanced, set the Muxer Class based on the OS and Reboot the server.

Solaris/HP-UX Native Muxer : weblogic.socket.DevPollSocketMuxer
POSIX Native Muxer : weblogic.socket.PosixSocketMuxer
Windows Native Muxer : weblogic.socket.NTSocketMuxer

Java Muxer : weblogic.socket.JavaSocketMuxer

You may also set the above in the Weblogic startup scripts via the JAVA_OPTIONS:
-Dweblogic.MuxerClass=weblogic.socket.PosixSocketMuxer

Tuesday, 8 November 2016

Weblogic console page is not coming up after server reboot

We have bounced the server and restarted the weblogic services. After restating the services we are unable to access the console page.

Cause:

We found that Linux firewalls are enabled the server. When we rebooted the server, by detault iptables got restarted.

To check the status of your firewall and all rules, enter:
# iptables -L -n (as root user)

Fix:

Stop the ipchains service(as root user):
# service ipchains stop

Stop the iptables service:
# service iptables stop

Stop the ipchains service from starting when you restart the server:
# chkconfig ipchains off

Stop the iptables service from starting when you restart the server:
# chkconfig iptables off

Monday, 7 November 2016

Ora-12547: tns:lost contact 12c

We are unable to access the jdbc url and sql developer after configuring E-Business suite R12.2.5

Error:

I/O Error: Connection Reset
ora-12547: tns:lost contact 12c

Fix:

Backup the sqlnet.ora file from both DB and Apps side and comment the below parameters.

#tcp.validnode_checking = yes
#tcp.invited_nodes=(hostname)

Thursday, 3 November 2016

libmawt.so: libXi.so.6: cannot open shared object file: No such file or directory

We are getting below error while installing BI APPS rcu.

Error:

[oracle@test-krishna bin]$ ./rcu
Exception in thread "main" java.lang.UnsatisfiedLinkError: /u01/Softs/weblogic/rcu_obi/jdk/jre/lib/i386/xawt/libmawt.so: libXi.so.6: cannot open shared object file: No such file or directory
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1807)
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1703)
at java.lang.Runtime.load0(Runtime.java:770)
at java.lang.System.load(System.java:1003)
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1807)
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1724)
at java.lang.Runtime.loadLibrary0(Runtime.java:823)
at java.lang.System.loadLibrary(System.java:1028)
at sun.security.action.LoadLibraryAction.run(LoadLibraryAction.java:50)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.Toolkit.loadLibraries(Toolkit.java:1605)
at java.awt.Toolkit.<clinit>(Toolkit.java:1627)
at com.jgoodies.looks.LookUtils.isLowResolution(LookUtils.java:484)
at com.jgoodies.looks.LookUtils.<clinit>(LookUtils.java:249)
at com.jgoodies.looks.plastic.PlasticLookAndFeel.<clinit>(PlasticLookAndFeel.java:135)
at oracle.sysman.assistants.rcu.ui.InteractiveRCUModel.<init>(InteractiveRCUModel.java:117)
at oracle.sysman.assistants.rcu.Rcu.execute(Rcu.java:307)
at oracle.sysman.assistants.rcu.Rcu.main(Rcu.java:363)

Fix:

[root@test-krishna Desktop]# yum install libXtst.i686

Resolving Dependencies
--> Running transaction check
---> Package libXtst.i386 0:1.0.1-3.1 will be updated
---> Package libXtst.i686 0:1.2.2-2.1.el6 will be an update
--> Processing Dependency: libXi.so.6 for package: libXtst-1.2.2-2.1.el6.i686
--> Running transaction check
---> Package libXi.i686 0:1.7.4-1.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

========================================================================================================================================================================
Package Arch Version Repository Size
========================================================================================================================================================================
Updating:
libXtst i686 1.2.2-2.1.el6 base 19 k
Installing for dependencies:
libXi i686 1.7.4-1.el6 base 37 k

Transaction Summary
========================================================================================================================================================================
Install 1 Package(s)
Upgrade 1 Package(s)

Total download size: 55 k
Is this ok [y/N]: Y
Downloading Packages:
(1/2): libXi-1.7.4-1.el6.i686.rpm | 37 kB 00:00
(2/2): libXtst-1.2.2-2.1.el6.i686.rpm | 19 kB 00:00
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 55 kB/s | 55 kB 00:01
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
Installing : libXi-1.7.4-1.el6.i686 1/3
Updating : libXtst-1.2.2-2.1.el6.i686 2/3
Cleanup : libXtst-1.0.1-3.1.i386 3/3
Verifying : libXi-1.7.4-1.el6.i686 1/3
Verifying : libXtst-1.2.2-2.1.el6.i686 2/3
Verifying : libXtst-1.0.1-3.1.i386 3/3

Dependency Installed:
libXi.i686 0:1.7.4-1.el6

Updated:
libXtst.i686 0:1.2.2-2.1.el6

Complete!

Monday, 17 October 2016

Script to find the number of active users in oracle R12 application

select 'Number of user sessions : ' || count( distinct session_id) How_many_user_sessions from icx_sessions icx where disabled_flag != 'Y'
and PSEUDO_FLAG = 'N'
and (last_connect + decode(FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT'), NULL,limit_time, 0,limit_time,FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT')/60)/24) > sysdate and counter < limit_connects;

Monday, 3 October 2016

How to Configuring Node Manager to Start Managed Servers

If a Managed Server contains other Oracle Fusion Middleware products, such as Oracle SOA Suite, Oracle WebCenter Portal, or Oracle JRF, the Managed Servers environment must be configured to set the correct classpath and parameters. This environment information is provided through the start scripts, such as startWebLogic and setDomainEnv, which are located in the following directory:

$DOMAIN_HOME/bin

If the Managed Servers are started by Node Manager (as is the case when the servers are started by the Oracle WebLogic Server Administration Console or Fusion Middleware Control), Node Manager must be instructed to use these start scripts so that the server environments are correctly configured. Specifically, Node Manager must be started with the property StartScriptEnabled=true.

There are several ways to ensure that Node Manager starts with this property enabled. As a convenience, Oracle Fusion Middleware provides the following script, which adds the property StartScriptEnabled=true to the nodemanager.properties file:

$ORACLE_COMMON_HOME/common/bin/setNMProps.sh.

For example, on Linux, execute the setNMProps script and start Node Manager:

ORACLE_COMMON_HOME/common/bin/setNMProps.sh
MW_HOME/wlserver_n/server/bin/startNodeManager.sh

When you start Node Manager, it reads the nodemanager.properties file with the StartScriptEnabled=true property, and uses the start scripts when it subsequently starts Managed Servers. Note that you need to run the setNMProps script only once.

Also note that when the StartScriptEnable property is set to true, the Node Manager reads the startWebLogic script, which in turns reads the setDomainEnv script. As a result, you must make any tuning changes by editing the setDomainEnv script. Any changes that are performed using the command line or Administration Console will not be implemented when Node Manager starts the servers. For example, if you use the Administration Console to change the server start arguments, those changes are written to config.xml, but the Node Manager ignores these settings and uses those in setDomainEnv.

Sunday, 18 September 2016

Oracle E-Business Suite 12.2.6 Now Available

Oracle E-Business Suite Release 12.2.6 is now available.

Instructions for downloading and applying this latest release update pack (RUP) for the EBS 12.2 codeline can be found here:

Oracle E-Business Suite 12.2.6 Readme (Doc ID 2114016.1)

What Does Release 12.2.6 Include?

As a consolidated suite-wide patchset, this RUP includes new features, statutory and regulatory updates, and enhancements for stability, performance, and security.

Release 12.2.6 is cumulative. That means that as well as providing new updates for this release, it also includes updates that were originally made available as one-off patches for earlier 12.2 releases.

For a complete list of new features, refer to:
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Documents (Doc ID 1302189.1)

Thursday, 15 September 2016

RCU/jdk/jre/lib/i386/xawt/libmawt.so: libXtst.so.6: cannot open shared object file: No such file or directory

I got this error while installing RCU on OEL6.

$ ./rcu
Exception in thread "main" java.lang.UnsatisfiedLinkError:
/Installation/rcu/rcuHome/jdk/jre/lib/i386/xawt/libmawt.so:
libXtst.so.6: cannot open shared object file: No such file or directory
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1778)
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1674)
at java.lang.Runtime.load0(Runtime.java:770)
at java.lang.System.load(System.java:1003)
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1778)
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1695)
at java.lang.Runtime.loadLibrary0(Runtime.java:823)
at java.lang.System.loadLibrary(System.java:1028)

Cause:
libXtst rpm for 32 bit is missing.

Fix:
Please check that the libXtst-xx.el6.i686.rpm (32 bit) installed.
rpm -qa |grep libXtst
If it is not installed the need to install:
rpm -ivh libXtst-xx.el6.i686.rpm

Friday, 9 September 2016

ORA-01654: unable to extend index APPLSYS.AD_PATCH_COMMON_ACTIONS_U2 by 16 in tablespace APPS_TS_TX_IDX

While applying an NLS Patch getting ORA-1654 errors occurred due to space issues.

Error:

ORA-01654: unable to extend index APPLSYS.AD_PATCH_COMMON_ACTIONS_U2 by 16 in tablespace APPS_TS_TX_IDX

ORA-01654: unable to extend index APPLSYS.AD_PROGRAM_RUN_TASK_JOBS_N1 by 16 in tablespace APPS_TS_TX_IDX

After fixing the ORA-1654 errors by setting the APPS_TS_TX_IDX datafile to autoextend, reapplying the same NLS patch gives the following warning message and the patch is skipped:

Fix:

1. Resolve the ORA-1654 error per any of the available methods.

2. Test reapplying the patch using following option:

adop phase=apply apply_mode=downtime patches=19676458 options=forceapply restart=no abandon=yes

3. Confirm the patch applied successfully using the above command.

Tuesday, 23 August 2016

INST-08109: An ORACLE_HOME environment variable should not be defined

I got the below error while installing Oracle BI 11.1.1.9 on Linux 5.7.

Error :

INST-08109: An ORACLE_HOME environment variable should not be defined

Fix:

unset ORACLE_HOME and try to re-install.

INST-08109: An ORACLE_HOME environment variable should not be defined

Wednesday, 10 August 2016

Error in invoking target client_sharedlib of makefile

I am getting below error while installing Oracle Database 12c in OEL6.

Error:

Fix:

Step 1:
Edit /etc/sysctl.conf file and entry followings.
#vi /etc/sysctl.conf
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=262144
net.core.wmem_max=262144

Step 2:

Create the below soft links.

ln -s /etc /etc/rc.d
ln -s /usr/bin/awk /bin/awk
ln -s /usr/bin/basename /bin/basename
ln -s /usr/bin/rpm /bin/rpm
ln -s /lib/x86_64-linux-gnu/libgcc_s.so.1 /usr/lib64/
ln -s /usr/lib/x86_64-linux-gnu/libc_nonshared.a /usr/lib64/
ln -s /usr/lib/x86_64-linux-gnu/libpthread_nonshared.a /usr/lib64/
ln -s /usr/lib/x86_64-linux-gnu/libstdc++.so.6 /usr/lib64/

Issue resolved after done all the above steps/changes.

Error in invoking target 'client_sharedlib' of makefile

I am getting below error while installing Oracle Database 12c in OEL6.

Error: