statistics stat

exec dbms_stats.gather_schema_stats( ownname => 'HMA_TM_STAGE') ;

exec dbms_stats.gather_schema_stats( ownname => 'HMA_TM_STAGE',degree => 6) ;

EXEC DBMS_STATS.gather_table_stats(ownname => 'HMA_TM_PROD_GEN2_MONITOR', tabname => 'zzt_service_log', degree => 8);

EXEC DBMS_STATS.gather_index_stats(ownname => 'HMA_TM_PROD_GEN2_MONITOR', indname => 'SYS_IL0001313574C00015$$', degree => 8);


exec dbms_stats.lock_table_stats('HMA_TM_PROD_GEN2_MONITOR', 'ZZT_SERVICE_LOG');

Check who is using temp tablespace, Temp Tablespace Usage

SQL>select s.sid || ',' || s.serial# sid_serial, s.username, 

         o.blocks * t.block_size / 1024 / 1024 mb_used, o.tablespace, 

         o.sqladdr address, h.hash_value, h.sql_text 

         from v$sort_usage o, v$session s, v$sqlarea h, dba_tablespaces t 

         where o.session_addr = s.saddr 

         and o.sqladdr = h.address (+) 

         and o.tablespace = t.tablespace_name ;

In RAC

select s.sid || ',' || s.serial# sid_serial, s.username, 

         o.blocks * t.block_size / 1024 / 1024 mb_used, o.tablespace, 

         o.sqladdr address, h.hash_value, h.sql_text 

         from gv$sort_usage o, gv$session s, gv$sqlarea h, dba_tablespaces t 

         where o.session_addr = s.saddr 

         and o.sqladdr = h.address (+) 

         and o.tablespace = t.tablespace_name;

Not related

select * from dba_users where temporary_tablespace !='TEMP';

 
 

select 'alter user '||USERNAME||' temporary tablespace temp2;' from dba_users where temporary_tablespace='TEMP';

Patch apply manually rac (Doc ID 1641136.1)

5 Manual Steps for Apply/Rollback Patch

Steps for Applying the Patch

Note: You must stop the EM agent processes running from the database home, prior to patching the Oracle RAC database or GI Home. Execute the following command on the node to be patched. As the Oracle RAC database home owner execute: $ <ORACLE_HOME>/bin/emctl stop dbconsole

Execute the following on each node of the cluster in non-shared CRS and DB home environment to apply the patch.

1. Stop the CRS managed resources running from DB homes.
    
   If this is a GI Home environment, as the database home owner execute:

   $ <ORACLE_HOME>/bin/srvctl stop home -o <ORACLE_HOME> -s <status file location> -n <node name>
   

   If this is an Oracle Restart Home environment, as the database home owner execute:

   $ <ORACLE_HOME>/bin/srvctl stop home -o <ORACLE_HOME> -s <status file location>
   

   
   

   Note:  You need to make sure that the Oracle ACFS file systems are unmounted (see My Oracle Support document 1494652.1 How to Mount or Unmount ACFS File System While Applying GI Patches?) and all other Oracle processes are shutdown before you proceed.

2. Run the pre root script.
    
   If this is a GI Home, as the root user execute:

   # <GI_HOME>/crs/install/rootcrs.pl -unlock
   

   If this is an Oracle Restart Home, as the root user execute:

   # <GI_HOME>/crs/install/roothas.pl -unlock
   

3.  
   Apply the CRS patch using.
    
   As the GI home owner execute:

   $ <GI_HOME>/OPatch/opatch napply -oh <GI_HOME> -local <UNZIPPED_PATCH_LOCATION>/<GI_PSU_number>/<OCW Components_number>
   

   As the GI home owner execute:

   $ <GI_HOME>/OPatch/opatch napply -oh <GI_HOME> -local <UNZIPPED_PATCH_LOCATION>/<GI_PSU_number>/<ACFS Components_number>
   

   As the GI home owner execute:

   $ <GI_HOME>/OPatch/opatch apply -oh <GI_HOME> -local <UNZIPPED_PATCH_LOCATION>/<GI_PSU_number>/<DB_PSU_number>
   

4.  
   Run the pre script for DB component of the patch.
    
   As the database home owner execute:

   $ <UNZIPPED_PATCH_LOCATION>/<GI_PSU_number>/<OCW Components_number>/custom/server/<OCW Components_number>/custom/scripts/prepatch.sh -dbhome <ORACLE_HOME>
   

5.  
   Apply the DB patch.
    
   As the database home owner execute:

   $ <ORACLE_HOME>/OPatch/opatch napply -oh <ORACLE_HOME> -local <UNZIPPED_PATCH_LOCATION>/<GI_PSU_number>/<OCW Components_number>/custom/server/<OCW Components_number>
   $ <ORACLE_HOME>/OPatch/opatch apply -oh <ORACLE_HOME> -local <UNZIPPED_PATCH_LOCATION>/<GI_PSU_number>/<DB_PSU_number>
   

6.  
   Run the post script for DB component of the patch.
    
   As the database home owner execute:

   $ <UNZIPPED_PATCH_LOCATION>/<GI_PSU_number>/<OCW Components_number>/custom/server/<OCW Components_number>/custom/scripts/postpatch.sh -dbhome <ORACLE_HOME>
   

7. Run the post script.
    
   As the root user execute:

   # <GI_HOME>/rdbms/install/rootadd_rdbms.sh
   

   If this is a GI Home, as the root user execute:

   # <GI_HOME>/crs/install/rootcrs.pl -patch
   

   If this is an Oracle Restart Home, as the root user execute:

   # <GI_HOME>/crs/install/roothas.pl -patch
   

8. If the message, "A system reboot is recommended before using ACFS� is shown, then a reboot must be issued before continuing. Failure to do so will result in running with an unpatched ACFS\ADVM\OKS driver.
9. Start the CRS managed resources that were earlier running from DB homes.
    
   If this is a GI Home environment, as the database home owner execute:

   $ <ORACLE_HOME>/bin/srvctl start home -o <ORACLE_HOME> -s <status file location> -n <node name>
   

   If this is an Oracle Restart Home environment, as the database home owner execute:

   $ <ORACLE_HOME>/bin/srvctl start home -o <ORACLE_HOME> -s <status file location> 
   

Steps for Rolling Back the Patch From a GI Home

Execute the following on each node of the cluster in non-shared CRS and DB home environment to rollback the patch.

1. Stop the CRS managed resources running from DB homes.
    
   If this is a GI Home environment, as the database home owner execute:

   $ <ORACLE_HOME>/bin/srvctl stop home -o <ORACLE_HOME> -s <status file location> -n <node name>
   

   If this is an Oracle Restart Home environment, as the database home owner execute:

   $ <ORACLE_HOME>/bin/srvctl stop home -o <ORACLE_HOME> -s <status file location> 
   

   
   

   Note:  You need to make sure that the Oracle ACFS file systems are unmounted (see My Oracle Support document 1494652.1 How to Mount or Unmount ACFS File System While Applying GI Patches?) and all other Oracle processes are shut down before you proceed.

2. Run the pre root script.
    
   If this is a GI Home, as the root user execute:

   # <GI_HOME>/crs/install/rootcrs.pl -unlock
   

   If this is an Oracle Restart Home, as the root user execute:

   # <GI_HOME>/crs/install/roothas.pl -unlock
   

