| database will not start [message #55904] |
Sun, 23 February 2003 16:42  |
John Mancuso
Messages: 6
Registered: February 2003
|
Junior Member |
|
|
Just did a fresh install of Oracle 9 on Redhat 8.
Anyway I can connect to sqlplus if i do a "sqlplus
/nolog; connect / as sysdba". Then i'll do a
'startup' and the Oracle instance starts ok (except
for an error in identifying controlfile- who cares).
From here I can't do anything- can't create a simple
table, describe anything...etc.For example-
create table crap (ID NUMBER);
ERROR
ORA-01109: database not open.
If I try to log in with sqlplus-
Enter user-name: oracle
Enter password:*******
ERROR:
ORA-01033: ORACLE initialization or shutdown in
progress
ora_pmon_Oracle,ora_dbw0_Oracle,ora_lgwr_Oracle,ora_ckpt_Oracle
,ora_smon_Oracle,ora_reco_Oracle all show up in my
process list.
Please help- tearing my hair out!!!
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
