Monday, May 29, 2017

Webinar: Still uncertain Install Oracle Binaries or Clone Oracle Home?

Many DBA's still uncertain whether Install Oracle Binaries or Clone Oracle Home while migrating the databases. Lets join the webinar and find out?

Date and time:  June 12th 2017 8:00am-9:00am
Pacific Daylight Time (San Francisco, GMT-07:00)


This Webinar covers following Topics. 
  • When cloning useful 
  • Different methods of Cloning 
  • How to perform Cloning 
  • References 
  • Q&A 
To register for this Webinar, please send an email to SatishbabuGunukula@gmail.com.
Note that registrations are limited and first come and first serve basis.

You will receive an email confirmation with meeting session link.

For Presentation link "Click here"

Regards,
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com

Friday, May 26, 2017

How to manage Oracle RAC?

Oracle Real Application cluster is a group of independent servers that collaborate as singe system and provides single system image for management and configuration. All tools and utilities provided by oracle to manage system can be used from one system. The clusterware and Database can be installed, configured and managed from single location.

Rolling PatchOracle supports rolling patches, but this requires that each node has a separate Oracle Home. The patches are applied one node at a time while other nodes are operational. Oracle cluster patches are applied in rolling fashion, so no downtime required.

Refer https://docs.oracle.com/cd/B16240_01/doc/em.102/e15294/rac.htm

Rolling UpgradeOracle supports rolling upgrades and individual patches will be rolling upgradable. If any patch modifies the common structures shared between the instances or database will not be quailed for rolling upgrade. Oracle will certify the patches eligible for rolling upgrade and not all the patches are eligible, rolling upgrades are not approved for patch sets. From oracle 10g release1 supports database software upgrade in rolling fashion without any down time by using Data Guard SQL Apply.

Refer: https://docs.oracle.com/cd/B28359_01/install.111/b28263/procstop.htm#CWLIN341

Enterprise Grid ControlOracle Enterprise Grid Control is a GUI management tool provided by oracle to eliminate tedious work and manage your cluster environment more efficiently. This tool provides the centralized management of cluster databases, using this tool you can view system status, view alerts and set thresholds for alert generation, backup and recovery, monitor cluster wait events, monitor performance metrics across all database instances, and you can able to perform all maintenance activities.

Refer : https://docs.oracle.com/cd/E11857_01/em.111/e11982/overview.htm

Scalability
Oracle Real Application Cluster provides scalability for all your enterprise business applications. Oracle provides a wide array of tools and techniques for scaling, and you can use these tools to ensure seamless growth while minimizing the investment in hardware resources. You can allow RAC database to grow seamlessly from a small system to a big multinational enterprise applications.

Refer : https://docs.oracle.com/cd/B10501_01/rac.920/a96597/psscadtl.htm

Oracle RAC architecture automatically accommodates rapidly changing business requirements, adding a server to the cluster does not require an outage and as soon as the new Instance added the application can take advantage of extra resources. You need to make sure that all servers in the cluster must run the same OS and same Oracle version, but they do not have to be the exactly same capacity. Oracle automatically balances the user load among the multiple nodes in the cluster.

High Availability
Oracle Real application cluster provides the following important features for a High available data management.

Reliability – In Oracle real application cluster if an instance fails, the remaining instances in the server remain active and open for users. Oracle cluster monitors all oracle processes and immediately restarts any failed component.

Recoverability - If an instance fails in Oracle RAC database, it is recognized by other instances in the server pool and recovery will start automatically. Fast connection Failover (FCF) and Fast application notification (FAN) makes it easy for applications to mask component failures from the user.

Continuous Operations – Oracle Real application cluster provides continuous service for both unplanned and planned outages. If a server or instances fails, the database remains open and the application/users are able to access data from other surviving instances. Most of the database maintenance operations can be performed without downtime and many other maintenance tasks can be done in a rolling fashion so application downtime is minimized.

Error Detection - Oracle Cluster automatically monitors oracle databases and other oracle process (ASM instances, Listener, ONS…etc) and provides fast detection of problems in the RAC environment. It also automatically recovers from failures often before users noticed that a failure has occurred.
Scalability - Oracle Real Application Cluster provides scalability for all your enterprise business applications. Oracle provides a wide array of tools and techniques for scaling, and you can use these tools to ensure seamless growth while minimizing the investment in hardware resources. You can allow RAC database to grow seamlessly from a small system to a big multinational enterprise applications.