3.  
   Roll back the CRS patch.
    
   As the GI home owner execute:

   $ <GI_HOME>/OPatch/opatch rollback -local -id <OCW Components_number> -oh <GI_HOME> 
   $ <GI_HOME>/OPatch/opatch rollback -local -id <ACFS Components_number> -oh <GI_HOME> 
   $ <GI_HOME>/OPatch/opatch rollback -local -id <DB_PSU_number> -oh <GI_HOME> 
   

4.  
   Run the pre script for DB component of the patch.
    
   As the database home owner execute:

   $ <UNZIPPED_PATCH_LOCATION>/<GI_PSU_number>/<OCW Components_number>/custom/server/<OCW Components_number>/custom/scripts/prepatch.sh -dbhome <ORACLE_HOME>
   

5.  
   Roll back the DB patch from the database home.
    
   As the database home owner execute:

   $ <ORACLE_HOME>/OPatch/opatch rollback -local -id <OCW Components_number> -oh <ORACLE_HOME> 
   $ <ORACLE_HOME>/OPatch/opatch rollback -local -id <DB_PSU_number> -oh <ORACLE_HOME>
   

6.  
   Run the post script for DB component of the patch.
    
   As the database home owner execute:

   $ <UNZIPPED_PATCH_LOCATION>/<GI_PSU_number>/<OCW Components_number>/custom/server/<OCW Components_number>/custom/scripts/postpatch.sh -dbhome <ORACLE_HOME>
   

7. Run the post script.
    
   As the root user execute:

   # <GI_HOME>/rdbms/install/rootadd_rdbms.sh
   

   If this is a GI Home, as the root user execute:

   # <GI_HOME>/crs/install/rootcrs.pl -patch
   

   If this is an Oracle Restart Home, as the root user execute:

   # <GI_HOME>/crs/install/roothas.pl -patch
   

8. If the message, "A system reboot is recommended before using ACFS� is shown, then a reboot must be issued before continuing. Failure to do so will result in running with an unpatched ACFS\ADVM\OKS driver.
9. Start the CRS managed resources that were earlier running from DB homes.
    
   If this is a GI Home environment, as the database home owner execute:

   $ <ORACLE_HOME>/bin/srvctl start home -o <ORACLE_HOME> -s <status file location> -n <node name>
   

   If this is an Oracle Restart Home environment, as the database home owner execute:

   $ <ORACLE_HOME>/bin/srvctl start home -o <ORACLE_HOME> -s <status file location> 
   

Patching an Oracle RAC Home Installation Manually

Note that USM only patches cannot be applied to a Database home.

1. Run the pre script for DB component of the patch.
    
   As the database home owner execute:

   $ <UNZIPPED_PATCH_LOCATION>/<GI_PSU_number>/<OCW Components_number>/custom/server/<OCW Components_number>/custom/scripts/prepatch.sh -dbhome <ORACLE_HOME>
   

2. Apply the DB patch.
    
   As the database home owner execute:

   $ <ORACLE_HOME>/OPatch/opatch napply -oh <ORACLE_HOME> -local <UNZIPPED_PATCH_LOCATION>/<GI_PSU_number>/<OCW Components_number>/custom/server/<OCW Components_number>
   $ <ORACLE_HOME>/OPatch/opatch apply -oh <ORACLE_HOME> -local <UNZIPPED_PATCH_LOCATION>/<GI_PSU_number>/<DB_PSU_number>
   

3. Run the post script for DB component of the patch.
    
   As the database home owner execute:

   $ <UNZIPPED_PATCH_LOCATION>/<GI_PSU_number>/<OCW Components_number>/custom/server/<OCW Components_number>/custom/scripts/postpatch.sh -dbhome <ORACLE_HOME>
   

Rolling Back the Patch from an Oracle RAC Home Installation Manually

1. Run the pre script for DB component of the patch.
    
   As the database home owner execute:

   $ <UNZIPPED_PATCH_LOCATION>/<GI_PSU_number>/<OCW Components_number>/custom/server/<OCW Components_number>/custom/scripts/prepatch.sh -dbhome <ORACLE_HOME>
   

2. Roll back the DB patch from the database home.
    
   As the database home owner execute:

   $ <ORACLE_HOME>/OPatch/opatch rollback -local -id <OCW Components_number> -oh <ORACLE_HOME>
   $ <ORACLE_HOME>/OPatch/opatch rollback -local -id <DB_PSU_number> -oh <ORACLE_HOME>
   

3. Run the post script for DB component of the patch.
    
   As the database home owner execute:

   $ <UNZIPPED_PATCH_LOCATION>/<GI_PSU_number>/<OCW Components_number>/custom/server/<OCW Components_number>/custom/scripts/postpatch.sh -dbhome <ORACLE_HOME>

Rman scenarios

Rman Scenarios
Using restore and recover

Set db_file_recovery_dest
Take backup of prod and autobackup of controlfile

Copy to same exact location in target server

Copy pfile from prod to target

Copy password file from prod to target

Now on Target

Startup nomount
Restore control file from autobackup location using rman
alter database mount
restore database in rman
recover database in rman
alter database open resetlogs


If you want same db name in test as well stop here..

If you want to change db name then
backup control file to trace

copy from trace and change name of db and locations if needed and change reuse to set on top and save it as ctrl.ora

change pfile to the new db name and locations if needed.

startup nomount
@ctrl.ora
alter database open resetlogs


********************************************************************************************************************************************************
Now using duplicate

duplicate can be done from backup as well as active database

Take backup of prod
Copy to same exact location in target server

Copy pfile from prod to target

Copy password file from prod to target

Now on Target

Startup nomount

rman target sys/oracle@prod auxiliary /

duplicate target database to test;


Other scenario is active database with out using backup.

ORA-27301: OS failure message: No space left on device

ORA-27301: OS failure message: No space left on device

After installing Oracle on Linux and creating a database,I tried to connect to sqlplus and startup the database instance I got this error:

$ sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Wed Oct 5 15:53:47 2011

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Enter user-name: / as sysdba
Connected to an idle instance.

SQL> startup
ORA-27154: post/wait create failed
ORA-27300: OS system dependent operation:semget failed with status: 28
ORA-27301: OS failure message: No space left on device
ORA-27302: failure occurred at: sskgpsemsper

Solution:

As root user, edit the /etc/sysctl.conf file and edit the kernel parameters
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128


and then run this command

/sbin/sysctl -p

Catproc invalid

SQL> select substr(comp_name,1,30) comp_name, substr(comp_id,1,10)

      comp_id,substr(version,1,12) version,status from dba_registry;

  2

COMP_NAME                      COMP_ID    VERSION      STATUS

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

Oracle XML Database            XDB        11.2.0.2.0   VALID

Oracle Expression Filter       EXF        11.2.0.2.0   VALID

Oracle Rule Manager            RUL        11.2.0.2.0   VALID

Oracle Workspace Manager       OWM        11.2.0.2.0   VALID

Oracle Database Catalog Views  CATALOG    11.2.0.2.0   VALID

Oracle Database Packages and T CATPROC    11.2.0.2.0   INVALID

JServer JAVA Virtual Machine   JAVAVM     11.2.0.2.0   VALID

Oracle XDK                     XML        11.2.0.2.0   VALID

Oracle Database Java Packages  CATJAVA    11.2.0.2.0   VALID

9 rows selected.

Causes:
The probable causes for dba_registry components became invalid could be any of the following.

