Friday, June 29, 2012

How to connect and start Oracle 7 database:

I started my job as DBA from oracle 9i, when I had a situation to start a version 7 DB it took me few minutes to find and resolve. Today after few years there was a need to check db status of version 7 database and my friend asked how? so I thought put this steps here though now there are very less version 7,8 databases.

1) Connect to  SVRMGRL
apu82$ svrmgrl

Oracle Server Manager Release - Production

Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.

Oracle7 Server Release - Production Release
With the distributed and parallel query options
PL/SQL Release – Production

2) Connect to database as internal

SVRMGR> connect internal
Connected to an idle instance.

3) Startup the database

SVRMGR> startup
ORACLE instance started.
Total System Global Area     109157168 bytes
Fixed Size                       39808 bytes
Variable Size                 23003056 bytes
Database Buffers              81920000 bytes
Redo Buffers                   4194304 bytes
Database mounted.
Database opened.
SVRMGR> exit

SQL> desc v$instance
 Name                            Null?    Type
 ------------------------------- -------- ----
 KEY                                      VARCHAR2(64)
 VALUE                                    NUMBER

SQL> select * from v$instance;

KEY                                                                   VALUE
---------------------------------------------------------------- ----------
RESTRICTED MODE                                                           0
SHUTDOWN PENDING                                                          0
STARTUP TIME - JULIAN                                               2455414
STARTUP TIME - SECONDS                                                66687

No comments:

Post a Comment