High Availability- Oracle Real application cluster provides Reliability, Recoverability, Continuous Operations, Error Detection features for a High available data management. If an instance fails in Oracle RAC database, the Cluster detects the problems immediately and recovery will start automatically. The remaining instances in the server remain active and open for uses.

Maintenance - In Oracle RAC, most of the database maintenance operations can be performed without downtime and many other maintenance tasks can be done in a rolling fashion (Rolling Patch, Rolling Upgrade) so application downtime is minimized

Regards
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com

Monday, May 22, 2017

Webinar: What’s new in Oracle 12c Recovery Manager (RMAN)?

Oracle Database 12c offers new enhancements and additions in Recovery Manager (RMAN). Take the advantage of new features for efficient backup & recovery.

Date and time: May, 31 2017 8:00am-9:00am
Pacific Daylight Time (San Francisco, GMT-07:00)

Join the Webinar to learn New Features in Oracle RMAN 12c
  • SQL Interface Improvements 
  • SYSBACKUP Privilege 
  • Support for multitenant container and pluggable databases 
  • DUPLICATE enhancements 
  • Multisection Backup Improvements 
  • Restoring and Recovering Files Over Network 
  • Storage Snapshot Optimization 
  • Active Database Duplication Improvements 
  • Cross-Platform Backup and Restore Improvements 
  • Recovering Tables and Table Partitions using RMAN Backups 
  • Unified auditing and RMAN 
To register for this Webinar, please send an email to SatishbabuGunukula@gmail.com.

Note that registrations are limited and first come and first serve basis.
You will receive an email confirmation with meeting session link.

For Presentation link "Click here"

Regards,
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com

Thursday, May 18, 2017

What is Orachk tool?

I come across an issue in Oracle Database environment and none of the team aware of what is Orachk and how to use it.

ORAchk tool:
ORAchk tool perform proactive health checks for Oracle software stack and this tool replaces RACcheck. Using this tool you can scan problems with oracle products

· Standalone Oracle Database
· Oracle Grid Infrastructure
· Oracle Golden Gate
· Upgrade Readiness Validations
· Oracle Real Application Clusters
· Maximum Availability Architecture (MAA) Validation

It is always  recommended to run this tool before upgrade.

ORAchk tool has below features

· Proactively scans for problems across the different layers and will not send any config data
· Provides a single dashboard view for your enterprise environment.
· Investigation and analyzing the issue makes simple and provides a report with risks
· You can configure to send email notifications when it detects problems
· Its free of Cost

How to run:

1. Download the orachk.zip and unzip

$unzip orachk.zip
Archive: orachk.zip
inflating: CollectionManager_App.sql
inflating: UserGuide.txt
inflating: orachk
creating: .cgrep/
inflating: .cgrep/init.tmpl
inflating: .cgrep/checkDiskFGMapping.sh
inflating: .cgrep/exalogic_zfs_checks_el_extensive.aksh
inflating: .cgrep/scnhealthcheck.sql
inflating: .cgrep/merge_collections.pl

2. Run the tool

$ ./orachk
This computer is for [S]ingle instance database or part of a [C]luster to run RAC database [S|C] [C]:S

List of running databases
1.ORCL1
2.TSTDB
3.MRST
…..

21. ROCL
22. All of above
23. None of above

Select databases from list for checking best practices. For multiple databases, select 32 for All or comma separated number like 1,2 etc [1-23][22].22

Searching out ORACLE_HOME for selected databases.
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Checking Status of Oracle Software Stack - Clusterware, ASM, RDBMS
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
-------------------------------------------------------------------------------------------------------
                                                 Oracle Stack Status
-------------------------------------------------------------------------------------------------------
Host Name  CRS Installed  ASM HOME       RDBMS Installed  CRS UP    ASM UP    RDBMS UP  DB Instance Name
-------------------------------------------------------------------------------------------------------
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Copying plug-ins
. .  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. .. . . .
*** Checking Best Practice Recommendations (PASS/WARNING/FAIL) ***
Collections and audit checks log file is
/tmp/oracheck/orachk_server1_ORCL1_052615_194626/log/orachk.log
Checking for prompts in /u01/home/oracle/.profile on server1 for oracle user...
=============================================================
                    Node name - server1