·                     Applied a patch and after the patch application because of some dependent object status change registry can become invalid

·                     Installed a new component and the new component installation got failed then registry components could become invalid

·                     catalog.sql or catproc.sql was not successfully ran after database creation. Any of them would have failed somewhere or any of the dependent object got invalid afterward

You can try the below steps to validate if you don’t have any invalid object in the database

SQL> select count(*) from dba_objects where status=’INVALID’;

COUNT(*)
———-
0

SQL> exec DBMS_REGISTRY_SYS.VALIDATE_CATPROC;

If you have any invalid objects in the database then follow the below steps

SQL> SQL> select count(*) from dba_objects where status='INVALID';

  COUNT(*)

----------

       449

1 row selected.

'Packages and Types' can usually be validated by running catalog and catproc scripts:

$sqlplus "/as sysdba"
SQL> startup restrict
SQL > @?/rdbms/admin/catalog.sql
SQL > @?/rdbms/admin/catproc.sql
SQL > @?/rdbms/admin/utlrp.sql

SQL> select substr(comp_name,1,30) comp_name, substr(comp_id,1,10)

      comp_id,substr(version,1,12) version,status from dba_registry;

  2

COMP_NAME                                COMP_ID    VERSION      STATUS

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

Oracle XML Database                      XDB        11.2.0.2.0   VALID

Oracle Expression Filter                 EXF        11.2.0.2.0   VALID

Oracle Rule Manager                      RUL        11.2.0.2.0   VALID

Oracle Workspace Manager                 OWM        11.2.0.2.0   VALID

Oracle Database Catalog Views            CATALOG    11.2.0.2.0   VALID

Oracle Database Packages and T           CATPROC    11.2.0.2.0   VALID

JServer JAVA Virtual Machine             JAVAVM     11.2.0.2.0   VALID

Oracle XDK                               XML        11.2.0.2.0   VALID

Oracle Database Java Packages            CATJAVA    11.2.0.2.0   VALID

9 rows selected.

Shutdown your database in the normal mode and startup with the normal mode.

Hope the above document help you in solving the issue.

Check online and offline datafiles

select a.file#, b.name ts_name from v$datafile a, v$tablespace b where a.ts#=b.ts# and b.name not in ('SYSTEM','SYSAUX') and a.status='ONLINE'




select a.file# from v$datafile a, v$tablespace b where a.ts#=b.ts# and b.name  in ('UNDOTBS1','UNDOTBS2');




select a.file# from v$datafile a, v$tablespace b where a.ts#=b.ts# and b.name not in ('SYSTEM','SYSAUX') and a.status='OFFLINE'

Sql History

--
-- Show the Plan Hash Values for a Given SQLID Over a Given Period
--

SET PAUSE ON
SET PAUSE 'Press Return to Continue'
SET PAGESIZE 60
SET LINESIZE 300

SELECT DISTINCT sql_id, plan_hash_value
FROM dba_hist_sqlstat q,
    (
    SELECT /*+ NO_MERGE */ MIN(snap_id) min_snap, MAX(snap_id) max_snap
    FROM dba_hist_snapshot ss
    WHERE ss.begin_interval_time BETWEEN (SYSDATE - &No_Days) AND SYSDATE
    ) s
WHERE q.snap_id BETWEEN s.min_snap AND s.max_snap
  AND q.sql_id IN ( '&SQLID')
/


--
-- List SQL Run Dates for a Given Plan Hash Value
--

SET PAUSE ON
SET PAUSE 'Press Return to Continue'
SET PAGESIZE 60
SET LINESIZE 300

SELECT DISTINCT
     sql_plan_hash_value,
     to_char(sample_time,'DD-Mon-YYYY') as st
FROM DBA_HIST_ACTIVE_SESS_HISTORY
WHERE sql_plan_hash_value=&Enter_Plan_Hash_Value
ORDER BY st
/

BLOB and CLOB Tips

1) BLOBs and CLOBs are identical in creation and use, their major difference is in that BLOBs are used for binary data (much like LONG RAW) while CLOBs are used for single byte character storage (like VARCHAR2).
Recommended to use CLOB if data is VARCHAR, and BLOB if data is going to be graphics, image, etc.

2) Always specify the LOB storage clause, if you force the system to do a default storage each time a BLOB or CLOB exceeds 4000 bytes you could cause datafile fragmentation and performance problems. The LOB storage clause gives you control instead of the system.
3) If most LOBs in your database tables are small in size—8K bytes or less—and only a few rows have LOBs larger than 8K bytes, then use the following guidelines to maximize database performance:
• Use ENABLE STORAGE IN ROW
• Set the DB_BLOCK_SIZE initialization parameter to 8K bytes and use a chunk size of 8K bytes
4) When storing a large LOB inside an Oracle data file, you should consider a 32k blocksize tablespace (to avoid chaining) and carefully set pctfree and pctused to minimize wasted space within the Oracle data blocks. Different blocksizes can improve performance in a variety of ways:

Contention reduction –
small rows in a large block perform worse under heavy DML than large rows in a small blocksize.
Faster updates –
Heavy insert/update tables can see faster performance when segregated into another blocksize which is mapped to a small data buffer cache. Smaller data buffer caches often see faster throughput performance.
Reduced Pinging –
RAC can perform far faster with smaller blocksizes, reducing cache fusion overhead.
Less RAM waste –
Moving random access small row tables to a smaller blocksize (with a corresponding small blocksize buffer) will reduce buffer waste and improve the chance that other data blocks will remain in the cache.
Faster scans –
Tables and indexes that require full scans can see faster performance when placed in a large blocksize.

Find Size of Largest 10 database objects in oracle database

SELECT * FROM
(
select 
    SEGMENT_NAME, 
    SEGMENT_TYPE, 
    BYTES/1024/1024/1024 GB, 
    TABLESPACE_NAME 
from 
    dba_segments
order by 3 desc  
) WHERE
ROWNUM <= 10

Check users having grants with grant option in oracle database

SELECT a.owner,a.table_name,a.privilege,a.GRANTEE from dba_tab_privs a WHERE a.grantable='YES'
and a.owner not in ('ANONYMOUS','APEX_030200','APEX_PUBLIC_USER','APPQOSSYS','CTXSYS','DBSNMP','DIP','DMSYS','EXFSYS','FLOWS_FILES','LBACSYS','MDDATA','MDSYS','MGMT_VIEW','ODM','ODM_MTR','OLAPSYS','ORACLE_OCM','ORDDATA','ORDPLUGINS','ORDSYS','OUTLN','OWBSYS','OWBSYS_AUDIT','PERFSTAT','PUBLIC','QS','QS_ADM','QS_CB','QS_CBADM','QS_CS','QS_ES','QS_OS','QS_WS','RMAN','SI_INFORMTN_SCHEMA','SPATIAL_CSW_ADMIN_USR','SPATIAL_WFS_ADMIN_USR','SYS','SYSMAN','SYSTEM','TSMSYS','WKPROXY','WKSYS','WMSYS','XDB','XS$NULL')
minus
SELECT a.owner,a.table_name,a.privilege,a.GRANTEE from dba_tab_privs a WHERE a.grantable='YES'
and a.owner like 'CUBEONE%'
and (  ( a.table_name in ('XX1','ODEC_CHAR_SEL','ODEC_CHAR_SEL_VAR','ODEC_VARCHAR2_SEL','ODEC_VARCHAR3_SEL','ODEC_VARCHAR2_SEL_VAR','ODEC_VARCHAR3_SEL_VAR','ODEC_NUMBER_SEL','ODEC_DATE_SEL','ODEC_FLOAT_SEL','ODEC_INTEGER_SEL','ODEC_LONG_SEL','ODEC_LONG_SEL2','ODEC_CLOB_SEL','ODEC_CLOB_SEL2','ODEC_BLOB_SEL') and a.privilege='EXECUTE')
    or ( a.table_name in ('DIA_ACCESS_LOG','DIA_ACCESS_LOG_SIUD','DIA_ACCESS_LOG_SUCCESS_FLAG','DIA_ACCESS_RPT') and a.privilege='SELECT' )
    or ( a.table_name in ('DIA_ACCESS_LOG') and a.privilege='INSERT')
    );

Oracle Database wallet creation

For Implementing TDE you need to install wallet

For RAC it is recommended to use shared location for wallet

First put the wallet location in sqlnet.ora

### TDE env. ###
ENCRYPTION_WALLET_LOCATION =
  (SOURCE = (METHOD = FILE)
   (METHOD_DATA =
    (DIRECTORY = /u01/app/oracle/admin/$ORACLE_UNQNAME/wallet)
   )
  )

After that make sure folder is present

mkdir -p /u01/app/oracle/admin/$ORACLE_UNQNAME/wallet/

Login to db

sqlplus / as sysdba

For Creating

ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY "xxxxxxx";


Once created Wallet will be open

If you need to open wallet manually. This should be done after restarting db or else you will get error when viewing encrypted tables saying wallet not open

For Opening

ALTER SYSTEM SET ENCRYPTION WALLET OPEN IDENTIFIED BY "xxxxxxxx";

For Closing

alter system set encryption wallet close identified by "xxxxxxxx";

Once you create wallet you will see a file named ewallet.p12 in the wallet folder.

Make sure you set permission to 600 for the file.

If RAC and not using shared location copy that file to same location on node2.

Your 2nd instance should pick it up.

you can check wallet status using 

select * from gv$encryption_wallet;

TIP: Some time gv$ shows one of the instance as closed. Then use 

select * from v$encryption_wallet;

Once it shows open then use the gv$ view again. I think its a bug in 11.2.0.4

Note: Also make sure you set up unq_name for database.

For RAC you can check using

srvctl config database -d db_name

Its a good practice to manually export the unq_name using the following before creating or opening the wallet.

FOR RAC set environments using following

srvctl setenv database -d prod -T "ORACLE_UNQNAME=prod"

 export ORACLE_UNQNAME=`$ORACLE_HOME/bin/srvctl config database |grep -w ${ORACLE_SID%?}`

Now configuring Auto login wallet

Use ORAPKI utility

orapki wallet create -wallet /u01/app/oracle/admin/$ORACLE_UNQNAME/wallet/ -auto_login

It will prompt for wallet password and your auto login wallet will be created. You will see a new file in the wallet location cwallet.sso

Make sure you change permissions for that file too

Deleting wallet ( To be continued)

Basically you need to decrypt everything before you remove wallet

For reference see: http://www.toadworld.com/platforms/oracle/w/wiki/11195.oracle-database-tde-in-rac-non-shared-location-auto-login-considerations

Refrence:

sqlplus startup works but srvctl fails: ORA-03113/ORA-28365: wallet is not open (Doc ID 2112118.1) Managing TDE wallets in a RAC environment (Doc ID 567287.1) PRCR-1079 CRS-5017 "ORA-28365: wallet is not open" When Starting Database Using srvctl as Wrong Environment Variable is Set in OCR (Doc ID 1567201.1)

To create a new entry in wallet.. Before doing this add a tns entry.. in the example below tns entry is thicon_sys and username is sys pasword is Password#1..
Location is wallet location.. we can get it form sqlnet.ora

mkstore -wrl /opt/app/oracle/product/11.2.0/11.2.0.4/dbs -createCredential thicon_sys sys Password#1


This lists the credentials stored in wallet


mkstore -wrl /opt/app/oracle/product/11.2.0/11.2.0.4/dbs -listCredential

Make sure to export unqname before creating wallet for RAC

 export ORACLE_UNQNAME=`$ORACLE_HOME/bin/srvctl config database |grep -w ${ORACLE_SID%?}`

The following may be/ may not be related 

To create a wallet in database here are the sample steps

Sample sqlnet.ora file


### TDE env. ###
ENCRYPTION_WALLET_LOCATION =
  (SOURCE = (METHOD = FILE)
   (METHOD_DATA =
    (DIRECTORY = /u01/app/oracle/admin/$ORACLE_UNQNAME/wallet)
   )
  )

#11gR1 and 11gR2 Target Database or Repository Create Several TNS-12599 Errors in Alert.log File (Doc ID 1150874.1)
SQLNET.ENCRYPTION_TYPES_SERVER= (3DES168)

#TNS-12599: TNS:cryptographic Checksum Mismatch in alert.log after enabling of encryption on the server side (Doc ID 1927120.1)
DIAG_ADR_ENABLED=OFF

After this

Create the db folder in the location

cd /u01/app/oracle/admin/

mkdir -p sdwh/wallet

Login to sdwh database as sysdba

sqlplus / as sysdba

ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY "xxxxxxxxxxx";

If you dont create folder as above mentioned similar to sqlnet.ora then  you will get the following error

ERROR at line 1:

ORA-28368: cannot auto-create wallet

After creating the password the wallet will be open and ready to be used.

You can close the wallet by using following command

alter system set encryption wallet close identified by "xxxxxxxxxx"

Once wallet is closed you wont be able to query the tables that are encrypted.

If you do a db shutdown which has wallet encrrypted columns or tablespace you should open the wallet after restart of database

Here is the command

ALTER SYSTEM SET ENCRYPTION WALLET OPEN IDENTIFIED BY "myPassword";

******************************************************************************************

Wallet addition info to prevent unauthorized access

Creating a Wallet

Use the mkstore command on an empty directory as follows:
mkdir -p /oracle/admin/DBNAME/wallet
mkstore -wrl /oracle/admin/DBNAME/wallet -create

You will be prompted for a password to secure the wallet. Make sure it is something secure, and record the password in your central password store.

Next, add the following lines to your sqlnet.ora configuration file.
SQLNET.WALLET_OVERRIDE = TRUE
WALLET_LOCATION=(
  SOURCE=(METHOD=FILE)
  (METHOD_DATA=(DIRECTORY=/oracle/admin/DBNAME/wallet))
)

Note: There are implications for both Clusterware and OS authentication when using wallet_override:, so please see the section "Known Issues / Gotchas" at the end of the article)

Adding a username and password to the wallet

Before adding the username and password, we create an alias in the tnsnames.ora file that will be used whenever we want to log in using the stored credentials. Only one password may be stored in the wallet per TNS alias: In our example below, we have created an alias called "DBFS":
# Connectiong string for DBFS Oracle Wallet
DBFS =
(DESCRIPTION =
(ADDRESS=(PROTOCOL=TCP)(HOST=`hostname`-vip)(PORT=1528))
(CONNECT_DATA=(SID=PMLOC1_1))
)

Now to add a username and password to an existing wallet, use the mkstore command with the -createCredential option as follows:
mkstore -wrl <wallet_location> -createCredential <TNS_alias> <username> <password>

