question from a new dba
From: Sze Shun Sum <alan_at_cs.ust.hk>
Date: Sat, 26 Nov 1994 15:34:40 GMT
Message-ID: <1994Nov26.153440.24126_at_uxmail.ust.hk>
Date: Sat, 26 Nov 1994 15:34:40 GMT
Message-ID: <1994Nov26.153440.24126_at_uxmail.ust.hk>
I would like to ask some questions:
- How could I know what databases are existing in Oracle ?
- What is the use of the file "init.ora" under $ORACLEHOME/dbs ?
- I have tried to create database named "alanddd" by: SQLDBA> startup nomount pfile=init.ora ORACLE instance started. SQLDBA> connect internal Connected. SQLDBA> create database alanddd 2> controlfile reuse 3> ; Statement processed.
What should I do after these ?? I read the Adminstrator's Guide. It tells me to startup and shutdown the database system. But I found that I have to "disconnect" before I shut it down. And after this, when I tried to startup the database system, it gave the following error messages:
SQLDBA> startup ORACLE instance started. ORA-01103: database name 'ALANDDD' in control file is not 'ORACLE' Attempting to shutdown instance........ORACLE instance shut down. Now, I could only startup the database system by: SQLDBA> startup nomount pfile=init.ora
What should I do to make the database system works fine as before ??
4. I even now couldn't login sqlplus by:
dbsvr2%~/dbs > sqlplus SQL*Plus: Version 3.0.9.1.2 - Production on Sat Nov 26 23:32:31 1994 Copyright (c) Oracle Corporation 1979, 1989. All rights reserved. Enter user-name: alan Enter password: ERROR: ORA-01033: ORACLE initialization or shutdown in progress
What should I do ??
5. Where can I get any documentation about Oracle (like FAQ)
through internet ??
I'm now using Oracle version 6 on a Sparc20 machine. Many many many thanks for help.
-- ___ _ / _ \| |__ _ _ _ | Name: Sze Shun Sum, Alan E-mail: alan_at_cs.ust.hk | _ | / _` | ' \ | Office: Rm 4212, HKUST, Clear Water Bay, HongKong |_| |_|_\__,_|_||_| | Phone: (852)358-8836 Favorite: Bridge, BasketballReceived on Sat Nov 26 1994 - 16:34:40 CET