Re: Queries of a Novice, please help

From: Tony Adolph <tony.adolph_at_viaginterkom.de>
Date: Thu, 19 Aug 1999 08:48:16 GMT
Message-ID: <7pggce$fne$1@nnrp1.deja.com>

> 1). I have a problem starting SQL Plus, i am ignorant of what
username and passwd should be used to open sqlplus initially.

---

Default passwords post installations are:   for SYSTEM passwd is MANAGER
and
  for SYS passwd is CHANGE_ON_INSTALL

> -->why am i getting error ORA-01033 ?

---

A useful command on a Unix box to get further details on Oracle error messages is "oerr", here's a demo for your error (the ora 2nd arg comes from the first part of the error number):

oerr ora 1033

01033, 00000, "ORACLE initialization or shutdown in progress" // *Cause: An attempt was made to log on while Oracle is being started up
// or shutdown.
// *Action: Wait a few minutes. Then retry the operation

The above error message tells you thatthe DB is shutting down, see the admin guy (or if its you), complete the shutdown and start the DB back up again

> 2). orapwd: why is it used?

---

its used to set the internal password

Do you have the "Oracle8i ... Getting Started" manual? It has some useful info.

Hope that helps
Tony Adolph

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Aug 19 1999 - 03:48:16 CDT