Example:
mkstore -wrl /oracle/admin/DBNAME/wallet -createCredential DBFS dbfs_admin p@ssw0rd

Testing the Wallet

That's it, your wallet is created and you've stored a username and password inside it. Now all you need to do is test it using the TNS alias you setup (DBFS in our example):
sqlplus /@DBFS

Administering the Wallet

Listing credentials stored in the wallet:
mkstore -wrl <wallet_location> -listCredential

Modifying credentials stored in the wallet:
mkstore -wrl <wallet_location> -modifyCredential <dbase_alias> <username> <password>

Deleting credentials stored in the wallet:
mkstore -wrl <wallet_location> -deleteCredential <db_alias>

Deleting the whole wallet:
rm -rf <wallet_location>

Which user is using what tablespace in oracle database

SELECT   b.TABLESPACE
       , b.segfile#
       , b.segblk#
       , ROUND (  (  ( b.blocks * p.VALUE ) / 1024 / 1024 ), 2 ) size_mb
       , a.SID
       , a.serial#
       , a.username
       , a.osuser
       , a.program
       , a.status
    FROM v$session a
       , v$sort_usage b
       , v$process c
       , v$parameter p
   WHERE p.NAME = 'db_block_size'
     AND a.saddr = b.session_addr
     AND a.paddr = c.addr
ORDER BY b.TABLESPACE
       , b.segfile#
       , b.segblk#
       , b.blocks;

Trigger to detect failed logins in oracle database

DROP TRIGGER SYS.HATA_TRIG_PREVENT_SQL_TOOLS;

CREATE OR REPLACE TRIGGER SYS.HATA_TRIG_Prevent_SQL_TOOLS
AFTER LOGON ON DATABASE
DISABLE
declare
v_user varchar2(30):=user;
v_program varchar2(100);
v_exists number(1) := 0;
 begin
select upper(b.program), upper(osuser) into v_program,v_user
from sys.v_$session b
WHERE audsid = USERENV('SESSIONID')
AND audsid != 0 -- Don't Check SYS Connections;
AND rownum = 1;

begin
select 1 into v_exists
from hataopsadm.ACCESS_TO_SQL_TOOL
where OS_ID = v_user;
exception
when no_data_found then
  v_exists := 0;
end;

   if  v_exists = 0 and (UPPER(v_program) LIKE '%TOAD%' OR UPPER(v_program) LIKE '%T.O.A.D%' OR -- Toad
    UPPER(v_program) LIKE '%SQL DEVELOPER%' OR     -- SQL Developer
UPPER(v_program) LIKE '%SQLNAV%' OR     -- SQL Navigator
UPPER(v_program) LIKE '%PLSQLDEV%' OR -- PLSQL Developer
UPPER(v_program) LIKE '%BUSOBJ%' OR -- Business Objects
UPPER(v_program) LIKE '%EXCEL%') -- MS-Excel plug-in
THEN
        raise_application_error(-20000, 'SQL tool with specified access is not allowed !!!');
   end if;
end;

trcasst for reading sqlnet trace files

oracle@prepo:/opt/app/oracle/product/10.2.0.5/network/trace>trcasst sql_trace_9371.trc

Trace Assistant Utility: Version 10.2.0.5.0 Production on October 30, 2014 11:15:06 AM

Copyright (c) 2001, 2010, Oracle.  All rights reserved.


    *************************************************************************
    *                        Trace Assistant                                *
    *************************************************************************

<--- Received 167 bytes - Connect packet  timestamp=28-OCT-2014 05:20:02:331
Current NS version number is: 308.
Lowest NS version number can accommodate is: 300.
        Maximum SDU size: 2048
        Maximum TDU size: 32767
        NT protocol characteristics:
                Test for more data
                Spawner is running
                Hang on to Listener connection
                Test operation
                Full duplex I/O
                Urgent data support
                Generate SIGURG signal
                Handoff connection to another
        Line turnaround value: 0
        Connect data length: 133
        Connect data offset: 34
        Connect data maximum size: 0
                Disable NA services on this connection
                Disable NA services on this connection
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=hmadwh2))(CONNECT
    _DATA=(SID=PREPO)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=infadm))))

---> Send 24 bytes - Accept packet  timestamp=28-OCT-2014 05:20:02:332
Accepted NS version number is: 308.
        Accepted maximum SDU size: 2048
        Accepted maximum TDU size: 32767
        Connect data length: 0
                Native Services wanted
                Disable NA services on this connection
                NAU doing O3LOGON - DH key foldedin

<--- Received 33 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:334
Set protocol (TTIPRO)
        Operation 01 (con) Receive protocol version=6
        Destination platform: Java_TTC-8.2.0

---> Send 183 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:334
Set protocol (TTIPRO)
        Operation 01 (con) Send protocol version=6
        Originating platform: SVR4-be-64bit-8.1.0

<--- Received 779 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:335
Set datatypes (TTIDTY)

---> Send 834 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:336
Set datatypes (TTIDTY)

<--- Received 19 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:338
Start of user function (TTIFUN)
        Get Oracle version/date (OVERSION)

---> Send 174 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:338
Return opi parameter (TTIRPA)
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

<--- Received 121 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:339
Start of user function (TTIFUN)
        Get the session key (OSESSKEY)

---> Send 73 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:341
Return opi parameter (TTIRPA)

<--- Received 155 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:342
Start of user function (TTIFUN)
        Generic authentication call (OAUTH)

---> Send 1197 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:345
Return opi parameter (TTIRPA)

<--- Received 92 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:347
Start of user function (TTIFUN)
        New v8 bundled call (OALL8) Cursor # 0
 Parse
ALTER SESSION SET TIME_ZONE = '-7:0'


---> Send 72 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:347
Return opi parameter (TTIRPA)

<--- Received 188 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:348
Start of user function (TTIFUN)
        New v8 bundled call (OALL8) Cursor # 1
 Parse
 ALTER SESSION SET NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS.FF'  NLS_TIME
STAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS.FF TZH:TZM'


---> Send 335 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:348
Return opi parameter (TTIRPA)

<--- Received 79 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:349
Start of user function (TTIFUN)
        New v8 bundled call (OALL8) Cursor # 1
 Parse Fetch
select USER from DUAL


---> Send 148 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:350
Describe information (TTIDCB)

<--- Received 96 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:350
Start of user function (TTIFUN)
        New v8 bundled call (OALL8) Cursor # 1
 Parse Fetch
select TZ_OFFSET(DBTIMEZONE) from dual


---> Send 163 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:351
Describe information (TTIDCB)

<--- Received 15 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:369
Start of user function (TTIFUN)
        Open a cursor (OOPEN)

---> Send 16 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:370
Return opi parameter (TTIRPA)
        Cursor #: 2

<--- Received 371 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:370
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  2
 Parse
DELETE FROM PCSF_RUN_LOG WHERE RUNCONTEXT = :v0 AND INTEGRATIONSERVICE =:v1 AN
D REPOSITORYNAME = :v2 AND REPOSITORYDOMAIN = :v3 AND RUNID != :v4 AND ENTRYTI
ME < :v5

---> Send 55 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:375
Return opi parameter (TTIRPA)

<--- Received 15 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:376
Start of user function (TTIFUN)
        Open a cursor (OOPEN)

---> Send 16 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:376
Return opi parameter (TTIRPA)
        Cursor #: 3

<--- Received 797 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:376
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
INSERT INTO PCSF_RUN_LOG (ABSOLUTEFILENAME, NODENAME, INTEGRATIONSERVICE, REPO
SITORYDOMAIN, REPOSITORYNAME, FOLDER, WORKFLOW, SESSIONPATH, RUNCONTEXT, RUNID
, ENTRYTIME, OSUSER, RUNINSTANCENAME) VALUES (:v0, :v1, :v2, :v3, :v4, :v5, :v
6, :v7, :v8, :v9, :v10, :v11, :v12)

---> Send 55 bytes - Data packet  timestamp=28-OCT-2014 05:20:02:379
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:20:04:365
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:20:04:370
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:20:12:380
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:20:12:385
Return opi parameter (TTIRPA)

<--- Received 138 bytes - Data packet  timestamp=28-OCT-2014 05:20:20:395
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
SELECT sys_context('USERENV', 'SERVER_HOST'), sys_context('USERENV', 'INSTANCE
_NAME') FROM dual

---> Send 53 bytes - Data packet  timestamp=28-OCT-2014 05:20:20:396
Return opi parameter (TTIRPA)

<--- Received 22 bytes - Data packet  timestamp=28-OCT-2014 05:20:20:397
Start of user function (TTIFUN)
        New describe any call (ODNY)

---> Send 172 bytes - Data packet  timestamp=28-OCT-2014 05:20:20:397
Return opi parameter (TTIRPA)

<--- Received 72 bytes - Data packet  timestamp=28-OCT-2014 05:20:20:398
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 !Keep Fetch

---> Send 100 bytes - Data packet  timestamp=28-OCT-2014 05:20:20:398
Row transfer header (TTIRXH)
        end of row
        Requests: 2, Iteration #: 0
        Number of iterations: 125, UAC buffer length: 0

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:20:20:399
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:20:20:403
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:20:28:414
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:20:28:418
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:20:36:429
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:20:36:433
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:20:44:444
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:20:44:448
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:20:52:459
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:20:52:464
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:21:00:474
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:21:00:479
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:21:08:489
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:21:08:493
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:21:16:504
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:21:16:521
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:21:24:532
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:21:24:539
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:21:32:549
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:21:32:556
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:21:40:566
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:21:40:570
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:21:48:581
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:21:48:585
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:21:56:596
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:21:56:601
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:22:04:611
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:22:04:617
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:22:12:628
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:22:12:632
Return opi parameter (TTIRPA)

<--- Received 361 bytes - Data packet  timestamp=28-OCT-2014 05:22:14:887
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
DELETE FROM PCSF_RUN_LOG WHERE RUNCONTEXT = :v0 AND INTEGRATIONSERVICE =:v1 AN
D REPOSITORYNAME = :v2 AND REPOSITORYDOMAIN = :v3 AND RUNID != :v4 AND ENTRYTI
ME < :v5

---> Send 53 bytes - Data packet  timestamp=28-OCT-2014 05:22:14:895
Return opi parameter (TTIRPA)

<--- Received 712 bytes - Data packet  timestamp=28-OCT-2014 05:22:14:895
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  2
 Parse
INSERT INTO PCSF_RUN_LOG (ABSOLUTEFILENAME, NODENAME, INTEGRATIONSERVICE, REPO
SITORYDOMAIN, REPOSITORYNAME, FOLDER, WORKFLOW, SESSIONPATH, RUNCONTEXT, RUNID
, ENTRYTIME, OSUSER, RUNINSTANCENAME) VALUES (:v0, :v1, :v2, :v3, :v4, :v5, :v
6, :v7, :v8, :v9, :v10, :v11, :v12)

---> Send 55 bytes - Data packet  timestamp=28-OCT-2014 05:22:14:898
Return opi parameter (TTIRPA)

<--- Received 365 bytes - Data packet  timestamp=28-OCT-2014 05:22:17:496
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  2
 Parse
DELETE FROM PCSF_RUN_LOG WHERE RUNCONTEXT = :v0 AND INTEGRATIONSERVICE =:v1 AN
D REPOSITORYNAME = :v2 AND REPOSITORYDOMAIN = :v3 AND RUNID != :v4 AND ENTRYTI
ME < :v5

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:22:17:505
Return opi parameter (TTIRPA)

<--- Received 769 bytes - Data packet  timestamp=28-OCT-2014 05:22:17:505
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
INSERT INTO PCSF_RUN_LOG (ABSOLUTEFILENAME, NODENAME, INTEGRATIONSERVICE, REPO
SITORYDOMAIN, REPOSITORYNAME, FOLDER, WORKFLOW, SESSIONPATH, RUNCONTEXT, RUNID
, ENTRYTIME, OSUSER, RUNINSTANCENAME) VALUES (:v0, :v1, :v2, :v3, :v4, :v5, :v
6, :v7, :v8, :v9, :v10, :v11, :v12)

---> Send 55 bytes - Data packet  timestamp=28-OCT-2014 05:22:17:531
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:22:20:643
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:22:20:647
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:22:28:658
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:22:28:662
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:22:36:673
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:22:36:678
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:22:44:689
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:22:44:694
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:22:52:704
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:22:52:709
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:23:00:720
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:23:00:724
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:23:08:735
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:23:08:739
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:23:16:750
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:23:16:755
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:23:24:765
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:23:24:770
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:23:32:780
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:23:32:785
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:23:40:796
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:23:40:800
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:23:48:811
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:23:48:815
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:23:56:826
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:23:56:831
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:24:04:841
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:24:04:846
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:24:12:857
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:24:12:861
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:24:20:872
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:24:20:876
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:24:28:887
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:24:28:911
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:24:36:921
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:24:36:926
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:24:44:937
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:24:44:942
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:24:52:952
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:24:52:957
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:25:00:968
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:25:00:972
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:25:08:983
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:25:08:987
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:25:16:998
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:25:17:002
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:25:25:013
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:25:25:018
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:25:33:028
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:25:33:034
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:25:41:045
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:25:41:049
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:25:49:060
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:25:49:065
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:25:57:076
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:25:57:082
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:26:05:093
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:26:05:097
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:26:13:108
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:26:13:112
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:26:21:123
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:26:21:127
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:26:29:138
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:26:29:142
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:26:37:153
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:26:37:158
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:26:45:168
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:26:45:173
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:26:53:183
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:26:53:188
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:27:01:199
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:27:01:203
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:27:09:214
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:27:09:218
Return opi parameter (TTIRPA)

<--- Received 361 bytes - Data packet  timestamp=28-OCT-2014 05:27:14:448
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
DELETE FROM PCSF_RUN_LOG WHERE RUNCONTEXT = :v0 AND INTEGRATIONSERVICE =:v1 AN
D REPOSITORYNAME = :v2 AND REPOSITORYDOMAIN = :v3 AND RUNID != :v4 AND ENTRYTI
ME < :v5

---> Send 53 bytes - Data packet  timestamp=28-OCT-2014 05:27:14:456
Return opi parameter (TTIRPA)

<--- Received 712 bytes - Data packet  timestamp=28-OCT-2014 05:27:14:456
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  2
 Parse
INSERT INTO PCSF_RUN_LOG (ABSOLUTEFILENAME, NODENAME, INTEGRATIONSERVICE, REPO
SITORYDOMAIN, REPOSITORYNAME, FOLDER, WORKFLOW, SESSIONPATH, RUNCONTEXT, RUNID
, ENTRYTIME, OSUSER, RUNINSTANCENAME) VALUES (:v0, :v1, :v2, :v3, :v4, :v5, :v
6, :v7, :v8, :v9, :v10, :v11, :v12)

---> Send 55 bytes - Data packet  timestamp=28-OCT-2014 05:27:14:459
Return opi parameter (TTIRPA)

<--- Received 365 bytes - Data packet  timestamp=28-OCT-2014 05:27:17:139
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  2
 Parse
DELETE FROM PCSF_RUN_LOG WHERE RUNCONTEXT = :v0 AND INTEGRATIONSERVICE =:v1 AN
D REPOSITORYNAME = :v2 AND REPOSITORYDOMAIN = :v3 AND RUNID != :v4 AND ENTRYTI
ME < :v5

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:27:17:148
Return opi parameter (TTIRPA)

<--- Received 769 bytes - Data packet  timestamp=28-OCT-2014 05:27:17:148
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
INSERT INTO PCSF_RUN_LOG (ABSOLUTEFILENAME, NODENAME, INTEGRATIONSERVICE, REPO
SITORYDOMAIN, REPOSITORYNAME, FOLDER, WORKFLOW, SESSIONPATH, RUNCONTEXT, RUNID
, ENTRYTIME, OSUSER, RUNINSTANCENAME) VALUES (:v0, :v1, :v2, :v3, :v4, :v5, :v
6, :v7, :v8, :v9, :v10, :v11, :v12)

---> Send 55 bytes - Data packet  timestamp=28-OCT-2014 05:27:17:151
Return opi parameter (TTIRPA)

<--- Received 371 bytes - Data packet  timestamp=28-OCT-2014 05:27:17:169
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
DELETE FROM PCSF_RUN_LOG WHERE RUNCONTEXT = :v0 AND INTEGRATIONSERVICE =:v1 AN
D REPOSITORYNAME = :v2 AND REPOSITORYDOMAIN = :v3 AND RUNID != :v4 AND ENTRYTI
ME < :v5

---> Send 55 bytes - Data packet  timestamp=28-OCT-2014 05:27:17:173
Return opi parameter (TTIRPA)

<--- Received 789 bytes - Data packet  timestamp=28-OCT-2014 05:27:17:174
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  2
 Parse
INSERT INTO PCSF_RUN_LOG (ABSOLUTEFILENAME, NODENAME, INTEGRATIONSERVICE, REPO
SITORYDOMAIN, REPOSITORYNAME, FOLDER, WORKFLOW, SESSIONPATH, RUNCONTEXT, RUNID
, ENTRYTIME, OSUSER, RUNINSTANCENAME) VALUES (:v0, :v1, :v2, :v3, :v4, :v5, :v
6, :v7, :v8, :v9, :v10, :v11, :v12)

---> Send 55 bytes - Data packet  timestamp=28-OCT-2014 05:27:17:176
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:27:17:228
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  2
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:27:17:233
Return opi parameter (TTIRPA)

<--- Received 372 bytes - Data packet  timestamp=28-OCT-2014 05:30:44:327
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  2
 Parse
DELETE FROM PCSF_RUN_LOG WHERE RUNCONTEXT = :v0 AND INTEGRATIONSERVICE =:v1 AN
D REPOSITORYNAME = :v2 AND REPOSITORYDOMAIN = :v3 AND RUNID != :v4 AND ENTRYTI
ME < :v5

---> Send 53 bytes - Data packet  timestamp=28-OCT-2014 05:30:44:328
Return opi parameter (TTIRPA)

<--- Received 806 bytes - Data packet  timestamp=28-OCT-2014 05:30:44:328
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
INSERT INTO PCSF_RUN_LOG (ABSOLUTEFILENAME, NODENAME, INTEGRATIONSERVICE, REPO
SITORYDOMAIN, REPOSITORYNAME, FOLDER, WORKFLOW, SESSIONPATH, RUNCONTEXT, RUNID
, ENTRYTIME, OSUSER, RUNINSTANCENAME) VALUES (:v0, :v1, :v2, :v3, :v4, :v5, :v
6, :v7, :v8, :v9, :v10, :v11, :v12)

---> Send 55 bytes - Data packet  timestamp=28-OCT-2014 05:30:44:332
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:30:45:629
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:30:45:635
Return opi parameter (TTIRPA)

<--- Received 372 bytes - Data packet  timestamp=28-OCT-2014 05:30:46:279
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
DELETE FROM PCSF_RUN_LOG WHERE RUNCONTEXT = :v0 AND INTEGRATIONSERVICE =:v1 AN
D REPOSITORYNAME = :v2 AND REPOSITORYDOMAIN = :v3 AND RUNID != :v4 AND ENTRYTI
ME < :v5

---> Send 53 bytes - Data packet  timestamp=28-OCT-2014 05:30:46:280
Return opi parameter (TTIRPA)

<--- Received 797 bytes - Data packet  timestamp=28-OCT-2014 05:30:46:281
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  2
 Parse
INSERT INTO PCSF_RUN_LOG (ABSOLUTEFILENAME, NODENAME, INTEGRATIONSERVICE, REPO
SITORYDOMAIN, REPOSITORYNAME, FOLDER, WORKFLOW, SESSIONPATH, RUNCONTEXT, RUNID
, ENTRYTIME, OSUSER, RUNINSTANCENAME) VALUES (:v0, :v1, :v2, :v3, :v4, :v5, :v
6, :v7, :v8, :v9, :v10, :v11, :v12)

---> Send 55 bytes - Data packet  timestamp=28-OCT-2014 05:30:46:284
Return opi parameter (TTIRPA)

<--- Received 372 bytes - Data packet  timestamp=28-OCT-2014 05:30:48:274
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  2
 Parse
DELETE FROM PCSF_RUN_LOG WHERE RUNCONTEXT = :v0 AND INTEGRATIONSERVICE =:v1 AN
D REPOSITORYNAME = :v2 AND REPOSITORYDOMAIN = :v3 AND RUNID != :v4 AND ENTRYTI
ME < :v5

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:30:48:276
Return opi parameter (TTIRPA)

<--- Received 816 bytes - Data packet  timestamp=28-OCT-2014 05:30:48:276
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
INSERT INTO PCSF_RUN_LOG (ABSOLUTEFILENAME, NODENAME, INTEGRATIONSERVICE, REPO
SITORYDOMAIN, REPOSITORYNAME, FOLDER, WORKFLOW, SESSIONPATH, RUNCONTEXT, RUNID
, ENTRYTIME, OSUSER, RUNINSTANCENAME) VALUES (:v0, :v1, :v2, :v3, :v4, :v5, :v
6, :v7, :v8, :v9, :v10, :v11, :v12)

---> Send 55 bytes - Data packet  timestamp=28-OCT-2014 05:30:48:278
Return opi parameter (TTIRPA)

<--- Received 372 bytes - Data packet  timestamp=28-OCT-2014 05:30:50:249
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
DELETE FROM PCSF_RUN_LOG WHERE RUNCONTEXT = :v0 AND INTEGRATIONSERVICE =:v1 AN
D REPOSITORYNAME = :v2 AND REPOSITORYDOMAIN = :v3 AND RUNID != :v4 AND ENTRYTI
ME < :v5

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:30:50:250
Return opi parameter (TTIRPA)

<--- Received 793 bytes - Data packet  timestamp=28-OCT-2014 05:30:50:251
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  2
 Parse
INSERT INTO PCSF_RUN_LOG (ABSOLUTEFILENAME, NODENAME, INTEGRATIONSERVICE, REPO
SITORYDOMAIN, REPOSITORYNAME, FOLDER, WORKFLOW, SESSIONPATH, RUNCONTEXT, RUNID
, ENTRYTIME, OSUSER, RUNINSTANCENAME) VALUES (:v0, :v1, :v2, :v3, :v4, :v5, :v
6, :v7, :v8, :v9, :v10, :v11, :v12)

---> Send 55 bytes - Data packet  timestamp=28-OCT-2014 05:30:50:258
Return opi parameter (TTIRPA)

<--- Received 372 bytes - Data packet  timestamp=28-OCT-2014 05:30:52:245
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  2
 Parse
DELETE FROM PCSF_RUN_LOG WHERE RUNCONTEXT = :v0 AND INTEGRATIONSERVICE =:v1 AN
D REPOSITORYNAME = :v2 AND REPOSITORYDOMAIN = :v3 AND RUNID != :v4 AND ENTRYTI
ME < :v5

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:30:52:246
Return opi parameter (TTIRPA)

<--- Received 806 bytes - Data packet  timestamp=28-OCT-2014 05:30:52:246
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
INSERT INTO PCSF_RUN_LOG (ABSOLUTEFILENAME, NODENAME, INTEGRATIONSERVICE, REPO
SITORYDOMAIN, REPOSITORYNAME, FOLDER, WORKFLOW, SESSIONPATH, RUNCONTEXT, RUNID
, ENTRYTIME, OSUSER, RUNINSTANCENAME) VALUES (:v0, :v1, :v2, :v3, :v4, :v5, :v
6, :v7, :v8, :v9, :v10, :v11, :v12)

---> Send 55 bytes - Data packet  timestamp=28-OCT-2014 05:30:52:249
Return opi parameter (TTIRPA)

<--- Received 273 bytes - Data packet  timestamp=28-OCT-2014 05:30:53:645
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
UPDATE PCSF_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0, ELECTION_STATUS = :v1
 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3

---> Send 54 bytes - Data packet  timestamp=28-OCT-2014 05:30:53:649
Return opi parameter (TTIRPA)

<--- Received 372 bytes - Data packet  timestamp=28-OCT-2014 05:30:55:146
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  3
 Parse
DELETE FROM PCSF_RUN_LOG WHERE RUNCONTEXT = :v0 AND INTEGRATIONSERVICE =:v1 AN
D REPOSITORYNAME = :v2 AND REPOSITORYDOMAIN = :v3 AND RUNID != :v4 AND ENTRYTI
ME < :v5

---> Send 53 bytes - Data packet  timestamp=28-OCT-2014 05:30:55:147
Return opi parameter (TTIRPA)

<--- Received 808 bytes - Data packet  timestamp=28-OCT-2014 05:30:55:148
Start of user function (TTIFUN)
        Fast upi calls to opial7 (OALL7) Cursor #  2
 Parse
INSERT INTO PCSF_RUN_LOG (ABSOLUTEFILENAME, NODENAME, INTEGRATIONSERVICE, REPO
SITORYDOMAIN, REPOSITORYNAME, FOLDER, WORKFLOW, SESSIONPATH, RUNCONTEXT, RUNID
, ENTRYTIME, OSUSER, RUNINSTANCENAME) VALUES (:v0, :v1, :v2, :v3, :v4, :v5, :v
6, :v7, :v8, :v9, :v10, :v11, :v12)

---> Send 55 bytes - Data packet  timestamp=28-OCT-2014 05:30:55:151
Return opi parameter (TTIRPA)

<--- Received 15 bytes - Data packet  timestamp=28-OCT-2014 05:33:16:939
Start of user function (TTIFUN)
        Close cursor (OCLOSE) Cursor # 2

---> Send 13 bytes - Data packet  timestamp=28-OCT-2014 05:33:16:940
V6 Oracle func complete (TTISTA)
        Succeeded

<--- Received 15 bytes - Data packet  timestamp=28-OCT-2014 05:33:16:940
Start of user function (TTIFUN)
        Close cursor (OCLOSE) Cursor # 3

---> Send 13 bytes - Data packet  timestamp=28-OCT-2014 05:33:16:941
V6 Oracle func complete (TTISTA)
        Succeeded

<--- Received 13 bytes - Data packet  timestamp=28-OCT-2014 05:33:16:941
Start of user function (TTIFUN)
        Logoff off of Oracle (OLOGOFF)
        MAXIMUM OPEN CURSORS: 2
        CURSORS NOT CLOSED: 0


---> Send 12 bytes - Data packet  timestamp=28-OCT-2014 05:33:16:942
V6 Oracle func complete (TTISTA)
        Succeeded

///////////////////////////////////////////////////////////////
Error found. Error Stack follows:
              id:0
  Operation code:68
      NS Error 1:12537
      NS Error 2:12560
NT Generic Error:507
  Protocol Error:0
        OS Error:0
 NS & NT Errors Translation
12537, 00000 "TNS:connection closed"
 // *Cause: "End of file" condition has been reached; partner has disconnected.
 // *Action: None needed; this is an information message.
/
12560, 00000 "TNS:protocol adapter error"
 // *Cause: A generic protocol adapter error occurred.
 // *Action: Check addresses used for proper protocol specification. Before
 // reporting this error, look at the error stack and check for lower level
 // transport errors.For further details, turn on tracing and reexecute the
 // operation. Turn off tracing when the operation is complete.
/
00507, 00000 "Connection closed"
 // *Cause: Normal "end of file" condition has been reached; partner has
 // disconnected.
 // *Action: None needed; this is an information message.
/
///////////////////////////////////////////////////////////////


----------------------
Trace File Statistics:
----------------------
Start Timestamp : 28-OCT-2014 05:20:02:331
End Timestamp   : 28-OCT-2014 05:33:16:942
Total number of Sessions: 1

DATABASE:
  Operation Count:    2 OPENS,    86 PARSES,    86 EXECUTES,     3 FETCHES
    Parse Counts:
       0 PL/SQL,     3 SELECT,     12 INSERT,    57 UPDATE,    12 DELETE,
       0 LOCK,       0 TRANSACT,    2 DEFINE,     0 SECURE,     0 OTHER
    Execute counts with SQL data:
       0 PL/SQL,     3 SELECT,     12 INSERT,    57 UPDATE,    12 DELETE,
       0 LOCK,       0 TRANSACT,    2 DEFINE,     0 SECURE,     0 OTHER

    Operation Ratio: 43.0 PARSES per OPEN,  1.0 EXECUTES per PARSE

  Packet Ratio: 1.1511627906976745 packets sent per operation
  Currently opened Cursors: 0
  Maximum opened Cursors  : 2

ORACLE NET SERVICES:
  Total Calls  :        99 sent,         99 received,          96 oci
  Total Bytes  :      7981 sent,      31395 received
    Average Bytes:        80 sent per packet,        317 received per packet
    Maximum Bytes:      1197 sent,        816 received

  Grand Total Packets:     99  sent,      99 received


    *************************************************************************
    *                    Trace Assistant has completed                      *
    *************************************************************************