Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • send email from unix mailx with attachment. Linux/Unix
  • Changing default shell Linux/Unix
  • scripts to take listener.log backup Linux/Unix
  • Gathering statistics with DBMS_STATS Oracle
  • Gather Stats manually using DBMS_STATS after disabling DBMS_SCHEDULER jobs as previous entry Oracle
  • FGA Part-I Oracle
  • ext#.sql Oracle
  • replace alphabets using sed Linux/Unix
  • Read CSV file using PySpark Python/PySpark
  • Adding a new disk and mount it automatically. on VMWARE LINUX Linux/Unix
  • Oracle Data Direct to TAPE Oracle
  • tuning commmand for cpu, ip and memory stats Linux/Unix
  • CTAS with LONG Column for 7.x and 8 and 8i Oracle
  • Handling LOB data in Oracle Oracle
  • proc.sql Oracle

Year: 2009

remove archfiles only when it is applied to DR rm_archfiles.sh

Posted on 08-Jul-2009 By Admin No Comments on remove archfiles only when it is applied to DR rm_archfiles.sh

ARCH_DEST=$1 COMFORT_SPACE=$2 ALERT_LOG=$3 NOTIFY_LIST=dbaoracle@1800flowers.com

Linux/Unix, shell

remove archfiles only when it is applied to DR rm_archfiles.sh

Posted on 08-Jul-2009 By Admin No Comments on remove archfiles only when it is applied to DR rm_archfiles.sh

/oracle/scripts/rm_archfiles.sh “/db9/archlog” “90” “/oracle/admin/TESTDB/bdump/alert_TESTDB.log” #!/bin/sh RUNNING=`ps -ef|grep rm_archfiles.sh|grep -v grep|wc -l` if [ $RUNNING -gt 2 ] then echo “Exiting !!! Total $RUNNING occurence of rm_archfiles.sh are running at `date`” exit fi

Linux/Unix, shell

run this before doing any dbchange pvm_pre_change.sql

Posted on 08-Jul-2009 By Admin No Comments on run this before doing any dbchange pvm_pre_change.sql

column currdate new_value pvmdt noprint select ‘pvm_comp_’ || to_char(SYSDATE, ‘DDMONRRRR_HH24MI’) || ‘.sql’ currdate from v$instance; spool &pvmdt set lines 120 pages 2000 set head off set feedback off prompt set pages 5000 lines 120 prompt select ‘prompt ‘||a.owner||’.’||a.object_name||’ – ‘||a.object_type|| chr(10)|| prompt ‘alter ‘|| prompt decode(a.object_type,’PACKAGE BODY’,’PACKAGE’,object_type) || ‘ “‘|| prompt a.owner||’”.’||a.object_name||’ compile ‘|| prompt…

Read More “run this before doing any dbchange pvm_pre_change.sql” »

Oracle, SQL scripts

Implementing Listener Security

Posted on 08-Jul-2009 By Admin No Comments on Implementing Listener Security

Step:1 ====== Do following steps to implement encrypted listener password. $ lsnrctl LSNRCTL> set current_listener LISTENER LSNRCTL>set save_config_on_stop on LSNRCTL> change_password Old password: New password: e1 Reenter new password: e1 LSNRCTL> set password Password: e1 LSNRCTL> stop Step:2 ====== Check your listener.ora file Entries similar to the following should have been added to your listener.ora…

Read More “Implementing Listener Security” »

Oracle, SQL scripts

Implementing Listener Security

Posted on 08-Jul-2009 By Admin No Comments on Implementing Listener Security

# Listener Security #

Oracle, SQL scripts

Implementing Listener Security

Posted on 08-Jul-2009 By Admin No Comments on Implementing Listener Security
Oracle, SQL scripts

Free conference number from http://www.freeconference.com

Posted on 06-Jul-2009 By Admin No Comments on Free conference number from http://www.freeconference.com

dedicated dial-in number 1 (218) 339-2699 access code 328166

Oracle, SQL scripts

pvm_pre_change.sql

Posted on 23-Jun-2009 By Admin No Comments on pvm_pre_change.sql

column currdate new_value pvmdt noprint select ‘pvm_comp_’ || to_char(SYSDATE, ‘DDMONRRRR_HH24MI’) || ‘.sql’ currdate from v$instance; spool &pvmdt set lines 120 pages 2000 set head off set feedback off prompt set pages 5000 lines 120 prompt select ‘prompt ‘||a.owner||’.’||a.object_name||’ – ‘||a.object_type|| chr(10)|| prompt ‘alter ‘|| prompt decode(a.object_type,’PACKAGE BODY’,’PACKAGE’,object_type) || ‘ “‘|| prompt a.owner||’”.’||a.object_name||’ compile ‘|| prompt…

Read More “pvm_pre_change.sql” »

Oracle, SQL scripts

Database logon trigger issue

Posted on 22-Jun-2009 By Admin No Comments on Database logon trigger issue

Problem Description ——————- You create a database event trigger that fires each time a user connects to the database. For any reason, the login trigger becomes invalid. (The trigger is retrieving information from a table that may be inadvertently dropped.) Who can connect? Solution Description ——————– Connect under a user who owns the following system…

Read More “Database logon trigger issue” »

Oracle, SQL scripts

kill all processes from specific user in solaris.

Posted on 22-Jun-2009 By Admin No Comments on kill all processes from specific user in solaris.

kill all processes from user name atsscript on solaris. pkill -9 -u atsscript

Linux/Unix, shell

Posts pagination

Previous 1 … 3 4 5 … 9 Next

Categories

  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • MYSQL (5)
  • Oracle (393)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (0)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (342)
  • SQL Server (6)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • Trace a SQL session from another session using ORADEBUG30-Sep-2025
  • SQL Server Vs Oracle Architecture difference25-Jul-2025
  • SQL Server: How to see historical transactions25-Jul-2025
  • SQL Server: How to see current transactions or requests25-Jul-2025
  • T-SQL Vs PL/SQL Syntax25-Jul-2025
  • Check SQL Server edition25-Jul-2025
  • Checking SQL Server Version25-Jul-2025
  • Oracle vs MYSQL Architecture differences (For DBAs)24-Jul-2025
  • V$INSTANCE of Oracle in MYSQL24-Jul-2025
  • Day to day MYSQL DBA operations (Compared with Oracle DBA)24-Jul-2025

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Locktree.sql Oracle
  • Jai Shree Ram Oracle
  • Search and Replace vi editor command. Linux/Unix
  • RAC with RHEL4 and 11g Oracle
  • Jai Shree Ram Oracle
  • Drop database in Oracle 10g Oracle
  • Implementing Listener Security Oracle
  • Directory wise folder wise space usage Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme