script for zipping files in a directory for linux

 for i in `ls *.*`
 do
 gzip $i
 done

Comments

Post a Comment

Popular posts from this blog

Installing DBMS_JAVA package in Oracle and calling UTL_DBWS web services through Oracle database

Installing DBMS_JAVA package in Oracle following  files need to be run:-  sql> select comp_name, version, status from dba_registry where comp_name like '%JAVA%'; @?/javavm/install/initjvm.sql; @?/xdk/admin/initxml.sql; @?/xdk/admin/xmlja.sql; @?/rdbms/admin/catjava.sql; @?/rdbms/admin/catexf.sql; and verify your java installation in Oracle Database  sql> select comp_name, version, status from dba_registry where comp_name like '%JAVA%'; sql> select dbms_java.longname(object_name), status, object_type from all_objects where       object_type = 'JAVA CLASS'; ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ calling  UTL_DBWS  web services through Oracle Database :-  set the follwing parameters in .bash_profile of oracle user  export JAVA_HOME=$ORACLE_HOME/jdk ORACLE_BASE=/opt/oracle/product; export ORACLE_BASE ORACLE_HOME=/opt/oracle/product/11.2.0/dbhome_1; exp...
Read more

stick the job to the specific instance in Oracle RAC

First method ( and easy one too ) :- note:-  must perform this activity on each instance one by one. ......stop jobs which is assigning to the specific instance..... $ export ORACLE_SID=SID connect database using job owner .... $ sqlplus username/password list of jobs and its instance....  sql> select JOB,INSTANCE from user_jobs;        JOB   INSTANCE ---------- ----------       2510          0       2951          0       2992          0       3091          0       3111          0       1570          0       1567          0       1568          0       1569     ...
Read more

configure Oracle Golden Gate between Oracle - Postgres

 Source: Oracle 19c  Target: PostgreSQL 15 Golden Gate Version: Golden Gate 19.1 for Oracle (Source), Golden Gate 19.1 for PostgreSQL Database (Target ). Source Hostname: oracle  Target Hostname: postgres  Run below commands on Target Postgres database by root , postgres and Oracle users :-  install postgress dev binary :- rpm -ivh libtermcap-devel rpm -ivh readline-devel rpm -ivh gcc* rpm -ivh zlib rpm -ivh postgresql93-odbc yum search postgre | grep odbc give full permission to /tmp folder ( chmod -R 777 /tmp) download and install postgress 15  https://www.postgresql.org/ftp/source/v15.1/ postgresql-15.1.tar.gz tar -xvf above file  ./configure mkdir build_dir cd build_dir /path/to/source/tree/configure [options go there] make make install make install-docs adduser postgres mkdir /u02/pgsql/data chown postgres /u02/pgsql/data su - postgres /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data You can now start the database server using: /usr/local/pgsq...
Read more