Oracle : Setting up Oramenu for Databases

Share via:

Post Views: 0

Use this script to setup oramenu:

#!/bin/bash
# set -x
# Pawan - www.orskl.com - Setting environmental variables from menu. Date: 27-Mar-2017 
# 
# THIS SCRIPT WILL draw the menu of all available Oracle Instances from /etc/oratab.
# It will simplify the way you set environment varaibles.
#
# Get the list of SID's from /etc/oratab file
# Draw the menu
# let user select the option
# set those environment variables.
# 

if [ -f /etc/oratab ]
then
echo "Please select your SID to set its environment variables"
select sid in `cut -f "1" -d "#" /etc/oratab | awk -F: '{print $1}' | grep -v '^$'`
do
if [ `echo "X"${sid}` == "X" ]
then
echo "Invalid selection. Select numbers of respectice SID"
break
else
. /usr/local/bin/oraenv <<< $sid >/dev/null
break
fi
done
else
echo "Oracle is not installed on this server"
fi

#!/bin/bash

# set -x

# Pawan - www.orskl.com - Setting environmental variables from menu. Date: 27-Mar-2017

# THIS SCRIPT WILL draw the menu of all available Oracle Instances from /etc/oratab.

# It will simplify the way you set environment varaibles.

# Get the list of SID's from /etc/oratab file

# Draw the menu

# let user select the option

# set those environment variables.

if [ -f /etc/oratab ]

then

echo "Please select your SID to set its environment variables"

select sid in `cut -f "1" -d "#" /etc/oratab | awk -F: '{print $1}' | grep -v '^$'`

if [ `echo "X"${sid}` == "X" ]

then

echo "Invalid selection. Select numbers of respectice SID"

break

else

. /usr/local/bin/oraenv <<< $sid >/dev/null

break

done

else

echo "Oracle is not installed on this server"

~$ chmod +x oramenu
~$ sudo su – root
~# cp /home/oracle/oramenu /usr/local/bin/
~# exit
logout
~$ . oramenu

Example :

$ chmod +x oramenu
oracle@server123:ORCL1:/home/oracle >
$ . oramenu
Please select your SID to set its environment variables
1) DEMO
2) TEST
3) +ASM
4) ORCL1
5) ORCL2
6) ORCL3
#? 4
oracle@server123:ORCL1:/local/home/oracle >
$ s

SQL*Plus: Release 12.1.0.2.0 Production on Mon Mar 27 12:50:56 2017

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options

SQL> set linesize 300
SQL> select name||’ – ‘||instance_name||’@’||host_name||’ – ‘||DB_UNIQUE_NAME||’ – ‘||version||’ – ‘||open_mode||’ – ‘||to_char(startup_time,’DD-MON-YYYY HH24:MI:SS’) || ‘ – ‘|| database_role from v$database, v$instance;

NAME||’-‘||INSTANCE_NAME||’@’||HOST_NAME||’-‘||DB_UNIQUE_NAME||’-‘||VERSION||’-‘||OPEN_MODE||’-‘||TO_CHAR(STARTUP_TIME,’DD-MON-YYYYHH24:MI:SS’)||’-‘||DATABASE_ROLE
—————————————————————————————————————————————————————————————————————————-
ORCL1 – ORCL1@server123.com – ORCL1 – 12.1.0.2.0 – READ WRITE – 20-NOV-2016 23:55:13 – PRIMARY

Share via:

Note: Please test scripts in Non Prod before trying in Production.

13 thoughts on “Oracle : Setting up Oramenu for Databases”

Dinesh Pal

April 26, 2017 at 9:55 am

Nice

Deneen

May 25, 2017 at 3:43 pm

Hey! This is my first visit to your blog! We are a team of volunteers
and starting a new initiative in a community in the same niche.
Your blog provided us beneficial information to work on. You have done a wonderful
job!

Lon

May 25, 2017 at 11:17 pm

Very quicily this web page will be famous among all blogging and site-building viewers,
due to it’s pleasant articles orr reviews

Brent

May 29, 2017 at 10:31 am

Your style is unique in comparison to other people I have read stuff from.
Thanks for posting when you’ve got the opportunity, Guess
I’ll just book mark this site.

Ernesto

June 4, 2017 at 2:29 am

Your style iis unique compared tto other folks I’ve read stuff from.
Thanks for posting when you’ve ggot the opportunity, Guess I will just bkok mark this web site.

Ellie

June 6, 2017 at 11:57 am

Hello, i read your blog from time to time and i own a similar one and i was just wondering if you get a lot of spam feedback?
If so how do you protect against it, any plugin or
anything you can advise? I get so much lately it’s driviing mme mad sso aany
assistance is very much appreciated.