Create Database
SVRMGR> CREATE DATABASE sroyit
LOGFILE 'C:\Oracle8i\oradata\sroyit\redo01.log' SIZE 1024K, 'C:\Oracle8i\oradata\sroyit\redo02.log' SIZE 1024K
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXLOGHISTORY 1
DATAFILE 'C:\Oracle8i\oradata\sroyit\system01.dbf' SIZE 50M REUSE
MAXDATAFILES 254
MAXINSTANCES 1
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET WE8ISO8859P1;
Statement processed.
C:\>svrmgrl or SVRMGRL
Oracle Server Manager Release 3.1.5.0.0 - Production
(c) Copyright 1997, Oracle Corporation. All Rights Reserved.
Oracle8i Release 8.1.5.0.0 - Production
With the Java option
PL/SQL Release 8.1.5.0.0 - Production
SVRMGR> connect internal as sysdba;
Connected.
SVRMGR> startup mount sroyit;
ORACLE instance started.
Total System Global Area 137072588 bytes
Fixed Size 65484 bytes
Variable Size 63590400 bytes
Database Buffers 73342976 bytes
Redo Buffers 73728 bytes
Database mounted.
SVRMGR> alter database open;
Statement processed.
SVRMGR> shutdown immediate;
ORACLE instance shut down.
SVRMGR> help
The following are SIMPLIFIED syntax descriptions. For complete syntax descriptions, please refer to the Oracle Server Manager User's Guide.
STARTUP [DBA] [FORCE] [PFILE=filespec] [EXCLUSIVE | SHARED]
[MOUNT dbname | OPEN dbname] [NOMOUNT]
SHUTDOWN [NORMAL | IMMEDIATE | ABORT]
MONITOR For graphical modes only, bring up a monitor
ARCHIVE LOG [START] [STOP] [LIST] [NEXT] [
RECOVER { [DATABASE [MANUAL] ] | [TABLESPACE ts-name [,tsname]] }
CONNECT [username [/password] ] [INTERNAL] ['@'instance-spec]
DISCONNECT
SET options: INSTANCE, ECHO, TERMOUT, TIMING, NUMWIDTH, CHARWIDTH
SHOW LONGWIDTH, DATEWIDTH, AUTOPRINT and for SHOW: ALL, SPOOL
EXIT
REM
SQL statements can also be executed.