=============================================================
Collecting - Database Parameters for ORCL1database
Collecting - Database Parameters for TSTDB database
Collecting - Database Parameters for MRST database
……..
============
Best Practice checking completed.Checking recommended patches on server1.
---------------------------------------------------------------------------------
Collecting patch inventory on ORACLE_HOME /oracle/product/10.2.0/db_1
Collecting patch inventory on ORACLE_HOME /oracle/product/11.2.0.4/dbhome_1
Collecting patch inventory on ORACLE_HOME /oracle/product/11.2.0/dbhome_1
Collecting patch inventory on ORACLE_HOME /oracle/product/12.1.0.2/dbhome_1
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
1 Recommended RDBMS patches for 102040 from /oracle/product/10.2.0/db_1 on server1
---------------------------------------------------------------------------------
Patch#   RDBMS    ASM     type                Patch-Description
---------------------------------------------------------------------------------
12879929  no             merge               DATABASE PATCH SET UPDATE 10.2.0.4.11 (PRE-REQ 10.2.0.4.4|INCLUDES CPUJAN2012)
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
1 Recommended RDBMS patches for 112040 from /oracle/product/11.2.0.4/dbhome_1 on server1
---------------------------------------------------------------------------------
Patch#   RDBMS    ASM     type                Patch-Description
---------------------------------------------------------------------------------
19769489  no             merge               DATABASE PATCH SET UPDATE 11.2.0.4.5 (INCLUDES CPUJAN2015)
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
1 Recommended RDBMS patches for 112010 from /oracle/product/11.2.0/dbhome_1 on server1
---------------------------------------------------------------------------------
Patch#   RDBMS    ASM     type                Patch-Description
---------------------------------------------------------------------------------
12419378  no             merge               DATABASE PSU 11.2.0.1.6 (INCLUDES CPUJUL2011)
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
1 Recommended RDBMS patches for 121020 from /oracle/product/12.1.0.2/dbhome_1 on server1
---------------------------------------------------------------------------------
Patch#   RDBMS    ASM     type                Patch-Description
---------------------------------------------------------------------------------
19769480  no             merge               DATABASE PATCH SET UPDATE 12.1.0.2.2 (JAN2015)
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------

---------------------------------------------------------------------------------
              RDBMS homes patches summary report
---------------------------------------------------------------------------------
Total patches  Applied on RDBMS Applied on ASM ORACLE_HOME
---------------------------------------------------------------------------------
 1              0              0                /oracle/product/10.2.0/db_1
 1              0              0                /oracle/product/11.2.0.4/dbhome_1
 1              0              0                /oracle/product/11.2.0/dbhome_1
 1              0              0                /oracle/product/12.1.0.2/dbhome_1
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
Detailed report (html) - /tmp/oracheck/orachk_server1_ORCL1_052615_194626/orachk_server1_ORCL1_052615_194626.html
UPLOAD(if required) /tmp/oracheck/orachk_server1_ORCL1_052615_194626.zip
/oracle:DBA>


Regards,
Satishbabu Gunukula, Oracle ACE

Friday, May 12, 2017

Webinar: What is Virtual Private Catalog?

Virtual private catalog will allow you to maintain only one recovery catalog repository by securing boundaries between administrators of various databases or between DBAs, as well as allowing you to separate their duties.

Date and time: May, 19th 2017 8:00am-9:00am
Pacific Daylight Time (San Francisco, GMT-07:00)

Join the Webinar to learn about Virtual Private Catalog and Demo.
  • Overview of RMAN 
  • Overview of Recovery Catalog
  • About Virtual Private Catalog
  • Benefits of Virtual Private Catalog
  • Create Virtual Private Catalog 
  • Manage Virtual Private Catalog
  • RMAN stored Script
  • Q& A
To register for this Webinar, please send an email to SatishbabuGunukula@gmail.com.

Note that registrations are limited and first come and first serve basis.
You will receive an email confirmation with meeting session link.

For Presentation link "Click here"

Regards,
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com

Monday, April 24, 2017

ORA-29855: error occurred DRG-10700: preference does not exist while creating Text Index


User come across an issue that creating index hanging during datapump import. We have excluded the index during export and trying to create after importing data.

CREATE INDEX "AMX"."BRR_360_TXT" ON "AMX"." BRR_360_BLOB" ("FILE_DATA")
INDEXTYPE IS "CTXSYS"."CONTEXT" PARAMETERS ('POPULATE FILTER ODP_FILTER LEXER ODP_LEXER WORDLIST ODP_WORDLIST STOPLIST ODP_STOPLIST SECTION GROUP ODP_SECTION_GROUP')
PARALLEL 4

This was the error that we got

ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10700: preference does not exist: ODP_FILTER
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 366

User have generated the index creating script using dbms_metadata.get_ddl. The index creating script works in case normal index.

But noticed that the index that user was creating is a Text index and we need to use different package i.e CTX_REPORT.CREATE_INDEX_SCRIPT

I have used below script on the source DB to create index for Text index

SET LONG 32000 LINES 200
SET HEAD OFF
SET PAGESIZE 10000
SET TRIMOUT ON TRIMSPOOL ON
SELECT CTX_REPORT.CREATE_INDEX_SCRIPT('<your_text_index_name>') FROM DUAL;
spool off


Regards,
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com

Domain index creation hangs during datapump import

The impdp hangs while creating Domain index and never completes. User waited for 3 days but no luck. All the objects got imported except one domain index.


$ tail -f output
…..
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/INDEX/DOMAIN_INDEX/INDEX

When I query data_datapump_jobs , I can see that import is still running.

OWNER_NAME JOB_NAME OPERATION JOB_MODE STATE DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS
------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------- ----------------- -----------------
SYS SYS_IMPORT_SCHEMA_01 IMPORT SCHEMA EXECUTING 32 2 35
SAPCLD SYS_EXPORT_SCHEMA_01 EXPORT SCHEMA NOT RUNNING 0 0 0

When I query v$session_longops, I can see that 48915 out of 48916 MB done and job hangs

select * from (
select opname, target, sofar, totalwork,
units, elapsed_seconds, message
from v$session_longops order by start_time desc)
…..

SYS_IMPORT_SCHEMA_01 48915 48916 MB 81659 SYS_IMPORT_SCHEMA_01: IMPORT : 48915 out of 48916 MB done

Solution: After research I found that there is a bug in 11.2.0.4 and applying below patch resolved the issue.
Patch 23521888: MERGE REQUEST ON TOP OF 11.2.0.4.0 FOR BUGS 20503463 16683112


Reference: Please find couple of datapump performance Bugs in 11.2.0.4
============================================================
For 11.2.0.4
EXPDP Performance Bugs:
MLR Patch 21443197 released on top of 11.2.0.4 contains the fixes for the bugs: 18082965 18469379 18793246 20236523 19674521 20532904 20548904

IMPDP Performance Bugs:
- Bug 19520061 - IMPDP: EXTREMELY SLOW IMPORT FOR A PARTITIONED TABLE
- Bug 13609098 - IMPORTING SMALL SECUREFILE LOBS USING DATA PUMP IS SLOW >>>>> This patch is already in lsinventory

Bug 21128593 : UPDATING THE MASTER TABLE AT THE END OF DP JOB IS SLOW STARTING WITH 12.1.0.2>> But patch is already in lsinventory

Monday, January 30, 2017

Webinar: Install Oracle Binaries or Clone Oracle Home

Oracle supports cloning and users can easily clone existing Oracle installations. But you need to understand why cloning is useful.

Date and time: Friday, Feb 24th 2017 8:00am-9:00am
Pacific Daylight Time (San Francisco, GMT-07:00)


This Webinar covers following Topics.
  • When cloning useful 
  • Different methods of Cloning 
  • How to perform Cloning 
  • References 
  • Q&A 
To register for this Webinar, please send an email to SatishbabuGunukula@gmail.com.
Note that registrations are limited and first come and first serve basis.

You will receive an email confirmation with meeting session link.

For Presentation link "Click here"

Regards,
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com

Thursday, January 19, 2017

RMAN-06023 and Specification does not match any backup

If you come across a situation that you want to use RMAN to restore but there is a backup without using RMAN.

When you try to restore using RMAN you will receive the error message as below
RMAN-06023: no backup or copy of datafile xx found to restore

When you query catalog you will get below message as no backups in repository.

RMAN> LIST BACKUP OF DATABASE;
Specification does not match any backup in the repository

If you want to use the backups taken using HOT backup mode or copy, you must register all data files, archive logs into RMAN catalog.

Use below command to register.
RMAN> catalog start with '/ora-backup/ORCL/arch-bkp/' noprompt;
RMAN> catalog start with '/ora-backup/ORCL/data-bkp/' noprompt;

If your archive logs and data files are in same location then you need to run only once.

Once all backup copies are registered in RAM you can follow below link to restore

Regards,
Satishbabu Gunukula, Oracle ACE


error in invoking target 'agent nmhs' of makefile

I come across a situation that servers & Operating systems are (O/S) are getting upgraded and we cannot perform in place upgrade for easy roll backing capability.

Also new O/S does not support the Database version.

We need to restore the Oracle database into unsupported Server version. We have copied the Database binaries and during the Database upgrade we got below error.

error in invoking target 'agent nmhs' of makefile

Workaround:
During upgrade or clone  you will get this error when relink is running

Here is the workaround 
ls $ORACLE_HOME/sysman/lib/ins_emagent.mk

Search for the line 
$(MK_EMAGENT_NMECTL)
Change it to:
$(MK_EMAGENT_NMECTL) -lnnz11

https://community.oracle.com/thread/1093616

Goto Database upgrade window and click on "Retry" and upgrade should run successfully.

Regards
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com

SUSPEND and RELEASE background Jobs in SAP

To Suspend all Background jobs follow below steps. Normally uses will do this before upgrade or maintenance activity.

To SUSPEND
SE38 --> Program: BTCTRNS1 --> Run




To RELEASE 
SE38 --> Program: BTCTRNS2 --> Run


Thanks
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com

OPatch failed with error code 73

If users copy the ORACLE_HOME from one system to another unix system, make sure you run the clone command. If not the ORACLE_HOME information will not be registered in the oraInventory.

Some times users may get below errors when they copy ORACLE_HOME, ORACLE Inventory from a different system. Note that the path and SID may not be same.

Inventory load failed... OPatch cannot load inventory for the given Oracle Home.
Possible causes are:
   Oracle Home dir. path does not exist in Central Inventory
   Oracle Home is a symbolic link
   Oracle Home inventory is corrupted
LsInventorySession failed: OracleHomeInventory gets null oracleHomeInfo


OPatch failed with error code 73

By running ORACLE_HOME "Clone" command will create new inventory (if missing) and also takes care of re-linking of libraries..etc

$ORACLE_HOME/oui/bin/runInstaller -clone ORACLE_HOME="/home/oracle/product/v11203" ORACLE_HOME_NAME="Ora11203_home1" ORACLE_BASE="/oracle" oracle.sysman.ccr:PRE_REQUISITE=true

Before you run above command make sure you have /etc/oraInst.loc file with inventory_loc and inst_group.

Note that there are many parameters available and full list of parameters visit
https://docs.oracle.com/cd/E35328_01/E35330/html/vmiug-manager-runinstaller.html

Thanks,
Satish

Enhance Tracing for SAP HANA SSO Issues

SAP HANA will not login and authentication failures and errors. To troubleshooting any login/authentication/sso issue user need to enable tracing

Normally I enable below tracing to get the required info

ALTER SYSTEM ALTER CONFIGURATION ('indexserver.ini', 'SYSTEM') set ('trace', 'authentication') = 'debug' with reconfigure;
ALTER SYSTEM ALTER CONFIGURATION ('indexserver.ini', 'SYSTEM') set ('trace', 'crypto') = 'debug' with reconfigure;
ALTER SYSTEM ALTER CONFIGURATION ('xsengine.ini', 'SYSTEM') set ('trace', 'authentication') = 'debug' with reconfigure;
ALTER SYSTEM ALTER CONFIGURATION ('xsengine.ini', 'SYSTEM') set ('trace', 'xssession') = 'debug' with reconfigure;
ALTER SYSTEM ALTER CONFIGURATION ('xsengine.ini', 'SYSTEM') set ('trace', 'xsauthentication') = 'debug' with reconfigure;

Reproduce the issue and collect the trace. After you collect all the necessary info you can run below command to disable the tracing.

ALTER SYSTEM ALTER CONFIGURATION ('indexserver.ini', 'SYSTEM') UNSET ('trace', 'authentication');
ALTER SYSTEM ALTER CONFIGURATION ('indexserver.ini', 'SYSTEM') UNSET ('trace', 'crypto');
ALTER SYSTEM ALTER CONFIGURATION ('xsengine.ini', 'SYSTEM') UNSET ('trace', 'authentication');
ALTER SYSTEM ALTER CONFIGURATION ('xsengine.ini', 'SYSTEM') UNSET ('trace', 'xssession');
ALTER SYSTEM ALTER CONFIGURATION ('xsengine.ini', 'SYSTEM') UNSET ('trace', 'xsauthentication');

Hope this helps,

Regards
Satishbabu Gunukula, Oracle ACE
http://oracleracexpert.com