Oracle : Setting up Oramenu for Databases

Share via:

Use this script to setup oramenu:

 

 

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

Or

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

Copyright (c) 1982, 2014, Oracle. All rights reserved.

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.
1 Star2 Stars3 Stars4 Stars5 Stars (20 votes, average: 5.00 out of 5)
Loading...

13 thoughts on “Oracle : Setting up Oramenu for Databases

  1. 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!

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

  3. 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.

  4. 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.

  5. 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.

  6. Very good post Vinod. Below are my suggestions. Hope this will help you else please ignore them

    1. Try to post the screenshot of the result instead of text output.
    2. Avoid “root” (Can try sudo)

Add Comment