Sponsored Content
Top Forums Shell Programming and Scripting need script for activate and deactivated databases in server Post 302095184 by krishna176 on Saturday 4th of November 2006 01:42:09 AM
Old 11-04-2006
need script for activate and deactivated databases in server

Hi all,

i am using below command to find the running datases, bases this command i need a (shell/korn)script for which databases are running and which databases are not running in one file. i need out put below format.

Kindly help to me. its very critical issue for me. i dont have script knowledge.


command : #ps -ef |grep pmon


databases
----------------

SREDEV1
SREDEV2
SREDEV3
SREDEV4
SREUAT2
SREUAT3
SREUAT4
SREUAT5
SREUAT6
SREUAT7
SREQA1
SREQA2
SREQA4
OREDEV1
COEDEV
REP_DB
MRTDEV1
RICDEV3A
RICPROD2
ODSUAT1
----------------------


OUTPUT

STGDEV1 RUNNING
*****STGDEV2 NOT RUNNING*******
STGDEV3 RUNNING
STGDEV4 RUNNING
******STGUAT2 NOT RUNNING******
******STGUAT3 NOT RUNNING******
******STGUAT4 NOT RUNNING******
---------------------------------------------


THANKS & REGARDS
KRISHNA MURTHY
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

how do i activate php on linux....

i have activated mysql, and apache on my redhat 9 box, i went to mr BASH and wrote a php script, and it wouldn't execute. any help????????????????????????????????????? is there something that i need to activate??????? i have RUBY on there too,does it matter or no??? ... (2 Replies)
Discussion started by: mbabeli
2 Replies

2. UNIX for Advanced & Expert Users

activate and deactivate

hi all by using gethostbyname, i can know whether the net is available or not. it is working fine when i activate or deactivate in neat. the problem is when i remove cable(netcable) it is not working proparly, i would like to know it. am using fedora5, AMD can u please help me . thank... (3 Replies)
Discussion started by: munna_dude
3 Replies

3. SCO

How to activate/use networkcards SCO Open Server

Hi, in our business we have a formerly (few years ago) installed computer with an openserver SCO 5.05 there are 3 network cards in it. one on board and two 3Com-cards Looking with ifconfig (or scoadmin) they seemed to be installed correctly. IP-Adress, netmask broadcas looks OK. But no... (3 Replies)
Discussion started by: klex
3 Replies

4. Shell Programming and Scripting

Activate all Linux services script

Now i'm up to making a script from which you could activate all Linux services without being an expert. It's gonna be a powerful tool, I'll look forward to make it able to change the port which the service is assigned to. But I need some help, post some script to activate services and I'll fusion... (8 Replies)
Discussion started by: Dax01
8 Replies

5. AIX

Migration DB2 V8 databases to Power7 server

hi Guys, I just wondering if someone has gone through this process before. We are about to migrate all our current LPARS from a Power6 server to a new Power7 server. The only concern we have is that we are runing a few DB2 V8 databases on AIX 5.3 and basically DB2 v8 is been out of support for... (2 Replies)
Discussion started by: arizah
2 Replies

6. Shell Programming and Scripting

Activate and deactivate function within a ksh script

Hi, I have written a function which will blink a text "Scanning...". Now in the main script when I am doing the scan in the server I want to call this function so that user will see a blinking text on the screen and at the same time script will proceed will the scan function. Once scan is... (2 Replies)
Discussion started by: suhasingale
2 Replies

7. Shell Programming and Scripting

script to find oracle databases that are not in cluster

I need to create a script to list all the databases that are in cluster environment. The reason is that there are databases which are not in under cluster control and we need to identify those. The easiest way to identify is: clrt list (if SUNW.oracle_server:6, SUNW.oracle_listener:5 are not... (0 Replies)
Discussion started by: misterx12345
0 Replies

8. Shell Programming and Scripting

Passwordless login gets deactivated after some time

Hi Friends, I was successfully able to login passwordlessly to server 1.1.1.2 from server 1.1.1.1 by following the below steps. I had already generated the keys using (ssh-keygen -t rsa) once and i am assuming i do not have to do that again. ssh id@1.1.1.2 mkdir -p .ssh cat... (8 Replies)
Discussion started by: srkmish
8 Replies

9. Shell Programming and Scripting

Automation script for Oracle queries for two different Databases

Hi Team, I am Oracle Databse developer. I am currently working on two databases. DB1 and DB2. in DB1 I have a Select query which will return 100 records. In Db2 I have a Select query which also return 100 records. In these two tables ( in different Schemas) we have a common column. ... (2 Replies)
Discussion started by: vasuvv
2 Replies
ONEVM(1)					  onevm(1) -- manages OpenNebula virtual machines					  ONEVM(1)

NAME
onevm SYNOPSIS
onevm command [args] [options] OPTIONS
-m, --multiple x Instance multiple VMs -x, --xml Show the resource in xml format -n, --numeric Do not translate user and group IDs -k, --kilobytes Show units in kilobytes -t, --type type Type of the new Image -l, --list x,y,z Selects columns to display with list command -d, --delay x Sets the delay in seconds for top command -v, --verbose Verbose mode -h, --help Show this message -V, --version Show version and copyright information COMMANDS
o create file Creates a new VM from the given template file. This command bypasses the Template pool, which is the preferred way to instantiate new VMs. See 'onetemplate create' and 'onetemplate instantiate' valid options: multiple, xml, numeric, kilobytes o delete range|vmid_list Deletes the given VM States: ANY o hold range|vmid_list Sets the given VM on hold. A VM on hold is not scheduled until it is released. It can be, however, deployed manually; see 'onevm deploy' States: PENDING o release range|vmid_list Releases a VM on hold. See 'onevm hold' States: HOLD o saveas vmid diskid img_name Sets the specified VM disk to be saved in a new Image. The Image is created inmediately, but the contents are saved only if the VM is shut down gracefuly (i.e., using 'onevm shutdown' and not 'onevm delete') States: ANY valid options: type o shutdown range|vmid_list Shuts down the given VM. States: RUNNING o reboot range|vmid_list Reboots the given VM, this is equivalent to execute the reboot command from the VM console. States: RUNNING o deploy range|vmid_list hostid Deploys the given VM in the specified Host. This command forces the deployment, in a standard installation the Scheduler is in charge of this decision States: PENDING o livemigrate range|vmid_list hostid Migrates the given running VM to another Host without downtime States: RUNNING o migrate range|vmid_list hostid Saves the given running VM and starts it again in the specified Host States: RUNNING o restart range|vmid_list Forces a re-deployment of the given VM, issuing a boot action. States: UNKNOWN, BOOT o resubmit range|vmid_list Resubmits the VM to PENDING state. This is intented for VMs stuck in a transient state. To re-deploy a fresh copy of the same VM, create a Template and instantiante it, see 'onetemplate instantiate' States: ANY, except SUSPENDED or DONE o cancel range|vmid_list Cancels the given VM. The process is checked by OpenNebula, so if the process fails the VM remains in running state. If the action succeeds the VMDIR in the remote machine is not deleted States: RUNNING o stop range|vmid_list Stops a running VM. The VM state is saved and transferred back to the front-end along with the disk files States: RUNNING o suspend range|vmid_list Saves a running VM. It is the same as 'onevm stop', but the files are left in the remote machine to later restart the VM there (i.e. the resources are not freed and there is no need to re-schedule the VM). States: RUNNING o resume range|vmid_list Resumes the execution of the a saved VM States: STOPPED, SUSPENDED o chgrp range|vmid_list groupid Changes the VM group o chown range|vmid_list userid [groupid] Changes the VM owner and group o chmod range|vmid_list octet Changes the VM permissions o list [filterflag] Lists VMs in the pool valid options: list, delay, xml, numeric, kilobytes o show vmid Shows information for the given VM valid options: xml o top [filterflag] Lists Images continuously valid options: list, delay, xml, numeric, kilobytes ARGUMENT FORMATS
o file Path to a file o range List of id's in the form 1,8..15 o text String o hostid OpenNebula HOST name or id o groupid OpenNebula GROUP name or id o userid OpenNebula USER name or id o vmid OpenNebula VM name or id o vmid_list Comma-separated list of OpenNebula VM names or ids o filterflag a, all all the known VMs m, mine the VM belonging to the user in ONE_AUTH g, group 'mine' plus the VM belonging to the groups the user is member of uid VM of the user identified by this uid user VM of the user identified by the username LICENSE
OpenNebula 3.4.1 Copyright 2002-2012, OpenNebula Project Leads (OpenNebula.org) Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 April 2012 ONEVM(1)
All times are GMT -4. The time now is 05:50 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy