Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Rownum with Order by Oracle
  • Updated LCK.SQL file. Oracle
  • pvmehta.com SQL scripts
    Find which sessions is accessing object that prevent your session to have exclusive locks in Oracle Oracle
  • AWR settings- MMON is not taking snapshot. Oracle
  • changing kernel parameter in Oracle Enterpise Linux Linux/Unix
  • Find sort details from Db find_sort.sql Oracle
  • find_string_in_database.sql Oracle
  • db_status.sql Oracle
  • get_vmstat_solaris Oracle
  • Implementing Listener Security Oracle
  • Oracle 10g Installation/Applying Patches Tips Oracle
  • Establishing trusted relationship between dbmonitor( central monitoring) and monitoring targets. Linux/Unix
  • Day to day MYSQL DBA operations (Compared with Oracle DBA) MYSQL
  • OEM-troubleshooting on 20-MAY-08 Oracle
  • to see when crontab is changed. Linux/Unix

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
  • alter database backup controlfile to trace Oracle
  • oracle Dba site Oracle
  • usnsql.sql Displays information about UNDO segments with sql statements Oracle
  • Unix command for system configuration Linux/Unix
  • First Entry in RAC Oracle
  • How to Use DBMS_STATS to Move Statistics to a Different Database Oracle
  • How To Resolve Stranded DBA_2PC_PENDING Entries ID 401302.1 (Very Good prooven) Oracle
  • Adding Datafile on Primary Server and Impact on Standby Server Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme