Howto restart an Oracle database

Howto restart an Oracle database

Howto restart an Oracle database 150 150 Roderick Derks

SSH Secure Shell 3.2.9 (Build 283)
Copyright (c) 2000-2003 SSH Communications Security Corp – http://www.ssh.com/

This copy of SSH Secure Shell is a non-commercial version.
This version does not include PKI and PKCS #11 functionality.

Last login: Thu Jan 24 10:49:50 2008 from 10.20.113.226
[root@ezhoradb04 ~]# su – oracle
ezhoradb04 [epdtst] ~> . oraenv
ORACLE_SID = [epdtst] ? algtst
ezhoradb04 [algtst] ~> sqlplus /nolog

SQL*Plus: Release 9.2.0.8.0 – Production on Sat Jan 26 12:13:38 2008

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> connect / as sysdba        
Connected.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  286331356 bytes
Fixed Size                   451036 bytes
Variable Size             234881024 bytes
Database Buffers           50331648 bytes
Redo Buffers                 667648 bytes
Database mounted.
Database opened.

cd $ORACLE_BASE/admin/agtst/bdump
ls -lrt
view alert_algtst.log

Roderick Derks

Liefhebber van fietsen, van het oplossen van IT puzzels, en van het delen van informatie om anderen te helpen.

All stories by:Roderick Derks

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Your Name (required)

Your Email (required)

Subject

Your Message

Your Name (required)

Your Email (required)

Subject

Your Message