Blog for open world

Oracle data all table keyword search.

2014-08-18T05:55:00.002-07:00

SET SERVEROUTPUT ON SIZE 100000;

DECLARE
match_count INTEGER;
-- Type the owner of the tables you are looking at
v_owner VARCHAR2(255) :='SCOTT';

-- Type the data type you are look at (in CAPITAL) VARCHAR2, NUMBER, etc.
v_data_type VARCHAR2(255) :='VARCHAR2';

-- Type the string you are looking at
v_search_string VARCHAR2(4000) :='%RCT2011030328%';

BEGIN
FOR t IN (SELECT table_name, column_name FROM all_tab_cols where owner=v_owner and data_type = v_data_type) LOOP

    EXECUTE IMMEDIATE
    'SELECT COUNT(*) FROM '||t.table_name||' WHERE lower('||t.column_name||') like :1'
    INTO match_count
    USING v_search_string;

    IF match_count > 0 THEN
      --dbms_output.put_line( t.table_name ||' '||t.column_name||' '||match_count );
INSERT INTO
    XSTOCKS.trn_cds_checkdatastring a ( a.str_cds_place)
    VALUES (t.table_name ||' '||t.column_name||' '||match_count);

    END IF;

END LOOP;
END;

Oracle Long operation monitoring

2014-07-11T03:45:00.000-07:00

Lock session

select v$session.username,
           v$lock.sid,
               id1, id2,
           lmode,
               request, block, v$lock.type , v$session.osuser , v$session.machine , v$session.process , v$process.pid
    from v$lock, v$session , v$process
    where v$lock.sid = v$session.sid
    and v$lock.type = 'TX'
    and v$process.addr = v$session.paddr
order by username

active long operation

select username||'('||sid||','||serial#||') ospid = '|| process ||
    ' program = ' || program username,
    to_char(LOGON_TIME,' Day HH24:MI') logon_time,
    to_char(sysdate,' Day HH24:MI') current_time,
    sql_address,
    sql_hash_value , a.osuser ,a.machine ,a.last_call_et
   from v$session a
   where status = 'ACTIVE'
   and rawtohex(sql_address) <> '00'
   and username is not null
   order by last_call_et desc

Long opseration details

select distinct x.sid , a.machine , x.opname , a.program , x.target , x.sofar ,x.totalwork , x.start_time , x.last_update_time ,x.time_remaining , x.elapsed_seconds , context , message,
           sql_text
from v$session_longops x , gv$sqlarea y , v$session a
where x.username = 'SYS'
and x.sql_hash_value = y.HASH_VALUE
and a.sid = x.sid
and a.status = 'ACTIVE'
order by TIME_REMAINING desc

oracle dbms schedulers

2014-07-11T03:42:00.001-07:00

BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'TEST_SHEDULE',
job_type => 'STORED_PROCEDURE',
job_action => 'DPG.SP_SHEDULE_TEST',
start_date => to_date('26/05/2011 13:38:00' , 'DD/MM/RRRR HH24:MI:SS' ),
repeat_interval => 'FREQ=MINUTELY;INTERVAL=2;',
comments => 'My new job');
END;
/
DECLARE
BEGIN
DBMS_SCHEDULER.ENABLE('TEST_SHEDULE');
END;
-------------------------------------------------------------
EXEC dbms_scheduler.run_job('TEST_SHEDULE');
-------------------------------------------------------------
EXEC DBMS_SCHEDULER.DROP_JOB('my_java_job');
-------------------------------------------------------------
SELECT * FROM dba_scheduler_jobs where job_creator = 'DPG' order by job_name

How to create a yum repository on RHEL/CentOS 5.x with CD/DVD or ISO images

2014-07-11T03:38:00.001-07:00

Mount your CD/DVD or ISO images

DVD Disk or DVD ISO image

If you have DVD disk, please mount dvd-rom first, and then create yum repository:

# mkdir /mnt/dvd/
# mount /dev/cdrom /mnt/dvd/

If you use DVD iso, please copy it to the system, and then create yum repository:

# mkdir /mnt/dvd/
# mount -o loop /root/rhel5.1-dvd.iso /mnt/dvd

CD images

If you have multiple CD image files, you should mount all iso images and then create yum repository.

Mount all iso images:

# mkdir -p /mnt/{1,2,3,4,5}
# mount -o loop rhel5.1-disc1.iso /mnt/1
# mount -o loop rhel5.1-disc2.iso /mnt/2
# mount -o loop rhel5.1-disc3.iso /mnt/3
# mount -o loop rhel5.1-disc4.iso /mnt/4
# mount -o loop rhel5.1-disc5.iso /mnt/5

Install necessary package

Find and install 'createrepo' package in /mnt directory:

# find /mnt -iname 'createrepo*'
/mnt/dvd/Server/createrepo-0.4.11-3.el5.noarch.rpm

# rpm -ivh /mnt/dvd/Server/createrepo-0.4.11-3.el5.noarch.rpm

Create yum repository

Create metadata

Create yum repository:

# cd /mnt/
# createrepo .

Define yum repository

Create yum repository define file /etc/yum.repos.d/dvdiso.repo:

[MailRepo]
name=MailRepo
baseurl=file:///mnt/
enabled=1
gpgcheck=0

Test it

# yum clean all
# yum list

If 'yum list' list all packages in DVD/CD disks or ISO images, it works. :)

Send Email using mysql trigger

2014-04-08T21:50:00.000-07:00

CREATE TRIGGER dbo.whatever ON dbo.wherever
FOR INSERT AS BEGIN SET NOCOUNT ON;

IF EXISTS (SELECT 1 FROM inserted WHERE speed > 100) BEGIN EXEC msdb.dbo.sp_send_dbmail @to = 'whoever@yourcompany.com',
                                            @profile_name = 'default',
                                            @subject = 'Someone was speeding',
                                            @body = 'Yep, they sure were.';
END END GO

Java ArrayList Example

2013-09-15T03:54:00.000-07:00

import java.util.ArrayList;

public class ArrayListDemo {
   public static void main(String[] args) {
      
      // create an empty array list with an initial capacity
      ArrayList<Integer> arrlist = new ArrayList<Integer<(8);

      // use add() method to add elements in the list
      arrlist.add(20);
      arrlist.add(25);
      arrlist.add(10);
      arrlist.add(15);        
       
      // let us print all the elements available in list
      for (Integer number : arrlist) {
         System.out.println("Number = " + number);
       }

      // list contains element 10
      boolean retval = arrlist.contains(10); 
   
      if (retval == true) {
        System.out.println("element 10 is contained in the list");
       }
      else {
        System.out.println("element 10 is not contained in the list");
       }
  
      // list does not contain element 30
      boolean retval2 = arrlist.contains(30);
   
      if (retval2 == true) {
        System.out.println("element 30 is contained in the list");
       }
      else {
        System.out.println("element 30 is not contained in the list");    
       }
   }
}

Let us compile and run the above program, this will produce the following result:

Number = 20
Number = 25
Number = 10
Number = 15
element 10 is contained in the list
element 30 is not contained in the list

send e-mail configuration using Access list to Network Services in Oracle Database 11g

2013-09-13T12:58:00.000-07:00

•acl - The name of the access control list XML file, generated relative to the "/sys/acls" directory in the XML DB Repository.
•description - A description of the ACL.
•principal - The first user account or role being granted or denied permissions. The text is case sensitive.
•is_grant - TRUE to grant, FALSE to deny the privilege.
•privilege - Use 'connect' for UTL_TCP, UTL_SMTP, UTL_MAIL and UTL_HTTP access. Use 'resolve' for UTL_INADDR name/IP resolution. The text is case sensitive.
•start_date - Default value NULL. When specified, the ACL will only be active on or after the specified date.
•end_date - An optional end date for the ACL.

CONN sys/password@db11g AS SYSDBA

CREATE USER test1 IDENTIFIED BY test1;
GRANT CONNECT TO test1;

CREATE USER test2 IDENTIFIED BY test2;
GRANT CONNECT TO test2;

BEGIN
DBMS_NETWORK_ACL_ADMIN.create_acl (
    acl          => 'test_acl_file.xml',
    description => 'A test of the ACL functionality',
    principal    => 'TEST1',
    is_grant     => TRUE,
    privilege    => 'connect',
    start_date   => SYSTIMESTAMP,
    end_date     => NULL);

COMMIT;
END;
/

BEGIN
DBMS_NETWORK_ACL_ADMIN.add_privilege (
    acl         => 'test_acl_file.xml',
    principal   => 'TEST2',
    is_grant    => FALSE,
    privilege   => 'connect',
    position    => NULL,
    start_date => NULL,
    end_date    => NULL);

COMMIT;
END;
/

BEGIN
DBMS_NETWORK_ACL_ADMIN.delete_privilege (
    acl         => 'test_acl_file.xml',
    principal   => 'TEST2',
    is_grant    => FALSE,
    privilege   => 'connect');

COMMIT;
END;
/

BEGIN
DBMS_NETWORK_ACL_ADMIN.drop_acl (
    acl         => 'test_acl_file.xml');

COMMIT;
END;
/

•acl - The name of the access control list XML file.
•host - The hostname, domain, IP address or subnet to be assigned. Hostnames are case sensitive, and wildcards are allowed for IP addresses and domains.
•lower_port - Defaults to NULL. Specifies the lower port range for the 'connect' privilege.
•upper_port - Defaults to NULL. If the lower_port is specified, and the upper_port is NULL, it is assumed the upper_port matches the lower_port.

BEGIN
DBMS_NETWORK_ACL_ADMIN.assign_acl (
    acl         => 'test_acl_file.xml',
    host        => '192.168.2.3',
    lower_port => 80,
    upper_port => NULL);

DBMS_NETWORK_ACL_ADMIN.assign_acl (
    acl         => 'test_acl_file.xml',
    host        => '10.1.10.*',
    lower_port => NULL,
    upper_port => NULL);

COMMIT;
END;
/

NetBeans: java.lang.ClassNotFoundException

2013-09-11T19:13:00.001-07:00

Find the class that error occurs and do some frontend adjustment. then compile again. apply to netbeans 7.3.

Mysql access denied for user 'root'@'localhost' (using password yes)

2013-09-05T12:34:00.001-07:00

Mysql Upgrade upgrade and bugfix

2013-08-30T21:33:00.003-07:00

After upgrading MySQL from version 5.0 to 5.5 I started getting the following message trying to edit table structure in Navicat:

Cannot load from mysql.proc.
The table is probably corrupted Luckily there is an easy fix.

Run the following command from the command prompt (on Windows you might need to run it from MySQL's bin directory).

mysql_upgrade

In some cases you will need specify

mysql root password and --force option (if you run upgrade procedure already).

mysql_upgrade -u root -p --force

Complete remove Mysql

2013-08-29T11:50:00.001-07:00

sudo apt-get remove mysql-server mysql-client mysql-common
sudo apt-get purge mysql-server mysql-client mysql-common
sudo apt-get autoremove

locate mysql (get lla location where install mysql and delete)

java resultset insert, update and delete

2013-08-24T01:20:00.003-07:00

//STEP 1. Import required packages
import java.sql.*;

public class JDBCExample {
   // JDBC driver name and database URL
   static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";  
   static final String DB_URL = "jdbc:mysql://localhost/EMP";

   //  Database credentials
   static final String USER = "username";
   static final String PASS = "password";
   
 public static void main(String[] args) {
   Connection conn = null;
   try{
      //STEP 2: Register JDBC driver
      Class.forName("com.mysql.jdbc.Driver");

      //STEP 3: Open a connection
      System.out.println("Connecting to database...");
      conn = DriverManager.getConnection(DB_URL,USER,PASS);

      //STEP 4: Execute a query to create statment with
      // required arguments for RS example.
      System.out.println("Creating statement...");
      Statement stmt = conn.createStatement(
                           ResultSet.TYPE_SCROLL_INSENSITIVE,
                           ResultSet.CONCUR_UPDATABLE);
     //STEP 5: Execute a query
      String sql = "SELECT id, first, last, age FROM Employees";
      ResultSet rs = stmt.executeQuery(sql);

      System.out.println("List result set for reference....");
      printRs(rs);

      //STEP 6: Loop through result set and add 5 in age
      //Move to BFR postion so while-loop works properly
      rs.beforeFirst();
      //STEP 7: Extract data from result set
      while(rs.next()){
         //Retrieve by column name
         int newAge = rs.getInt("age") + 5;
         rs.updateDouble( "age", newAge );
         rs.updateRow();
      }
      System.out.println("List result set showing new ages...");
      printRs(rs);
      // Insert a record into the table.
      //Move to insert row and add column data with updateXXX()
      System.out.println("Inserting a new record...");
      rs.moveToInsertRow();
      rs.updateInt("id",104);
      rs.updateString("first","John");
      rs.updateString("last","Paul");
      rs.updateInt("age",40);
      //Commit row
      rs.insertRow();

      System.out.println("List result set showing new set...");
      printRs(rs);
      
      // Delete second record from the table.
      // Set position to second record first
      rs.absolute( 2 );
      System.out.println("List the record before deleting...");
      //Retrieve by column name
      int id  = rs.getInt("id");
      int age = rs.getInt("age");
      String first = rs.getString("first");
      String last = rs.getString("last");

      //Display values
      System.out.print("ID: " + id);
      System.out.print(", Age: " + age);
      System.out.print(", First: " + first);
      System.out.println(", Last: " + last);

     //Delete row
      rs.deleteRow();
      System.out.println("List result set after \
                                 deleting one records...");
      printRs(rs);

      //STEP 8: Clean-up environment
      rs.close();
      stmt.close();
      conn.close();
   }catch(SQLException se){
      //Handle errors for JDBC
      se.printStackTrace();
   }catch(Exception e){
      //Handle errors for Class.forName
      e.printStackTrace();
   }finally{
      //finally block used to close resources
      try{
         if(conn!=null)
            conn.close();
      }catch(SQLException se){
         se.printStackTrace();
      }//end finally try
   }//end try
   System.out.println("Goodbye!");
}//end main

   public static void printRs(ResultSet rs) throws SQLException{
      //Ensure we start with first row
      rs.beforeFirst();
      while(rs.next()){
         //Retrieve by column name
         int id  = rs.getInt("id");
         int age = rs.getInt("age");
         String first = rs.getString("first");
         String last = rs.getString("last");

         //Display values
         System.out.print("ID: " + id);
         System.out.print(", Age: " + age);
         System.out.print(", First: " + first);
         System.out.println(", Last: " + last);
     }
     System.out.println();
   }//end printRs()
}//end JDBCExample

CREATE OR REPLACE PROCEDURE GRANT_SELECT AS

2013-07-12T03:44:00.001-07:00

Alternative colour for java jtable

2013-07-01T10:33:00.001-07:00

jTblRefe = new javax.swing.JTable(){public Component prepareRenderer
    (TableCellRenderer renderer,int Index_row, int Index_col)
    {
        Component comp = super.prepareRenderer(renderer, Index_row, Index_col);
        //even index, selected or not selected

        if (Index_row % 2 == 0 ) {
            comp.setBackground(new java.awt.Color(230,212,212));
        }
        else
        {
            comp.setBackground(Color.white);
        }

        return comp;
    }

    public boolean isCellEditable(int row,int column){
        return false;
    };

}
;

Check java jar application is already running.

2013-07-01T09:45:00.000-07:00

ServerSocket ss;
try {
    ss = new ServerSocket(MY_PORT);
    // not already running.
} catch (BindException e) {
    // already running.
}

Steps.

1) open listning port.

2) check listning port alredy runnig.

Good luck.

java textbox + jformattedtextfield format

2013-05-30T08:12:00.001-07:00

MaskFormatter formatter = new MaskFormatter("*****");
jtxtSellingPrice.setFormatterFactory(new javax.swing.text.DefaultFormatterFactory(formatter));
formatter.setValidCharacters("1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ $#@!&*()");

Character	Description
#	Any valid number, uses `Character.isDigit`.
'	Escape character, used to escape any of the special formatting characters.
U	Any character (`Character.isLetter`). All lowercase letters are mapped to upper case.
L	Any character (`Character.isLetter`). All upper case letters are mapped to lower case.
A	Any character or number (`Character.isLetter` or `Character.isDigit`)
?	Any character (`Character.isLetter`).
*	Anything.
H	Any hex character (0-9, a-f or A-F).

How to search data in java jtable

2013-05-24T05:03:00.001-07:00

import javax.swing.JFrame;

import javax.swing.JScrollPane;

import javax.swing.JTable;

import javax.swing.RowFilter;

import javax.swing.table.DefaultTableModel;

import javax.swing.table.TableModel;

import javax.swing.table.TableRowSorter;



public class Main {

  public static void main(String[] args) {

    Object[][] data = { { "A", 5 }, { "B", 2 }, { "C", 4 }, { "D", 8 } };

    String columnNames[] = { "Item", "Value" };

    TableModel model = new DefaultTableModel(data, columnNames) {

      public Class getColumnClass(int column) {

        return getValueAt(0, column).getClass();

      }

    };

    JTable table = new JTable(model);



    RowFilternew RowFilter() {

      public boolean include(Entry entry) {

        Integer population = (Integer) entry.getValue(1);

        return population.intValue() > 3;

      }

    };



    TableRowSorter sorter = new TableRowSorter(model);

    sorter.setRowFilter(filter);

    table.setRowSorter(sorter);

    JScrollPane scrollPane = new JScrollPane(table);

    JFrame frame = new JFrame("Filtering Table");

    frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

    frame.add(scrollPane);

    frame.setSize(300, 200);

    frame.setVisible(true);

  }

}

refer http://www.java2s.com/Code/JavaAPI/javax.swing.table/DefaultRowSortersetRowFilterRowFiltersuperTableModelsuperIntegerfilter.htm

mycode

 TableRowSorter sorter = new TableRowSorter(dtm);
          
 RowFilter filter = RowFilter.regexFilter(jtxtSearch.getText().toString());
          
          sorter.setRowFilter(filter);
          
          jtblData.setRowSorter(sorter);

2013-02-12T09:24:00.002-08:00

Import data into Oracle8i or higher release database. import export compatibility matrix Which Export client to use when importing into an Oracle8i 8.1.7
           or a higher release target database
          (always use the Import client of the target database):

+-----------+--------------------------------------------------------------+
|  EXPORT   |                       IMPORT into:                           |
|   from    +--------+--------+--------+--------+--------+-----------------+
|    \/            8.1.7    |9.2.0     |10.1.0     |10.2.0    |11.1.0    |11.2.0   |        |
+-----------+--------+--------+--------+--------+--------+--------+--------+
|  5.x 1)2) | EXP5x   | EXP5x   | EXP5x   | EXP5x   | EXP5x   | EXP5x |        |
|  6.x    2) | EXP6x   | EXP6x   | EXP6x   | EXP6x   | EXP6x   | EXP6x |        |
|  7.x    3) | EXP7x   | EXP7x | EXP7x   | EXP7x   | EXP7x   | EXP7x |        |
+-----------+--------+--------+--------+--------+--------+--------+--------+
|  8.0.3      | EXP803 | EXP803 | EXP803 | EXP803 | EXP803 | EXP803 |        |
|  8.0.4      | EXP804 | EXP804 | EXP804 | EXP804 | EXP804 | EXP804 |        |
|  8.0.5      | EXP805 | EXP805 | EXP805 | EXP805 | EXP805 | EXP805 |        |
|  8.0.6      | EXP806 | EXP806 | EXP806 | EXP806 | EXP806 | EXP806 |        |
+-----------+--------+--------+--------+--------+--------+--------+--------+
|  8.1.5      | EXP815 | EXP815 | EXP815 | EXP815 | EXP815 | EXP815 |        |
|  8.1.6      | EXP816 | EXP816 | EXP816 | EXP816 | EXP816 | EXP816 |        |
|  8.1.7      | EXP817 | EXP817 | EXP817 | EXP817 | EXP817 | EXP817 |        |
+-----------+--------+--------+--------+--------+--------+--------+--------+
|  9.0.1      | EXP817 | EXP901 | EXP901 | EXP901 | EXP901 | EXP901 |        |
|  9.2.0      | EXP817 | EXP920 | EXP920 | EXP920 | EXP920 | EXP920 |        |
+-----------+--------+--------+--------+--------+--------+--------+--------+
| 10.1.0  4)| EXP817 | EXP920 |
| 10.2.0  4)|   N/S      | EXP920 |
+-----------+--------+--------+--------+--------+--------+--------+--------+
| 11.1.0  4)|   N/S      | EXP920*|
| 11.2.0 4)|   N/S      | EXP920*|
+-----------+--------+--------+--------+--------+--------+--------+--------+
Remarks:1) Import can read export dump files created by EXPORT release 5.1.22 and higher (up to same version).
2) An Oracle5 or Oracle6 export dump and an Oracle8 or Oracle8i or Oracle9i Import: see the Oracle Utilities Manual, Chapter 2 "Import" for special considerations to keep in mind.
3) An Oracle7 export dump and an Oracle8 or Oracle8i or Oracle9i Import: check constraints on the DATE columns become invalid when TO_DATE function has not been used in the constraint (this was not required in earlier Oracle versions).
4) To have a better performance and more flexibility when exporting from and importing into Oracle10g and higher release databases, we recommend the usage of the Export Data Pump (expdp) and Import Data Pump (impdp) clients.
5) The original Export client is desupported for general use as of Oracle Database 11g.

Solution in fusion

2012-08-09T09:31:00.002-07:00

BIZ Fusion first application is ready to release ....... !!!!!!!!!!!!!!!!!

Performanace tuning by AWR and ADDM.

2012-04-11T22:31:00.006-07:00

Snapshots

BEGIN
DBMS_WORKLOAD_REPOSITORY.modify_snapshot_settings(
retention => 43200, -- Minutes (= 30 Days). Current value retained if NULL.
interval => 30); -- Minutes. Current value retained if NULL.
END;
/

Extra snapshots can be taken and existing snapshots can be removed, as shown below

EXEC DBMS_WORKLOAD_REPOSITORY.create_snapshot;

BEGIN
DBMS_WORKLOAD_REPOSITORY.drop_snapshot_range (
low_snap_id => 22,
high_snap_id => 32);
END;
/

Baselines View the difference between two time.

BEGIN
DBMS_WORKLOAD_REPOSITORY.create_baseline (
start_snap_id => 210,
end_snap_id => 220,
baseline_name => 'batch baseline');
END;
/

BEGIN
DBMS_WORKLOAD_REPOSITORY.drop_baseline (
baseline_name => 'batch baseline',
cascade => FALSE); -- Deletes associated snapshots if TRUE.
END;
/

DBA_HIST_SNAPSHOT view is use for get the snapshot ID;

Workload Repository Reports
@$ORACLE_HOME/rdbms/admin/awrrpt.sql
@$ORACLE_HOME/rdbms/admin/awrrpti.sql

http://www.dbapool.com/analyzer/ Online Analyzer

ADDM report

By script

@/u01/app/oracle/product/10.1.0/db_1/rdbms/admin/addmrpt.sql

BY Pakage

BEGIN
-- Create an ADDM task.
DBMS_ADVISOR.create_task (
advisor_name => 'ADDM',
task_name => '970_1032_AWR_SNAPSHOT',
task_desc => 'Advisor for snapshots 970 to 1032.');

-- Set the start and end snapshots.
DBMS_ADVISOR.set_task_parameter (
task_name => '970_1032_AWR_SNAPSHOT',
parameter => 'START_SNAPSHOT',
value => 970);

DBMS_ADVISOR.set_task_parameter (
task_name => '970_1032_AWR_SNAPSHOT',
parameter => 'END_SNAPSHOT',
value => 1032);

-- Execute the task.
DBMS_ADVISOR.execute_task(task_name => '970_1032_AWR_SNAPSHOT');
END;
/

-- Display the report.
SET LONG 100000
SET PAGESIZE 50000
SELECT DBMS_ADVISOR.get_task_report('970_1032_AWR_SNAPSHOT') AS report
FROM dual;
SET PAGESIZE 24

Gap Resolution of Physical Standby Database to Hang

2012-03-15T22:26:00.002-07:00

Fetching gap sequence in thread 1, gap sequence 53713-53713FAL[client]:
Error fetching gap sequenceWed May 12 15:26:44 2010FAL[client]:
Failed to request gap sequenceGAP - thread 1 sequence 53713-53713DBID 2748812654 branch 645984751

select sequence#, name, archived, applied from v$archived_log
where sequence# like '%53713%';

SEQUENCE# NAME ARC APP
---------- ------------------------------------------------------- --- ---
53713 /opt/oracle/admin/PROD/standby/arch_3_53713_645984751 YES NO

* check which sequence is not sync.

* copy them to primary to standby.

* then register the sequence.

ALTER DATABASE REGISTER OR REPLACE PHYSICAL LOGFILE '/opt/oracle/admin/BMCPD/standby/arch_1_53713_645984751';

Install pakege in suse linux by zyper (error -'/etc/init.d/vboxdrv setup' )

2012-01-25T15:58:00.000-08:00

First make certain that openSUSE is up-to-date

Code: Select all Expand view
zypper update

Then install all packages needed to compile external modules.

Code: Select all Expand view
sudo zypper install gcc make automake autoconf kernel-source kernel-syms

Then install VirtualBox again and it should work after a reboot. Make sure that your user name in in the vboxusers group as well.

Oracle Long operations

2012-01-10T06:06:00.000-08:00

SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK,
ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE"
FROM V$SESSION_LONGOPS WHERE OPNAME LIKE 'RMAN%'
AND OPNAME NOT LIKE '%aggregate%'
AND TOTALWORK != 0
AND SOFAR <> TOTALWORK/

RMAN backup script.

2011-09-30T10:38:00.000-07:00

#!/bin/bash
SHELL=/bin/bash
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
export ORACLE_SID=xxx

#wd=`date +%Y_%m_%d`
#mkdir -p /orabackup/test_backup/$wd

rman target backup/backup "two less than simbole" EOF
run {
set controlfile autobackup format for device type disk to '/backup/%F';
allocate channel c1 device type disk format='/backup/%d_%T_%U';
backup database;
sql 'alter system archive log current';
backup archivelog all;
delete noprompt archivelog all completed before 'SYSDATE-7';
release channel c1;
}
EOF

Linux automate backup copy to windows script

2011-09-30T10:18:00.000-07:00

#!/bin/bash

SHELL=/bin/bash

# get sysdate to variable
wd=`date +%Y_%m_%d`

# get previous day to variable if required
#wd=`date -d "-1 day" +"%Y_%m_%d"`

mount -t smbfs -o username=administrator,password=password //[IP]/Exp /share/winShare

tar -czPf /share/winShare/MiddleDB_$wd.tgz /orabackup/backup/$wd/*

umount /share/winShare