Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Very Good Oralce Internal Tuning Book Oracle
  • create a folder in multiple places Linux/Unix
  • Small sample shell program Linux/Unix
  • Search and replace pattern Linux/Unix
  • move_arch_files.ksh Linux/Unix
  • Error Handling in Proc Oracle
  • Drop tempfiles from database Oracle
  • findinfo.sql (SQL for getting CPU and Active session info) Oracle
  • Drop specific SQL plan baseline – spm Oracle
  • login.sql Oracle
  • remove archfiles only when it is applied to DR rm_archfiles.sh Linux/Unix
  • adding new line after specific pattern using sed Linux/Unix
  • Export Oracle data and Compress at same time Oracle
  • move_arch_files.ksh Linux/Unix
  • SQL Tracker by SID sqltrackerbysid.sql Oracle

Validating ORACLE_SID againt oratab file.

Posted on 05-Oct-2006 By Admin No Comments on Validating ORACLE_SID againt oratab file.

The following script shows how to check an Oracle SID to be sure that it’s valid. The script expects the SID to be passed in as the first parameter, and it begins by checking to see if a parameter was even passed. The script next counts the number of times the first parameter value appears in the /etc/oratab file. A valid Oracle SID will appear once in that file.

#!/bin/ksh

# Exit if no first parameter $1 passed.

if [ -z “$1” ]

then

echo “Please pass a valid ORACLE_SID

to this script”

exit 99

fi

# Validate the Oracle database name with

# lookup in /etc/oratab.

TEMP=`cat /etc/oratab|grep ^$1:|

cut -f1 -d’:’|wc -l`

tmp=`expr TEMP` # Convert string to number.

if [ $tmp -ne 1 ]

then

echo “Your input $1 is not a valid ORACLE_SID.”

exit 99

fi

Linux/Unix, shell

Post navigation

Previous Post: Some useful Unix Commands
Next Post: Looping for remote servers and find its database from oratab file.

Related Posts

  • fuser to check who is using diretory Linux/Unix
  • Adding addidional hard drive and attach it to a linux box. Linux/Unix
  • Looping for remote servers and find its database from oratab file. Linux/Unix
  • set_env_dba Linux/Unix
  • replacing ^M character when passing files from Windows to Unix Linux/Unix
  • checking connectivity between two servers Linux/Unix

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

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
  • shr1.sql for MTS or Shared server configuration Oracle
  • Btee and Bitmap Plans in Oracle 9i and higher Oracle
  • initUOCIOTTO.ora Oracle
  • Error Handling in Proc Oracle
  • To find explain plan for a statement that occurred in past. Oracle
  • Trace a SQL session from another session using ORADEBUG Oracle
  • 284785.1 How to check RAC Option is currently linked into the Oracle Binary Oracle
  • Global Unique Identifier Generation in Oracle 9.2 SYS_GUID() Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme