Check for errors in the alert.log file of the database, I think it is called
orclALRT.LOG.
Can't say for sure where oracle stores this file in a default install.
Could be c:\oracle\admin\orcl\bdump or c:\orant\rdbms\log or
c:\orant\rdbms\trace. Check for *.trc files too (in the udump dir).
I'am almost sure the database won't open properly because of some errors.
To find the actual status of the database start svrmgrl, connect internal
and do "select * from v$instance;".
The "status" column shows you if the database is started, mounted or open.
It should be open, I expect it to be mounted.
brian <brian_dellong_at_yahoo.com> schreef in berichtnieuws
a74ee6e1.0211230804.79ab1b98_at_posting.google.com...
| Please help me with this oracle problem that i am having.
| i have included relevant info that may help solve this issue
|
| windows NT4.0 Oracle 8i
| chose the Typical install in 8i during installation hence
| i guess a starter db is created by the installation
|
| I cannot connect to the sqlplus (on the same server box, tried both
| via the GUI [under ApplicationDevoplement>>sqlplus and also via the
| command line sqlplus]
|
| following steps were taken:
| via srvmgrl connected as internal and did a startup and then
| proceeded with sqlplus connection (tried both gui and command_line)
|
| following is the error:
| ORA-01033: Oracle initialization in progress.
|
| waited for 20 minutes and tried again. same error. did a shutdown
| and then startup then tried, same error
| ------------------------------------------------------
| Other messages that may help are below:
|
| All services are started fine. init.<sid> file exists fine and points
| correctly to the init.ora file.
|
| (a) shutdown, shutdown normal show this
| Error ORA-01507: database not mounted
|
| (b) for sqlplus/nolog brings into sql> and i am not
| challenged for username/password
|
| tried with just sqlplus and it challenges for
| Enter user-name: i entered sys / as sysdba
| asks for password: i entered change_on_install
|
| and again i get the same error ORA-01033: Oracle
| initialization in progress.
Received on Sat Nov 23 2002 - 10:23:55 CST
