Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Reuse old/configured server for new purpose problems.
Operating Systems Solaris Reuse old/configured server for new purpose problems. Post 302770346 by cero on Friday 15th of February 2013 10:25:23 AM
Old 02-15-2013
I'll give some further details for the shutdown, as it may be important (there are some posts on this site that demonstrate what happens when you delete a file at os level with processes still having it open).

1) Check if a database is running by looking if there are database processes. The most important process for a Oracle-database is pmon, and looking at the process owner you find out which user you should use to perform the actions below.
Code:
ps -eaf |grep pmon

If there is no pmon process the database is already shut down. If there is more than one you have to do the steps below for each of them. (select * from v$database does NOT show how many databases are installed)


2) Identify the system-ID
There should be a file /etc/oratab (on solaris maybe /var/opt/oracle/oratab). This file tells you how many databases are installed on your system. The structure of this file is:
Code:
<ORACLE_SID>:<ORACLE_HOME>:<AutomaticStart>

<ORACLE_SID> is the "databasename" and <ORACLE_HOME> is the place where the software is installed. There should be a line in this file for each database the server houses.


3) Set up the environment
Switch user to the software owner and set the environment variables ORACLE_HOME and ORACLE_SID (with the values found in /etc/oratab)
Code:
su - oracle
ORACLE_HOME=/path/shown/in/etc/oratab
ORACLE_SID=most_likely_smart


4) Shut down the database:
Code:
lsnrctl stop
sqlplus /nolog
connect / as sysdba;
shutdown abort;
exit

Last edited by cero; 02-15-2013 at 11:54 AM..
This User Gave Thanks to cero For This Post:
RedSpyder
 

10 More Discussions You Might Find Interesting

1. Linux

httpd server problems!

Hello, My apache was working before, but not anymore. When I try to run this service this way: service httpd start I get the following error: Starting httpd: /usr/sbin/httpd: error while loading shared libraries: libpcre.so.0: cannot open shared object file: Permission denied Anyone... (2 Replies)
Discussion started by: HSN
2 Replies

2. UNIX for Dummies Questions & Answers

How to reuse same major number

Hi, I am working on device drivers.Once If register a device i'll get one major no. If i unregister and register again i'll get a different major no.What i have to do to get same major no. each time :( (0 Replies)
Discussion started by: Agnello
0 Replies

3. HP-UX

Reuse disk from other HP-UX

Hello, I have 2 hp-ux both running 11.23, I have move one of a harddisk from "UNIX A" to "UNIX B", so how can I read back the data in "UNIX B"? Thanks (5 Replies)
Discussion started by: zetadhell
5 Replies

4. AIX

What's the purpose of rj45-like connector on front panel of p5 55A server ?

Hi, What is the purpose of this connector ? I attached picture of it. In docs it is called "Ethernet connector". thanks Vilius (1 Reply)
Discussion started by: vilius
1 Replies

5. Shell Programming and Scripting

Reuse Variable..

Hi. I have these two variables: My objective here is to reuse that $file_name variable again and again by resetting the $cv value. for example, if i reissue the cv="$(print 'CV01')" command, thus $file_name is now should be "CP99978_CV01.TXT", not "CP99978_CV01.TXT" anymore. How I'm... (7 Replies)
Discussion started by: aimy
7 Replies

6. AIX

restoring mksysb backup of a clustered server configured in HACMP

Hi, I have done NIM restoration via nim_bosinst a lot of times but I have some doubts on restoring a server which is clustered specifically HACMP. Previously, I don't know the trend but after doing a nim_bosinst, I can see the client's hostname is back to "localhost" rather than its original... (0 Replies)
Discussion started by: depam
0 Replies

7. Shell Programming and Scripting

A bad configured logrotate can cause a problems with memory leak ?

I am newbe to unix. I have a very serious problem on my server. I have a java application running, and all day on Monday morning, the process that is associated with this java is locked. Usually I doing a shutdown by the shutdown java command , you have to kill the process with the kill-kill... (1 Reply)
Discussion started by: jjoottaa
1 Replies

8. Emergency UNIX and Linux Support

Reuse a LUN

I have a LUN (From HP-Storage VA7110) that is claimed on 2 servers, but is in used in one of the VG on Server-1 . Now I want to shut Server-1 and re-use that LUN on server-2 . Server-1 Path-1 : /dev/rdsk/c4t0d1 Path-2: /dev/rdsk/c6t0d1 Server-2 Path-1: /dev/rdsk/c5t0d1 Path-2:... (8 Replies)
Discussion started by: Shirishlnx
8 Replies

9. Solaris

Unable to boot from mirror disk on x86 server configured under VxVM

Hi, Can you help me on booting x86 server configured under VxVM. Server boots fine normally from both the disks but if I try to boot server from mirror disk without starting veritas, then it does not boot. vxplex -g rootdg dis var-02 vxplex -g rootdg dis swapvol-02 vxplex -g rootdg dis... (2 Replies)
Discussion started by: milindphanse604
2 Replies

10. Programming

Reuse format strings

I have a collection of format strings for sscanf, such as "%02d%*1s%02d%*1s%02d" to read in certain formatted strings, such as dates, times, etc. I wonder if there is a way to use them in printf without some changes? The example above would not work - at least I can't think of any ways to... (4 Replies)
Discussion started by: migurus
4 Replies

LEARN ABOUT REDHAT

mkcat

mkcat(8)                                                  GNATS Admininstration Utilities                                                 mkcat(8)

NAME

       mkcat - create a new GNATS category

SYNOPSIS

       mkcat  [ -d databasename | --database=databasename ]
              [ -h | --help ]

DESCRIPTION

       Scans the database for any new categories, creating new subdirectories in the database directory if any are found.

       This  program  is  mostly obsolete since directories for categories are automatically created as necessary, but is left for histerical rea-
       sons.

       mkcat should be run by the GNATS user (by default gnats).

OPTIONS

       -d, --database
              Specifies the database to be scanned for new categories; if no database is specified, the database named default is  assumed.   This
              option overrides the database specified in the GNATSDB environment variable.

       -h, --help
              Displays a short usage message.

ENVIRONMENT VARIABLES

       The GNATSDB environment variable is used to determine which database to use.  For a local database, it contains the name of the database to
       access.  If GNATSDB is not set, the database named default is used.

SEE ALSO

       Keeping Track: Managing Messages With GNATS (also installed as the GNU Info file gnats.info)

       databases(5), dbconfig(5), delete-pr(8), edit-pr(1) file-pr(8), gen-index(8), gnats(7), gnatsd(8), mkcat(8),  mkdb(8),  pr-edit(8),  query-
       pr(1), queue-pr(8), send-pr(1).

COPYING

       Copyright (c) 1993, 1999, 2003, Free Software Foundation, Inc.

       Permission  is  granted  to make and distribute verbatim copies of this manual provided the copyright notice and this permission notice are
       preserved on all copies.

       Permission is granted to copy and distribute modified versions of this manual under the conditions for verbatim copying, provided that  the
       entire resulting derived work is distributed under the terms of a permission notice identical to this one.

       Permission  is  granted  to  copy and distribute translations of this manual into another language, under the above conditions for modified
       versions, except that this permission notice may be included in translations approved by the Free Software Foundation  instead  of  in  the
       original English.

GNATS                                                               August 2003                                                           mkcat(8)
All times are GMT -4. The time now is 03:35 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy