Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • longtx.sql Oracle
  • All About oracle password and security from metalink Oracle
  • Removing Blank lines from file using grep Linux/Unix
  • Passing from Unix to PLSQL using bind variables Linux/Unix
  • Oracle GoldenGate lag monitoring shell script Linux/Unix
  • telnet listening Linux/Unix
  • How to choose Driver table in SQL statement Oracle
  • CTAS with LONG Column for 7.x and 8 and 8i Oracle
  • normal maintenance for exp-imp and renaming table Oracle
  • 339939.1 Running Cluster Verification Utility to Diagnose Install Problems Oracle
  • How to connect to Oracle Database with Wallet with Python. Oracle
  • oracle tips… from http://www.bijoos.com/oracle/douknow.htm Oracle
  • Proc Compilation Oracle
  • Reclaim temp tablespace for oracle 8, 8i Oracle
  • sess1.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

  • Process Map for CPU and Memory for OS processes Linux/Unix
  • copying/removing directory with all its subdirectory Linux/Unix
  • Small sample shell program Linux/Unix
  • Adding addidional hard drive and attach it to a linux box. Linux/Unix
  • handling filenname with space Linux/Unix
  • replacing ^M character when passing files from Windows to Unix 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 (392)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (0)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • SQL Server (6)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • 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
  • MYSQL and Oracle Comparison for Oracle DBA24-Jul-2025

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Useful Solaris Commands on 28-SEP-2005 Linux/Unix
  • Export Import with QUERY Oracle
  • Korn Shell Arithmatic Linux/Unix
  • Small sample shell program Linux/Unix
  • sql_plan9i.sql Oracle
  • Find All internal Parameters Oracle
  • proc.sql Oracle
  • Search and replace pattern Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme