root@rac12cnode1 oracle]# java -version
java version "1.4.2"
gij (GNU libgcj) version 4.1.2 20071124 (Red Hat 4.1.2-42)

Copyright (C) 2006 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.  There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
[root@rac12cnode1 oracle]# java -version

rpm -ivh jdk-8u144-linux-x64.rpm

oracle@rac12cnode1 ~]$ java -version
java version "1.8.0_45"
Java(TM) SE Runtime Environment (build 1.8.0_45-b14)
Java HotSpot(TM) 64-Bit Server VM (build 25.45-b02, mixed mode)
[oracle@rac12cnode1 ~]$ 
********************************************************************************************************************
root@rac12cnode1 Desktop]# rpm -ivh jdk-8u144-linux-x64.rpm 
Preparing...                
########################################### [100%]
   1:jdk1.8.0_45            ########################################### [100%]
Unpacking JAR files...
        rt.jar...
        jsse.jar...
        charsets.jar...
        tools.jar...
        localedata.jar...
        jfxrt.jar...
        plugin.jar...
        javaws.jar...
        deploy.jar...
[root@rac12cnode1 Desktop]# 


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


vi Ambasa_AC_Test.java

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import oracle.jdbc.replay.OracleDataSourceImpl;

public class Ambasa_AC_Test {
    private void pressAnyKeyToContinue()
    {
        System.out.print("Press any key to continue...");
        try { System.in.read(); }
        catch(Exception e) { e.printStackTrace(); }
    }

    public String getInstanceName(Connection conn) throws SQLException {
        PreparedStatement pstmt = conn.prepareStatement("select instance_name from v$instance");
        String r=new String();
        ResultSet result = pstmt.executeQuery();

        while (result.next()){
            r=result.getString("instance_name");
        }
        pstmt.close();
        return r;
    }


    public String getStatValue(Connection conn, String statName) throws SQLException {
        String q="select value "+
                 "from v$statname sn, v$sesstat ss "+
                 "where sn.statistic#=ss.statistic# "+
                 "and sn.name=? and "+
                 "ss.sid=SYS_CONTEXT('USERENV','SID')";
        String r=null;

        PreparedStatement pstmt = conn.prepareStatement(q);
        pstmt.setString(1,statName);
        ResultSet rs = pstmt.executeQuery();
        while (rs.next()){
            r=rs.getString("value");
        }
        pstmt.close();
        return r;
    }

    private void doTx(Connection c, int numValue) throws SQLException {
        String updsql = "UPDATE ambasa_ac_test " +
                        "SET C2='BBBBB' " +
                        "WHERE C1=?";
        PreparedStatement pstmt = null;

        /* Beginning of the callback
         * AutoCommit has to be disabled in the callback part.
         */
        ((oracle.jdbc.replay.ReplayableConnection)c).beginRequest();
        pstmt=c.prepareStatement(updsql);
        c.setAutoCommit(false);
        for (int i=0;i<numValue;i++) {
            pstmt.setInt(1,i);
            pstmt.executeUpdate();
        }
        c.commit();
        // End of the Callback.
        ((oracle.jdbc.replay.ReplayableConnection)c).endRequest();
        pstmt.close();
    }


    public static void main(String args[]) throws SQLException {
         Connection conn = null;
         int numValue = Integer.parseInt(args[0]);
         int stat_before=0;
         int stat_after=0;
         String statname="CPU used by this session";

         try {
              // Here we have to use OracleDataSourceImpl in remplacement of OracleDataSource.
                 OracleDataSourceImpl ocpds = new OracleDataSourceImpl();
              ocpds.setURL("jdbc:oracle:thin:@oralab82-scan.ambasa.com:1521/crm");
              ocpds.setUser("ambasa");
              ocpds.setPassword("asl");

                  Ambasa_AC_Test self = new Ambasa_AC_Test();

              // Get a connection from the data source and prepare the statement
              conn = ocpds.getConnection();

              //Get instance name the program is connected to
              System.out.println("Instance Name = "+self.getInstanceName(conn));
              self.pressAnyKeyToContinue();

              stat_before=Integer.parseInt(self.getStatValue(conn,statname));
              System.out.println("Performing transactions");
              self.doTx(conn,numValue);
              stat_after=Integer.parseInt(self.getStatValue(conn,statname));

              System.out.println("Instance Name = "+self.getInstanceName(conn));
              System.out.println(statname+" = "+(int)(stat_after-stat_before));
              System.out.println("session pga memory max = "+self.getStatValue(conn,"session pga memory max"));
              conn.close();
         } catch (Exception e) {
              e.printStackTrace();
        }

    }
}


ls -l /u01/app/oracle/product/12.1.0/dbhome_1/jdbc/lib/ojdbc7.jar
ls -l /u01/app/oracle/product/12.1.0/dbhome_1/ucp/lib/ucp.jar
export CLASSPATH=/u01/app/oracle/product/12.1.0/dbhome_1/jdbc/lib/ojdbc7.jar:/u01/app/oracle/product/12.1.0/dbhome_1/ucp/lib/ucp.jar

javac Ambasa_AC_Test.java

srvctl add service -d cdb -s crm -preferred cdb1 -available cdb2 -pdb CDB1_AMBASAPDB -m basic -e TRANSACTION -z 30 -w 10
-commit_outcome TRUE  -replay_init_time 1800 -retention 86400 -notification TRUE

srvctl status service -d cdb -s crm -v

srvctl start service -d cdb -s crm

srvctl status service -d cdb -s crm -v

[oracle@racnode1 ambsa]$ cat /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/tnsnames.ora

[oracle@racnode1 ambasa]$ cat /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/tnsnames.ora
# tnsnames.ora.racnode1 Network Configuration File: /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/tnsnames.ora.racnode1
# Generated by Oracle configuration tools.

CDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oralab82-scan.ambasa.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = cdb)
    )
  )

CDB1_AMBASAPDB=
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oralab82-scan.ambasa.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = CDB1_AMBASAPDB)
    )
  )

CDB1_AMBASAPDB_s2=
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oralab82-scan.ambasa.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = CDB1_AMBASAPDB_s2)
    )
  )

crm=
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oralab82-scan.ambasa.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = crm)
    )
  )


sqlplus sys/sys@CDB1_AMBASAPDB as sysdba

create user ambasa identified by asl;
grant sysdba,dba to ambasa;
sqlplus ambasa/asl@crm

show parameter instance_name

drop table ambasa_ac_test purge;

create table ambasa_ac_test (C1 number, C2 varchar2(10));

begin
for i in 1.. 10000 loop insert into ambasa_ac_test values (i,'AAAAAA'); end loop;commit; end;
/

select count(*) from ambasa_ac_test;

drop table ambasa_ac_test_count purge;

create table ambasa_ac_test_count (edate date, inst_name varchar2(10),C1 number);

select inst_name,count(*) from ambasa_ac_test_count group by inst_name;

create or replace trigger ambasa_ac_test_count_trigger
before update on ambasa_ac_test for each row
declare
 pragma autonomous_transaction;
begin
 insert into ambasa_ac_test_count values(sysdate,sys_context('USERENV', 'INSTANCE_NAME'),:old.C1);
commit;
end;
/


vi Start_Ambasa_AC_Test.sh

java -classpath .:/u01/app/oracle/product/12.1.0/dbhome_1/ucp/lib/ucp.jar:/u01/app/oracle/product/12.1.0/dbhome_1/jdbc/lib/ojdbc7.jar Ambasa_AC_Test 10000

:wq! 

cat Start_Ambasa_AC_Test.sh

[oracle@racnode1 ambasa]$ cat Start_Ambasa_AC_Test.sh
java -classpath .:/u01/app/oracle/product/12.1.0/dbhome_1/ucp/lib/ucp.jar:/u01/app/oracle/product/12.1.0/dbhome_1/jdbc/lib/ojdbc7.jar Ambasa_AC_Test 10000
[oracle@racnode1 ambasa]$ pwd


ls -l Start_Ambasa_AC_Test.sh

chmod +x Start_Ambasa_AC_Test.sh

ls -l Start_Ambasa_AC_Test.sh

sqlplus ambasa/asl@crm

show parameter instance_name

select inst_name,count(*) from ambasa_ac_test_count group by inst_name;

sh Start_Ambasa_AC_Test.sh

select inst_name,count(*) from ambasa_ac_test_count group by inst_name;

ps -ef |grep pmon

srvctl status service -db cdb -v

*******************Do not do it in production/Realtime*****************
**********KILL Any Mandatory Background Process like PMON**************
*******************Do not do it in production/Realtime*****************

kill -9 PMON_PID

select inst_name,count(*) from ambasa_ac_test_count group by inst_name;

srvctl status service -d cdb -s crm -v

SQL> show parameter instance_name





srvctl add service -d cdb -s crm -preferred cdb1 -available cdb2 -pdb CDB1_AMBASAPDB -j SHORT -B SERVICE_TIME -z 30 -w 10 -commit_outcome TRUE -m basic -e TRANSACTION -replay_init_time 1800 -retention 86400 -notification TRUE


srvctl status service -d cdb -s crm -v

srvctl start service -d cdb -s crm

srvctl status service -d cdb -s crm -v

srvctl relocate service -db <db_unique_name> -service <service_name> {-oldinst <old_inst_name> -newinst <new_inst_name>
srvctl relocate service -db cdb -service crm -oldinst cdb2 -newinst cdb1
srvctl status service -d cdb -s crm -v


[oracle@racnode1 ambasa]$ sh Start_Ambasa_AC_Test.sh
Instance Name = cdb1
Press any key to continue...
Performing transactions
Instance Name = cdb2
CPU used by this session = 937
session pga memory max = 2584888
[oracle@racnode1 ambasa]$